Data Engineer

The ITG division of the National Association of Insurance Commissioners (NAIC) has an exciting opportunity for a Data Engineer. The Data Engineer designs, builds, and maintains scalable data solutions that support a SAAS application, analytics, and reporting. This role partners closely with business and technical stakeholders to ensure data is accurate, secure, and delivered efficiently. The position contributes to data architecture, integration, and migration efforts. This is a full-time hybrid position. Residency within a 100-mile radius of the Kansas City office is required.

Responsibilities Include:

• Design, develop, test, and maintain data pipelines, ETL processes, and data storage solutions

• Develop and maintain data migration scripts, mappings, and validation processes

• Collaborate with business and technical partners to gather and document data requirements

• Ensure data quality, integrity, security, and performance across source and target systems

• Support analytics and data warehouse platforms, including data marts and data lakes

• Monitor, troubleshoot, and resolve production data issues and performance concerns

Management Responsibilities:

This position does not have direct reports.

Minimum Education and/or Experience Required:

• Bachelor's degree in Computer Science, Data Analytics, Data Science, Computer Science, Software Engineering, Mathematics/Statistics, or related field, or equivalent experience

• 3 years of experience working with relational databases and SQL

• Experience with data integration, ETL processes, and the software development lifecycle

Preferred Experience:

• Master's degree in a related analytical or technical field

• Experience with cloud-based data technologies and modern data platforms

• Experience with data warehouse architecture and analytics solutions

• AWS Cloud Practitioner or similar certification

Systems & Technology Requirements:

• SQL and relational database management systems (RDBMS)

• Snowflake

• ThoughtSpot

• Data Cataloging and Governance tools (Atlan)

• ETL tools (e.g., Informatica or similar)

• Data Visualization (Tableau/Power BI)

• Gitlab

• Programming or scripting languages such as Python or Java

• Cloud platforms and data services

• Microsoft Office / Microsoft 365

Travel:

This position does not require overnight business travel. Employees are responsible for their personal transportation to/from the home and office, including events, meetings, and training required by the NAIC.

Compensation:

$93,000- $110,000 commensurate with education and experience.

Sponsorship:

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.