Senior Data Architect

Clean Energy & Infrastructure Services; West Fargo (ND); On-site; USD 130,000 - 180,000; Full time

Benefits offered by this job

401(k) with company match

Employee Stock Purchase Plan (ESPP)

Healthcare, Dental, Vision insurance

Flexible spending account (FSA)

Job summary

Clean Energy & Infrastructure Services is seeking a Senior Data Architect to design and govern data integration across on-prem and cloud environments. You will lead a small team while collaborating with program managers, business groups, and IT support to ensure scalable, secure data architecture and reporting solutions.

The role emphasizes SQL, data warehousing, Power BI, and governance, with a focus on enterprise data standards and efficient data flows.

Qualifications

• Bachelor's degree in computer science or computer/management information systems.
• 7–10 years related experience and/or training.
• Extensive experience maintaining and supporting production systems and infrastructure.
• Experience with SQL administration and database design.
• Experience with SharePoint and Power Apps suite, especially Power BI.
• Excellent communication, planning and problem-solving skills.

Responsibilities

• Design and develop data integration strategies and solutions for complex projects or business issues.
• Collaborate with cross functional teams to plan and develop solutions to support a continually evolving construction organization.
• Work with stakeholders at different levels in the organization.
• Manage and automate data flow.
• Organize data and optimize data retrieval.
• Determine requirements for data design.
• Create roles and procedures to ensure data integrity and security.
• Develop and maintain data warehouse.
• Operate and optimize: ensure customer satisfaction by providing highly-available, performant systems.
• As subject matter expert, ensure project teams follow data architecture standards.
• Develop ETL processes with Azure Data Factory and similar tools.
• Oversee a team of 2-4 employees.
• Manage staffing, including recruitment, communication of job expectations, supervision, employee development, evaluation and disciplinary actions.
• Conduct employee reviews annually or as needed and recognize and celebrate staff contributions.
• Other duties as assigned

Skills

SQL administration

Power BI

SharePoint

Power Apps

Data modeling

Analytical thinking

Education

Bachelor's degree in Computer Science or MIS

Tools

Azure Data Factory

SQL Server

ETL tools

Job description

Senior Data Architect

US-ND-Fargo

Overview

As a Senior Data Architect, you will be responsible for our business-critical systems (on-prem and cloud). This highly visible role will have you working closely with other disciplines including program managers, project managers, business groups, and IT support teams. You will need an excellent combination of relevant technical knowledge, cross-group collaboration skills, communication and negotiation skills, relationship-building skills, and planning skills. You will also need a sense of urgency to get things done efficiently, working both independently and as part of a team. You understand the need for implementing and following processes to support enterprise systems.

Company Overview

MasTec's Clean Energy & Infrastructure (CE& I) segment generates more than $4.5 billion in annual revenue, providing construction services across three operating groups: Renewables, Industrial & Infrastructure and General Building. Our Renewables expertise includes solar, wind, energy storage, aftermarket services, substations and switchyards. Our Industrial expertise includes manufacturing, mining and mineral processing, power plants, conventional power generation, alternative fuel generation and other innovative solutions. In Infrastructure, we specialize in electrical, environmental, highways, roads and bridges, aggregate mining, ports and terminals, rail, pump and lift stations, water transmission and pipelines, water and wastewater treatment plants, and stormwater. Our General Building expertise includes airports, seaport terminals, sports and entertainment, pre-engineered metal buildings, and data centers.

MasTec, a minority-owned Fortune 500 company, has shaped the construction industry for more than 90 years. With over 35,000 employees and 400 offices nationwide, we provide flexibility and career growth in dynamic work environments. Sustainability and safety are foundational to our culture and influence everything we do.

Our company is experiencing rapid growth and provides numerous opportunities for qualified, talented, and motivated professionals. As a member of the MasTec team, you will engage in exciting new projects and benefit from a culture that prioritizes professional development and support for skill enhancement. We foster a creative and innovative environment that is, above all, supportive. Our goal is to cultivate a respectful workplace where all employees feel valued, included, and empowered to become innovative leaders in our industry.

