Current jobs related to Data Warehouse Developer - New York, New York - UrBench


  • New York, New York, United States MetroPlusHealth Full time

    Job Title: Data Warehouse DeveloperAt MetroPlusHealth, we're committed to empowering New Yorkers by uniting communities through care. We're seeking a skilled Data Warehouse Developer to join our team and help us achieve our mission.Job SummaryThe Data Warehouse Developer will be responsible for designing, developing, and delivering Azure Databricks Lakehouse...


  • New York, New York, United States Novisync Inc Full time

    Job Description**About the Role**We are seeking an experienced Data Warehouse Architect to join our team at Novisync Inc. As a key member of our data team, you will be responsible for designing and developing scalable data warehouse solutions that meet the needs of our business.Key Responsibilities:Design and implement data warehouse architectures for...

  • Data Engineer

    6 days ago


    New York, New York, United States Creative Data Resources Full time

    Job Title: ETL DeveloperAt Creative Data Resources, we are seeking an experienced ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, implementing, and maintaining data pipelines that extract, transform, and load data from various sources into our data warehouse.Key Responsibilities:Migrate existing SSIS scripts to...

  • Data Modeler

    6 days ago


    New York, New York, United States NTT DATA Services Full time

    About the RoleWe are seeking a skilled Data Modeler to join our team in New York, USA. As a Data Modeler, you will be responsible for designing and implementing data models, data warehouses, and data lakes on target platforms.Key ResponsibilitiesDevelop conceptual, logical, and physical data models to support business requirements.Implement data strategies...


  • New York, New York, United States Comprehensive Resources Inc Full time

    Job Title: Senior Data Warehouse EngineerWe are seeking a highly skilled Senior Data Warehouse Engineer to join our team at Comprehensive Resources Inc. As a key member of our Information Technology department, you will play a vital role in designing and building an enterprise data warehouse.Key Responsibilities:Design and develop data warehouse solutions at...


  • New York, New York, United States Comprehensive Resources Inc Full time

    Job DescriptionComprehensive Resources Inc is seeking a highly skilled Data Warehouse Developer to play a key role in the modernization of our business applications. The ideal candidate will have extensive experience in designing and building an enterprise data warehouse, as well as a strong background in business analysis and technical skills.Key...

  • Senior Data Engineer

    3 weeks ago


    New York, New York, United States A Place For Mom Full time

    About A Place for MomA Place for Mom is the leading online resource connecting families searching for senior care with a team of expert advisors providing insight-driven, personalized solutions.Job DescriptionWe are seeking a highly skilled Sr. Data Engineer to join our team and contribute to the development of our data warehouse and ETL processes. As a key...

  • ETL Developer

    7 days ago


    New York, New York, United States Creative Data Resources Full time

    Job Title: ETL DeveloperWe are seeking an experienced ETL Developer to join our team at Creative Data Resources. As an ETL Developer, you will be responsible for designing, implementing, and maintaining data pipelines using Python and Snowflake.Key Responsibilities:Migrate existing SSIS ETL scripts to Python and develop new ETL scriptsSupport existing SSIS...


  • New York, New York, United States Tech Tammina Full time

    Job Title:Data Warehouse ArchitectLocation:NYC, NYExperience:14+ years in the IT industry, with 8+ years working with US companies in the US, and 8+ years as a Data Architect/Engineer. Recent experience (since 2015) in a major banking or brokerage house environment, with 6+ years of experience with Informatica and Azure.Key Responsibilities:Design and...


  • New York, New York, United States Unreal Gigs Full time

    Unreal GigsWelcome to Unreal Gigs, a pioneering company at the forefront of data-driven innovation. Our mission is to harness the power of data to drive transformative change and solve complex problems across industries.We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting, and business...


  • New York, New York, United States Brandon Consulting Associates, Inc. Full time

    Job DescriptionBrandon Consulting Associates, Inc. is seeking a highly skilled Data Warehouse Specialist to join our team. As a key member of our Data Warehouse team, you will be responsible for designing, developing, and implementing data warehouses and data marts to support business intelligence and analytics initiatives.Key Responsibilities:Design and...


  • New York, New York, United States Genesis10 Full time

    About the RoleGenesis10 is seeking a highly skilled Snowflake Data Architect to join our team for a 3-month consulting engagement with a leading consumer finance lender firm. The ideal candidate will have a strong background in designing, developing, and maintaining data architectures, data models, and standards for various data integration and data...


  • New York, New York, United States mountsinai Full time

    Lead Data Warehouse ArchitectThe Mount Sinai Health System is seeking a highly skilled Lead Data Warehouse Architect to join our Scientific Computing and Data group. As a key member of our team, you will design and oversee the implementation and testing of a scalable, high-availability, high-performance data warehouse.The Mount Sinai Data Warehouse (MSDW)...


  • New York, New York, United States VedaInfo Full time

    About the Role:We are seeking a highly skilled Data Warehouse Architect with expertise in Greenplum and other Data Warehouse Appliances to join our team at VedaInfo. As a key member of our team, you will be responsible for architecting complex Data Warehouse implementations that meet the evolving needs of our clients.Key Responsibilities:Design and implement...


  • New York, New York, United States VedaInfo Full time

    About the Role:We are seeking a highly skilled Data Warehouse Architect with expertise in Greenplum and other Data Warehouse Appliances to join our team at VedaInfo. As a key member of our team, you will be responsible for architecting complex Data Warehouse implementations that meet the evolving needs of our clients.Key Responsibilities:Design and implement...


  • New York, New York, United States Tech Tammina Full time

    Job Title: Data Warehouse ArchitectLocation: NYC, NYExperience:14+ years in the IT industry.8+ years working with US companies in the US.8+ years as a Data Architect/Engineer.5+ years of recent experience (since 2015) in a major banking or brokerage house environment.6+ years with Informatica and Azure.6+ years designing and implementing ETL processes using...


  • New York, New York, United States mountsinai Full time

    Job Title: Lead Data Warehouse ArchitectWe are seeking a highly skilled Lead Data Warehouse Architect to join our team at Mount Sinai Health System. As a key member of our Scientific Computing group, you will be responsible for designing and overseeing the implementation of a scalable, high-availability, high-performance data...


  • New York, New York, United States mountsinai Full time

    Job Title: Lead Data Warehouse ArchitectWe are seeking a highly skilled Lead Data Warehouse Architect to join our team at Mount Sinai Health System. As a key member of our Scientific Computing group, you will be responsible for designing and overseeing the implementation of a scalable, high-availability, high-performance data...


  • New York, New York, United States VedaInfo Full time

    Data Warehouse Architect Job Description **Job Summary:** We are seeking a highly skilled Data Warehouse Architect with expertise in Greenplum and other DW Appliances to lead the design and implementation of a complex Data Warehouse solution. **Key Responsibilities:** * Architect a scalable and efficient Data Warehouse implementation using Greenplum and...


  • New York, New York, United States New York State Civil Service Full time

    Job SummaryWe are seeking a highly skilled Data Warehouse Architect to join our team at New York State Civil Service. As a key member of our IT department, you will be responsible for designing and building data warehouse structures to support our reporting and analytic needs.Key ResponsibilitiesDesign and develop data warehouse structures to meet business...

