See more Collapse

Senior Analyst, Data and Analytics

1 month ago

Old Toronto, Canada Air Canada Full time

Description

Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.

We are seeking a highly skilled Senior Analyst, Data & Analytics – Data Modeler with experience in Data Vault 2.0 methodology, coupled with proficiency in traditional data modeling techniques. The ideal candidate will play a pivotal role in designing, implementing, and maintaining robust data models that support our organization's evolving data architecture needs. This position provides the opportunity to be involved in new or existing BI and DWH solutions and to work with many different business areas within the company. The candidate will participate in all phases of the DWH development life cycle as well as support the day-to-day operations as it pertains to data modeling improvements and supporting the existing platform.

Responsibilities:

  • Lead the design and development of scalable, flexible, and extensible data models using Data Vault 2.0 methodology.
  • Utilize traditional data modeling techniques (e.g., dimensional modeling, ER modeling) as needed to complement Data Vault 2.0 constructs.
  • Ensure that data models adhere to best practices, standards, and principles while aligning with business requirements and objectives.
  • Develop, enhance, and manage conceptual data model, enterprise logical data model (LDM), physical data model (PDM) for the data platform.
  • Ensure data lineage mapping across implementations for the platform.
  • Understand and meet referential data integrity requirements based on business needs. Develop and/or assist in generating source to target data mapping.
  • Perform data model consolidation and integration to integrate new silos of organizations source data to the data platform.
  • Data analysis/profiling and reverse engineering of data. Strong knowledge of relational and multi-dimensional database architectures
  • Collaborate closely with cross-functional teams including Data Engineers, Data Architects, Product Managers, Product Owners, and business stakeholders to understand data requirements and translate them into effective data models.
  • Provide technical guidance and mentorship to junior data modeling team members, fostering a culture of knowledge sharing and continuous learning.
  • Champion data governance principles and practices to maintain data integrity, consistency, and quality within the data models.
  • Implement data quality checks, validation rules, and standards within the data modeling process to ensure the accuracy and reliability of data assets.
  • Identify opportunities for performance optimization within data models, including but not limited to indexing strategies, partitioning, and denormalization techniques.
  • Work collaboratively with Database Administrators and Performance Engineers to fine-tune data models for optimal query performance and scalability.
  • Document data models comprehensively, including entity-relationship diagrams, data dictionaries, metadata, and lineage information.
  • Communicate effectively with technical and non-technical stakeholders, presenting complex data modeling concepts in a clear and understandable manner.

