Data Engineer Associate

About this role

<p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> AIR’s Tek Office is seeking a motivated <strong>Data Engineer Associate</strong> to join our collaborative data and analytics team. The  Data Engineer Associate will support the design, development, and maintenance of scalable data pipelines and contribute to building modern data platforms that enable business intelligence, analytics, and reporting. This role is ideal for an early-career professional with a foundational understanding of data engineering principles and hands-on experience (academic or professional) with Microsoft Azure and Microsoft Fabric tools. The position offers opportunities for mentorship, technical skill development, and exposure to modern cloud-based data solutions in a collaborative environment. This position reports into the Technology Office.</span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">This position offers hybrid work flexibility, requiring three days per week in AIR’s Virginia office, with occasional travel for meetings, training sessions, and conferences.</span></p> <h4><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">About AIR:</span></h4> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="color: rgb(0, 0, 0);">Founded in 1946 and headquartered in Arlington, Virginia, the American Institutes for Research (AIR) is a nonpartisan, not-for-profit organization that conducts behavioral and social science research and delivers technical assistance to address some of the most pressing challenges in the United States and globally. We generate evidence and apply data-driven solutions that expand opportunities and improve lives for all.</span></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Responsibilities:</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">The responsibilities for the position include:</span></p> <ul> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Assist in the development and maintenance of data pipelines and ETL/ELT processes using Azure and Fabric tools.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Support ingestion, integration, and transformation of data from multiple internal and external sources.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Work with Azure Data Factory, Azure Synapse, and Microsoft Fabric (Data Factory, Lakehouse, Dataflows, etc.).</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Help design and maintain data models, data lakes, and data warehouses.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Write and optimize SQL queries for data transformation and validation.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Collaborate with data analysts, business stakeholders, and senior engineers to align on shared team objectives and drive successful outcomes.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Monitor and troubleshoot data workflows to ensure reliability and performance.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Participate in data quality, governance, and documentation efforts.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Contribute to process automation and continuous improvement.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Duties and responsibilities may change based on business needs. </span></li> </ul> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Qualifications:</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Education, Knowledge, and Experience</strong></span></p> <ul> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, related field or at least 2 years of relevant professional…