Data Engineer

Position Overview

AASM is looking for a Data Engineer who enjoys building well-designed pipelines and turning raw source data into something people can actually use. This role calls for strong T-SQL and SQL Server expertise, hands-on experience with ELT development and dimensional modeling (star schema and snowflake), and the ability to create analytics-ready datasets that power better reporting and decision-making. As part of a growing BI function, you'll partner with stakeholders, deliver practical solutions, and play a meaningful role in how the organization works with its data.

What You’ll Do

• Design, build, and maintain scalable data pipelines to ingest, transform, and load data into a centralized data warehouse.
• Integrate data from APIs and SaaS platforms, developing automated ingestion workflows with appropriate controls (e.g., authentication, pagination, rate limiting, incremental loads).
• Implement and optimize ELT processes in SQL Server to ensure performance, reliability, and scalability.
• Develop and maintain data models (e.g., star and snowflake schemas) to support reporting and analytics.
• Partner with business and technical stakeholders to translate requirements into effective data solutions.
• Ensure data quality and consistency by implementing automated validation checks and resolving pipeline issues.
• Document data systems and processes, support governance standards, enable BI integration (e.g., Power BI), and advance self-service analytics.

What We’re Looking For

• Bachelor’s degree in a related field or equivalent experience
• 3+ years of data engineering or ELT experience
• Strong SQL Server proficiency for ELT and data transformation, with experience in BI tools (e.g., Power BI) and data warehousing best practices.
• Advanced knowledge of data modeling (e.g., star and snowflake schemas) and data architectures, including data lakes and lakehouse environments.
• Ability to design, optimize, and scale data pipelines for performance and reliability.
• Proficiency in Python (or similar) for data manipulation and automation, with knowledge of API standards (e.g., REST, OAuth) for secure integration.
• Experience implementing automated data pipeline testing, including validation, quality checks, and regression testing.
• Strong communication skills to collaborate with technical and business stakeholders.

Preferred Qualifications

• Experience with cloud platforms (Azure, AWS)
• Familiarity with tools like Microsoft Fabric, Snowflake, or Databricks
• Knowledge of API integrations (REST, OAuth)
• Experience with data testing and quality validation
• Understanding of data lake/lakehouse concepts
• Relevant certifications in data or cloud technologies

Culture and Benefits

• The AASM is proud to be an Equal Employment Opportunity employer and a recipient of the 2025 Best Workplaces in Illinois award. We celebrate diversity and are committed to creating an inclusive environment for all employees.
• Aside from the great job opportunity, we offer a collaborative and fun work culture with amazing benefits.
• Benefits include:
• Affordable medical & dental coverage for you and your family
• Free life & disability insurance
• 3 weeks of PTO plus paid company holidays
• 8 weeks PAID parental leave
• Flex-time hours
• Business casual environment
• Generous 401(k) plan
• Flexible spending & dependent care accounts
• Health savings account with generous employer contributions
• Professional development (association membership, tuition reimbursement, certification, LinkedIn Learning)
• Pet insurance
• Discounted fitness membership
• Door Dash meal perks
• Service recognition and peer-to-peer platform
• Weekly Wellness Wednesdays
• Twice daily plank breaks
• Seasonal staff events