The Clean Energy & Infrastructure Group comprises the following market sectors and operating companies: Renewables: IEA Constructors, Wanzek Construction, White Construction; Industrial: Casey Industrial, Phoenix Industrial, MasTec Industrial; Infrastructure: American Civil Constructors West Coast, Cash Construction, FNF Construction, MasTec Civil, McKee Utility Contractors, Precision Aggregate Products, Ragnar Benson Construction, Saiia, William Charles Construction, William Charles Electric; General Building: Lemartec, NV2A.

Responsibilities

Essential Job Functions:

• Design and develop data integration strategies and solutions for complex projects or business issues
• Collaborate with cross functional teams to plan and develop solutions to support a continually evolving construction organization
• Work with stakeholders at different levels in the organization
• Manage and automate data flow
• Organize data and optimize data retrieval
• Determine requirements for data design
• Create roles and procedures to ensure data integrity and security
• Develop and maintain data warehouse
• Operate and optimize: ensure customer satisfaction by providing highly-available, performant systems
• As subject matter expert, ensure project teams follow data architecture standards
• Develop ETL processes with Azure Data Factory and similar tools
• Oversee a team of 2-4 employees
• Manage staffing, including recruitment, communication of job expectations, supervision, employee development, evaluation and disciplinary actions
• Conduct employee reviews annually or as needed and recognize and celebrate staff contributions
• Other duties as assigned

Qualifications

Education and Work Experience Requirements:

• Bachelor's degree (BA/BS) in computer science or computer/management information systems
• 7-10 years related experience and/or training or equivalent combination of education and experience
• Knowledge, Skills and Abilities Required:
• Take reasonable care of your own and others' health and safety and of those who may be affected by the day-to-day delivery of this role by taking personal responsibility for working toward the Company's Zero Injury principles
• Extensive experience maintaining and supporting production systems and infrastructure
• Highly skilled at SQL administration and database design
• Experience with SharePoint and Power Apps suite, especially Power BI
• Excellent analytical and creative problem-solving skills
• Experience with waterfall and agile models for system development
• Excellent communication and relationship-building skills
• Excellent planning skills
• Strong negotiation skills
• Ability to work independently
• Logical and efficient, with a keen attention to detail

Work Environment & Physical Requirements

• When visiting jobsites the work environment involves some exposure to hazards or physical risks, which require following basic safety precautions
• This work environment may involve moderate exposure to unusual elements, such as extreme temperatures, dirt, dust, fumes, smoke, unpleasant odors and/or loud noises

What's in it for You

Financial Wellbeing

• Competitive pay with ongoing performance review and merit increase
• 401(k) with company match & Employee Stock Purchase Plan (ESPP)
• Flexible spending account (Healthcare & Dependent care)

Health & Wellness

• Medical, Dental, and Vision insurance (plan choice) - coverage for spouse, domestic partner, and children
• Diabetes Management, Telehealth Coverage, Prescription Drug Plan, Pet Insurance, Weight Management Drug Discount
• Discounted National Gym Membership Network

Family & Lifestyle

• Paid Time Off, Paid Holidays, Bereavement Leave
• Military Leave, including Benefits Continuation
• Employee Assistance Program

Planning for the Unexpected

• Short and long-term disability, life insurance, and accidental death & dismemberment
• Voluntary life insurance, accident, critical illness, hospital indemnity coverage
• Emergency Travel Assistance Program
• Group legal plan

Position may be subject to pre-employment screening, which may include background check and drug testing. Accessibility: If you need accommodation as part of the employment process, contact [e-mail].

MasTec, Inc. is an Equal Employment Opportunity Employer. The Company's policy is not to unlawfully discriminate against any applicant or employee on the basis of race, color, sex, sexual orientation, gender identity, religion, national origin, age, disability, genetic information, military status, or any other consideration made unlawful by applicable federal, state, or local laws. The Company also prohibits harassment of applicants and employees based on any of these protected categories. It is also MasTec's policy to comply with all applicable state, federal and local laws respecting consideration of unemployment status in making hiring decisions.

Service Line

CEISV-CE&I Services LLC