Data Warehouse Developer

3 months ago


New York, New York, United States UrBench Full time
Job DescriptionJob Description

Data Warehouse Developer.

DURATION: 6 months
LOCATION: Hybrid, New York, NY

CLIENT: NYS HCR

RATE: $65

DUE: MAY 29TH

37.5 hour work week

INTERVIEW VIRTUAL

NO LAYERS

Visa USC/GC/GC-EAD/H4-EAD

The successful candidate will play a vital role in helping fulfill strategic, analytical and operational reporting requirements.

The client is undergoing a major modernization of their business applications and is seeking a Data Warehouse Developer (Developer) within their Information Technology department to play a key role in this effort, which will include designing and building an enterprise data warehouse.

The Developer must have extensive experience in software analysis, design, development, implementation and maintenance of Data Warehouse/Data Marts. The Developer will work closely with project managers, IT staff, program staff and other stakeholders to define and develop requirements for the enterprise data warehouse. The Developer will apply a range of specialized skills and tools to complete the following specific duties and responsibilities:

The Developer will use their extensive knowledge of business analysis best practices to facilitate requirements sessions and communicate clearly and effectively with end-users, applications developers, senior business managers and other team members. The Developer will be accountable for providing coordination to ensure the appropriate collection of data; documentation of information; and presentation of findings. The Developer will provide documentation and flow-charts of the organization's workflow, as well as ad-hoc query support and report creation.

