Software Development IV

2 weeks ago


Cambridge, United States Dansources Technical Services Full time
Job DescriptionJob Description

Software Development IV - Hybrid Role - 1 Day on-site @ Cambridge, MA office

Job 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, 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.

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.

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

Job Role Specific Requirements:

  • Data warehouse SDLC
    1. Expertise in DW/ETL development lifecycle for new development and maintenance & Support
    2. SDLC Experience with Data Migration related projects
    3. Provide the realistic effort and schedule estimation for the work involved
  • Data Integration Services Maintenance & Support
    1. Oversee and manage all data imports, exports, and other interconnections to and from the Data Warehouse (DW).
    2. Develop technical requirements, level of effort and scheduling estimates, and implement DW enhancements as requested by the DW Steering Committee.
    3. Adjust existing ETL (Extract, Transform, and Load) routines for new data elements and data sources and integrate new data into DW.
    4. Oversee and monitor SQL System Agent jobs and analyze any failures.
  • Data Integration Services Development
    1. Architect, Design, Develop, Test and Deploy ETLs based on the Standards and needs.
  • Data Quality
    1. Verify that existing DW Dashboards are properly reflecting current DW values.
    2. Data Quality Check Audits and Maintenance.
    3. Develop the QA deliverables including Testing approach, Test Cases and Test Plan
  • Task Documentation
    1. Experience in Requirement collection process from the Business Users and documenting the same and follow the approval process.
    2. Provide updated and current technical and user documentation for DW use and operation.
    3. Create and maintain the necessary documentations across SDLC.
  • System Maintenance
    1. Manage database storage, database performance, data availability, perform database compaction and manage the Data Warehouse database size.
    2. Perform database consistency checks between Data Warehouse and all other system interacting with Data Warehouse. (e.g., Delphi)
    3. DW health check proposal and Implementation

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.

