Teacup Tech Systems

Please apply ONLY if you have Public Service Experience in Canada

Experience and Skill Set Requirements:

Experience:

Experience of 7+ years of working with SQL Server, ADF and T-SQL Development
Experience working with building Databases, Data Warehouse and Data Mart and working with delta / incremental and full loads
Experience with any ETL tools such as SQL Server, ADF, Cloud tools
Experience working with MSSQL Sever on premise and within Azure Environment
Experience on Data modeling, and tools – e.g. SAP Power Designer,
Experience with snowflake and star schema model. Experience in designing data warehouse solutions using slowly changing dimensions.
Experience working with SQL Server SSIS and other ETL tools, solid knowledge and experience with SQL, other RDBMS (SQL Server, SSIS)
Understanding data warehouse architecture with a data vault, dimensional data and fact model.
Analyze, design, develop, test and document ETL programs from detailed and high-level specifications, and assist in troubleshooting.
Utilize SQL to perform tasks other than data transformation (DDL, complex queries)
Good knowledge of database performance optimization techniques
Ability to assist in the requirements analysis and subsequent developments
Ability to conduct unit tests and assist in test preparations to ensure data integrity
Work closely with Designers, Business Analysts and other Developers
Liaise with Project Managers, Quality Assurance Analysts and Business Intelligence Consultants
Design and implement technical enhancements of Data Warehouse as required.

Skills:

7+ years in ETL tools such as Microsoft SSIS, stored procedures
2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines
2+ years Python
Databricks
Synapse (nice to have)
SQL Server
Oracle
Ability to present technical requirements to the business