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