Data Integration Specialist

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.

- Database Maintenance: Index optimization, integrity checks, and scheduled jobs.

- Database Migrations: Planning and executing migrations across environments or versions.

- Writing efficient and optimized SQL queries, views, and stored procedures for data retrieval and manipulation.

- Work with enterprise-wide data, dashboards, and other analysis tools to provide insights for business decision making.

- Provide oversight and at times management of project plans, fulfillment of tasks and budgeting, and evaluation of training and testing compliance.

- Assure the integrity of project data, including data extraction, storage, manipulation, processing, and analysis.

- Understand, interpret, and apply business rules to ensure an elevated level of data integrity and consistency.

- Communicate analysis results and make recommendations to senior management.

- Monitor and control access permissions and privileges for database users.

- Develop, manage, and test database backup and recovery plans.

- Perform related tasks as needed.

Essential Qualifications

- Bachelor’s degree in Computer Science, Database Administration or related field; or equivalent education and experience.

- Extensive Microsoft SQL Server experience.

- Experience programming VB.NET and ASP.NET.

- Understanding of database management standard concepts, practices, and procedures.

- Excellent written and verbal English language skills; strong interpersonal skills; excellent attention to detail.

- Excellent presentation and group facilitation skills.

- Ability to handle multiple projects at once.

Preferred Qualifications

- At least eight years of experience in the IT field.

- At least five years of experience with database administration.

- Experience with SharePoint database.

- Experience with PostgreSQL database backup and recovery.

- Experience with database reporting using SSRS, Power BI, Powerview and analytics.

- Experience with ESRI ArcSDE.

- Experience working in customer service field.

- Effective workplace skills as demonstrated through WorkKeys assessments (Workplace Documents – 5, Applied Math – 5, Graphic Literacy – 5).

Physical Requirements & Working Conditions

- Normal office environment with minimum discomfort due to noise, dirt, and dust.

- Must be able to perform computer-related work for extended periods of time.

- Mental ability to frequently handle pressures related to working on multiple projects requiring attention to detail.

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.