We are seeking a senior T-SQL ETL Developer to be part of a new DW/BI initiative. The position is remote and contract-to-hire.  This role will be primarily responsible for ETL load processes into the Data Warehouse.  Work with the Data Architect and Reporting/Analytics team to identify potential areas of improvement in the ETL process. The ideal candidate needs to be highly motivated, with the ability to actively engage with the team.
Position Duties and Responsibilities
  • Expert understanding of OLTP and OLAP relational database architecture
  • Expert understanding of principles and mechanics of moving bulk data
  • Deep proficiency in T-SQL and SQL Server Performance Tuning
  • Proficient knowledge of SQL Server Integration Services (SSIS)
  • Strong written and verbal communication skills
  • Ability to work independently or alongside the team
  • Design and maintain data integration processes between Data Warehouse and external data sources
  • Create and maintain all design documents related to ETL processes for the Data Warehouse
  • Develop stored procedures as part of the ETL load process
  • Optimize existing ETLs for performance
  • Mentor other members of the team and supervise their work
DESIRED PROFESSIONAL SKILLS AND EXPERIENCE
  • B.S. in Computer Science / Software Engineering
  • 7 to 10 years of relevant experience in a data integration environment
  • At least 3 years of tech lead experience in a BI / data integration team

Apply Now