Martineau Recruiting Technology
Data & Analytics Architect/ Engineer (Columbus)
Martineau Recruiting Technology, Columbus, Ohio, United States, 43224
Our client is a leader in the Mechanical Construction + Construction Services industry, bringing talented Mechanical, Electric and Plumbing resources to large-scale construction projects (i.e. Hospitals, Universities, etc.).
They're currently consolidating several business units I.T. resources, into a single centralized organization and seeking to move from current Enterprise Reporting solutions to a cloud-based Data & Analytics approach. Theyll be leveraging Azure SQL and Microsoft Fabric, Data Factory, etc. They're a small ( This is truly a ground floor opportunity as theyve just implemented Oracles Enterprise Performance Management software running in Azure and will be looking to build out their enterprise analytics solutions.
More specifically, you'll lead the architecture and design of their future state Data & Analytics solutions: Architect and support scalable data solutions leveraging Microsoft Azure + Fabric Lead the design and development of ETL/ ELT processes Engage/ collaborate with Finance, Operations to identify needs, establish KPIs and translate them into dashboards, report and technical solutions Develop, manage and optimize Power BI reports + dashboards Establish best practices around data governance, security and compliance issues Oversee Data Quality Mgmt., metadata documentation and process improvements Monitor system performance, database tuning and query optimization
SERIOUS CANDIDATES MUST HAVE: US Citizen or Green Card Holder (Absolute MUST!) Data Modeling and Data Warehouse design background Extensive Azure SQL database/ data warehouse experience Advanced Power BI report/ dashboard development- Proven track-record leveraging Microsoft Fabric, Data Factory, Azure, etc. Strong ETL/ ELT development -pulling data from CRM, ERP, etc sources Analytics for financial operations (Financial reporting standards, processes, etc.)
PREFERRED EXPERIENCE A PLUS: Mechanical Construction (HVAC, Electrical, Industrial Plumbing) and/ or Construction Service industry background Experience implementing data governance, data security and compliance practices
They're currently consolidating several business units I.T. resources, into a single centralized organization and seeking to move from current Enterprise Reporting solutions to a cloud-based Data & Analytics approach. Theyll be leveraging Azure SQL and Microsoft Fabric, Data Factory, etc. They're a small ( This is truly a ground floor opportunity as theyve just implemented Oracles Enterprise Performance Management software running in Azure and will be looking to build out their enterprise analytics solutions.
More specifically, you'll lead the architecture and design of their future state Data & Analytics solutions: Architect and support scalable data solutions leveraging Microsoft Azure + Fabric Lead the design and development of ETL/ ELT processes Engage/ collaborate with Finance, Operations to identify needs, establish KPIs and translate them into dashboards, report and technical solutions Develop, manage and optimize Power BI reports + dashboards Establish best practices around data governance, security and compliance issues Oversee Data Quality Mgmt., metadata documentation and process improvements Monitor system performance, database tuning and query optimization
SERIOUS CANDIDATES MUST HAVE: US Citizen or Green Card Holder (Absolute MUST!) Data Modeling and Data Warehouse design background Extensive Azure SQL database/ data warehouse experience Advanced Power BI report/ dashboard development- Proven track-record leveraging Microsoft Fabric, Data Factory, Azure, etc. Strong ETL/ ELT development -pulling data from CRM, ERP, etc sources Analytics for financial operations (Financial reporting standards, processes, etc.)
PREFERRED EXPERIENCE A PLUS: Mechanical Construction (HVAC, Electrical, Industrial Plumbing) and/ or Construction Service industry background Experience implementing data governance, data security and compliance practices