ETL Developer

Bethesda, MD · Information Technology

TalEx is partnering with a top place to work in the DC area to identify an ETL Developer. This is a direct hire position located in Bethesda, MD.

Data Warehouse Essential Duties and Responsibilities

Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) as necessary to connect legacy data stores, the data warehouse, and third-party platforms including Salesforce
Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
Ensure the stabilization and high performance of existing ETL processes
Troubleshoot any complex data-related issues as well as provide support to production
Develop and deploy ETL job workflow with reliable error/exception handling and rollback
Drive process improvement and improve process efficiency
Document all ETL and data warehouse processes and flows
Communicate issues, risks and concerns proactively to management
Performs other related duties as required

Education and Experience

Bachelor's degree in Computer Science, Engineering or related discipline
5+ years of professional experience in ETL development and Microsoft SSIS, SSAS
5+ years of professional experience in T-SQL development, debugging and optimization
Experience working in an Agile environment (Scrum, Kanban)
Experience with SQL Server Reporting Services (SSRS) is a plus

Knowledge, Skills and Abilities

Effective decision making and critical thinking skills for problem identification and solution recommendations
Ability to be flexible, set priorities and meet deadlines in a changing environment for self and team
Passionate in providing excellent customer service
Outstanding verbal and written communication skills
Detail-oriented while consistently looking at the big picture