Data Integration Specialist

Data Integration Specialist - Holland, MI

DISHER is currently partnering with Holland Board of Public Works to find their next Data Integration Specialist. 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.

What it's like to work here :

Community-owned utility since 1893, their to top priority is taking care of the essentials for people right here in Holland. Serving their neighbors, family and friends, there is no stronger driver of their standards of excellence. Their reliable, efficient utility infrastructure and services empower our community for advancement and self-determination.

We are a local not-for-profit utility that builds and maintains infrastructure and reliable utility services. We strive to be exemplary stewards of the resources entrusted to us. We aim to be an employer of choice, bringing 180 skilled and professional jobs to our community. Holland is located on the beautiful shores of Lake Michigan and is located in one of Michigan's fastest-growing industrial and residential areas.

What you will get to do :

• 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 Fortra 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. o 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.

What will make you successful :

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.