Jobs
>
Cambridge

    Senior Datawarehouse/ETL Developer - Cambridge, United States - Eliassen Group

    Eliassen Group
    Eliassen Group Cambridge, United States

    2 weeks ago

    Default job background
    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.

    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.

  • Eliassen Group

    Senior Datawarehouse/ETL Developer

    2 weeks ago

    Eliassen Group Cambridge, United States

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

  • Matal

    ETL Developer

    2 weeks ago

    Matal Boston, United States Full time, Part time, Contract, Training

    Responsibilities Analyze and evaluate detailed business functional and high-level technical requirements. Assume responsibility by ensuring that design/code reviews are scheduled and executed. Provide feedback and recommend solutions. Ensure that design standards and documentatio ...

  • FirstPRO

    ETL Developer

    1 day ago

    FirstPRO Watertown, United States

    FirstPro is now accepting resumes for an ETL Developer based in Waltham, MA. This role will focus on providing engineering support for routine daily and long term monitoring, process design and economic benefit analysis for process units from a data perspective. This is a contrac ...

  • Global Channel Management

    ETL Developer

    5 hours ago

    Global Channel Management Winchester, United States

    About the job ETL Developer · ETL Developer needs 8+ years experience · ETL Developer requires: · Expertise in data mapping from transactional application to data warehouse · Data validation · Data mapping · Data warehousing · ETL Developer duties: · Develop and maintain ...

  • Global Channel Management

    ETL Developer

    1 hour ago

    Global Channel Management Winchester, United States

    ETL Developer needs 8+ years' experience · ETL Developer requires: · Expertise in data mapping from transactional application to data warehouse · Data validation · Data mapping · Data warehousing · ETL Developer duties: · Develop and maintain ETL processes that meet projec ...

  • firstPRO, Inc

    ETL Developer

    5 days ago

    firstPRO, Inc Waltham, United States

    firstPRO is now accepting resumes for an ETL Developer with Experience in Matillion(ETL) and Snowflake. This is a 6+month contract with a hybrid schedule. · 2. Experience in Data warehousing. · 3. Strong SQL Skills. · Provides engineering support for routine daily and long term ...

  • Federal Home Loan Bank of Boston

    Senior ETL Developer

    1 week ago

    Federal Home Loan Bank of Boston Boston, United States Full time

    The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place ...

  • Raise

    ETL Developer

    5 days ago

    Raise Waltham, United States

    We're Hiring Our key client is hiring and looking to add an ETL Developer to their team. Please check the description below and reach out to us for more details if you are interested. · Pay Rate: $55.00-$65.00/hour on W2 · Work Type: Onsite – Waltham, MA 02451 · Duration: 6-month ...

  • firstPRO, Inc

    ETL Developer

    5 days ago

    firstPRO, Inc Waltham, United States

    FirstPro is now accepting resumes for an ETL Developer based in Waltham, MA. This role will focus on providing engineering support for routine daily and long term monitoring, process design and economic benefit analysis for process units from a data perspective. This is a contrac ...

  • Raise

    ETL Developer

    3 days ago

    Raise Waltham, United States

    Were Hiring Our key client is hiring and looking to add an ETL Developer to their team. Please check the description below and reach out to us for more details if you are interested. · Pay Rate: $55.00-$65.00/hour on W2 · Work Type: Onsite Waltham, MA 02451 · Duration: 6-month ...

  • Global Channel Management

    ETL Developer

    1 week ago

    Global Channel Management Woburn, United States

    Job Description: ETL Developer needs 6+ years' experience ETL Developer requires: Database design and DBA experience Experience with ODI 12C2. Experience in Data warehousing Strong Communication Skills4. ETL Developer duties: Perform transactional applications (source) to data wa ...

  • NavitsPartners

    Talend Senior ETL Developer

    3 days ago

    NavitsPartners Somerville, United States

    Job Description · Job DescriptionPosition: Talend Senior ETL Developer · Duration: 12 months · Location: HYBRID (Tue/Wed onsite - Back Bay area, Boston ) · Extension: Highly possible · Position Summary · The Client needs a talented Talend Senior ETL Developer to assist with t ...

  • Global Channel Management

    DBA ETL Developer

    1 week ago

    Global Channel Management Winchester, United States

    About the job DBA ETL Developer DBA/ETL Developer needs database design and DBA experienceDBA/ETL Developer requires:Experience with ODI 12C2.Experience in Data warehousing3.Strong Communication SkillsDBA/ETL Developer duties:Perform transactional applications (source) to data wa ...

  • Global Jupiter

    Senior Data Warehouse/ETL Developer

    3 days ago

    Global Jupiter Cambridge, United States

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

  • Arbella Insurance

    ETL Developer

    1 week ago

    Arbella Insurance Quincy, United States Full time

    Why Arbella? · At Arbella, we're focused on people. We work hard to attract and retain the best. That means providing a great work environment, encouraging work/life balance, offering flexible work arrangements, competitive salaries and exceptional benefits packages. We invest i ...

  • Arbella Insurance

    ETL Developer

    3 days ago

    Arbella Insurance Quincy, United States

    Why Arbella? At Arbella, we're focused on people. We work hard to attract and retain the best. That means providing a great work environment, encouraging work/life balance, offering flexible work arrangements, competitive salaries and exceptional benefits packages. We invest in o ...

  • Global Channel Management

    DBA ETL Developer

    1 week ago

    Global Channel Management Winchester, United States

    About the job DBA ETL Developer · DBA/ETL Developer needs database design and DBA experience · DBA/ETL Developer requires: · Experience with ODI 12C2. · Experience in Data warehousing3. · Strong Communication Skills · DBA/ETL Developer duties:Perform transactional applicati ...

  • Global Network Technologies

    Sr. Talend ETL Developer

    1 week ago

    Global Network Technologies Boston, United States

    Job Description · Job DescriptionJob Title: Sr. Talend ETL Developer · Location requirements/Schedule: Hybrid · Location/s: : 501 Boylston Street, Suite 5100, Boston, MA 02116 Local Candidates · Start Date: ASAP · Bonus/Benefits: NO · Type of contract: C2C, W2, Contract to Hire C ...

  • Eliassen Group

    Senior Data Warehouse/ETL Developer

    6 days ago

    Eliassen Group Cambridge, United States

    **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 ...

  • Eliassen Group

    Senior Data Warehouse/ETL Developer

    2 weeks ago

    Eliassen Group Cambridge, United States

    **Must be local to Boston, MA to go onsite 1-2 days a week in Cambridge, MA.** · Submit your CV and any additional required information after you have read this description by clicking on the application button. · Our government client is looking for a Senior Data Warehouse/ETL ...