Skills & Experience

- 5+ years of hands-on experience in Microsoft SQL Server development
- Solid proficiency in SQL Server Integration Services (SSIS)
- Demonstrated experience with Azure cloud services (Azure Data Factory, Azure SQL Database, or related services)
- Experience integrating data from various source systems including MySQL, PostgreSQL, Google Big Query, Excel/CSV files, and API integrations.
- Expertise in writing complex T-SQL including stored procedures, functions, and views
- Deep understanding of SQL optimization techniques and performance tuning
- Experience working with large-scale datasets and managing enterprise-wide data integrations
- Proficiency in C# for developing custom data solutions and SSIS script tasks
- Working knowledge of Azure Dev Ops for version control and project management
- Hands-on experience with data warehousing principles, including dimensional modelling, SCD Type 2, and Lakehouse-based data architecture.

Essential Competencies

- Critical Thinking: Ability to analyze complex data challenges and architect effective solutions
- Problem-Solving: Strong analytical skills with a methodical approach to troubleshooting
- Communication: Clear and effective stakeholder communication.
- Collaboration: Works effectively across teams.
- Technical Acumen: Quick to adapt to recent technologies and methodologies

Nice to have

- Experience with Power Automate for workflow automation and integration
- Experience using Databricks and Python
- Experience with Google Cloud Services
- Familiarity with Agile methodologies and collaborative development practices
- Understanding of data security and compliance requirements