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 its 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 Michigans 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 technology stack including backend services and application development.
- Design and implement 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:
- Bachelors degree in Computer Science Database Administration or related field; or equivalent education and experience.
- Extensive Microsoft SQL Server experience.
- Experience programming and .
- 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
- 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).
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.
Required Experience:
IC
Data Integration Specialist - Holland MIDISHER 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 ...
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 its 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 Michigans 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 technology stack including backend services and application development.
- Design and implement 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:
- Bachelors degree in Computer Science Database Administration or related field; or equivalent education and experience.
- Extensive Microsoft SQL Server experience.
- Experience programming and .
- 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
- 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).
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.
Required Experience:
IC
View more
View less