Data & Analytics Architect/ Engineer Job at Martineau Recruiting Technology, Columbus, OH

M3RNL2g3QmZpR3YrUk9Gdm5mZUVjakkxMmc9PQ==
  • Martineau Recruiting Technology
  • Columbus, OH

Job Description

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. They’ll be leveraging Azure SQL and Microsoft Fabric, Data Factory, etc. They're a small (<20 FTE's) I.T. department where you'll play a couple different roles so are seeking those that have worked in smaller shops and enjoy the variety.

This is truly a ground floor opportunity as they’ve just implemented Oracle’s 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

Job Tags

Similar Jobs

Intersport

Account Exec., or Senior Account Exec., Sponsorship & Experiential Marketing Job at Intersport

 ...Background Location: Hybrid work-from-home and office: 303 E Wacker Dr., Suite 2200, Chicago, IL Type: Full-time, permanent position Division: Agency Services Reports to: Account Director Agency Services Overview Intersport is an award-winning agency... 

Sysco

CDL A Backhaul Delivery Truck Driver Part-Time Job at Sysco

JOB SUMMARYSysco is the global leader in foodservice distribution. With over 67,000 associates and a fleet of over 13,000 vehicles, Sysco operates approximately 330 distribution facilities worldwide and serves more than 600,000 customer locations. We are looking ...

AIS Healthcare

Home Infusion Billing Specialist Job at AIS Healthcare

 ...looking for an experienced and motivated Home Infusion Biller to join our dynamic team!...  ...is a full-time position responsible for billing process for our IG division. The perfect...  ...provider will receive reimbursement for medical services rendered. EDUCATION AND EXPERIENCE... 

Infinity Quest UK

Sr Azure Data Factory Engineer Job at Infinity Quest UK

 ...Data Engineering Processing Design and implement scalable data ingestion pipelines from diverse sources including APIs SharePoint onpremise...  ...AI agents for workflow automation Cloud Data Platforms Azure Build and maintain solutions using Azure Data Factory... 

Capital One

Lead Full Stack Software Engineer (Java, AWS) Job at Capital One

 ...Bachelors Degree ~ Minimum 4 years of professional experience in software engineering (Internship experience does not count)~ At least...  ...a variety of technology projects while leading a team of developers proficient in distributed microservices and full stack systems...