Roles & responsibilities
develop, design, tune, and maintain ssis packages
design and develop sql server stored procedures, functions, views and triggers to be used during the etl process.
Write scripts for automated testing of data in the target facts and dimensions.
Capture audit information during all phases of the etl process.
Write and maintain documentation of the etl processes via process flow diagrams.
Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
Collaborate with business users, support team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse.
Maintain documentation on all ssis packages developed and deployed.
Assist in the development of data integration strategies for new data sources
keep abreast of new features and functionality in ssis and make recommendations on how they can be utilized to improve etl processes
provide training and support to other team members on the use of ssis
required skills and qualifications
5+ years in a professional software development role
3+ years experience with ssis development, including data warehousing and etl
experience developing complex sql queries for data analysis
familiarity with t-sql and stored procedures
preferred skills and qualifications
experience with azure data factory
experience with power bi or other business intelligence tools
experience with git or other source control management systems
experience/knowledge in crm dynamics will be added advantage.
Tipo de puesto: tiempo completo, por tiempo indeterminado
salario: $80,000.00 - $95,000.00 al mes
horario:
- turno de 8 horas
prestaciones:
- días por enfermedad
- programa de referidos
- seguro de gastos médicos
- seguro de gastos médicos mayores
- seguro de vida
- trabajo desde casa
- vales de despensa
tipos de compensaciones:
- bono anual
- bono mensual
- bono trimestral
lugar de trabajo: empleo remoto