Data Engineer / Business Intelligence Specialist

Kalsec Inc.; Kalamazoo (MI); On-site; USD 70,000 - 90,000; Full time

Job summary

Kalsec Inc. in Kalamazoo, Michigan is seeking a BI Specialist to develop and integrate multiple data sources for business intelligence solutions. This role involves collaborating with various teams to deliver insights and improve decision-making processes.

The ideal candidate will have a background in computer science, proficiency in SQL, and experience with tools like Power BI and Snowflake. The position requires both independent work and collaboration to enhance business operations.

Qualifications

• Bachelor's degree in Computer Science or related field required.
• Experience in Data Engineer, Data Analyst, or BI Developer roles preferred.
• Proficiency in writing SQL required.

Responsibilities

• Gather and document requirements for ETL processes.
• Collaborate with teams to design and deliver reporting solutions.
• Support deployment and maintenance of BI platforms.

Skills

SQL proficiency

Data analysis

Python for ETL development

Experience with Power BI

Understanding of data warehouse concepts

Problem-solving skills

Education

Education in Computer Science or related field

Tools

SAP Business Objects

Power BI

Snowflake

AWS

Job description

Overview

Job Summary
This role is responsible for developing and integrating data from multiple source systems, supporting the operation and reliability of the organization’s Business Intelligence (BI) platform. This role focuses on developing global reports, performing multi-system data mining, and ensuring high availability and performance of BI solutions. The BI Specialist works closely with the Director of Information Services, the Data Warehouse and Analytics Manager, Data Scientists, Data Analysts, business process owners, and other stakeholders. In this role, they identify business needs, recommend solutions, and design, implement, and support BI and analytics capabilities. These solutions deliver timely, actionable insights that enable faster and more informed business decisions.

Responsibilities include gathering requirements, designing dashboards and analytics solutions, and ensuring efficient data resource usage across global units.

Essential Job Responsibilities

Data Engineering & Analytics

• Gather and document requirements for ETL processes into SnowKAP (Kalsec Analytics Platform), the company’s cloud-based data warehouse, from a wide range of source systems.
• Collaborate with directors, managers, developers, and end users to design and deliver dashboards, metrics, reports, and analytics solutions.
• Analyze and evaluate business systems, workflows, and procedures to identify improvement opportunities.
• Ensure efficient and consistent use of data resources across global business units.
• Contribute to short- and long-term BI and analytics strategy development.
• Recommend improvements to enhance scalability, performance, and growth of the BI/KAP architecture.
• Develop and maintain semantic layers, metadata, reports, and report definitions.
• Research emerging data technologies to support future data management initiatives.
• Utilize BI and database platforms including SAP Business Objects, Cognos, Power BI, Tableau, DB2, Oracle, Teradata, MySQL, SAP HANA, PostgreSQL, and Snowflake.

BI Platform Operations

• Support deployment, monitoring, maintenance, enhancement, and upgrades of BI and SnowKAP systems.
• Develop and maintain global maintenance schedules for BI and data warehousing platforms.
• Establish best practices for issue resolution in a high-availability, 24/7 global environment.
• Troubleshoot BI tools and applications, and perform performance tuning.
• Ensure change management activities comply with organizational standards.
• Communicate regularly with executives, department leaders, and end users to support data-driven decision making.
• Design and deliver end-user training and documentation, and provide ongoing technical support.

Qualifications

Required

• Education in Computer Science, Computer Engineering, Information Systems, or a related field.
• Professional experience in one or more of the following roles: Data Engineer, Data Analyst, BI Developer (including Senior BI Developer), Business Objects Administrator, Business Systems Analyst, Technology Functional Lead, Programmer Analyst, or a closely related position.
• Proficiency in writing simple to complex SQL (Structured Query Language).
• Experience with SAP Business Objects and Power BI.
• Strong understanding of data warehouse concepts.
• Advanced proficiency in Python for ETL development.
• Hands-on experience with Snowflake.
• Experience with ERP systems, preferably Infor M3.
• Familiarity with AWS or other cloud platforms.
• Strong problem-solving and analytical skills.
• Ability to work independently as well as collaboratively in cross-functional team environments.
• Excellent written, verbal, and technical documentation skills.

Desired

• Experience designing, developing, and maintaining Python-based ETL processes to integrate data from multiple source systems.
• Proven ability to enhance and optimize existing ETL applications to support new integrations and improve performance.
• Experience managing, monitoring, and optimizing data pipelines within Snowflake.
• Knowledge of data quality, security, and scalability best practices in cloud environments (AWS preferred).
• Experience building new dashboards and migrating legacy SAP Business Objects reports to Power BI.
• Strong collaboration skills with business stakeholders to design intuitive, actionable BI solutions.
• Hands-on experience extracting and transforming data from ERP systems such as Infor M3 for analytics and reporting.
• Snowflake certification.
• Experience modernizing or migrating legacy BI platforms to cloud-based or modern analytics solutions.

Working Conditions

• On-call availability
• Overtime hours may be required
• Sitting for extended periods of time
• Dexterity of hands and fingers to operate a computer keyboard, mouse, and other devices
• Ability to lift computers, monitors, and other peripherals