Sr Systems Engineer

CEI Services•Fargo, ND

1d•Onsite

About The Position

Responsible for leading the ongoing development, support, and optimization of critical business data systems and reporting platforms, both on-premises and in the cloud. As a senior member of the team, this role plays a vital part in driving the success of enterprise data solutions by designing robust SQL-based architectures, developing ETL pipelines, and ensuring the integrity, availability, and performance of business-critical systems. This position works closely with Program Managers, Project Managers, business groups, and IT support teams, requiring a strong combination of technical expertise, cross-functional collaboration, communication, and planning skills. A deep understanding of SQL development, database administration, data architecture principles, and systems integration is essential to success in this role. 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.

Requirements

Bachelor's degree in Computer Science or Computer/Management Information Systems
5–7 years of related experience and/or training, or equivalent combination of education and experience, with specific focus on SQL development, database administration, and enterprise systems support
Proven experience writing complex T-SQL queries and designing scalable database solutions
Demonstrated experience designing and supporting ETL processes and data pipelines
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
Advanced proficiency in SQL development and database engineering, with a strong command of query design, performance tuning, and database administration
Deep understanding of data modeling, schema design, and database best practices to ensure data integrity, security, and reliability
Solid experience with ETL design and development, including data extraction, transformation, loading, pipeline orchestration, and performance optimization
Familiarity with ETL and data integration tools such as Azure Data Factory (ADF) and SSIS
Highly proficient using Power Platform tools (Power Apps, Power Automate, Power BI) for building business solutions and generating insights
Skilled in use of reporting technologies such as SSRS and Crystal Reports
Proficient in scripting languages such as PowerShell and Python for task automation and process optimization
Demonstrated ability to mentor engineers, and drive adoption of engineering standards and best practices
Excellent analytical and creative problem-solving skills with a logical, detail-oriented approach
Working knowledge of project management methodologies including waterfall and agile
Excellent written and oral communication skills with the ability to convey complex technical concepts to both technical and non-technical stakeholders
Strong relationship-building, planning, and negotiation skills
Ability to work both independently and collaboratively as part of a team
Willingness and ability to travel as required for project implementation, training, or client support

Nice To Haves

Experience with Oracle Database administration and development, including schema design, performance tuning, and Oracle-specific features
Proficiency in PL/SQL programming, including packages, procedures, functions, cursors, and exception handling
Familiarity with Oracle-specific query optimization techniques and execution plan analysis
Experience migrating or integrating Oracle-based systems with SQL Server or cloud-based data platforms
Knowledge of Oracle tools such as SQL Developer, TOAD, or Oracle Data Integrator (ODI)

Responsibilities

Design, develop, and maintain complex SQL-based solutions including stored procedures, functions, triggers, views, and advanced T-SQL queries to support business operations and reporting needs
Write and optimize complex queries across the full spectrum: joins, aggregations, subqueries, set operations, and data manipulation
Enforce constraints, referential integrity, and sound database design principles to ensure data consistency and reliability
Perform indexing strategy design, execution plan analysis, and query performance tuning to maintain high-availability, performant systems
Administer SQL Server environments including security, user roles, permissions, and compliance with data governance standards
Lead the development and implementation of data integration strategies and ETL processes using tools such as Azure Data Factory (ADF), SSIS, Oracle Data Integrator (ODI) and similar platforms
Design and implement data extraction methods including batch, incremental, and change data capture (CDC) approaches
Develop data transformation and cleansing workflows ensuring validation, quality standards, and error handling throughout the pipeline
Define and manage data loading strategies (full load, incremental load) and oversee pipeline orchestration and scheduling
Perform ETL performance tuning and ensure pipeline reliability, scalability, and maintainability
Design and maintain data warehouse structures, ensuring sound data modeling and adherence to data architecture standards
Manage and automate data flow across enterprise systems, ensuring seamless interoperability and data integrity
Conduct thorough root cause analysis on system and data issues, implement preventive measures, and manage critical incidents to minimize business impact
Create roles, permissions, and procedures to ensure data security and compliance with industry standards and regulations
Leverage scripting languages such as PowerShell and Python to automate tasks, streamline processes, and enhance operational efficiency
Utilize Power Platform tools (Power BI, Power Apps, Power Automate) to build business solutions and deliver meaningful reporting insights
Develop reports and dashboards using reporting technologies such as SSRS and Crystal Reports to support business decision-making
Provide technical leadership and mentorship to a team of Systems Engineers; set standards for system design, code quality, documentation, and operational excellence
Lead the design and review of advanced system architectures, ensuring solutions are scalable, resilient, secure, and aligned with industry best practices
Lead complex system and data projects from initiation to completion — defining scope, managing milestones, coordinating cross-functional stakeholders, and delivering within budget and timeline
Drive continuous improvement of system operations, ETL processes, and monitoring practices; identify automation opportunities and champion engineering efficiency
Foster a culture of knowledge sharing by creating and delivering technical training sessions, writing runbooks, and building onboarding materials for new team members
Communicate effectively with business stakeholders to understand system and data requirements; translate them into actionable technical specifications
Other duties as assigned

Benefits

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)
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
Paid Time Off, Paid Holidays, Bereavement Leave
Military Leave, including Benefits Continuation
Employee Assistance Program
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