**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 W2
Skills, 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
Requirements of the Data Warehouse/ETL Developer: - 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
Please be advised- If anyone reaches out to you about an open position connected with Eliassen Group, please confirm that they have an Eliassen.com email address and never provide personal or financial information to anyone who is not clearly associated with Eliassen Group. If you have any indication of fraudulent activity, please contact InfoSec@eliassen.com.
Job ID: 383713
About Eliassen Group:
Eliassen Group is a leading strategic consulting company that provides business and IT services for our clients as they seek to transform and execute strategies that will drive exceptional outcomes. Leveraging over 30 years of success, we focus on professional services, talent solutions, and life sciences. Eliassen Group offers local community presence and deep networks. We are committed to positively impacting the lives of our employees, clients, consultants, and the communities in which we operate.
Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
Don’t miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!
