As a consultant in the workforce solution/Technology team, you will be responsible for designing, developing, and maintaining data integration and reporting solutions with a strong focus on SQL Server and SSIS (SQL Server Integration Services). You will work closely with business stakeholders and technical teams to deliver scalable data pipelines, ETL processes, and reporting solutions that enable data-driven decision-making. This role requires strong technical expertise in SQL development and ETL processes, attention to detail, and the ability to manage multiple priorities in a fast-paced environment.
Key job responsibilities:
- 6 years of relevant experience in SQL development, data engineering, or ETL development.
- Design, develop, and maintain ETL workflows using SSIS (SQL Server Integration Services).
- Write, optimize, and maintain complex SQL queries, stored procedures, functions, and views.
- Work with SQL Server databases for data extraction, transformation, and loading processes.
- Perform data validation, data quality checks, and performance tuning of queries and ETL pipelines.
- Develop and support reporting solutions using SSRS or similar reporting tools.
- Troubleshoot and resolve data issues, ensuring reliability and accuracy of data pipelines.
- Collaborate with cross-functional teams to gather requirements and deliver data solutions.
- Support legacy systems and assist in enhancements or migration projects as required.
- Follow best practices for data security, governance, and coding standards.
- Participate in deployment activities and maintain documentation for ETL and database processes.
Education/Background:
Bachelor / Master degree in Computer Science Engineering, or a related field.
Key skills:
· Strong hands-on experience with SQL Server and T-SQL development.
· Experience with SSIS (SQL Server Integration Services) for ETL development.
· Ability to write complex SQL queries, optimize performance, and handle large datasets.
· Good understanding of data warehousing concepts (fact/dimension tables, star schema).
· Experience working with SSRS or other reporting tools.
· Knowledge of data integration, transformation, and validation techniques.
· Strong analytical and problem-solving skills.
· Good communication and collaboration skills.
· Ability to work independently and manage multiple tasks effectively.
· Exposure to Azure Data Factory / AWS ETL and SSRS tools.
· Basic understanding of AWS cloud services and PostgreSQL.
· Basic knowledge of Python or scripting for automation.
· Familiarity with CI/CD pipelines and version control tools (Azure DevOps/Git).
· Experience in database performance tuning and query optimization.
· Understanding of Agile development methodologies.
