BI Engineer
Core
Design, build, and maintain data pipelines and models to power dashboards, KPIs, analytics products, automation workflows, and AI agents.
Role type
Senior BI Engineer (Data Engineering & Platform Modernization)
Builds
Data lake, SQL layer, BI platform, automation workflows, and AI agent data sources
Domain
IT Services / MSP / Professional Services
Required skills
SQL, ETL/ELT pipeline development, REST API integration, Python, PowerShell, Data modeling, Data quality monitoring
Preferred skills
Microsoft Fabric, Azure Synapse, Azure Data Factory, Power BI, ConnectWise PSA, NetSuite, HubSpot, Workflow automation (Power Automate), AI/LLM data integration, Post-merger data consolidation
Technologies
Azure Cloud, Data Warehouse, ETL, Fabric, HubSpot, LLM, Power BI, PowerShell, Python, REST, RPA, SQL
Responsibilities
Design and maintain pipelines bringing data from source systems into the data lake and SQL layer; Lead technical work to modernize the BI platform and retire legacy pipelines; Partner with business leaders to translate reporting needs into data models; Monitor pipeline health and resolve data quality issues; Build and support back-end integrations and APIs for automation and AI agents; Support data migration and system integration for acquired companies; Document data sources and pipelines.
Seniority
Senior, hands-on IC