Senior Datawarehouse/ETL Developer

2 weeks ago

Cambridge, United States Eliassen Group Full time

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, including user interfaces, ETL processes, and data analysis. The Senior Datawarehouse/ETL Developer must have DW SDLC knowledge and experience with MS-SQL Server database development, SQL Server Integration Services, Data Warehouse and database modeling and Data Warehouse architecture.


Due to the nature of this work our client will sponsor this candidate for a security clearance, this process will add 3-6 weeks for the onboarding process.


Top Qualifications, Skills, Experience or Certifications:

Bachelor’s degree and a minimum of ten years of experience providing data security for databases, with experience supporting Enterprise Data Warehouse (EDW Also Software design and development. Five of the ten years of experience must include software project responsibility for the design, deployment, and maintenance of DW/ETL applications.

  • Senior-level DW/ETL designers will demonstrate responsibility for successfully executing project programming tasks independently.



Job Role Specific Requirements:


Core responsibilities and duties; highlight day-to-day activities:

  • Data warehouse SDLC
  • Expertise in DW/ETL development lifecycle for new development and maintenance & Support
  • SDLC Experience with Data Migration related projects
  • Provide the realistic effort and schedule estimation for the work involved.


  • Data Integration Services Maintenance & Support
  • Oversee and manage all data imports, exports, and other interconnections to and from the Data Warehouse (DW).
  • Develop technical requirements, level of effort and scheduling estimates, and implement DW enhancements as requested by the DW Steering Committee.
  • Adjust existing ETL (Extract, Transform, and Load) routines for new data elements and data sources and integrate new data into DW.
  • Oversee and monitor SQL System Agent jobs and analyze any failures.
  • Data Integration Services Development
  • Architect, Design, Develop, Test and Deploy ETLs based on the Standards and needs.


Data Quality

  • Verify that existing DW Dashboards are properly reflecting current DW values.
  • Data Quality Check Audits and Maintenance.
  • Develop the QA deliverables including Testing approach, Test Cases and Test Plan


Task Documentation

  • Experience in Requirement collection process from the Business Users and documenting the same and follow the approval process.
  • Provide updated and current technical and user documentation for DW use and operation.
  • Create and maintain the necessary documentations across SDLC.


System Maintenance

  • Manage database storage, database performance, data availability, perform database compaction and manage the Data Warehouse database size.
  • Perform database consistency checks between Data Warehouse and all other system interacting with Data Warehouse. (e.g., Delphi)
  • DW health check proposal and Implementation


MUST Have Skills:

• MS SSIS (Extract, Transform, and Load)

• Data Warehouse Architecture & Design Concepts

• SQL System Agent

• MS Office Tools

• MS SQL server 2014 or later


Preferred Skills:

• Azure cloud platform

• SharePoint

• Visual Studio, Git and GitHub

• Business Analysis

• MS SSRS

• MS Power BI


Attributes:

• Ability to work independently and manage and report the work without much oversight.

• Team Player, willing to share knowledge and pitch in wherever needed.

• Multi-tasking, Prioritization, and Time Management - Ability to pivot and act in a timely manner.

• Technical Aptitude – capable of handling a multitude of technical issues at the same time.

• Excellent written and verbal communication - Ability to accurately convey and receive information from various level of stakeholders.

• Work and Schedule Flexibility

• Able to work in an in-person and Remote work environments.

• Open to learn new technology and processes to adapt and improve based on the needs.

  • Senior Data Warehouse/ETL Developer

    4 weeks ago

    Cambridge, United States Eliassen Group Full time

    **Must be local to Boston, MA to go onsite 1-2 days a week in Cambridge, MA.**Our government client is looking for a Senior Data Warehouse/ETL Developer to join their team.Due to federal security clearance requirements, applicant must be a United States Citizen or Permanent Resident with the ability to obtain a Public Trust Clearance. We offer a great...

  • Senior Data Warehouse/ETL Developer

    4 weeks ago

    Cambridge, United States Eliassen Group Full time

    **Must be local to Boston, MA to go onsite 1-2 days a week in Cambridge, MA.**Our government client is looking for a Senior Data Warehouse/ETL Developer to join their team.Due to federal security clearance requirements, applicant must be a United States Citizen or Permanent Resident with the ability to obtain a Public Trust Clearance. We offer a great...

  • Senior Data Warehouse/ETL Developer

    4 weeks ago

    Cambridge, United States Eliassen Group Full time

    **Must be local to Boston, MA to go onsite 1-2 days a week in Cambridge, MA.**Our government client is looking for a Senior Data Warehouse/ETL Developer to join their team.Due to federal security clearance requirements, applicant must be a United States Citizen or Permanent Resident with the ability to obtain a Public Trust Clearance. We offer a great...

  • Senior Business Intelligence Developer

    4 weeks ago

    Cambridge, United States Eliassen Group Full time

    **Hybrid in Cambridge, MA.**Our government client is looking for a Senior BI Developer to join their team.Due to federal security clearance requirements, applicant must be a United States Citizen or Permanent Resident with the ability to obtain a Public Trust Clearance. We offer a great benefits package that includes Medical, Dental, and Vision benefits,...

  • Senior Business Intelligence Developer

    4 weeks ago

    Cambridge, United States Eliassen Group Full time

    **Hybrid in Cambridge, MA.**Our government client is looking for a Senior BI Developer to join their team.Due to federal security clearance requirements, applicant must be a United States Citizen or Permanent Resident with the ability to obtain a Public Trust Clearance. We offer a great benefits package that includes Medical, Dental, and Vision benefits,...

  • Senior Frontend Developer

    4 weeks ago

    Cambridge, United States Maris Consulting Group℠ Full time

    Maris ConsultingCambridge, MA Contract-to-HireSenior Front-End DeveloperAbout the role:As a Frontend Engineer, you will work with designers and other developers to build thoughtful and functional interfaces to inspect, interact and analyze large volumetric data sets. You will have ownership over projects as you help us develop new features and get them into...

  • Senior Frontend Developer

    4 weeks ago

    Cambridge, United States Maris Consulting Group℠ Full time

    Maris ConsultingCambridge, MA Contract-to-HireSenior Front-End DeveloperAbout the role:As a Frontend Engineer, you will work with designers and other developers to build thoughtful and functional interfaces to inspect, interact and analyze large volumetric data sets. You will have ownership over projects as you help us develop new features and get them into...

  • Senior Director, Learning

    4 weeks ago

    Cambridge, United States Editas Medicine Full time

    Job DescriptionJob DescriptionAt Editas, we’re driven by a collective purpose, to bring transformative and life changing therapies to people living with serious diseases with the greatest unmet needs. This fuels our drive to excel in scientific innovation, allowing us to harness the power and potential of CRISPR/Cas9 and CRISPR/Cpf1 (Cas12a) gene editing....

  • Senior Director, Learning

    2 weeks ago

    Cambridge, United States Editas Medicine Full time

    At Editas, we're driven by a collective purpose, to bring transformative and life changing therapies to people living with serious diseases with the greatest unmet needs. This fuels our drive to excel in scientific innovation, allowing us to harness the power and potential of CRISPR/Cas9 and CRISPR/Cpf1 (Cas12a) gene editing. We believe our people are at...

  • Senior Director of Business Development

    3 weeks ago

    Cambridge, United States 先声药业 Full time

    Simcere Pharmaceutical Group is a pharmaceutical company driven by innovative R&D. We are committed to "providing today's patients with medicines of the future" across the following core therapeutic areas: oncology, central nervous system, autoimmunity, and infectious disease. Meanwhile, we are also actively expanding our presence in disease areas with...

  • Senior Director of Business Development

    4 weeks ago

    Cambridge, United States 先声药业 Full time

    Simcere Pharmaceutical Group is a pharmaceutical company driven by innovative R&D. We are committed to "providing today's patients with medicines of the future" across the following core therapeutic areas: oncology, central nervous system, autoimmunity, and infectious disease. Meanwhile, we are also actively expanding our presence in disease areas with...

  • Salesforce Platform Developer

    4 weeks ago

    Cambridge, United States Harvard University Full time

    **Position Description** The Salesforce Platform Developer reports to the Director for Software Development and Operation and is responsible for design, hands-on development and maintenance of software solutions built in the Salesforce ecosystem with its out-of-box development platforms such as SFDX and OmniStudio. This role will be a part of Agile...

  • Senior Development Associate, Analytical Development

    3 weeks ago

    Cambridge, Massachusetts, United States Editas Medicine Full time

    At Editas, we’re driven by a collective purpose, to bring transformative and life changing therapies to people living with serious diseases with the greatest unmet needs. This fuels our drive to excel in scientific innovation, allowing us to harness the power and potential of CRISPR/Cas9 and CRISPR/Cpf1 (Cas12a) gene editing. We believe our people are at...

  • Senior Development Associate

    2 weeks ago

    Cambridge, Massachusetts, United States Editas Medicine Full time

    As a member of the Process and Analytical Development (PAD) department, the Senior Development Associate contributes to Editas’s efforts to develop safe and effective cellular therapies using CRISPR-based gene editing technologies. Key Responsibilities and Accountabilities: Perform experimentation to develop cellular processes to support gene-edited cell...

  • Senior Scientist, Antibody Discovery Platform Development

    2 weeks ago

    Cambridge, United States Johnson & Johnson Full time

    Janssen Research & Development, L.L.C., a division of Johnson & Johnson's Family of Companies is recruiting for a Senior Scientist, Antibody Discovery Platform Development located in Cambridge, MA. At Janssen, we never stop working toward a future where disease is a thing of the past. We're the Pharmaceutical Companies of Johnson & Johnson, and you can...

  • Senior Scientist

    3 weeks ago

    Cambridge, United States NanoDx, Inc. Full time

    About the Organization:Are you driven to be a major contributor in an organization that will provide groundbreaking technology in the medical device industry? Are you looking for an opportunity for growth in a company that values its colleagues and their ideas and experience? If you answered yes, then joining NanoDx Inc. may be your next best...

  • Senior Scientist

    4 weeks ago

    Cambridge, United States NanoDx, Inc. Full time

    About the Organization:Are you driven to be a major contributor in an organization that will provide groundbreaking technology in the medical device industry? Are you looking for an opportunity for growth in a company that values its colleagues and their ideas and experience? If you answered yes, then joining NanoDx Inc. may be your next best...

  • Senior Director, Learning

    3 weeks ago

    Cambridge, Massachusetts, United States Editas Medicine Full time

    At Editas, we’re driven by a collective purpose, to bring transformative and life changing therapies to people living with serious diseases with the greatest unmet needs. This fuels our drive to excel in scientific innovation, allowing us to harness the power and potential of CRISPR/Cas9 and CRISPR/Cpf1 (Cas12a) gene editing. We believe our people are at...

  • Senior Scientist, Technical Development

    2 weeks ago

    Cambridge, Massachusetts, United States Biogen Full time

    Job Description About This Role Biogen is searching for a biophysicist to fill a Senior Scientist position within the Analytical Development (AD) – Biologics/Advanced Therapies & Medicinal Products (ATMP) department in Cambridge, MA. This key technical leadership role will lead the biophysical and higher-order-structure characterization for biologics...

  • Senior Content Manager

    4 weeks ago

    Cambridge, Massachusetts, United States Veralto Full time

    Veralto's Water Quality companies—Aquatic Informatics, ChemTreat, Hach, McCrometer, OTT HydroMet, Sea-Bird Scientific, Trojan Technologies, and XOS—help customers manage, treat, purify, and protect the global water supply, from municipal and wastewater treatment facilities to lakes, rivers, watersheds, and oceans.And our Product Quality and Innovation...