Sr Systems Engineer

Data Systems And Reporting Platform Lead

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.

This position is onsite in Fargo or Miami, with a remote option available for candidates located outside those areas.

Mas Tec'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.

Mas Tec, 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 Mas Tec 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, Mas Tec industrial; infrastructure:
American civil constructors west coast, cash construction, FNF construction, Mas Tec civil, McKee utility contractors, precision aggregate products, Ragnar Benson construction, Saiia, William Charles construction, William Charles electric; general building:
Lemartec, NV2A.

• 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…