Position Details --

Title: Sr. Datawarehouse/ ETL Developer

Location: Hybrid - 1 day on-site in Cambridge, MA

Duration: 6 month CTH

Notes: Public Trust might be required

Daily Responsibilities:

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

MUST HAVES:

• 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
• MS SSIS (Extract, Transform, and Load)
• Data Warehouse Architecture & Design Concepts
• SQL System Agent
• MS Office Tools
• MS SQL server 2014 or later
• Data warehouse SDLC
• Data Integration Services Maintenance & Support
• Data Integration Services Development
• Data Quality
• System Maintenance

PLUSSES:

• Azure cloud platform
• SharePoint
• Visual Studio, Git and GitHub
• Business Analysis
• MS SSRS
• MS Power BI