Data Engineer I

AOPA • Frederick, MD

24d • $70,000 - $80,000 • Hybrid

About The Position

Reporting to the Manager, Data Analytics, the candidate’s primary role will be to design, build, integrate, and maintain data from multiple sources and facilitate an environment through which management can better direct business strategy via data driven decision making. This will include gathering requirements from business partners, identifying potential information solutions, creating data pipelines, deploying new data sets, and maintaining existing environments in support of a cohesive enterprise data structure capable of implementing organizational initiatives and fulfilling ad-hoc data requests and projects.

Requirements

• Detail-oriented self-starter with initiative and follow-through.
• Discipline to follow established processes and write clean and functional code.
• Strong attention to detail.
• Ability to learn and develop proficiency with additional tools as business needs evolve.
• Ability to prioritize and complete multiple projects with defined deadlines and varying degrees of complexity simultaneously.
• Ability to understand business issues and interpret data in a way that provides actionable insights.
• Excellent written and verbal communication skills and a desire and willingness to collaborate with technical teammates and business partners.
• Bachelor’s degree in Computer Science or equivalent technology degree with a focus on development and coding.
• Working knowledge of Python and SQL; proficiency in at least one or more of the following languages: Python, R, HTML/CSS/JavaScript.
• Develop and maintain Extract-Transform-Load (ETL) scripts, SQL scripts, and ETL schedules using modern data integration tools.
• Strong troubleshooting skills with the ability to diagnose and resolve issues across the full stack from infrastructure through application layers.

Nice To Haves

• Master’s degree in Computer Science or similar.
• Previous experience developing an enterprise data warehouse.
• Exposure to tools such as Google Cloud, Salesforce, or SQL Server
• Familiarity with data privacy regulations (e.g., GDPR, CCPA, HIPAA).

Responsibilities

• Coordinate with cross-functional teams to transform the association’s data into business information that helps departments fulfill strategic objectives.
• Assists in the development, construction, testing, and maintenance of data architectures.
• Supports efforts to align data architecture with business requirements.
• Identifies and escalates opportunities to improve data reliability, efficiency, and quality.
• Contributes to the design and support of the enterprise data warehouse.
• Assists in building and maintaining custom data integrations across multiple systems.
• Responds to periodic analytics requests from other departments, with guidance from senior staff as needed.
• Participates in fostering a culture of data collaboration across the organization.
• Prepares technical documentation for data architecture, API specifications, and automation processes under the guidance of senior engineers.
• Create and extend enterprise data catalog capabilities that document what data exists across organizational systems, how it is structured, and how it connects, enabling teams across the company to navigate the full data landscape.
• Although this job description aims to capture the majority of the position duties, other duties may be assigned based on business and departmental needs.

Benefits

• Flight Training (earn your Private Pilot License for free) & Annual Flight Proficiency Program (so you can keep flying and remain proficient)
• Medical, Dental, and Vision insurance is available for employees and their dependents the 1st of the month following their start date
• Flexible Spending Plans
• Health Savings Plan with employer contribution (for eligible participants)
• 401(k) Retirement Plan with a company match, and annual discretionary supplemental employer contribution
• Company paid Short and Long-term Disability Insurance
• Company paid Life Insurance and AD&D insurance with the option to buy up
• Paid Time Off (PTO): 17 days accrued during first year (accruals increase based on tenure)
• Paid Holidays: 12 holidays
• Personal days: 3 (prorated based on hire date)
• Volunteer day: 1 (prorated based on hire date)
• Work From Home Fridays
• Paid Parental Leave
• AOPA Membership
• Employee Assistance Program
• Wellness Program (earn medical insurance premium discounts)
• Gym Reimbursement Program
• Supplemental insurance options (critical illness, accident, hospital indemnity)
• Tuition Reimbursement Program
• Discount on AOPA swag
• Business casual dress code
• Free coffee, tea, hot cocoa

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level