What are the responsibilities and job description for the Data Warehouse Developer position at MetroPlus?
Empower. Unite. Care.
MetroPlusHealth is committed to empowering New Yorkers by uniting communities through care. We believe that health care is a right, not a privilege. If you have compassion and a collaborative spirit, work with us. You can come to work being proud of what you do every day.
If your skills, experience, and qualifications match those in this job overview, do not delay your application.
About NYC Health Hospitals
MetroPlus Health provides the highest quality healthcare services to residents of Bronx, Brooklyn, Manhattan, Queens, and Staten Island through a comprehensive list of products, including, but not limited to, New York State Medicaid Managed Care, Medicare, Child Health Plus, Exchange, Partnership in Care, MetroPlus Gold, Essential Plan, etc. As a wholly-owned subsidiary of NYC Health Hospitals, the largest public health system in the United States, MetroPlus Health network includes over 27,000 primary care providers, specialists, and participating clinics. For more than 30 years, MetroPlus Health has been committed to building strong relationships with its members and providers to enable New Yorkers to live their healthiest life.
Position Overview
The Data Warehouse Developer will be accountable for the successful design, development, and delivery of Azure Databricks Lakehouse solutions within a SQL Server Data Warehouse environment. An ideal candidate will be someone who leads, develops, maintains, and integrates processes for a data warehouse that will extract data from standardized or varied data sources and transforms data for storing in proper formats and structures for querying and analysis using SSIS. This would include loading data into an operational data store (ODS) and a dimensional model (EDM).
Job Description
- Design and develop data warehouses and data marts to support data analysis and reporting.
- Interact with end users and business analysts to understand requirements.
- Develop SQL Server objects including, but not limited to, stored procedures, functions, and views.
- Design and implement technology best practices, guidelines, and repeatable processes.
- Create data validation rules on source data to confirm the data has correct and / or expected values.
- Perform data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, gathering of natural keys, and metadata information.
- Leverage Databricks to optimize and accelerate processing and analytics tasks.
- Collaborate with Databricks Administrator to ensure optimal cluster configuration.
- Implement data quality and data governance policies to ensure data accuracy and consistency.
- Participate in the development / implementation of master data management (MDM) strategies and solutions within complex system landscapes.
- Develop Azure Databricks data engineering, AI, and machine learning tasks.
Minimum Qualifications
Professional Competencies
LI-Remote
J-18808-Ljbffr
