Business Intelligence Data Engineer

Job Summary

The Data Engineer will be responsible for the full cycle of DW development, including analyzing business requirements, designing ETL processes, leveraging dimensional modeling to present data to the presentation layer for reporting, and providing post‑deployment support, including production support.

They will gather, collect, store, transform, and schedule (batch or real‑time) data pipelines, serving any visualization tools and evaluating BI/DW tools for incorporation into the data platform and educating stakeholders on their use.

• Work with business requirements to identify and understand source data systems; provide resolution for all data issues and coordinate with data analysts to validate requirements.
• Map source system data to data warehouse tables.
• Develop and perform tests and validate all data flows; prepare all ETL/ELT processes according to business requirements.
• Define and capture metadata and rules associated with ETL processes.
• Adapt ETL processes to accommodate changes in source systems and new business user requirements.
• Collaborate with all developers and business users to gather required data, execute ETL programs and scripts, and implement all data warehouse activities and produce reports.
• Provide support and maintenance on ETL processes and documentation.
• Build partnerships across application, business, and infrastructure teams.
• Strive to continuously improve software delivery processes and practices.
• Champion company standards and best practices.

• Accountable for properly following all IT standards, processes, and methodologies, including but not limited to Quality Assurance (QA).
• Other responsibilities and accountabilities may be assigned based on business and organization needs.

Regular travel requirements (