*Note: Candidate must be a U.S. citizen or green card holder who has resided in the U.S. for at least 3 years and the ability to obtain a public trust*



  • Cambridge, United States Dansources Technical Services Full time

    Job DescriptionJob DescriptionSoftware Development IV - Hybrid Role - 1 Day on-site @ Cambridge, MA officeJob 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...

  • Software Developer

    Found in: beBee jobs US - 6 days ago


    Cambridge, Massachusetts, United States Quality Coding Software Solutions LLC Full time

    Software DeveloperJob DescriptionOverviewQCSS Health is seeking a Software Developer to support our current SaaS applications and contribute to building next gen products. We offer an exciting opportunity to support Medicaid health plans and providers in improving health care outcomes for vulnerable populations. Our solutions positively impact over one...

  • Software Development Engineer

    Found in: beBee jobs US - 3 weeks ago


    Cambridge, Massachusetts, United States Philips Full time

    Software Development Engineer (Cambridge, MA)Work as a Software Engineer in the Hospital Patient Monitoring Team, and you will be working in an Agile environment responsible for designing, developing, and testing software for our new Real-time Patient Monitoring platform using technologies including .NET Framework, C#, React, GraphQL, Postgres, Kafka, and...


  • Cambridge, United States CareerBuilder Full time

    SOFTWARE DEVELOPER 2 , Computer Science and Artificial Intelligence Laboratory (CSAIL)- MIT RAISE (Responsible AI for Social Empowerment and Education) , to play a key role in the evolution, operation, and educational research with an emphasis on developing and supporting technology that will be integrative across three RAISE initiatives. RAISE builds tools...

  • Software Engineer

    1 week ago


    Cambridge, United States Next Jump Full time

    Next Jump seeks a Software Engineer in our Cambridge, Massachusetts office who will Design, architect and code advanced Web 2.0 applications Platforms and services to implement & support the Next Jump rewards & loyalty programs for its clients. The Engineer will play a key role in every aspect of project strategy, design & implementation. The Engineer will...

  • Software Engineer

    Found in: beBee jobs US - 4 days ago


    Cambridge, Massachusetts, United States Foundation Medicine Full time

    About the JobThe Software Engineer is a crucial part of the Computational Biology Team and is broadly responsible for building and supporting the software applications and their components. The technical products which are developed by the incumbent filling this position help doctors match patients to more advanced treatment options. This position completes...

  • Software Engineer

    Found in: beBee S US - 5 days ago


    Cambridge, United States Foundation Medicine Full time

    About the Job The Software Engineer is a crucial part of the Computational Biology Team and is broadly responsible for building and supporting the software applications and their components. The technical products which are developed by the incumbent filling this position help doctors match patients to more advanced treatment options. This position...

  • Software Engineer

    Found in: Talent US C2 - 5 days ago


    Cambridge, United States MIT Full time

    Job Description SOFTWARE ENGINEER , , Systems Engineering Team, to engage with interdisciplinary research groups across MIT to determine requirements, iterate on architectural specifications, and produce robust, scalable systems that meet identified needs in biological and artificial intelligence research. Past projects include a Monte Carlo-based...

  • Sr Software Engineer

    Found in: beBee jobs US - 1 week ago


    Cambridge, Massachusetts, United States Foundation Medicine Full time

    About the JobThis position is a member of the Systems sub-team of the Computational Biology, Engineering group. This team is responsible for developing components of, and programmatic interfaces to, the genomics platform and analysis pipeline codebase. We build backend systems that power global production operations and research on cloud deployed systems....

  • Senior Software Engineer

    Found in: beBee jobs US - 1 week ago


    Cambridge, Massachusetts, United States Harvard Business School Online Full time

    Harvard Business School Online's case-based, active, and social learning model provides educational experiences that help learners achieve their personal and professional goals wherever they are in their career, or the world. Who will build and support these exciting tools? You will Your work will be seen and used regularly by students around the world. If...


  • Cambridge, United States edX Full time

    Software Solutions Architect at edX - Djangojobs.Net Login Register Jobs Companies Post About Pricing Salary Contact Software Solutions Architect at edX Cambridge,MA,United States May 18, 2015 Position Overview: edX is looking for an experienced software engineer to join our Solutions team. The Solutions team builds technology and features for edX's Open...


  • Cambridge, United States Metric Bio Full time

    Our client, a prominent Global Pharmaceutical Company with a rich legacy, dedicated to maintaining the most comprehensive and innovative portfolio in the industry. Renowned for ground-breaking R&D, the company invests significantly in identifying, developing, and delivering innovative solutions to enhance the treatment of diseases and illnesses. Role...

  • Principal Software Engineer

    Found in: Talent US C2 - 5 days ago


    Cambridge, United States Broad Institute Full time

    Description & Requirements Are you a software engineer who wants to make a difference, transform medicine, and improve human health? The Broad Institute is looking for a passionate Principal Software Engineer to help us build researcher tools that will enable the next decade of scientific discovery in human medicine. The project: You’ll be...


  • Cambridge, United States Metric Bio Full time

    Our client, a prominent Global Pharmaceutical Company with a rich legacy, dedicated to maintaining the most comprehensive and innovative portfolio in the industry.Renowned for ground-breaking R&D, the company invests significantly in identifying, developing, and delivering innovative solutions to enhance the treatment of diseases and illnesses.Role...

  • Senior Clinical Development Director

    Found in: Appcast US C2 - 2 weeks ago


    Cambridge, United States Metric Bio Full time

    Our client, a prominent Global Pharmaceutical Company with a rich legacy, dedicated to maintaining the most comprehensive and innovative portfolio in the industry.Renowned for ground-breaking R&D, the company invests significantly in identifying, developing, and delivering innovative solutions to enhance the treatment of diseases and illnesses.Role...

  • Senior Clinical Development Director

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago


    Cambridge, United States Metric Bio Full time

    Our client, a prominent Global Pharmaceutical Company with a rich legacy, dedicated to maintaining the most comprehensive and innovative portfolio in the industry.Renowned for ground-breaking R&D, the company invests significantly in identifying, developing, and delivering innovative solutions to enhance the treatment of diseases and illnesses.Role...

  • Embedded Software Test Engineer

    Found in: beBee jobs US - 1 week ago


    Cambridge, Massachusetts, United States Superpedestrian Full time

    Superpedestrian is engineering the future of micromobility. The Superpedestrian team is composed of some of the most talented operations specialists, policy managers, designers and engineers, all focused on transforming the future urban mobility. Our scooters, called LINK, were designed to prioritize safety from the inside out, and our Superpedestrian team...


  • Cambridge, United States ICONSTAFF Full time

    Job DescriptionJob DescriptionOur clients mission it to empower doctors with real time diagnostic tools to improve patient outcomes. They are looking for an experienced manager for their platform engineering team.The successful candidate will be part of the engineering leadership team and manage a group of frontend, backend and data engineers. Please come...


  • Cambridge, United States ICONSTAFF Full time

    Job DescriptionJob DescriptionThis is an opportunity to drive the development and deployment of world-class privacy and security services.If you have experience working in a startup, this could be the place for you.You will have the opportunity to help build and shape the technologies that bring much-needed reform to the field of secure systems.The Principal...

  • Software Engineer II, WebApps

    Found in: beBee S US - 5 days ago


    Cambridge, United States Foundation Medicine Full time

    About the Job The Software Engineer II, Computational Biology (WebApps Team) will work as part of a new product team, focused on improving blood-based cancer diagnostic capabilities in areas such as cancer detection, minimum residual disease, and other related applications. This team is comprised of talent from across the Roche ecosystem, including Roche...