Americaninstitutesforresearch

Americaninstitutesforresearch

Data Engineer Associate

US-VA-Arlington · Staff+ · Full-time

Work authorization requiredDetected 22 days ago
PythonGitSQLAzureCI/CDData AnalysisData EngineeringData ScienceData VisualizationResearchCommunicationCollaborationProblem SolvingCritical ThinkingMentoringPublic SpeakingAdaptability

About the role

  • AIR's Tek Office is seeking a motivated Data Engineer Associate to join our collaborative data and analytics team.
  • 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.

Responsibilities

  • Support ingestion, integration, and transformation of data from multiple internal and external sources.
  • Help design and maintain data models, data lakes, and data warehouses.
  • Write and optimize SQL queries for data transformation and validation.
  • Collaborate with data analysts, business stakeholders, and senior engineers to align on shared team objectives and drive successful outcomes.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, related field or at least 2 years of relevant professional experience.
  • 1-2 years of experience in data engineering, data analysis, or related roles.
  • Hands-on experience with SQL and relational databases, along with familiarity in Python, PySpark, or similar programming languages.
  • Hands-on experience with Microsoft Fabric (Lakehouse, Data Factory, Dataflows Gen2, OneLake), along with familiarity with Power BI, APIs, and modern data integration techniques.
  • Demonstrated ability to exercise independence and initiative while partnering collaboratively to achieve shared team objectives.
  • If you are unsure of the legitimacy of a communication you have received, please reach out to recruitment@air.org.
  • You can also report it to your state attorney general.
  • Education, Knowledge, and Experience
  • Foundational understanding of data engineering concepts, including ETL/ELT processes, data modeling, and data warehousing.
  • Exposure to Microsoft Azure data services, including Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake Storage, supporting scalable and cloud-based data solutions.

Nice to have

  • Understanding of CI/CD pipelines, version control (Git), data governance, security, and compliance practices, with exposure to big data or distributed computing frameworks
  • relevant Microsoft and industry certifications preferred.

Skills

  • Advanced analytical and problem-solving skills, demonstrating strong critical thinking, data accuracy, and disciplined attention to detail.
  • #LI-MP1 #LI-Hybrid
  • Disclosures: Applicants must be currently authorized to work in the U.S. on a full-time basis.
  • Employment-based visa sponsorship (including H-1B sponsorship) is not available for this position.
  • Depending on project work, qualified candidates may need to meet certain residency requirements.

Company info

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

Visa & Work Authorization

  • Disclosures: Applicants must be currently authorized to work in the U.S. on a full-time basis.

This listing is sourced directly from Americaninstitutesforresearch's careers page and normalized into a canonical job model.