Business Intelligence Specialist

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