Data Analyst

2 weeks ago


Ottawa, Canada CAA North & East Ontario Full time

**Job Title: Data Analyst**

**Location: HYBRID: Work-From-Home / 1031 Bank St, Ottawa, ON**

**Job Summary**:
The Data Analyst plays a pivotal role in facilitating data-driven decision-making across the organization by collecting, analyzing, and interpreting complex datasets. They possess a keen analytical mindset, a knack for problem-solving, and a passion for transforming data into actionable insights.

Responsibilities include gathering and processing data from various sources while ensuring its accuracy and integrity. Leveraging expertise in SQL and data visualization tools like PowerBI, the Data Analyst conducts in-depth analyses to uncover trends, patterns, and outliers. From scheduled reports to ad hoc presentations, findings are communicated effectively to stakeholders, with approaches tailored to meet their specific needs.

With knowledge of Enterprise Data Warehouse principles and data governance concepts, the Data Analyst ensures the company's data infrastructure is scalable, efficient, and compliant. Quality assurance is paramount, with regular audits conducted to maintain data integrity and reliability.

**Responsibilities**:
Data Collection and Processing:

- Gather and compile data from various sources, ensuring data accuracy and integrity.
- Clean, preprocess, and transform raw data into a format suitable for analysis.
- Work on refined (L) or semirefined data (Y) to extract meaningful insights.

Data Analysis:

- Conduct exploratory data analysis to identify trends, patterns, and outliers.
- Perform statistical analyses to derive meaningful insights and draw actionable conclusions.
- Develop and implement data models and algorithms to address specific business questions.

Reporting and Visualization:

- Create clear and concise scheduled reports and dashboards using tools like PowerBI to communicate findings to stakeholders.
- Generate ad hoc reports in response to specific inquiries or emerging business needs.
- Utilize data visualization tools to present complex information in a visually appealing and understandable manner.

Business Requirements:

- Collaborate with stakeholders to understand business requirements and translate them into data analysis tasks.
- Assist in the creation of Business Requirement Documents (BRDs) by providing insights and data-driven recommendations.

Presentation Creation:

- Develop presentations to summarize key findings, insights, and recommendations derived from data analysis.
- Communicate complex technical concepts in a clear and compelling manner to both technical and nontechnical audiences.
- Collaborate with stakeholders to tailor presentations to specific audience needs and preferences.

Collaboration:

- Work closely with cross-functional teams to understand their data needs and provide analytical support.
- Collaborate with data engineers and other stakeholders to ensure seamless data flow and integration.

Quality Assurance:

- Conduct regular audits of datasets to ensure accuracy, completeness, and consistency.
- Identify and resolve data quality issues to maintain a high standard of data integrity.

**Requirements**:The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and Experience
- Bachelor's degree in a quantitative field such as Statistics, Mathematics, Computer Science, or a related field.
- Proven experience of 5-7 years as a Data Analyst or similar role, with a strong portfolio showcasing impactful analyses.

Technical Skills:

- Proficiency in SQL for data querying and manipulation, with experience in SQL Server Management Studio (SSMS).
- Experience with data visualization tools, such as PowerBI, and proficiency in MS Office Suite.
- Familiarity with version control systems like GIT.
- Knowledge: Understanding of Enterprise Data Warehouse (EDW) principles and data governance concepts.

Soft Skills:

- Strong attention to detail and the ability to work with large, complex datasets.
- Excellent communication skills to convey technical concepts to nontechnical stakeholders.

**Compensation**
- Salary: $60,000 - $65,000
- Health & Dental Benefits
- Pension Plan
- 3 Weeks Vacation
- CAA Membership

Employment is contingent on a successful Criminal Background Check and references.

Job applicants who have disabilities shall be provided with reasonable
accommodation throughout the recruiting process.

**Job Types**: Full-time, Permanent

**Salary**: $60,000.00-$65,000.00 per year

**Benefits**:

- Casual dress
- Company events
- Company pension
- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- On-site parking
- Paid time off
- Store discount
- Vision care
- Work from home

