Senior Datawarehouse/ETL Developer

3 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

    1 month 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

    1 month 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

    1 month 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 Manager, Strategy

    3 days ago

    Cambridge, United States Simcere Zaiming Full time

    Position Overview:Reporting to Executive Director, Business Development & Licensing, this position will play a crucial role as a key partner within the Business Development team and the senior management team. This position involves developing tactical and strategic execution to achieve department goals. The role includes overseeing the team's engagement in...

  • Senior Manager, Strategy

    2 days ago

    Cambridge, United States Simcere Zaiming Full time

    Position Overview:Reporting to Executive Director, Business Development & Licensing, this position will play a crucial role as a key partner within the Business Development team and the senior management team. This position involves developing tactical and strategic execution to achieve department goals. The role includes overseeing the team's engagement in...

  • Senior Manager, Strategy

    2 days ago

    Cambridge, United States Simcere Zaiming Full time

    Position Overview:Reporting to Executive Director, Business Development & Licensing, this position will play a crucial role as a key partner within the Business Development team and the senior management team. This position involves developing tactical and strategic execution to achieve department goals. The role includes overseeing the team's engagement in...

  • Senior Development Associate, Analytical Development

    4 days ago

    Cambridge, Massachusetts, United States Editas Medicine Full time

    At Editas, we are united by a common goal: to deliver groundbreaking therapies to individuals facing severe illnesses with the most critical needs. This ambition propels us to strive for excellence in scientific advancement, enabling us to leverage the potential of CRISPR/Cas9 and CRISPR/Cpf1 (Cas12a) gene editing.We firmly believe that our team members are...

  • Senior Director, Learning

    1 month 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 Software Development Engineer

    2 days ago

    Cambridge, United States Philips Full time

    Job Title Senior Software Development Engineer Job Description Software Development Engineer (Cambridge, MA) As a leader of a full-stack agile team, design, develop, and test software for our existing and new Real-time Patient Monitoring platform using technologies including .NET Framework, C#, AWS, Angular, SQLServer Postgres, Kafka, and Kubernetes. Design...

  • Senior Director of Business Development

    1 month 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...

  • Senior Development Associate, Analytical Development

    4 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

    3 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

    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 Scientist

    1 month 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, Business Development and Strategy, Count Me In

    17 hours ago

    Cambridge, United States Broad Institute Full time

    Description & Requirements Senior Director, Business Development and StrategyThe Broad Institute has played a pivotal role in mapping the genetic basis of disease, and developed operational frameworks and software platforms to engage patients through web-based study recruitment. We are well-positioned to lead the next phase of transformation for rare...

  • Senior Scientist, Technical Development

    3 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

    1 month 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...