Data Warehouse Developer
Job Ref: 111605
Category: Information Technology
Department: INFORMATION TECHNOLOGY
Location: 50 Water Street, 7th Floor, New York, NY 10004
Job Type: Regular
Employment Type: Full-Time
Hire In Rate: $130,000.00
Salary Range: $130,000.00 - $140,000.00
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.
About NYC Health + Hospitals
MetroPlusHealth provides the highest quality healthcare services to residents of Bronx, Brooklyn, Manhattan, Queens and Staten Island through a comprehensive list of products. As a wholly-owned subsidiary of NYC Health + Hospitals, the largest public health system in the United States, MetroPlusHealth network includes over 27,000 primary care providers, specialists and participating clinics.
Position Overview
The Data Warehouse Developer will be accountable for 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.
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.
- 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.
- Develop Azure Databricks data engineering, AI, and machine learning tasks.
Minimum Qualifications
- Bachelor's degree in computer science or related field.
- 10+ years of relevant professional experience.
- 5 years' experience with Databricks Lakehouse Platform.
- Strong SQL skills for data manipulation and query optimization.
- Knowledge of Python is required.
- Proficiency in cloud platforms like AWS, Azure, or Google Cloud.
- Hands-on experience on unified data analytics platform with Azure Databricks.
- Strong experience using SSIS as the ETL tool in a data warehouse environment.
- Experience with Power BI or other BI reporting tools is a plus.
- Working experience with Salesforce and MuleSoft is a plus.
- Knowledge of Visual Studio .Net development is a plus.
- Experience in a health care related business is a plus.
Professional Competencies
- Integrity and Trust
- Customer Focus
- Functional/Technical skills
- Written/Oral Communication
- Ability to adapt to different projects and assignments quickly.
- Team player with strong communication skills.
- Excellent analytical and problem-solving skills.
#LI-Remote
#J-18808-Ljbffr