Data Engineer III, Business Analytics - Pediatric Associates

Pediatric Associates was founded in Hollywood, FL in 1955. The same clinician-led, evidence-based, medical home passion is a unifying driver for those who join Pediatric Associates Family of Companies. The Pediatric Associates Family of Companies is a growing team of Pediatricians and Pediatric Care Teammates who are excited to be part of the first nationwide Pediatric Primary Care Medical Home. We further our uniqueness by ensuring the clinician voice is leading our medical home innovations.

Remote Opportunity

PRIMARY FUNCTION

The Data Engineer is responsible for designing, building, and supporting our leading-edge Data & Analytics technology platform for enabling value-based healthcare, population health management, and enterprise analytics. The leading-edge technology platform includes cloud-based (Microsoft Azure) big data platform, MS SQL Server stacks, and modern data engineering design patterns & tools.

ESSENTIAL DUTIES AND RESPONSIBILITIES

This list may not include all of the duties that may be assigned.

Designs, builds and maintains scalable, automated data pipelines to enable Reporting, Data Visualization, Advanced Analytics, Data Science, and Machine Learning solutions.

Supports critical MS SQL databases that support various pipelines with a scalable distributed architecture. Maintaining database health by performing database administration activities.

Supports critical data pipelines with a scalable distributed architecture, including data ingestion (streaming, events, and batch), data integration (ETL, ELT, Azure Data Factory), and distributed data processing using Databricks Data & Analytics and Azure Cloud Technology Stacks.

Builds cloud data solutions using multiple technologies, such as SQL, Python, Data Lake (Databricks Delta Lake), Cloud Data Warehouse, RDBMS.

Understands and implements best practices in managing data, including master data, reference data, metadata, data quality, and lineage.

Deploys, automates, maintains, and manages cloud-based production systems to ensure the availability, performance, scalability, and security of production systems.

Engages with cross-functional stakeholders to identify pain points, business and technical requirements, and to design data solutions using best-practice patterns and modern architecture.

Owns end-to-end design and development, testing, the release of critical components using Databricks technology stack and Microsoft Azure cloud platforms and services.

Lead other Data Engineers on the team and guide them on best practices for our enterprise data platform.

Solution architecting and deploying features and functionality within our enterprise data platform. This includes developing and maintaining our enterprise data model.

QUALIFICATIONS

EDUCATION: Minimum BA or BS degree in Computer Science, Information Systems, or related field required. MS in Business Analytics or related discipline preferred.

EXPERIENCE

• Minimum 6 years of experience in creating robust enterprise-grade data engineering pipelines using SQL, Python, Apache Spark, ETL, ELT, Databricks Technology Stack, Azure Cloud Services, Cloud-based Data and Analytics platforms required. 8-10 years preferred.
• Minimum 5 years of experience in managing MS SQL server databases.
• Strong proficiency in SQL and data analysis required.
• Experience in distributed data (structured, semi-structured, unstructured, streaming) processing techniques using Apache Spark, Hadoop, Hive, Kafka, and big data ecosystem technologies preferred.
• Experience in data modeling and design for data warehouse, relational databases, and NoSQL data stores preferred.

KNOWLEDGE, SKILLS AND ABILITIES

• Proficiencies in MS SQL server administration activities such as performing regular database maintenance tasks which include but limited to backups, index optimization, and statistics updates to ensure database health and performance.
• Security Management: Implementing and managing database security measures, including user roles, permissions, and encryption to safeguard sensitive data.
• Monitoring and Alerting: Setting up and managing monitoring tools to track database performance, health, and usage, and configuring alerts for potential issues.
• Capacity Planning: Assessing current and future database storage needs, planning for capacity upgrades, and managing resource allocation.
• Strong problem-solving, critical thinking, verbal, and written communication skills.
• Ability to influence decisions related to advanced analytics strategy & roadmaps, business use cases, and data platform capabilities.
• Effective communication and collaboration with internal cross functional teams, leadership team, technology partners & vendors, and end users.
• Excellent analytical, organizational skills and ability to work in a startup environment and to deliver on tight deadlines using Agile practices.
• Healthcare industry experience highly desired.

TYPICAL WORKING CONDITIONS

• Non-patient facing
• May be either full time remote/telework or rotate working in the office and remote/telework
• If remote, this job must be U.S. based
• Indoor work; professional office environment
• Operating computer
• Reach outward

OTHER PHYSICAL REQUIREMENTS

• Vision
• Sense of sound
• Sense of touch

The Pediatric Associates Family of Companies an Equal Employment Opportunity/Affirmative Action employers and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

PI242592549