The Developer must have strong technical knowledge and understanding of IT systems and applications as well as the ability to plan and track business analyses activities as part of a project. The Developer also must have good listening skills and interviewing skills to talk with individuals and groups about their needs and ask the right questions to surface essential requirements information. The ideal candidate will also possess good writing skills to ensure effective communication of information to customers, marketing, managers, and technical staff.

The Developer will report directly to the CIO, and indirectly to the VP / Application Development Manager, and will play a vital role in helping client fulfil its strategic, analytical and operational reporting requirements. The ideal candidate will demonstrate critical thinking skills when solving problems and making recommendations for new solutions.

Qualifications:

  • Bachelor's degree; MBA or relevant technical degree preferred.
  • Minimum 10 years of experience in related professional business/project analyst capacity.
  • A strong background in technology, analysis and critically evaluating information gathered from multiple sources.
  • Experience decomposing high-level information into details, distinguishing user requests from the underlying true needs, and developing solution ideas from requirements.
  • Strong experience writing business requirements documentation (BRDs) and functional requirements documentation (FRDs).
  • Proven experience successfully working in a team setting and ability to reconcile conflicts.
  • Excellent oral and written communication skills.
  • Experience in the housing and financial sector is preferred and a major plus, especially around accounting, bonds, mortgages, underwriting, loans origination and servicing; in addition to, experience around grants, tax credits, property/buildings asset management and compliance reporting.
  • Excellent experience with MS Office 2013/2016 and above as well as design tools and flowcharting tools, e.g. Visio.
  • Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data warehouse applications.
  • Experience in developing Data Warehouse/Data Marts using, as examples, OBIEE, OBI APPS, Cognos, Business Objects, SPSS, SSIS, SSRS, Informatica Power Center, OWB and ODI.
  • Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts.
  • Experience in defining metadata standards for the enterprise data warehouse.
  • Experience in design and development of ETL processes using Dimensional Modeling for ROLAP and MOLAP, ETL technical architecture, and BI load dependency plan, job scheduling and cycle management.
  • Experience in developing end-to-end Data warehouse ETL routines.
  • Experience in using SQL in advanced analytical functions.
  • Experience in writing complex PL/SQL packages stored Procedures, functions, cursors, triggers, views, and materialized views.
  • Experience in creation of enterprise data Warehouse Test plan, Test script creation and Test Script Execution for different test environments such as System, Integration and User Acceptance.
  • Experience developing optimal approach for obtaining data from diverse source system platforms and moving it to the Enterprise Data Warehouse.
  • Experience in Logical and Physical data Models for enterprise data warehouse and applications.
  • Experience developing and configuring Interactive Dashboards with drill-down capabilities, links/images, HTML objects and folders.
  • Proficient in using the time-series functions to support historical time comparison analysis.
  • Experience with Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies.

Day to Day Tasks

  • Designing and building an enterprise data warehouse.
  • Work closely with project managers, IT staff, program staff and other stakeholders to define and develop requirements for the enterprise data warehouse.
  • Use extensive knowledge of business analysis best practices to facilitate requirements sessions and communicate clearly and effectively with end-users, applications developers, senior business managers and other team members.
  • Be accountable for providing coordination to ensure the appropriate collection of data; documentation of information; and presentation of findings.
  • Provide documentation and flow-charts of the organization's workflow, as well as ad-hoc query support and report creation.
  • Plan and track business analyses activities as part of a project.
  • Talk with individuals and groups about their needs and ask the right questions to surface essential requirements information.