Senior Data Engineer / ETL Developer for Multi-Source CRM Data Warehouse + Power BI Reporting

We are looking for an experienced Senior Data Engineer / ETL Developer to help us build a centralized data layer / data warehouse for reporting across multiple business systems. Project overview We currently use multiple platforms, including: ServiceM8 GoHighLevel CallRail We want to build a middle data layer / warehouse architecture so that all source systems feed into a centralized database, and Power BI connects only to that central data source. Target architecture ServiceM8 / GoHighLevel / CallRail APIs → ETL / Data Integration Layer → SQL Database / Data Warehouse → Power BI What we need We need someone who can help design and/or build the data integration layer and warehouse so the system is: stable scalable easy to maintain suitable for long-term operational reporting ready for Power BI dashboards capable of supporting near real-time or frequent refreshes where possible Scope of work The ideal person should be able to: connect to multiple APIs build automated ETL / ELT pipelines handle authentication, token refresh, and refresh reliability extract and normalize data from different systems standardize fields and KPI definitions across platforms design and build SQL tables, views, and reporting-ready models support historical data tracking reduce API dependency issues and refresh failures recommend the best database / cloud setup support future integrations with additional systems help define source-of-truth logic for KPIs and employee data prepare the structure so Power BI can sit on top cleanly Preferred technical experience We are open to recommendations, but experience with some of the following would be valuable: SQL Server / Azure SQL / Microsoft Fabric / PostgreSQL API integrations ETL / ELT pipelines Azure Data Factory, Fabric, dbt, Python, or similar tools data warehouse design Power BI data modeling support CRM / operational reporting integrations handling multiple SaaS system integrations Nice to have experience with ServiceM8, GoHighLevel, or CallRail APIs experience building operational KPI dashboards experience supporting employee rankings / performance reporting experience with near real-time reporting architecture Deliverables At minimum, we want help with: recommending the best warehouse / platform setup designing the data model and architecture building the API integrations and refresh process creating the reporting-ready SQL layer documenting the structure and pipeline logic making the system ready for Power BI dashboard development Project notes The dashboard itself is not the main unknown. The bigger challenge is the data integration complexity, API limitations, data quality, and architecture decisions, so we are specifically looking for someone strong on the data engineering / warehouse side, not just dashboard visuals. To apply, please include a short summary of similar projects you’ve done what stack you would recommend for this project whether you would use Azure SQL, SQL Server, Fabric, PostgreSQL, or another approach how you would structure the ETL / warehouse layer examples of API-to-warehouse projects you’ve built your experience preparing multi-source data for Power BI