Sr Systems Engineer

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.

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

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

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…