Must-Have Skills (Mandatory)
1. Extensive experience with the MS SQL Server suite - SQL, SSIS, and Power BI.
2. Advanced SQL expertise: Strong skills in scripting complex business logic using T-SQL.
3. SSIS development: Demonstrated track record in designing, developing, and deploying high-performance SSIS packages.
4. ETL/ELT architecture: Proven skills in building and managing robust ETL/ELT pipelines using SSIS, Azure Data Factory, and Microsoft Fabric.
5. Data modelling: Proficient in designing high-performance relational and non-relational schema models. Experience with data normalisation, dimensional modelling, and NoSQL schema design.
6. Analytics and data warehousing: Prior involvement in data analytics, data warehousing projects; and experience in delivering interactive Power BI dashboards.
7. Autonomous delivery: Ability to deliver results as an independent contributor, with minimal supervision.
8. Stakeholder management: Excellent communication and stakeholder management skills, including collaboration with business executives.
9. Data Governance: Practical experience implementing strict data governance measures—encryption, masking, and implementing data security techniques, including Row-Level and Column-Level Security (RLS/CLS).
Good to Have (Optional)
1. Experience developing complex data transformation workloads using Python and PySpark.
2. Exposure to management of SQL Server (2019+), Azure SQL, Azure Virtual Machines, and other Azure Services.
3. Experience in deploying/integrating GPT models via Azure AI Foundry/Cognitive Services.
4. Familiarity with Salesforce, Jitterbit, CData, Dbamp.
