Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Data Engineer role.
Rezi rewrites your resume against American College of Physicians's job description. Free.
Tailor your resume to this Data Engineer role.
Rezi rewrites your resume against American College of Physicians's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Engineer posting at American College of Physicians — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Engineer posting at American College of Physicians — free, in seconds.
About the Role
The Data Engineer will provide technical leadership for building and managing enterprise-wide data transformation, orchestration processes, and data pipelines, working across diverse source systems, a medallion-modeled data lakehouse, and data activation platforms.
Responsibilities
- Provides technical leadership in data pipeline design and development organization-wide, ensuring data flows are orchestrated in alignment with business needs and system architectures, with an emphasis on ingestion, unifying transformations, and deliveries to activation platforms via the data lakehouse.
- Ensures that designs and techniques are compliant with system architectures and organizational data management and governance standards.
- Uses agile software development processes in collaboration with development, analyst, and data administration teams for iterative deployments with full visibility and change tracking.
- Ensures documentation of data models, transformations, and orchestration remains current, comprehensive, semantically precise, and accessible.
- Partners with the data management team to collaborate with business stakeholders, ensuring pipelines are optimized for quality, reliability, contextual accuracy, and actionability.
- Plays a key role in enterprise data architecture design and analysis, including interactions with consultants and contractors.
- Monitors data systems and flows, utilizing automated tooling to ensure successful and reliable pipelines.
Requirements
- A Bachelor's degree is required, preferably in Computer Science, Software Engineering, Systems Engineering, Data Science, or a related field.
- Demonstrable experience with the Snowflake platform and related tooling (e.g., dbt and Fivetran) is required.
- At least 3 years of experience designing and developing data pipelines in modern data engineering environments is required.
- Experience working with large-scale (1M+ records) customer and behavioral data models and systems (e.g., “Customer 360” models) is highly desirable.
- Experience with multiple techniques for modeling and transformations (e.g., ETL, reverse ETL, modern ELT, real-time/streaming processes like Apache Kafka).
- Strong understanding of all stages of integrated, data lakehouse-oriented architectures, from ingestion to semantic modeling to delivery/activation.
- Deep experience with core data engineering coding techniques/languages: SQL, Python.
- Experience working within multiple large-scale API-based, cloud architectures (e.g., Amazon AWS-based and Microsoft Azure-based) is highly preferred.
- Excellent oral and written communication skills are essential.
Skills
- Snowflake platform
- dbt
- Fivetran
- ETL
- Reverse ETL
- ELT
- Apache Kafka
- SQL
- Python
- Amazon AWS
- Microsoft Azure
Location
- Philadelphia HQ
Work Type
- Full-time
- Hybrid
Experience Level
- At least 3 years of experience
Education Level
- Bachelor's degree
Benefits
- Competitive salary
- Superior benefits
About the Company
- The American College of Physicians (ACP) is a national organization of internal medicine physicians and is the largest medical specialty organization and the second-largest physician group in the United States.
Equal Opportunity
- ACP is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to their age, race, color, religion, sex, gender identity, national origin, sexual orientation, protected veteran status, disability, or any other legally protected class.