Mastec Inc

Sr Systems Engineer

Mastec Inc$90K — $120K *
Fargo, ND 58103In-Person
Enterprise Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science or related field
  • 5-7 years of experience in SQL development and enterprise systems support
  • Proven ability in writing complex T-SQL queries and designing scalable database solutions
  • Experience in designing and supporting ETL processes and data pipelines
  • Advanced proficiency in SQL development and database engineering

Responsibilities

  • Design, develop, and maintain SQL solutions for business operations and reporting
  • Write and optimize complex queries for data manipulation
  • Ensure data consistency through sound database design principles
  • Administer SQL Server environments and ensure compliance with standards
  • Lead development and implementation of ETL processes using various tools
  • Design and implement data extraction and loading methods
  • Provide technical leadership and mentorship to a team; set standards for system design

Benefits

  • Competitive pay with performance review and merit increases
  • 401(k) with company match and Employee Stock Purchase Plan (ESPP)
  • Flexible spending account options for healthcare and dependent care
  • Comprehensive medical, dental, and vision insurance
  • Paid time off and paid holidays
  • Employee Assistance Program for personal support
  • Short and long-term disability and life insurance options
Full Job Description
Overview

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.

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

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

Qualifications

Work Experience and Education
  • 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


Knowledge, Skills and Abilities
  • 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
  • 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)


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

About Mastec Inc

MasTec is an infrastructure engineering and construction company that serves the utility, communications, and government industries. The company is specialized in the engineering, building, installation, maintenance, and upgrade of energy, utility, and communications infrastructure, including electrical utility transmission and distribution; power generation; natural gas and petroleum pipelines; wireless, wireline, and satellite communications; wind and solar farms; and water and sewer systems. MasTec was founded in 1994 and is based in Coral Gables, Florida.

Mastec Inc Careers

Join the dynamic team at Mastec Inc, a leader in infrastructure construction, where innovation meets professional excellence, creating a thriving environment for career growth. At Mastec Inc, we are committed to building a diverse and inclusive workforce, reflecting our dedication to leadership and innovation in the industry.

Work You'll Do

At Mastec Inc, you'll be part of a company that values your skills and supports your professional growth. Our team is at the forefront of the construction industry, leading projects that redefine landscapes and communities. With Mastec Inc, your work will not only be challenging and rewarding but also pivotal in shaping the future of infrastructure.

Explore Job Opportunities

Whether you're a seasoned professional or just starting your career, Mastec Inc offers a range of job opportunities and employment paths, including full-time positions and internships. Our hiring process is designed to be transparent and engaging, ensuring that every candidate is equipped to succeed from the interview through to their long-term career journey.

Innovate and Lead

Join a culture of innovation where your ideas can lead to significant advancements in construction methods and technologies. Mastec Inc encourages a culture of leadership and continuous improvement, where every team member is a key player in driving success.

Grow With Us

Career growth at Mastec Inc is not just a possibility—it's a priority. We are dedicated to providing professional development and diversity training that ensures every employee has the tools to advance and excel. From networking opportunities within the industry to leadership training programs, your potential for growth is limitless.

Benefits and Culture

Mastec Inc is proud to offer competitive benefits that support the health, well-being, and financial security of our employees and their families. Our culture is built on a foundation of respect, integrity, and commitment, making Mastec Inc not just a great place to work, but a community.

Internship Programs

Kickstart your career with a Mastec Inc internship, where you can apply your academic knowledge in a real-world setting. Gain invaluable experience, develop essential industry skills, and build a network of professional contacts. Our internships provide a robust platform for learning and growth, setting the stage for a successful career.

Join Our Team

Ready to take the next step in your career? Explore the open positions at Mastec Inc and find where your skills, passion, and ambitions can make a difference. We are continuously looking for curious, creative, and solution-driven team players who are ready to drive innovation and excellence in the construction industry.

Stay Connected

Keep up to date with the latest at Mastec Inc through our careers blog. Gain insider perspectives, industry-leading insights, and career tips that you can put to use today—all from the people who work here.

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding opportunities that await at Mastec Inc. At Mastec Inc, we're not just building projects—we're building careers. Join us and be part of a team that's setting new standards in the construction industry.
Learn more about Mastec Inc
Size
27,000 employees
Market Cap
$6.4 billion
Industry
Net Income
$322.8 million
Founded
1929
5 Year Trend
+9.1%
Revenue
$6.3 billion
NASDAQ

Similar Jobs

More Jobs at Mastec Inc

More Enterprise Technology Jobs

Find similar Sr Systems Engineer jobs: