Junior Data Analyst

2 months ago


Oakville, Canada OneFive Inc. Full time

As a Junior Data Analyst, you will play a critical role in preparing essential enterprise data alongside a team of seasoned data experts. This role is ideal for a budding data analyst or engineer looking to gain invaluable, hands-on experience in a real-world setting.

**Responsibilities**:
**General Profiling & Business Requirement Design**

1. Conduct data analysis and profiling using Informatica Data Quality (IDQ) tool to understand the structure, quality, and integrity of the data.

2. Collaborate with the data migration manager with project planning and status reporting on data profiling and cleansing activities. Overall adhere to the AX data clean up ways of working.

3. Collaborate with business stakeholders and data owners to interpret profiling results and understand data requirements and objectives.

4. Develop data quality rules & standards based on business requirements and industry best practices.

5. Document data quality processes, rules and standards for future reference and training purposes. Create and maintain source to target mappings.

6. Create a Data Quality scorecard and reports to track and monitor data quality metrics over time.

**Create & Executing Data Cleansing Rules**

1. Develop and maintain quality mappings, DQ rules, and workflow within Informatica data quality environment.

2. Perform data profiling, cleansing, standardization, and matching using Informatica data quality transformations and functionalities.

3. Troubleshoot & resolve issues related to the tool.

4. Collaborate with Informatica SME to implement automated data quality checks and validations within data pipelines and workflows.

**Testing**

1. Develop and execute test plans and test cases to validate effectiveness of data quality rules and cleansing processes.

2. Conduct data validation and verification activities to ensure data quality improvements meet requirements.

3. Identify and address data quality issues and anomalies through root cause analysis and troubleshooting.

4. Prepare and present test results including defects and resolution status.

**Rollout**

1. Monitor data quality metrics and trends to identify areas for improvement and optimization.

2. Prepare weekly status reports on data quality activities status, continuously communicate with the data migration manager arising risks, issues, and contingency plan.

3. Work with the Informatica SME for troubleshooting technical issues related to using Informatica data quality effectively for data profiling and cleansing purposes.

**Job Type**: Fixed term contract
Contract length: 6 months

Pay: $30.00-$45.00 per hour

Expected hours: 80 per week

Schedule:

- Monday to Friday

Work Location: Hybrid remote in Oakville, ON L6L 0G1

Expected start date: 2024-12-04


  • Junior Data Analyst

    6 days ago


    Oakville, Canada FCT Full time

    Company Summary Come work for a company that’s committed to the success of each and every employee. A place where innovators and collaborators come together and build on each other’s talents. Where diversity is welcomed and celebrated. FCT provides industry-leading title insurance, default solutions and other real estate related products and services...


  • Oakville, Canada LCM Security, Inc. Full time

    **Junior Security Analyst** **LCM Security** **Oakville, Ontario** LCM Security, Inc. was founded in 2001 to provide advanced network and security solutions that enable organizations to better leverage and control their investments in Internet and related Information Technology. Our focus is on methods and technologies that improve security, simplify...

  • Data Analyst

    2 days ago


    Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Data Analyst

    7 months ago


    Oakville, Canada Geotab Full time

    Who you are: We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Data Analyst, this role involves analyzing clearly defined datasets using diverse tools to address specific business requirements and uncover valuable insights. This position focuses on discerning how analysis results can directly...

  • Data Analyst

    7 months ago


    Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Data Analyst

    2 weeks ago


    Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Data Analyst

    2 weeks ago


    Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Finance Data Analyst

    2 weeks ago


    Oakville, Canada Siemens Healthineers Full time

    **Do you want to join us in helping to fight the world’s most threatening diseases and enabling access to care for more people around the world?** At Siemens Healthineers, we pioneer breakthroughs in healthcare. For everyone. Everywhere.** We offer you a flexible and dynamic environment with opportunities to go beyond your comfort zone in order to grow...

  • Data Analyst

    2 months ago


    Oakville, Canada Geotab Full time

    **Who we are**: Geotab ® is a global leader in IoT and connected transportation and certified "Great Place to Work." We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Data Analyst

    7 months ago


    Oakville, Canada Finsana Full time

    FinSANA is looking for a** Data Analyst **to join our Analytics team. Reporting to the Senior Manager of Analytics, the Data Analyst will work with the business to understand new data sources, assess data quality, build critical reports, and perform ad hoc analyses. This person is quantitatively driven, detail-focused, with excellent inter-personal skills to...

  • Financial Data Analyst

    4 months ago


    Oakville, Canada Geotab Full time

    Basis**: Permanent - Full-time** Area of Interest**: Finance** Location**: Oakville, Ontario** **Who we are - Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and...


  • Oakville, Canada Calligo Full time

    Calligo’s Data Insights division is rapidly growing and we are looking to add more talented consultants to our team. The primary reporting tools for this role are Tableau, Power BI, and Excel. There will be a heavy emphasis on designing intuitive and aesthetically appealing analytics tools while providing robust and meaningful business insights. Practical...


  • Oakville, Ontario, Canada PARSONS CORPORATION Full time

    Job Title: Environmental Data AnalystAbout the Role: Parsons Corporation is seeking a highly skilled Environmental Data Analyst to join our Critical Infrastructure team. This role offers an exciting opportunity to work with intelligent and diverse people sharing a common quest.Company Overview: For over 75 years, Parsons has designed and delivered critical...


  • Oakville, Canada CT Bank Full time

    **Help us boldly shape retail in Canada** Canadian Tire Corporation’s (CTC) rich heritage of serving Canadians from coast-to-coast dates back to 1922. Our vision is to become the #1 retail brand in Canada and we are focused on innovating and making important investments in our business, especially when it comes to our people. To reach our goal, we need...


  • Oakville, Canada FCT Full time

    Company Summary - Come work for a company that’s committed to the success of each and every employee. A place where innovators and collaborators come together and build on each other’s talents. Where diversity is welcomed and celebrated. - FCT provides industry-leading title insurance, default solutions and other real estate related products and services...

  • Data Analyst

    1 week ago


    Oakville, Canada SUEZ Full time

    Around the globe, we help cities and industries manage, optimize and make the most of their resources. We provide an array of solutions related to water, energy and materials to promote a cleaner more sustainable world for all of us._ - The collective expertise and passion of our people, combined with a broad portfolio of over 10,000 technologies, makes us...


  • Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Data Analyst

    5 days ago


    Oakville, Canada Indellient Full time

    **Who we are**: Indellient delivers leading-edge technology solutions that enable cloud transformation for our clients. Our solutions provide a competitive advantage for our clients by allowing them to offer new services and harness the power of the cloud. We build lasting relationships with our clients; and, in so doing, our clients view us as a high impact...

  • Financial Data Analyst

    7 months ago


    Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Business Analyst

    6 days ago


    Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...