Data Specialist

2 weeks ago

Old Toronto, Canada Knewin Full time
Data Specialist

Job Responsibilities:

  • Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, and works to improve the structure and efficiency of an organization's I&IT systems.
  • The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures, and the enablement of major business processes through enhancements to IT.
  • Provides subject matter expertise in their field and highly expert technical assistance.

Must Haves=:

  • Demonstrated deep Microsoft stack experience (10 Years) with at least the past 4 years of Microsoft Azure Data Factory experience.
  • Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.
  • Experience with migration from Cognos/Informatica to Power BI solutions
  • Experience with designing and implementing interactive and visually appealing reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI
  • Experience with Microsoft DevOps, pipelines, datasets, triggers, and other Azure Data Factory components

Evaluation Criteria:
Development - 25%
  • Design, develop, and maintain data pipelines using Azure Data Factory Services for data ingestion, transformation, and integration.
  • Develop ETL processes using SQL Server Integration Services (SSIS) to move and transform data from various sources into Azure data repositories.
  • Azure Data Factory, knowing how to create and manage pipelines, datasets, triggers, and other ADF components effectively.
  • Design and implement interactive and visually appealing reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI
  • Well-versed in ETL tools and technologies, especially those within Azure Data Factory, such as Data Flow, Mapping Data Flows, and other data transformation components.

Design/Architecture - 20%

  • Ensure data quality and data governance practices are implemented throughout the data integration process.
  • Demonstrated experience with data ingestion from multiple sources, staging, and data cleansing.
  • Guide the architecture leveraging Azure cloud services, ensuring effective and standard use of the Microsoft Stack tools and services critical for the integrity, quality, and pace of delivery.
  • Understanding Azure's security and compliance features is crucial to ensure data privacy and meet regulatory requirements.
  • Design, plan, and implement data integration and analytics solutions on the Microsoft Azure platform, leveraging Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant services.
  • Create architecture diagrams and technical documentation for Azure-based solutions.
  • Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.
  • Design and implement data models and cubes using SQL Server Analysis Services (SSAS) for efficient data analysis and reporting.
  • Design and develop interactive and informative dashboards and reports using Power BI to facilitate data-driven decision-making.

Data Modelling - 20%

  • Design experience with star and snowflake schemas, dimensional modeling, and data model architecture and design aligned with data standards and analytics needs of various stakeholders, includes creation DW, Views, Cubes, and other data services products, using SQL Server Analysis Services (SSAS)
  • Utilize tools like Erwin Data Modeler and Power Designer to create and maintain data models for efficient data storage and retrieval.
  • Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, DataStage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio, Erwin Data Modeler, Power Designer.

Technical skills - 30%

  • Demonstrated experience in guiding the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality, and pace of delivery.
  • Demonstrated deep Microsoft stack experience (10 Years) with at least the past 4 years of Microsoft Azure Data Factory experience.
  • Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.
  • Strong knowledge of data integration techniques, data warehousing, and ETL processes.
  • Familiarity with database management and SQL Server environments.
  • Strong problem-solving skills and ability to work collaboratively in a team.
  • Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, Datastage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio, Erwin Data Modeler, Power Designer

Public Sector Experience - 5%

  • Previous public sector experience in an organization of equivalent size or complexity to the Ontario Public Service

Notes:
  • Hybrid role- 3-days per week on-site required
