Data Integration Specialist

Description

Reports to : IT Manager

Job Summary : The Data Integration Specialist at Holland Board of Public Works is responsible for developing and maintaining integration procedures to enhance business systems, minimize manual tasks, and support management decisions through data analysis. This role also involves project management and system implementation support.

Essential Duties

• Assist and support outside vendor systems in the act of upgrading, troubleshooting, integration, and overall performance monitoring.
• Provide database expertise and problem-solving support to resolve system issues.
• Develop, implement, and maintain integration solutions that augment and enhance the use and functionality of HBPW business systems.
• Develop and maintain integrations with various API endpoints across diverse platforms and technology stacks.
• Proficient in C# and the Microsoft .NET technology stack, including backend services and application development.
• Design and implement ASP.NET web pages with responsive and user-friendly interfaces.
• Create and maintain PowerShell scripts for automation, system administration, and task scheduling.
• Utilize Python scripting for data processing, automation, and integration tasks.
• Manage and customize SharePoint environments, including site creation, workflows, and permissions.
• Leverage No Code / Low Code platforms such as Forta Automate and Power Automate to streamline business processes and reduce development time.
• Develop and maintain SSIS (SQL Server Integration Services) packages for ETL processes, data transformation, and system integration.
• Integrate and utilize Microsoft Graph (MSGraph) for accessing Microsoft 365 services and data.
• Administer SQL Server databases, including :

Database Administration : User management, security, backups, design improvements, capacity planning, and performance tuning.

Essential Qualifications

Preferred Qualifications

Physical Requirements & Working Conditions

Employment will be contingent upon favorable results of a background check, pre-employment physical and drug screening. Given our safety-sensitive industry, our workplace is alcohol and drug free (including marijuana and THC items).

This job description is intended to describe the general nature and level of work being performed by a person assigned to this position. It is not to be construed as an exhaustive list of all job duties assigned to or required of this position.