Senior Data Engineer - SQL Pipelines

Inserso; United States; On-site; USD 150,000 - 210,000; Full time

Job summary

Inserso seeks a hands-on Senior Data Engineer to design, build, and troubleshoot SQL-based data pipelines supporting mission-critical DevSecOps operations for the Air Force Reserve Command at Robins AFB. This role focuses on production pipelines, not reporting, with ownership of performance, reliability, and scalability across NIPR/SIPR using SQL Server, C#/.NET microservices, and scheduling frameworks.

You will work with a team to optimize ETL/ELT processes, implement data warehousing

Qualifications

• US citizen is required.
• Bachelor's degree in computer science or related field or equivalent experience.
• Must meet DoD 8140 compliance with required certification (e.g., Security+). If not currently held, must obtain before agreed date.
• Active DoD Secret clearance or ability to obtain/maintain one.
• 7+ years of software/data engineering with .NET/C# focus.
• Deep SQL Server understanding and performance tuning.

Responsibilities

• Build and maintain end-to-end production data pipelines (ETL/ELT) for large datasets.
• Write and optimize complex SQL, including stored procedures, CTEs, and window functions.
• Design and maintain SQL Server databases, including procedures, triggers, and views.
• Diagnose data inconsistencies and bottlenecks in production environments.
• Implement data warehousing strategies and incremental load patterns.
• Ensure database security across NIPR/SIPR environments.

Skills

Strong SQL

ETL/ELT design

SQL Server 2016+

C#/.NET

Data warehousing

DoD compliance awareness

Education

Bachelor's in CS or related field

Equivalent experience

Tools

SQL Server 2022

Azure cloud

Power BI

Job description

Inserso is seeking a hands-on Senior Data Engineer to design, build, and troubleshoot SQL-based data pipelines supporting mission-critical DevSecOps operations for the Air Force Reserve Command at Robins AFB. This role is focused on building and maintaining production data pipelines — not reporting or dashboard development. The ideal candidate has strong SQL coding skills, hands-on experience working with large datasets, and a proven track record of diagnosing and resolving complex data issues in operational environments. This position requires someone who can go beyond writing queries and take full ownership of data pipeline performance, reliability, and scalability across both NIPR/SIPR environments. Pipelines in this environment are code-first, built using SQL Server, C#/.NET microservices, and scheduling frameworks.

Responsibilities

• Build and maintain end-to-end data pipelines (ETL/ELT) that move, transform, and load large-scale datasets reliably in production environments.
• Write and optimize complex SQL using stored procedures, CTEs, window functions, and performance tuning techniques.
• Design, develop, and maintain SQL Server 2016+ databases including stored procedures, functions, triggers, views, and other database objects.
• Diagnose and resolve data inconsistencies, failed pipeline jobs, and performance bottlenecks in production environments.
• Design and implement data warehousing solutions, including incremental load strategies, staging patterns, and large-volume data handling.
• Implement and maintain database security measures to protect sensitive data across NIPR/SIPR environments.
• Troubleshoot and resolve database-related issues in both production and development environments.
• Collaborate on data modeling decisions including normalized vs. denormalized schema design.
• Participate in code reviews and ensure adherence to coding standards and best practices.
• Mentor junior developers and provide technical guidance on SQL Server development and pipeline engineering.
• Collaborate with application developers, system administrators, and stakeholders to deliver effective data solutions.
• Contribute to pipeline documentation, runbooks, and data architecture documentation.
• Support the team's ongoing migration to Azure cloud infrastructure as the effort progresses.

Required Skills/Experience

• Must be a U.S. Citizen.
• Bachelor's degree in computer science or an IT-related discipline or equivalent experience.
• Must meet DoD 8140 compliance through required certifications for elevated network privilege (e.g., CompTIA Security+). If the candidate doesn't already possess, must be willing to obtain it prior to an agreed upon date.
• Holds a current active DoD Secret clearance or have the ability to obtain and maintain a DoD Secret clearance.
• 7+ years of experience in software development, with a focus on .NET and C#.
• Deep understanding of SQL Server architecture, including database engine, storage engine, and query processor.
• Extensive experience with T-SQL, stored procedures, functions, triggers, and views.
• Proficiency in SQL Server 2022.
• Strong understanding of indexing strategies, query optimization, and performance tuning.
• Solid understanding of relational database design principles and normalization techniques.
• Experience designing and implementing complex database schemas.
• Proven ability to identify and resolve performance bottlenecks in SQL Server databases.
• Experience using performance monitoring tools and techniques.
• Experience designing and implementing ETL processes using SQL.
• Understanding of data warehousing concepts and methodologies.
• Strong understanding of database security principles and best practices.
• Experience implementing and maintaining database security measures.

Preferred Skills/Experience

• Experience with cloud-based database solutions (e.g., Azure SQL Database, AWS RDS).
• Experience with NoSQL databases.
• Experience with database administration tasks.
• Experience with Agile development methodologies.
• SQL Server certification (e.g., Microsoft Certified: Azure Data Engineer Associate).
• Experience with data visualization tools such as Power BI or Tableau.
• Experience with Python/PySpark.

Physical and/or Mental Qualifications

• Excellent communication, interpersonal, and collaboration skills.
• Ability to effectively communicate technical concepts to both technical and non-technical audiences.
• Ability to work independently and as part of a team.
• Ability to prioritize tasks and manage time effectively.
• Ability to adapt to changing priorities and requirements.