About this role

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

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

Health insurance for yourself and your family – 100% employer paid for employee and 50% employer paid for dependents
Dental and Vision insurance for yourself and your family – 100% employer paid for employee and dependents
Life/AD&D Insurance for yourself – 100% employer paid and covers 100% of your salary
Short Term Disability for yourself – 100% employer paid and covers 60% of your weekly salary
Long Term Disability for yourself – 100% employer paid and covers 60% of your monthly salary
401k with 4% match
Flex-time and paid time off to promote a healthy work-life balance

Business Intelligence Analyst – Data Engineering Specialist

Key skills