Create Email Alert

ⓘ There was an unexpected error processing your request.

Please refresh the page and try again.

If the problem persists, please contact us with your issue.

Email address is already registered

You can always manage your preferences and update your interests to ensure you receive the most relevant opportunities.

Would you like to [visit your alert settings] now?

Success! You're now signed up for Job Alerts

Get ready to discover your next great opportunity.

Similar Jobs

  • FMCNA Integrated Care Group

    Lead Data Warehouse Developer

    Lexington, MA, United States

    • Ending Soon

    **PURPOSE AND SCOPE:** Responsible for the delivery of enterprise data warehouse, data lake and cloud analytical platform solutions. Working closely with FMC clinical, business and IT colleagues, this experienced developer is responsible for analysis, design, development and on-going support for assigned programs and projects. Responsible for mento

    Job Source: FMCNA Integrated Care Group
  • Kyyba

    Data Warehouse BI Developer Lead

    Quincy, MA, United States

    • Ending Soon

    DETALIED LIST OF JOB DUTIES: • Providing functional and technical guidance to the BI development team. • Managing daily technical challenges and communicates to management any risks or issues. • Interacting with technical teams and development resources to help translate requirements into BI solutions, reports, and dashboards. This will include usi

    Job Source: Kyyba
  • New England Life Care

    Data Warehouse Developer

    Woburn, MA, United States

    • Ending Soon

    New England Life Care (NELC) is one of the fastest growing home infusion therapy services companies in New England and is the region’s only non-profit home infusion provider. NELC is a hospital collaborative serving more than 70 hospital systems in Maine, New Hampshire, and Massachusetts. NELC was created by local hospitals to ensure their patients

    Job Source: New England Life Care
  • New England Life Care

    Data Warehouse Developer

    Woburn

    • Ending Soon

    Job Description Job Description New England Life Care (NELC) is one of the fastest growing home infusion therapy services companies in New England and is the region’s only non-profit home infusion provider. NELC is a hospital collaborative serving more than 70 hospital systems in Maine, New Hampshire, and Massachusetts. NELC was created by

    Job Source: New England Life Care
  • Kyyba

    Data Warehouse Developer

    Quincy, MA, United States

    • Ending Soon

    POSITION SUMMARY: The Data Warehouse Report Developer will support existing warehouse analytics and provide input on best practices and potential efficiencies, work on multiple assignments concurrently to meet aggressive due dates, uses a range of expert technical skills based on a keen knowledge of data warehouse concepts, and must be highly profi

    Job Source: Kyyba
  • The MathWorks Inc

    Data Warehouse Developer

    Natick, MA, United States

    • Ending Soon

    Join our Data Warehouse team and help MathWorks solve interesting business problems, design top notch analytics, and make well-informed decisions.You will immerse yourself in specific areas of the business like Marketing, Sales, Finance, and Customer Service.You will become an expert in business processes and the analytics needed to support them.Yo

    Job Source: The MathWorks Inc
  • Global Jupiter

    Senior Data Warehouse/ETL Developer

    Cambridge, MA, United States

    • Ending Soon

    Description The Senior Datawarehouse/ETL Developer has expertise in MS SQL server-based data warehouse deployment, management, and maintenance. This position requires experience with enhancing and maintaining an existing data warehouse, integration of various source data systems, deploys and tests enhancements to the Data Warehouse system, includin

    Job Source: Global Jupiter
  • The Mathworks

    Senior Data Warehouse Developer/Analyst

    Natick, MA, United States

    Working under the direction of the Manager or Senior Team Lead, will be responsible for designing, developing and testing sophisticated data warehouse software; designing and developing data mart solutions to provide MathWorks with valuable customer and product insights; profiling and understanding large amounts of source data, including structured

    Job Source: The Mathworks

Lead Data Warehouse Developer

Lexington, MA, United States

Purpose and Scope:

Responsible for the delivery of enterprise data warehouse, data lake and cloud analytical platform solution.

Principal Duties and Responsibilities:

Designing enterprise warehouse, cloud data platform and data management initiatives.

Design and architect enterprise data warehouse following the data-vault and dimensional data modelling methodology.

Design the architecture to perform data management activities i.e., data extraction, transformation and load (ETL) to enterprise data warehouse. Implement the data management solutions using SQL, SQL procedures, Unix, Python, data management tools like Informatica power center SQL on Oracle exadata database.

Designing, implementing, maintaining and supporting data stores used for reporting and analytics (such as data lake, data warehouse systems and related data marts).

Design the overall architecture to Extract, Transform and Load (ETL) data into data warehouse or data mart and data lake

Develop code using SQL, SQL procedures, UNIX, python, ETL tools like Informatica Power center, AWS services like S3, data pipeline, AWS Glue, Python, AWS Lambda and Athena, Azure services like Data Lake, Data factory and Databricks to Load data into Data warehouse/DataMart/Data Lake.

Coordinating with peers from other clinical and IT groups to ensure successful design, planning and completion of programs and projects.

Understand the Upstream and downstream application process as part of requirement gathering working with peers from other clinical and IT groups.

Understanding business requirements and priorities to shape the scope and requirements of the Data Warehouse solution.

Gather and understand business requirements and translate business requirements to Functional and technical requirements for data warehouse solution.

Performing data analysis and data provisioning against source systems.

Perform analysis against source data by running complex SQLs and develop ETL code for getting more insights on source data as part of requirement gathering.

Perform data analysis on source data to investigate and resolve production issues reported by end users.

Designing the processes to acquire and integrate disparate data from multiple sources.

Design and develop ETL process using SQL and Informatica to load data into data warehouse on daily basis from various source application on SQL Server, Oracle, Cloud Sources and files

Design and develop the process in AWS or Microsoft Azure to integrate real-time IOT data and On Premise data into Data Lake.

Assisting in the data architecture design to be used for Business Intelligence and Analytical purposes.

Assist downstream users with data warehouse related requirements & architecture Questions and provide SQL’s and develop ETL code to read data from data warehouse for business intelligence and Analytical needs.

Documenting technical specifications for the design of data integration and data architecture.

Document functional and technical requirements in technical specification for developing code using SQL, SQL procedure, Unix, Python and ETL tools like Informatica Power center.

Performing unit testing to assure quality repeatable, quality processes with accurate data results and Installing processes for auditing target data stores and ensuring data quality.

Providing input and experience on the architecture, design and evolution of FMCNA enterprise warehouse and information delivery solutions, including tool selection, migration strategies, and risk mitigation.

Education Experience and Required Skills:

Position requires a Bachelor’s degree (or an equivalent foreign degree) in Computer Science, Electrical Engineering, IT or a closely related field and 8 years of experience as a Data Warehouse Developer. Must also have 5 years of experience (which can have been gained concurrently with the other experience requirements) working with Informatica Power Center, SQL Server, SQL and PLSQL, Dimensional and Data Vault Modeling, ETL design, Python and Unix Scripting; and 2 years of experience (which can have been gained concurrently with the other experience requirements) working with AWS services including S3, data pipeline, AWS Glue, AWS Lambda, EMR and Athena.

Apply

Create Email Alert

Create Email Alert

Lead Data Warehouse Developer jobs in Lexington, MA, United States

ⓘ There was an unexpected error processing your request.

Please refresh the page and try again.

If the problem persists, please contact us with your issue.

Email address is already registered

You can always manage your preferences and update your interests to ensure you receive the most relevant opportunities.

Would you like to [visit your alert settings] now?

Success! You're now signed up for Job Alerts

Get ready to discover your next great opportunity.