Sr Systems Engineer

Senior Data Engineer

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

Qualifications:

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