Data Engineer - Kalamazoo, MI

Role overview

Data platform and integration

• Design and maintain SQL databases, data warehouses, data structures, queries, stored procedures, views, and database objects.
• Administer and tune enterprise database environments; troubleshoot performance, availability, and reliability issues.
• Build scalable data models for operational and analytical workloads.
• Develop ETL/ELT processes and pipelines; move data across systems through APIs, middleware, file transfers, and integration platforms.
• Automate data import, export, transformation, and validation; troubleshoot integration issues and participate in migrations and modernization.

Modern platforms and collaboration

• Assist with Microsoft Fabric implementation, administration, and support; maintain enterprise data lake and lakehouse environments.
• Evaluate technologies and contribute to architecture for analytics, automation, and AI, including ontologies, semantic models, and business definitions.
• Gather and translate business requirements; participate in planning, solution design, testing, and implementation.
• Provide architecture and integration recommendations and support users with data issues and service requests.

Governance and improvement

• Support governance, metadata management, data quality, security, privacy, and regulatory compliance; maintain technical documentation and operational standards.
• Participate in project and change management and incorporate security in technical designs.
• Automate manual work, improve efficiency, support CI/CD, version control, testing, and reliable deployments, and participate in technology evaluation and cross-training.

Minimum education and experience

• Bachelor's degree in Computer Science, Information Systems, Data Science, Mathematics, Engineering, or a related field, or equivalent education and experience.
• 2–5 years of experience in data engineering, database development, data warehousing, or related technical work.
• Experience with Microsoft SQL Server, including SSIS; data integration; warehouses, dimensional models, and relational databases.
• Experience translating business requirements into technical solutions and using Python or another scripting language.

Skills and preferred knowledge

• Advanced SQL; relational database, warehousing, dimensional modeling, medallion architecture, and ETL/ELT knowledge.
• Knowledge of Power BI or similar BI tools; analytical and troubleshooting skills; clear written and verbal communication and ability to explain technical topics to nontechnical audiences.
• Microsoft Fabric, data lakes or lakehouses, Databricks, or Snowflake experience is considered.
• API design and integration, Azure data platforms, governance, metadata management, DevOps, source control, and deployment experience are preferred.

Work location and environment

• Regular, predictable attendance at the Kalamazoo, Michigan office is required; the work environment is a normal office.
• The role involves significant computer work, meetings, and phone conversations.

Schedule

• Normal operating hours are Monday through Friday, 8:15 a.m. to 5 p.m.
• Some after-hours work may be needed for implementations and troubleshooting.

Security