Search jobs > New York, NY > Data warehouse developer

Data Warehouse Developer

MetroPlusHealth
New York, NY
$130K-$140K a year
Full-time

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.

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

  • 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, Databricks Workspace user interface, managing Notebooks, Delta Lake with Python.
  • 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
  • 30+ days ago
Related jobs
Promoted
MetroPlus Health Plan
New York, New York

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 t...

Promoted
Amida Care
New York, New York

We are actively seeking a highly motivated, innovative and experienced individual to join our team as the Data Warehouse/ Business Intelligence Developer. The Data Warehouse Business Intelligence Developer's role is to design, develop and implement new organizational information systems and software...

UCI Software Solutions
New York, New York

Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts. New York State Homes and Community Renewal is undergoing a major modernization of their business applications and is seeking a...

MetroPlusHealth
New York, New York

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 t...

Mindlance
New York, New York

Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts. The Developer must have extensive experience in software analysis, design, development, implementation and maintenance of Data...

Mindlance
New York, New York

Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts. The Developer must have extensive experience in software analysis, design, development, implementation and maintenance of Data...

Velocity Search Group Inc
New York, New York

AWS ETL Developer. Our Client a leading Healthcare services organization is seeking a full time AWS ETL Developer to join their team. Develop and support data integrations and ETL processes between systems. Experience with data migration/ETL involving Salesforce using tools like AWS, Boomi, Mulesoft...

Promoted
VirtualVocations
Queens, New York

A company is looking for a Database Developer (Data Warehouse) to design and build components of a data warehouse to support business intelligence and data science initiatives. ...

Promoted
The Chefs' Warehouse
New York, New York

As a Warehouse Worker, you will be responsible for providing warehouse support including picking, packing, assembly, sorting, shipping, and receiving of orders to meet the facility’s productivity and quality goals within the establishment. About The Chefs' Warehouse. Mission: The mission o...

Promoted
Petadata
New York, New York

Experience with SQL Server Management Studio (SSMS) and T-SQL. Must collaborate with application developers and business analysts to design and implement efficient database structures. Write and optimize complex SQL queries for data retrieval, transformation, and reporting. Install, configure, and u...