Schedule:

- 8 hour shift
- Day shift
- Monday to Friday

**Experience**:

- Data analytics: 5 years (required)
- Power BI: 1 year (required)
- S


  • Systems Analyst

    3 weeks ago


    Ottawa, Canada NTT DATA Full time

    We are currently seeking a Systems Analyst to join our team in Canada. Location: Remote Language: Bilingual (English/French) Security: Reliability **How You'll Help Us**: We are looking for a Systems Analyst with 5 years experience. You will work collaboratively with stakeholders to identify improvements and design systems to implement those and...

  • Business Analyst

    3 weeks ago


    Ottawa, Canada NTT DATA Full time

    **Company Overview**: **Req ID**: 311478 We are currently seeking a Business Analyst to join our team in Ottawa, Ontario (CA-ON), Canada (CA). Position Description**: **Role**: Business Analyst Level 2 **Client**: Canadian Federal Government client **Location**: Remote **Language**: English **Security**: Secret **How You’ll Help Us**: We are looking for a...

  • Business Analyst

    2 days ago


    Ottawa, Canada NTT DATA Full time

    We are currently seeking a **Business Analyst (Bilingual) **to join our team **REMOTE** in the** Canada (EST work hours).** - Lead and conduct business analysis to assess client's business problems/opportunities and documents the business requirements in such a way that technology solutions can be determined. - Assist with the development of strategies and...

  • Business Analyst

    2 weeks ago


    Ottawa, Canada NTT DATA Full time

    We are currently seeking a Business Analyst to join our team in Ottawa, Ontario (CA-ON), Canada (CA). **How You'll Help Us**: As a Business Analyst, you will use your wide array of knowledge to provide support to our clients. If you are passionate about business analysis, technology and are solution driven, you will be a great fit for our team.In this...

  • Program Analyst

    3 weeks ago


    Ottawa, Canada NTT DATA Full time

    **Req ID**:224725 We are currently seeking a Program Analyst to join our team in Ottawa, Ontario (CA-ON), Canada (CA). **How You'll Help Us**: Our clients need digital solutions that will transform their business so they can succeed in today's hypercompetitive marketplace. As a team member, you will make these digital solutions come to life. You will...

  • Data Analyst

    3 weeks ago


    Ottawa, Canada Brik partners Full time

    Job brief Data Analyst Job Duties Data analyst responsibilities include conducting full lifecycle analysis to include requirements, activities and design. Data analysts will develop analysis and reporting capabilities. They will also monitor performance and quality control plans to identify improvements. **Responsibilities**: - Interpret data, analyze...

  • Data Analyst

    2 weeks ago


    Ottawa, Canada Compugen Inc Full time

    **Job Title** - Data Analyst **Vacancy No** - VN6014 **Work Location** - Ottawa, ON **Job Details** - The Data Analyst, reporting to the Specialist, Data Analysis, supports the Microsoft Structure Query Language (SQL) Server database and collects, transforms, and analyses data into convenient data sources. The Data Analyst develops user friendly reports...

  • Data Analyst

    3 weeks ago


    Ottawa, Canada vTech Solution Full time

    **Job Title: Data Analyst (Intermediate/Senior)** **Location: Nepean, Ottawa, ON** **Duration: 12+ months (with possible extension)** The Data Analyst should have the following experience and qualifications: - Completed an undergraduate degree in Business Administration, Computer Science, Management Information Systems, Engineering or in a related...

  • Data Analyst

    1 week ago


    Ottawa, Canada TechInsights Full time

    **OUR STORY** **THE OPPORTUNITY** TechInsights is looking for a Data Analyst to work closely with the Architecture and Engineering teams. In this role you will, design and implement structured and unstructured data systems, ETL flows, and Business Intelligence (BI) based dashboards for both internal reporting and end-customer deliverables. As the Data...


  • Ottawa, Canada PrecisionERP Incorporated Full time

    PrecisionERP is seeking a Senior Business Analyst/Data Analyst. This work can be done remotely but hybrid is a preference (4 times per month in Ottawa). Any candidate located in Canada in a time zone other than EST must be willing to work core hours of the Ottawa team. Projected start date is as soon as possible . Contract Duration: One year initially...


  • Ottawa, Canada PrecisionERP Incorporated Full time

    PrecisionERP is seeking a Senior Business Analyst/Data Analyst. This work can be done remotely but hybrid is a preference (4 times per month in Ottawa). Any candidate located in Canada in a time zone other than EST must be willing to work core hours of the Ottawa team. Projected start date is as soon as possible . Contract Duration: One year initially...

  • Data Analyst

    3 weeks ago


    Ottawa, Canada MSi Corp (Bell Canada) Full time

    **Key Responsibilities**: - Work with business analysts to understand the business requirements - Translate business requirements into technical ETL solutions - Support the current production versions and help investigate issues and identify root causes and get it fixed as soon as possible **Key Competencies and Experience**: - Bachelor's degree in...

  • Data Analyst

    2 weeks ago


    Ottawa, Canada MSi Corp (Bell Canada) Full time

    **Key Responsibilities**: - Work with business analysts to understand the business requirements - Translate business requirements into technical ETL solutions - Support the current production versions and help investigate issues and identify root causes and get it fixed as soon as possible **Key Competencies and Experience**: - Bachelor's degree in...


  • Ottawa, Canada PrecisionERP Incorporated Full time

    PrecisionERP is seeking a Senior Business Analyst/Data Analyst. This work can be done remotely but hybrid is a preference (4 times per month in Ottawa). Any candidate located in Canada in a time zone other than EST must be willing to work core hours of the Ottawa team.Projected start date is as soon as possible .Contract Duration: One year initially with two...


  • Ottawa, Canada PrecisionERP Incorporated Full time

    PrecisionERP is seeking a Senior Business Analyst/Data Analyst. This work can be done remotely but hybrid is a preference (4 times per month in Ottawa). Any candidate located in Canada in a time zone other than EST must be willing to work core hours of the Ottawa team.Projected start date is as soon as possible .Contract Duration: One year initially with two...


  • Ottawa, Canada NTT DATA Full time

    Tasks may include but are not limited to the following: Define and Design New Database Structures: - Develop database schema and structures in Oracle hosted on AWS or Azure ensuring alignment with FSIR project requirements. - Create tables, relationships, and indexes to accommodate SIN data and ensure scalability for future needs. Develop Data Conversion...


  • Ottawa, Canada PrecisionERP Incorporated Full time

    PrecisionERP is seeking a Senior Business Analyst/Data Analyst. This work can be doneremotelybut hybrid is a preference (4 times per month in Ottawa). Any candidate located in Canada in a time zone other than EST must be willing to work core hours of the Ottawa team.Projected start date is as soon as possible . Contract Duration:One year initially with two...


  • Ottawa, Canada PrecisionERP Incorporated Full time

    PrecisionERP is seeking a Senior Business Analyst/Data Analyst. This work can be doneremotelybut hybrid is a preference (4 times per month in Ottawa). Any candidate located in Canada in a time zone other than EST must be willing to work core hours of the Ottawa team.Projected start date is as soon as possible . Contract Duration:One year initially with two...

  • Data Analyst

    1 week ago


    Ottawa, Canada Abroad Work Full time

    Data Analyst Work in Ottawa for Foreigners - Visa SupportAbout Our Customer:My client is a leading organization within the market based in Ottawa. They are currently looking for an Employee to join their team on a long-term basis.Work Summary:The effective candidate will be responsible for performing various tasks connected with Data Analyst work.Other...

  • Data Analyst

    2 weeks ago


    Ottawa, Canada CAA North & East Ontario Full time

    **CAA North & East Ontario's success depends on great people. If you are ready for the challenge, find your job here.**: CAA North & East Ontario offers a wide range of career opportunities in our Head Office / Administration Center (Finance, IT, Marketing etc); our award winning Call Centers; Emergency Roadside Assistance and our full service CAA Stores. We...