Senior ETL Developer

• Responsible for maintenance and enhancement of current SSIS packages and data pipeline configurations

• Exercise good judgment, identify gaps in processes, and remediate antiquated ETL techniques

• Design, implement, and maintain ETL processes, procedures and policies in support of data operations

• Create efficient SSIS/SSDT packages for small and large data sets, ensuring performance, reliability, and consistency

• Automate SSIS/SSDT jobs and stored procedures

• Lead the team in implementing and improving SSIS Data Flow transformations

• Facilitate and work with teams to quickly identify, debug, and resolve technical project challenges

• Carry out monitoring, tuning, and database performance analysis

• Utilize ad-hoc techniques to perform on-the-fly analysis of data

• Develop stored procedures that conform to specific outputs and performance requirements to support

• Create and maintain SQL agent jobs that provide customer reporting and data maintenance

• Merge and analyze ambiguous data from disparate data sources

• Model and document processes and data flows
  

Qualifications:

• 5+ years of experience in ETL or Data Engineering development

• Subject matter expertise in SSIS ETL packages T-SQL

• Proven history in senior or lead role