Data Engineer / Business Intelligence Specialist

Kalsec•Kalamazoo, MI

2d•Onsite

About The Position

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.

Requirements

Bachelor’s degree with 2-4 years related experience or equivalent combination of education and experience.
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.

Nice To Haves

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.

Responsibilities

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.
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.