Business Intelligence Analyst – Data Engineering Specialist

Responsibilities

• Design and implement scalable, integrated data warehouse models incorporating data from Business Central and other sources

• Develop and maintain data pipelines using Python, SQL, and modern ETL tools

• Lead smaller client engagements, including requirements gathering and solution delivery

• Collaborate with reporting specialists to ensure data models support business KPIs and visualization needs

• Define and document transformation logic, data mappings, and warehouse specifications, adhere to modeling standards and governance practices

• Support report development in Power BI and Jet Reports as needed

• Troubleshoot data quality issues and optimize performance of data models

• Use GitHub for version control, collaboration, and documentation of data engineering workflows

Requirements

• 4+ years of experience in data engineering, BI development or related roles

• Experience with ERP data structures and warehouse modeling

• Proficiency in Python and SQL for data transformation and analysis

• Strong experience with Mage.AI, dbt, Microsoft SQL Server, Snowflake, or Microsoft Fabric

• Experience using GitHub for version control, collaboration, and workflow management

• Strong understanding of dimensional modeling and the Kimball methodology

• Experience with documentation, versioning, and data governance practices