Data Analytics Engineer ELT

Responsibilities

• Build the infrastructure required for optimal extraction, loading, and transformation (ELT) of data into our enterprise data warehouse (EDW) from a wide variety of data sources using SQL and Cloud data warehousing technologies (Azure, AWS, Snowflake, etc.)
• Create and maintain optimal data pipeline ingestion architecture for various unstructured and structured data sources
• Strong business process acumen with the ability to attribute how specific clinical or non-clinical business processes generate data
• With a comprehensive understanding of how our operational processes generate data, develop the transformation logic to establish structured and analytical data repositories across various domains
• Using data orchestration and scheduling techniques, combine and organize siloed data from multiple data storage locations, making it available for data analysis tools and enabling automation
• Develop and maintain front-end analytics tools and dashboards (Tableau/Power BI) that utilize the data pipeline to provide actionable insights into operational performance and other key business performance metrics
• Successfully implement sound data cataloging and analytics development best practices to create organized inventories and source control which aid in data governance
• Ensure data quality # governance at the enterprise level by utilizing data lineage techniques and following standard data documentation practices
• Collaborate with stakeholders including Executive leadership, Operations Management, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
• Ensure internal and external data security standards are maintained to safeguard our enterprise and patient data
• Provide recommendations to enhance our data engineering techniques and architecture design
• Create data tools and collaborate with management engineering, analytics, and data scientist team members to assist them in building and optimizing various analytics solutions
• Utilize agile skills that draw from other disciplines such as management consulting, business administration, organizational development, information technology, and computer science

Preferred

• CI/CD development experience for data transformation with SQL, highly preferred
• Experience with Cloud Data Warehouse architecture (Snowflake/Azure), preferred
• Experience with Python, R, or other programming language, preferred
• Master#s degree, preferred

Benefits

• Hybrid work arrangement
• Glassdoor
• 3.2
• The Westchester Medical Center Health Network (WMCHealth) is the pre-eminent provider of integrated health care in New York’s Hudson Valley region, serving nearly 2.5 million residents across more than 6,000 square miles.
• Valhalla, New York, US
• http://WMCHealth.org
• Distribution of Different Job Fields Receiving Sponsorship
• Represents job field similar to this job
• Customer Service and Support
• Trends of Total Sponsorships
• *2025
• (1)
• 2022
• Late Stage
• Leadership Team
• Sean S. Tedjarati, MD, MPH, MBA, CPE
• President and CEO WMCHealth Physicians, Advanced Physicians Services
• Anthony Frank
• Executive Vice President and CFO
• Recent News
• Crain's New York Business
• State shores up funding to abortion providers amid looming federal cuts
• 2025-06-25
• PR Newswire
• GT Medical Technologies Welcomes New GammaTile® Center of Excellence Program Designation
• 2025-06-03
• Connecticut Post
• Unions mark 'strike spring' as wave of organizing reshapes Connecticut’s health care industry
• 2025-05-30
• Company data provided by

Qualifications

• Minimum of 1 year of experience in an Analytics Engineer role, with an undergraduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field, required
• Proficiency in SQL, required
• Bachelor#s degree, required
• Experience in SQL development, table design, pipeline design and build, pipeline monitoring, orchestration # scheduling, data profiling, expertise in analyzing data to identify gaps and inconsistencies, troubleshooting, dashboard development/visualization, Cloud EDWs (Snowflake/Azure preferred), Data modeling, Data documentation, SSMS, SQL Server, SSIS Visual Studio
• Excellent written and verbal communication with a strong drive for perfection/professionalism in delivery and presentation
• Proven ability to work both independently on projects and as part of a larger team
• Advanced proficiency in statistics and statistical software with an ability to visualize data for improvement/performance monitoring
• CI/CD development experience for data transformation with SQL, highly preferred
• Experience with Cloud Data Warehouse architecture (Snowflake/Azure), preferred
• Experience with Python, R, or other programming language, preferred
• Master#s degree, preferred
• Minimum of 1 year of experience in an Analytics Engineer role, with an undergraduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field, required.

Required skills

• CI/CD for Data Transformation, Cloud Data Warehousing, Dashboard Development and Data Visualization, Data Modeling, Data Orchestration and Scheduling, Data Pipeline Design and Monitoring, Data Profiling, Python, R, SQL, SQL Server, SSIS, SSMS, Statistics, Visual Studio

Preferred skills

• Master#s degree, preferred

Experience

• 1+ years