Data Specialist

2 weeks ago

Toronto ON, 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

  • 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...

  • Power Platform and Data Visualization Specialist

    1 week ago

    Toronto, ON, 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...

  • 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 Science Specialist

    2 days ago

    Toronto, Canada Matrix Leap Full time

    About the Role We are seeking a highly analytical and detail-oriented Data Science Specialist to join our team. This role involves utilizing your research skills, scientific knowledge, and exceptional reasoning abilities to annotate complex datasets. Responsibilities Annotate and label large data

  • Data and Document Solution Specialist

    3 weeks ago

    Toronto, ON, Canada Mortgage Automator Inc. Full time

    Reports To: VP of Customer Success | Revision Date: March 2024 | Department: Data and Docs Job 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’...

  • Senior Data Governance and Data Quality Specialist

    2 weeks ago

    Waterloo, ON, Canada Equitable Life of Canada Full time

    it's about being part of a workplace that helps you grow and reach your full potential. Position Title: Data Governance and Quality Specialist Reports To: Head of Data Governance and Quality Corporate / Impact Term: Permanent Full-Time You will work in our office in Waterloo, ON a minimum of two (2) assigned, consecutive days every other week,...

  • Voice & Data Specialist

    4 weeks ago

    Toronto, ON, 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...

  • Data & Reporting Specialist

    4 weeks ago

    Toronto, Ontario, Canada Definity Careers Full time

    Reporting to the HR Systems leader, the Data & Reporting Specialist will play a key role in providing accurate and timely reporting of our people data across HR systems. You will collaborate with a variety of stakeholders to develop and maintain HR reports and dashboards that provide insights into people & culture operations. Additionally, you are...

  • Data Analyst

    3 days ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    **Company Description** We are a minority owned staff augmentation and technology consulting company To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professional growth. Arthur Grand Technologies is currently seeking a highly motivated and...

  • IT Data Specialist

    1 week ago

    Toronto, Canada TD Bank Full time

    **IT Data Specialist**: - 412036BR **Job Category - Primary** - Technology Solutions **Work Location** - TD Centre - West - 100 Wellington Street West **Employment Type** - Regular **City** - Toronto **Time Type** - Full Time **Province/State** - Ontario **Hours** - 37.5 **Workplace Model** - Hybrid **Pay Details** **Department...

  • Senior Specialist

    6 days ago

    Toronto, ON, Canada BDO Canada LLP Full time

    Senior Specialist, Algorithm Engineering page is loaded Senior Specialist, Algorithm Engineering Apply locations Toronto - Wellington St Edmonton - 103 St Calgary - 8th Ave SW Halifax - Mumford Rd Ottawa - Coventry Rd time type Full time posted on Posted 30+ Days Ago job requisition id JR1280 Putting people first, every day   BDO is a firm built on...

  • Senior Associate, Data Analytics

    1 week ago

    Toronto, ON, Canada Tundra Technical Solutions Inc. Full time

    Position: Senior Associate, Data Analytics - Implementation Specialist Joining a world class Data Analytics capability centre of excellence you will be responsible for working with our Fortune 500 clients designing, configuring and implementing cross-platform analytics data models across web and native mobile applications. You will leverage platforms such...

  • Data Automation Specialist

    3 weeks ago

    Toronto, Canada Wärtsilä Full time

    Data Automation Specialist Wärtsilä Energy Storage & Optimization (ES&O) is the leading global energy storage optimizer. Our mission is to deliver integrated energy solutions that build a resilient, intelligent, and flexible energy infrastructure - unlocking the way to an optimized renewable future. By integrating renewables, energy management...

  • Data Automation Specialist

    1 day ago

    Toronto, Canada Wärtsilä Full time

    Data Automation Specialist Wärtsilä Energy Storage & Optimization (ES&O) is the leading global energy storage optimizer. Our mission is to deliver integrated energy solutions that build a resilient, intelligent, and flexible energy infrastructure - unlocking the way to an optimized renewable future. By integrating renewables, energy management...

  • Sr Data Specialist, Corporate Actuarial

    4 weeks ago

    Toronto, Ontario, Canada Definity Careers Full time

    The Senior Data Specialist is an innovative and experienced data professional with expertise in collection, processing, and transformation of data used for modelling, analysis, and reporting purposes.Reporting to the Director, Special Projects, the Senior Data Specialist will be an integral part of an innovative, project-based team that translates business...

  • Data Integrity Specialist

    4 weeks ago

    Toronto, Canada Canada Life Assurance Company Full time

    **Job Description**: The Data Integrity Specialist is accountable for ensuring files are compliant within compliance and regulatory standards.Working in close partnership with the field offices, the Data Integrity Specialist will provide ad-hoc value-added training to Advisors. The DIS will also provide training focused on specific trends. **What you will...

  • Manager Data Analytics

    3 weeks ago

    Toronto, ON, Canada Cari Full time

    Full-time Publicis Sapient is a global digital transformation partner that empowers organizations to embrace digital innovation, enhance customer experiences, and accelerate business growth through a blend of strategy, consulting, agile engineering, and problem-solving creativity. With over 20,000 professionals worldwide, we help clients achieve their...