Note: The job is a remote job and is open to candidates in USA. Pediatric Associates Family of Companies is seeking a Senior Data Engineer to architect and implement reliable, scalable ELT/ETL workflows supporting enterprise-wide data needs. The role will design data models and pipelines, ensure data quality and security, collaborate with cross-functional teams, communicate technical solutions to stakeholders, and mentor engineers.
Responsibilities
- Design, build, and maintain scalable, reliable ELT/ETL pipelines using modern data engineering tools and frameworks
- Architect and optimize data models, schemas, and data platforms to support both analytical and operational workloads
- Design, document, and maintain enterprise-level data models (conceptual, logical, and physical) using data modeling best practices
- Collaborate with cross-functional teams to understand requirements, define data strategies, and deliver high-quality engineering solutions
- Lead and drive technical discussions, solution design, and architectural decisions across teams
- Implement and enforce comprehensive data quality standards, validation rules, and monitoring frameworks to ensure accuracy, consistency, completeness, and reliability across all data assets
- Develop efficient, well-structured SQL and complex data transformation logic to support analytics and reporting
- Monitor, troubleshoot, and enhance data pipelines for performance, reliability, and cost efficiency
- Ensure data security, compliance, and adherence to best practices across cloud and on-premise data systems
- Communicate complex technical topics in a clear, business-aligned manner to stakeholders at all levels
- Mentor and guide junior and mid-level engineers, contributing to team growth and engineering excellence
Skills
- Bachelor#s degree in related field required
- 10+ years of experience in data engineering or a related field required
- Expert-level proficiency in SQL and experience with data transformation tools (e.g., Azure Data Factory, Apache Spark, Glue) required
- Proven experience architecting and maintaining large-scale ELT/ETL pipelines in cloud environments (AWS, Azure, or GCP) required
- Deep understanding of data modeling concepts (dimensional modeling, star schema, normalization) required
- Hands-on experience with modern data warehousing platforms, preferably Databricks/Snowflake/Azure Synapse required
- Experience in DevOps activities, including implementing CI/CD pipelines and workflow automation for data engineering and analytics platforms required
- Strong programming skills in Python or another modern scripting language required
- Demonstrated ability to translate complex business requirements into scalable, high-impact technical solutions
- Excellent communication, documentation, and stakeholder engagement skills
- Proficient in building Power BI data models and creating effective dashboards
- Full time remote/telework
- Vision
- Sense of sound
- Sense of touch
- Master#s degree preferred
Benefits
- Full time remote/telework
Company Overview
Company H1B Sponsorship