Description

You will design and implement ETL processes to support data integration and analytics initiatives.

Responsibilities

• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) to load data into the data warehouse.
• Translate business requirements into technical specifications for ETL development.
• Optimize SQL queries, stored procedures, and views to support reporting and integration.
• Monitor and troubleshoot ETL jobs to ensure pipeline reliability and performance.
• Conduct data validation and reconciliation to ensure accuracy across systems and document data mappings and lineage.

Required Skills

• 5+ years of experience in business intelligence or data warehousing environments.
• Expertise in developing ETL processes using SSIS.
• Strong proficiency in SQL programming and SQL Server database management.
• Solid understanding of relational database concepts and data modeling principles.
• Experience with dimensional modeling techniques.
• Bachelor's Degree in Computer Science, Information Systems, or a related field.
• Ability to interpret complex data sets and extract actionable insights.

Preferred Skills

• Experience with Power BI, Tableau, or QlikView.
• Relevant certifications in SQL Server or business intelligence technologies.

Key Skills

Education

Bachelor's Degree