#gttca
#LI-GTT #J-18808-Ljbffr

  • Power Platform and Data Visualization Specialist

    1 week ago

    Old Toronto, Canada CB Canada Full time

    Job Title: Power Platform and Data Visualization Specialist Job Description: Buchanan Technologies is hiring for a Power Platform and Data Visualization Specialist for one of our clients based in Toronto, Ontario. This is a hybrid job type located in Toronto with a contract length of 12 months. Reporting: Reporting to the Director, Business Solutions and...

  • Power Platform and Data Visualization Specialist

    1 week ago

    Old Toronto, Canada CB Canada Full time

    Job Title: Power Platform and Data Visualization Specialist Job Description: Buchanan Technologies is hiring for a Power Platform and Data Visualization Specialist for one of our clients based in Toronto, Ontario. This is a hybrid job type located in Toronto with a contract length of 12 months. Reporting: Reporting to the Director, Business Solutions and...

  • Power Platform and Data Visualization Specialist

    1 week ago

    Old Toronto, Canada CB Canada Full time

    Job Title: Power Platform and Data Visualization Specialist Job Description: Buchanan Technologies is hiring for a Power Platform and Data Visualization Specialist for one of our clients based in Toronto, Ontario. This is a hybrid job type located in Toronto with a contract length of 12 months. Reporting: Reporting to the Director, Business Solutions and...

  • Power Platform and Data Visualization Specialist

    6 hours ago

    Old Toronto, Canada CB Canada Full time

    Job Title: Power Platform and Data Visualization Specialist Job Description: Buchanan Technologies is hiring for a Power Platform and Data Visualization Specialist for one of our clients based in Toronto, Ontario. This is a hybrid job type located in Toronto with a contract length of 12 months. Reporting: Reporting to the Director, Business Solutions and...

  • Data Specialist

    4 weeks ago

    Toronto, Canada University of Toronto Full time

    **Date Posted**:04/16/2024 **Req ID**: 36999 **Faculty/Division**: Temerty Faculty of Medicine **Department**: Dept of Family & Community Medicine **Campus**: St. George (Downtown Toronto) **Position Number**: 00054669 **Description**: **About us**: Home to over 40 departments and institutes, the University of Toronto's Temerty Faculty of Medicine lies at...

  • Data Modeling Specialist

    4 weeks ago

    Toronto, Ontario, Canada Procom Full time

    Data Modeling Specialist - Financial Systems On behalf of our client in the Financial Services Sector, PROCOM is looking for a Data Modeling Specialist - Financial Systems. Data Modeling Specialist - Financial Systems - Job DescriptionDesign and implement data models and schemas to support analytical reporting requirements, reports, and dashboards, manage...

  • Technical Specialist

    2 days ago

    Old Toronto, Canada International Financial Data Services Full time

    Technical Specialist - Operations Permanent 30 Adelaide Str, East Toronto, Ontario, M5C 3G9 Canada Job Description Who we are With its global headquarters in Toronto, Canada, International Financial Data Services (IFDS) is a world-leading provider of outsourcing and technology solutions to the financial services industry. IFDS services over 240 financial...

  • Technical Specialist

    3 days ago

    Old Toronto, Canada International Financial Data Services Full time

    Technical Specialist - Operations Permanent 30 Adelaide Str, East Toronto, Ontario, M5C 3G9 Canada Job Description Who we are With its global headquarters in Toronto, Canada, International Financial Data Services (IFDS) is a world-leading provider of outsourcing and technology solutions to the financial services industry. IFDS services over 240 financial...

  • Technical Specialist

    2 days ago

    Old Toronto, Canada International Financial Data Services Full time

    Technical Specialist - Operations Permanent 30 Adelaide Str, East Toronto, Ontario, M5C 3G9 Canada Job Description Who we are With its global headquarters in Toronto, Canada, International Financial Data Services (IFDS) is a world-leading provider of outsourcing and technology solutions to the financial services industry. IFDS services over 240 financial...

  • Technical Specialist

    4 days ago

    Old Toronto, Canada International Financial Data Services Full time

    Technical Specialist - Operations Permanent 30 Adelaide Str, East Toronto, Ontario, M5C 3G9 Canada Job Description Who we are With its global headquarters in Toronto, Canada, International Financial Data Services (IFDS) is a world-leading provider of outsourcing and technology solutions to the financial services industry. IFDS services over 240 financial...

  • Specialist, Data Acquisition

    4 weeks ago

    Toronto, Canada Ontario Health Full time

    At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value. How we work...

  • Mdm Specialist

    4 weeks ago

    Toronto, Canada Incept Data Solutions, Inc Full time

    Profile Summary: As part of the MDM portion of our Enterprise Data Governance program, we are looking to augment our team with an MDM Specialist. The role will be focused on developing and delivering content for consumption by the business and digital pillars. Will require someone with both prior experience with Master Data Management as well as expertise in...

  • Data Specialist

    3 days ago

    Toronto, Canada Alquemy Full time

    **Data Analyst** **1 year contract (Possible extension)** Our client is looking for a Data Specialist to support and technically lead different Enterprise Data Applications initiatives. The individual would be a self-starter, be data driven, have strong problem-solving and data analytic skills, be result oriented and have excellent communication...

  • Data and Document Solution Specialist

    4 weeks ago

    Old Toronto, Canada Mortgage Automator Inc. Full time

    Reports To: VP of Customer Success | Revision Date: March 2024 | Department: Data and DocsJob Summary: We’re seeking a detail-oriented problem-solver with a passion for using technology to streamline client experiences. As a Data and Document Solution Specialist, you’ll play a vital role in our mission to optimize efficiency in our clients’ business...

  • Data and Document Solution Specialist

    3 weeks ago

    Old Toronto, Canada Mortgage Automator Inc. Full time

    Reports To: VP of Customer Success | Revision Date: March 2024 | Department: Data and DocsJob Summary: We’re seeking a detail-oriented problem-solver with a passion for using technology to streamline client experiences. As a Data and Document Solution Specialist, you’ll play a vital role in our mission to optimize efficiency in our clients’ business...

  • Data and Document Solution Specialist

    3 weeks ago

    Old Toronto, Canada Mortgage Automator Inc. Full time

    Reports To: VP of Customer Success | Revision Date: March 2024 | Department: Data and DocsJob Summary: We’re seeking a detail-oriented problem-solver with a passion for using technology to streamline client experiences. As a Data and Document Solution Specialist, you’ll play a vital role in our mission to optimize efficiency in our clients’ business...

  • Data and Document Solution Specialist

    6 hours ago

    Old Toronto, Canada Mortgage Automator Inc. Full time

    Reports To: VP of Customer Success | Revision Date: March 2024 | Department: Data and DocsJob Summary: We’re seeking a detail-oriented problem-solver with a passion for using technology to streamline client experiences. As a Data and Document Solution Specialist, you’ll play a vital role in our mission to optimize efficiency in our clients’ business...

  • Voice & Data Specialist

    3 weeks ago

    Old Toronto, Canada Lightspeed Commerce Full time

    Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is looking for a Voice & Data Specialist to join our rapidly scaling team. The successful candidate will be responsible for the ongoing support and maintenance of the existing Telephony and...

  • Voice & Data Specialist

    4 weeks ago

    Old Toronto, Canada Lightspeed Commerce Full time

    Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is looking for a Voice & Data Specialist to join our rapidly scaling team. The successful candidate will be responsible for the ongoing support and maintenance of the existing Telephony and...

  • Voice & Data Specialist

    3 weeks ago

    Old Toronto, Canada Lightspeed Commerce Full time

    Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is looking for a Voice & Data Specialist to join our rapidly scaling team. The successful candidate will be responsible for the ongoing support and maintenance of the existing Telephony and...