24 Jan
Cleo Consulting
Old Toronto
Assignment: RQ00117 - Software Developer - ETL - Intermediate Job Title: Business Intelligence Specialist Requisition: RQ00117 Client: Metrolinx Start Date: 2025-02-10 End Date: 2025-08-08 Department: Solution Delivery Office Location: 277 Front Street West Business Days: 130.00
Note: Hybrid 2 times per week onsite
Public Sector Experience: Not required
Must Haves:
- 6+ years' experience in progressive complexity with Azure Data Lake, Databricks, SQL, Power BI, and data integration tools
- 6+ years' development/architecture experience
- 6+ years' working experience with data quality and data ingestion within the Azure platform
Description
Responsibilities
- Supports Client's wide-ranging business information requirements,
implementing and supporting business intelligence software solutions.
- Develops and supports customized query applications which analyze key business data.
- Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of "opportunity" and "key-trend" alerts.
- Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives. Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)
- Experience with developing feedback processes to fix corrupt data in the source systems
- Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores)
- Experience with developing,
implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
- Experience with developing monitoring and error notification processes to ensure data is updated as designed
- Experience with developing automation extraction, cleansing and load scripts
- Experience generating research models and reports (scheduled and ad-hoc)
- Proven troubleshooting and analytical experience
- Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
- Experience in the use of development tools and business re-engineering software
- Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines Knowledge and experience in developing data analysis applications
- Knowledge and understanding of Information Management principles, concepts, policies
Deliverables
- Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)
- Experience with developing feedback processes to fix corrupt data in the source systems
- Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores)
- Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
- Experience with developing monitoring and error notification processes to ensure data is updated as designed
- Experience with developing automation extraction, cleansing and load scripts
- Experience generating research models and reports (scheduled and ad-hoc)
- Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
- Experience in the use of development tools and business re-engineering software
- Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines Knowledge and experience in developing data analysis applications
- Knowledge and understanding of Information Management principles, concepts, policies and practices
- Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes.
- Experience with developing monitoring and error notification processes to ensure data is updated as designed
- Hands on experience working with stakeholders to develop and document interface
- Knowledge and experience in developing data analysis applications
- Knowledge and understanding of Information Management principles, concepts, policies and practices
- Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes.
- Experience with developing monitoring and error notification processes to ensure data is updated as designed
- Hands on experience working with stakeholders to develop and document interface
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.