View all jobs

Task-Based I&IT Consultant

Toronto, ON
Workplace Location: Toronto.
  • Works collaboratively within a development team to design, develop and optimize a Data Warehouse/ETL solution
  • Performs Logical and physical data modeling for enterprise data warehouse
  • Participates in the design of, and develops well-annotated, maintainable ETL processes according to specification and standards
  • Performance tunes and troubleshoots ETL processes under development
  • Participates in the development an enterprise data warehouse
  • Contributes to the creation and maintenance of technical and business Meta data flows
  • Understands and applies best practices for ETL development into standard warehouse models and dimensional data structures
  • Creates documentation for ETL processes and reviews with other development resources for consistency
  • Provides guidance and assists in resolving development issues
  • Cognos Experience
  • OBIEE Experience
  • ETL Design and Extensive ETL Scripting
  • This is a financial application project to experience in T-SQL is a must.
  • Experience with MS systems upgrades
  • Experience with Microsoft SQL Server (SSIS, complex T-SQL, stored procedures, views, triggers, indexes, scripting, database tuning, etc.) – 10 yrs
  • Data warehouse / ETL design, development, best practices and optimization
  • Logical and physical data modeling for enterprise data warehouse
  • Writing complex ETL including slowly changing dimensions, aggregate tables, versioning, archiving
  • ETL orchestration for performing updates to data warehouse (automation, logging, and notifications)
  • Database performance tuning (monitoring and tuning queries / data loads)
  • Working with business users to confirm / validate results
  • Data warehouse capacity planning
  • Strong analytical and problem-solving abilities
  • Building data warehouse for OBIEE, Microsoft Power BI, Cognos reporting environment a plus
Nice to have skills:
  • MSSQL version 2017
  • Exposure to Data Warehousing design and concepts including (This is not this person’s primary role):
  • Dimensional data modeling including star/snowflake schema;
  • Levels of Data Model design (conceptual, logical and physical data model)
  • Slowly Changing Dimension problem and approach;
Other best practices for ETL / data warehouse design and development

Share This Job

Powered by