Qualifications

  • Bachelor's or master’s degree in computer science, Information Systems, or a related field.
  • 2 to 3 years Experience in Data Vault 2.0 Modeling.
  • 5+ years of experience using the following modeling techniques: 3rd Normal form, ERD, Dimensional modelling (Star Schema/Snowflake Schema.
  • Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
  • Experience with metadata management and its use for modeling activities.
  • Experience with creating data model and data structure in Erwin Modeling.
  • Experience with Agile development methodologies and practices is a plus.
  • 5+ years of experience with data management standards and data model practices.
  • Thorough knowledge of conceptual and logical data modeling and familiarity with physical database design and optimization concepts.
  • Experience with common standards and best practices for data elements, data types, and file formats.
  • Ability to conceive and describe the big picture.
  • Solid analytical and strong problem-solving skills.
  • Proven ability to quickly work with multiple key stakeholders, and ability to focus on cross-group collaboration.
  • Data analysis/profiling and reverse engineering of data. Strong knowledge of relational and multi-dimensional database architectures.
  • Relevant certifications (e.g., Certified Data Management Professional (CDMP), Certified Data Vault Data Modeler) are desirable.

Conditions of Employment:

  • Candidates must be eligible to work in the country of interest, at the time any offer of employment is made and seeking any required work permits/visas or other authorizations which may be required is the sole responsibility of the candidates applying for this position.

Linguistic Requirements

Based on equal qualifications, preference will be given to bilingual candidates.

Diversity and Inclusion

Air Canada is strongly committed to Diversity and Inclusion and aims to create a healthy, accessible and rewarding work environment which highlights employees’ unique contributions to our company’s success.

As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.

Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.

#J-18808-Ljbffr

We have other current jobs related to this field that you can find below

  • Data & Analytics Analyst

    2 weeks ago

    Toronto, Canada International Data Group, Inc. Full time

    Overview: IDC Canada is seeking a **Data & Analytics** **Analyst** to join the consumer devices team. In this role, you will have the opportunity to work on several of IDC’s consumer device programs, including wearables, AR/VR, smart home, personal computing devices like PCs and tablets, and mobile phones. Having familiarity with or expertise in the...

  • Research Analyst, Data

    5 days ago

    Toronto, Canada International Data Group, Inc. Full time

    Overview: - Do you want to be part of a dynamic team in a fast-paced exciting industry? You can make an impact by joining IDC Canada._ IDC Canada is looking for a **Research Analyst **to join our Data and Analytics team on a full-time basis for a permanent opportunity. Reporting to the Research Manager of IDC Canada’s Market Insights and Analytics,...

  • Senior Data Analytics Consultant

    1 month ago

    Old Toronto, Canada TalentWorld Full time

    Explore the dynamic realm of data analytics as a Senior Data Analytics Consultant! Craft insightful dashboards and reports with Power BI, illuminating strategic pathways and uncovering actionable insights. Your expertise will be pivotal in decoding complex datasets and driving informed decisions. Join us in shaping the future of data-driven initiatives...

  • Data Analyst, Product Analytics

    6 days ago

    Old Toronto, Ontario, Canada Refinitiv Full time

    Data Analyst, Product Analytics page is loaded Data Analyst, Product Analytics Apply remote type Remote Job: Hybrid locations CAN-Toronto-19 Duncan Street time type Full time posted on Posted Today job requisition id JREQ178858 Data Analyst, Product AnalyticsIf you're an experienced data analyst who is ready to take on the challenge of collaborating with...

  • Senior Data Scientist- Marketing

    21 hours ago

    Old Toronto, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce.We are also...

  • Senior Data Scientist- Marketing

    2 days ago

    Old Toronto, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce.We are also...

  • Senior Data Analyst – Enterprise Analytics

    4 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Full-timeCompany DescriptionMomentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing...

  • Senior Data Analyst – Enterprise Analytics

    4 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Full-timeCompany DescriptionMomentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing...

  • Senior Data Analyst – Enterprise Analytics

    5 days ago

    Old Toronto, Ontario, Canada Momentum Financial Services Group Full time

    Full-timeCompany DescriptionMomentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing...

  • Senior Data Analyst – Enterprise Analytics

    4 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Full-timeCompany DescriptionMomentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing...

  • Senior Data Analyst – Enterprise Analytics

    3 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Full-timeCompany DescriptionMomentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing...

  • Senior Data Analyst – Enterprise Analytics

    3 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Full-timeCompany DescriptionMomentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing...

  • Senior Analyst, Data Analytics

    5 days ago

    Toronto, Ontario, Canada MCAN Mortgage Corporation Full time

    Senior Analyst, Data Analytics & Reporting Friday, May 10, 2024 Who we are: At MCAN, we are most proud of the team we have built and our team member experience. Our people are our best assets and are made up of respected industry innovators, influencers, and big thinkers. We do things differently than other lenders. Our business isn't selling mortgages,...

  • Analyst Data

    2 months ago

    Toronto, Canada Canada Life Assurance Company Full time

    **Job Description**: Are you seeking the opportunity to shape the future of Canada’s financial services landscape? Do you have a proven track record of developing and leading the execution of innovative strategies to enable business growth and improved advisor and client experiences? As the Senior Analyst Data & Analytics you will join Canada Life’s...

  • Senior Data Scientist- Marketing

    14 hours ago

    Toronto, Canada Tiger Analytics Full time

    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce.We are also...

  • Senior Data Scientist- Marketing

    7 days ago

    Toronto, Canada Tiger Analytics Full time

    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce.We are also...

  • Data Analyst

    3 weeks ago

    Toronto, Canada Environics Analytics Full time

    **ROLE OBJECTIVE**: Reporting to the Vice President of Data Solutions, the Data Analyst is responsible for completing client project work in a timely manner using standard practices and a variety of database and software tools. This individual must be detail oriented, have strong quantitative skills and enjoy working with databases. **SPECIFIC...

  • Data Analyst

    2 weeks ago

    Toronto, Canada Environics Analytics Full time

    **ROLE OBJECTIVE**: Reporting to the Vice President of Data Solutions (or his designate), the Data Analyst is responsible for completing client project work in a timely manner using standard practices and a variety of database and software tools. This individual must be detail oriented, have strong quantitative skills and enjoy working with...

  • Senior Data Analyst

    5 days ago

    Toronto, Ontario, Canada LatentView Analytics Full time

    About Us:LatentView Analytics is a leading provider of analytics and data-driven solutions, partnering with digital businesses to drive actionable insights and enhance decision-making processes. We are committed to fostering a diverse and inclusive workforce, providing equal employment opportunities for all applicants and employees.Job Description:We are...

  • Senior Data Analyst – Enterprise Analytics

    4 weeks ago

    Toronto, Canada Momentum Financial Services Group Full time

    Job Description*Candidates must reside in the GTA area to be considered for this role as they will be required to be in office 3 days a week at the Toronto Corporate Office.Role FunctionThe Senior Data Analyst will be a part of the Enterprise analytics team working closely with various business functions delivering key insights to meet their respective...