Data Warehouse Engineer
Axia Women's Health is the nation’s largest community-based, integrated women's health network in the country serving women throughout New Jersey, Pennsylvania, Indiana, and Kentucky. At its core, Axia Women’s Health is a community of over 400 providers across nearly 150 locations committed to providing a more caring, connected, and progressive health care experience for women. Its rapidly growing network spans OB/GYN care, breast health, high-risk pregnancy care, urogynecology care, behavioral health, and fertility. Together, Axia Women's Health puts women first by delivering the personalized care needed for women to lead healthier, happier lives. Axia Women’s Health has been recognized as the #1 Physician Practice for Women’s Health by Castle Connolly and certified as a Great Place to Work for four consecutive years. Learn more at www.axiawh.com.
A Junior Data Warehouse Engineer designs, builds, and maintains data pipelines (ETL/ELT) and database systems to support analytical reporting. They work under supervision to write SQL queries, ensure data quality, and document technical processes, collaborating with senior engineers to transform raw data into usable business insights.
Essential Functions:
- Data Pipelines (ETL/ELT): Assist in developing, testing, and maintaining data extraction, transformation, and loading processes.
- SQL & Data Modeling: Write and optimize SQL queries and assist with basic data modeling to structure data for analytics.
- Database Maintenance: Monitor, maintain, and troubleshoot data warehouse infrastructure.
- Data Quality Assurance: Perform data validation to ensure data accuracy, completeness, and reliability.
- Documentation: Document data definitions, technical processes, and data mapping for data catalogs.
Education & Experience
- Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related technical field required (or equivalent practical experience).
- 0-2 years of experience in data engineering, database administration, or data analysis
Required Skills
- Technical Skills: Proficiency in SQL (essential) and programming languages like Python or Java.
- Database Knowledge: Familiarity with relational databases (e.g., PostgreSQL, MySQL)
- Data Concepts: Basic understanding of data warehousing concepts (star schema, snowflake schema, ETL/ELT).
- ETL/ELT: Familiarity with data integration tools and technologies used for connecting to diverse data sources (e.g., Corepoint, REST APIs)
Full Time Benefits Summary
- Full time benefit-eligibility beginning the first of the month after hire
- Choice of multiple medical insurance plans to best meet your needs
- Additional insurance options including dental, vision, supplemental life insurance, FSA, HSA w/ employer contribution, identity theft, long term care, pet insurance and more!
- Generous PTO offering with additional time off for volunteering
- 401k with company match
- Access to Axia providers at little to no cost through Axia’s medical insurance
- Axia-paid life insurance, short term and long term disability
- Free counseling for colleagues and family members, including parents and parents-in-law
- Access to discount on Hotels, Theme Parks, Gym Memberships, and more through the Great Works Perks Program