Data & Analytics Architect/ Engineer

Martineau Recruiting Technology; Columbus (OH); On-site; USD 150,000 - 170,000; Full time

Job summary

A leading recruiting agency seeks a data solutions architect in Columbus, Ohio. This role involves designing ETL processes and collaborating with finance to develop reports and dashboards. Ideal candidates should have strong Azure SQL experience and a background in financial operations analytics. Competitive salary range is $150,000 to $170,000 per year with full-time employment.

Qualifications

• Must be a US Citizen or Green Card Holder.
• Experience in data warehouse design.
• Strong analytics background related to financial operations.

Responsibilities

• Architect scalable data solutions using Microsoft Azure.
• Lead design and development of ETL/ELT processes.
• Collaborate to identify needs and establish KPIs.

Skills

Data Modeling

ETL/ELT development

Azure SQL database

Power BI

Job description

Overview

Our client is a leader in the Mechanical Construction + Construction Services industry, bringing talented Mechanical, Electric and Plumbing resources to large-scale construction projects. They are consolidating several IT resources into a single centralized organization and moving from current Enterprise Reporting solutions to a cloud-based Data & Analytics approach. They will leverage Azure SQL and Microsoft Fabric, Data Factory, etc. It is a small IT department (<20 FTEs) where the role will involve multiple functions in a varied environment. This is a ground floor opportunity as they’ve just implemented Oracle’s Enterprise Performance Management software running in Azure and will be building out enterprise analytics solutions.

Responsibilities

• 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, reports and technical solutions
• Develop, manage and optimize Power BI reports + dashboards
• Establish best practices around data governance, security and compliance issues
• Oversee Data Quality Management, metadata documentation and process improvements
• Monitor system performance, database tuning and query optimization

Qualifications

• US Citizen or Green Card Holder (Absolute MUST!)
• Data Modeling and Data Warehouse design background
• Extensive Azure SQL database / data warehouse experience
• Strong ETL/ELT development - pulling data from CRM, ERP, etc sources
• Analytics for financial operations (Financial reporting standards, processes, etc.)

Preferred experience

• Mechanical Construction (HVAC, Electrical, Industrial Plumbing) and/or Construction Service industry background
• Experience implementing data governance, data security and compliance practices

Employment details

• Base pay range: $150,000.00/yr - $170,000.00/yr
• Employment type: Full-time
• Seniority level: Not Applicable
• Job function: Information Technology
• Industries: Construction