Data Acquisition Engineer I

AAA Washington; Bellevue (WA); Hybrid; USD 90,000 - 110,000; Full time

Benefits offered by this job

Health insurance

401(k) with employer match

Paid time off

Job summary

AAA Washington is seeking a Data Acquisition Engineer I to build and maintain data ingestion pipelines using Azure Data Factory and Fabric, under guidance from senior engineers. You will onboard source systems, ensure data quality, and contribute to medallion architecture foundations.

You will work with APIs, flat files, databases, and SaaS sources, land data into Bronze layer, write SQL for extraction and validation, and participate in sprint ceremonies and code reviews to support AAA’s data

Qualifications

• Bachelor's degree or equivalent preferred
• 0–2 years in data engineering or related field
• Experience building data ingestion pipelines is a plus

Responsibilities

• Build and maintain data ingestion pipelines using Azure Data Factory and Fabric
• Ingest data from APIs, flat files, databases and SaaS sources into data lakes
• Land raw data into Bronze layer following standards for format and auditability
• Write SQL queries for extraction, transformation and quality validation
• Apply data quality checks including schema validation and null checks
• Participate in sprint ceremonies and code reviews

Skills

Data ingestion

SQL

Python / PySpark

Data quality

Team collaboration

Communication

Education

Bachelor's degree in CS/IS/Engineering

Tools

Azure Data Factory

ADLS Gen2

Azure SQL Database

Azure Blob Storage

Fabric Data Factory

OneLake / Lakehouse

Dagster

dbt

Apache Airflow

Git

Job description

What You’ll Do

The Data Acquisition Engineer I builds and maintains data ingestion pipelines within the Microsoft Azure and Microsoft Fabric platform. Working under senior engineer guidance, this role contributes to pipeline development, source system onboarding, data quality execution, and medallion architecture foundation.

What You’ll Do

The Data Acquisition Engineer I builds and maintains data ingestion pipelines within the Microsoft Azure and Microsoft Fabric platform. Working under senior engineer guidance, this role contributes to pipeline development, source system onboarding, data quality execution, and medallion architecture foundation.

Who We Are

At AAA Washington, we equip our members with trusted service and expertise to confidently travel through life. We provide our members with best-in-class roadside assistance, discounts and rewards, travel services and insurance. For over 120 years, we’ve served our members, not shareholders, so our growth supports innovation for the Club today and for the future. Seeking to reflect the communities we serve and create an inclusive culture, we encourage employees to bring their full self to work and support applicants from all backgrounds, abilities and walks of life to apply.

Why You’ll Love Working At Aaa Washington

You’ll play an important role in bringing AAA Washington’s spirit of service and peace of mind to our membership. Consistently ranked as one of the Best Places to Work by Puget Sound Business Journal, we aim for work-life balance across the organization. We support hybrid and remote work options for many positions based in our corporate office (Bellevue, Washington) along with some of the best benefits in the region!

Essential Duties/Responsibilities

• Build and maintain data ingestion pipelines using Azure Data Factory (ADF) and Microsoft Fabric Data Factory
• Ingest structured and semi-structured data from APIs, flat files, databases, and SaaS sources into Azure Data Lake Storage Gen2 and Microsoft Fabric OneLake
• Land raw data into the Bronze layer of the medallion Lakehouse following team standards for format, partitioning, and auditability
• Write SQL queries for data extraction, transformation, and quality validation
• Apply data quality checks including schema validation, null checks, and row count assertions
• Execute ingestion workflows in orchestration tools (e.g.: Apache Airflow, Dagster, DLT) under guidance — run, monitor, and troubleshoot existing DAGs
• Develop awareness of Dagster and dbt asset-based modeling patterns through team exposure and structured learning
• Document pipeline designs, source-to-target mappings, and data dictionaries
• Participate in sprint ceremonies and code reviews
• Contributes to a positive team dynamic through respectful interactions, positive contributions, and active collaboration to achieve department and organizational goals.
• Incorporates AAA’s vision, mission and values in day-to-day activities and behaviors; guides and motivates others to remain committed to AAA’s vision mission and values.

Supervisory Responsibilities

• None

Minimum Qualifications

• Education — Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent preferred
• Experience — 0–2 years in data engineering, or a related field

Preferred Qualifications

• Microsoft Azure — Hands-on experience with ADF, ADLS Gen2, Azure SQL Database, and Azure Blob Storage preferred
• Microsoft Fabric — Familiarity with Fabric Data Factory, Lakehouse, OneLake, and Warehouse concepts preferred
• SQL — Proficiency in SQL for extraction, transformation, and quality validation preferred
• Storage — Familiarity with Delta Lake, Apache Iceberg, Parquet file formats is preferred
• Orchestration — Awareness of DAG concepts, task operators, and basic workflow execution and monitoring. Hands-on exposure to tools like Apache Airflow, DAGs, operators, and connections preferred
• Asset Based Modeling — Awareness of asset-based orchestration concepts; exposure to dbt models or Dagster assets is a plus
• Methodology — Awareness of medallion architecture (Bronze/Silver/Gold) and layered data design is preferred
• Python / PySpark — Basic proficiency for data manipulation and ingestion scripting
• Version Control — Familiarity with Git — branching, commits, and pull requests

Certificates, Licenses, Registrations

• Certification — DP-900 (Azure Data Fundamentals) or equivalent is preferred

Knowledge, Skills, Abilities

Technical Competencies

• Azure Data Factory — Build and configure pipelines with guidance
• Microsoft Fabric — Navigate Fabric workspaces; use Data Factory and Lakehouse
• SQL — Write proficient queries; apply joins, aggregations, and filters
• Python / PySpark — Write basic ingestion and transformation scripts
• Medallion Architecture — Understand Bronze / Silver / Gold principles; follow team standards
• Apache Airflow — Run and monitor existing DAGs; understand task operators and scheduling
• Dagster / dbt — Develop awareness of asset graphs and dbt model concepts
• Git — Commit, branch, and submit pull requests
• Data Quality — Apply schema validation, null checks, and row count assertions
• Ability to communicate clearly and professionally both verbally and in writing, including effective use of listening skills.
• Ability to establish and maintain cooperative working relationships.
• Skilled in establishing rapport and gaining the trust of others.

Salary

• Hiring Range: $43.30 - $53.06 per hour
• Discretionary bonus based on company performance

Benefits We Offer

• Health insurance (medical, vision, dental and prescription drug)
• Up to 22 days of Paid Time Off (PTO) in the first year
• Eleven paid holidays in addition to PTO
• 401(k) with Employer Match
• Life, Short-Term Disability and Long-Term Disability insurance
• Flexible Spending Accounts
• 4 Hours of Volunteer Time Off per year
• On-Demand Pay / Earned Wage Access
• Free Premier RV AAA Washington Membership
• Travel, Insurance, and Membership Discounts and Perks
• Paid, on-going training throughout your career
• THRIVE wellness program
• Tax-advantaged commuter benefit
• Free parking
• Financial Literacy Education

Work Environment & Physical Demands

• Hybrid work from home and office required
• The physical environment is typical of a standard office space. It requires the employee to work inside for the duration of work. Must be able to remain in a stationary position, sitting for more than 50% of the time. This position will require occasionally moving about inside the office to access equipment, cabinets, etc. May work around office equipment which could be noisy, such as copiers and fax machines.

Other

• Equipment used: computer, various virtual technologies, other office equipment
• Travel: Rarely Travel
• This position will require “on call” responsibilities on a rotating basis.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required.

Disclaimer

Position/Job characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.