Senior Data Warehouse/ETL Developer
Eliassen Group
- Cambridge, MA
- $60.00-65.00 per hour
- Contract
- Full-time
- {{$parent.googlePlacesAutocompleteEnabled ? location.description : location}}
0" ng-cloak> * {{keyword}}Location:
0" ng-cloak> * {{$parent.googlePlacesAutocompleteEnabled ? location.description : location}}Locations (up to three): {{$item.description}} {{$parent.googlePlacesAutocompleteEnabled ? location.description : location}}Senior Data Warehouse/ETL Developer in Cambridge, MA at Eliassen GroupDate Posted: 9/4/2024Job SnapshotEmployee Type:ContractorLocation:Job Type:Experience:Not SpecifiedDate Posted:9/4/2024Fully RemoteNoJob Description **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 benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.Pay Rate: $60.00 - $65.00/hr on W2Skills, experience, and other compensable factors will be taken into account when determining pay rate. The pay range provided in this posting is a reflection of a W2 hourly rate; other employment options may be available that may result in pay outside of the provided pay range.W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality.Responsibilities of the Senior Data Warehouse/ETL Developer:
- 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
- Adjust existing ETL 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
- Architect, Design, Develop, Test and Deploy ETLs based on the Standards and needs
- Verify that existing DW Dashboards are properly reflecting current DW values
- Develop the QA deliverables including Testing approach, Test Cases and Test Plans
- Create and maintain the necessary documentations across SDLC
- Provide updated and current technical and user documentation for DW use and operation
- 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
- A Bachelor's degree in Computer Science or related field and at least 10 years of experience providing data security for databases
- 5 of the 10 years of experience must include software project responsibility for the design, deployment, and maintenance of DW/ETL applications
- Experience supporting Enterprise Data Warehouse
- Experience in Requirement collection process from the Business Users and documenting the same and follow the approval process
- Experience with MS Office Tools and MS SQL server 2014 or later
- Experience with MS SSIS (Extract, Transform, and Load)
- Experience with Data Warehouse Architecture & Design Concepts
- Experience with SQL System Agent
- Expertise in DW/ETL development lifecycle for new development and maintenance & support