Business Intelligence Specialist - Senior

Position: Business Intelligence Developer

Location: Toronto, ON (Hybrid)

Duration: 248 Days Contract + Possible Extension

Experience:

• Experience of 7+ years of working with SQL Server, SSIS and T-SQL Development (Must Have)
• Experience working with building Databases, Data Warehouse and Data Mart and working with delta/incremental and full loads (Must Have)
• Data Warehouse concepts, Kimball and Inmon design methodologies (Must Have)
• Experience with Azure ETL tools such as Azure Data Factory and Azure Databricks (Must Have)
• Experience working with MSSQL Server and Oracle database tools (Must Have)
• Experience configuring and using Oracle GoldenGate (Nice to have)
• Knowledge of Dimensional Data modeling, and tools – e.g. Power Designer
• Experience with snowflake and star schema design.
• Experience in designing and implementing data warehouse solutions using slowly changing dimensions SCD Type 1, Type 2 and Type 3.
• 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 Data Analysts, Business Analysts, and 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 (Must Have)
• 2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines (Must Have)
• 2+ years Python/PySpark (nice to have)
• 2+ years Data Warehouse concepts and principles
• Knowledge of Dimensional modeling (nice to have)
• Databricks
• SQL Server
• Oracle
• Ability to present technical requirements to business users

Design Documentation and Analysis Skills (35 points):

• Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
• Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.
• Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
• Work with the Client & Developer(s) assigned to refine/confirm Business Requirements
• Participate in defect fixing, testing support and development activities for ETL tool. Assist with defect fixing and testing support for Power BI reports.
• Analyze and document solution complexity and interdependencies by function including providing support for data validation.

Development, Database and ETL experience (55 points):

• Demonstrated experience in Microsoft specific software development and a number of years of practical experience (minimum 7+ years)
• Proven experience in developing in Azure DevOps
• Experience in application mapping to populate data store and dimensional data mart schemas
• Demonstrated experience in Extract, Transform & Load and Extract, Load and Transforms software development and a number of years of practical experience (minimum 7+ years)
• Experience in providing ongoing support on Azure pipeline/configuration and SSIS development
• Experience building data ingesting and change data capture using Golden Gate (an asset but not mandatory)
• Assist in the development of the pre-defined and adhoc reports and meet the coding and accessibility requirements.
• Demonstrated experience with Oracle and Microsoft interfaces
• Proficient in SQL and Azure DevOps
• Implementing logical and physical data models

Must Have Requirements:

• 7+ years in ETL tools such as Microsoft SSIS, stored procedures (Must Have)
• 2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines (Must Have)
• 2+ years Python/PySpark (nice to have)