Data Analyst

7 days ago


Ottawa, Canada Apside Full time

In 2021 our client embarked on a digital transformation journey to become a more customer focused digital organization. Key to achieving the digital transformation is the data and analytics strategy. Over the last year, to enable the Digital transformation and data analytics strategy, our client has invested in developing a consolidated enterprise data platform on Azure cloud.

**Primary Responsibilities**
- Collects, documents, and analyzes information management and data requirements
- Designs and implements data solutions using client’s data platform technologies
- Designs, creates and optimizes data flows for migration methods of existing data.
- Works collaboratively with information governance analysts and data architects to ensure that data models and structures are compliant with governance standards.
- Communicates requirements, issues, and options for resolutions to various stakeholders and tailors messages to the audience.

**Specific Project Requirements**:

- Reverse engineer legacy ETL to modernize it for the enterprise data platform
- Design and implement future state architectures and data solutions
- Over 7 years of demonstrated experience in SQL programming and refactoring

**Top Skills Required**:

- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Experience with reverse engineering legacy ETL builds (**Data Manager**) and source-to-target mappings to design and build future data assets
- Well-rounded hands-on experience in the following data management domains: dimensional and relational data modeling, SQL programming and ETL development.

**Other Skills Required**:

- Experience implementing medallion architecture in Databricks
- Programming experience in SQL, Python and Apache Spark
- Validation/ testing of developed data solutions by comparing to existing or proxy datasets
- Experience with Microsoft Azure or other public cloud offerings
- Experience in Agile delivery
- Experience in **IBM Data Manager**
- Ability to understand, interpret, develop and maintain requirements and design documents
- Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.

**Assets**:

- Experience with ERWIN or similar data modelling tool
- Experience with Denodo data virtualization
- Experience with Power BI report development
- Experience working in an Agile environment/team
- Bilingualism in both official languages (English and French)


  • Systems Analyst

    1 week 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...


  • Ottawa, Canada NTT DATA Americas, Inc Full time

    A leading technology service provider is looking for a Data Analyst in Ottawa, Ontario. The role involves data management, analytics, and collaboration with cross-functional teams to improve manufacturing processes. Candidates should have 4 years of data analysis experience, preferably in pharmaceuticals, and strong skills in Excel and communication. The...


  • Ottawa, Canada NTT DATA Americas, Inc Full time

    A leading technology service provider is looking for a Data Analyst in Ottawa, Ontario. The role involves data management, analytics, and collaboration with cross-functional teams to improve manufacturing processes. Candidates should have 4 years of data analysis experience, preferably in pharmaceuticals, and strong skills in Excel and communication. The...

  • Business Analyst

    5 days 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...

  • Data Analyst

    2 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

    5 days 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

    1 week ago


    Ottawa, Canada Work sell buy Full time

    OverviewWe are looking for a Data Analyst in Ottawa. Our client is based in Ottawa, Canada and is seeking a Data Analyst to join their team on a full-time basis.ResponsibilitiesPerform data analysis to support business decisions (responsibilities to be detailed by the employer).QualificationsAt least 3 years of experience in a similar role.A valid Canada...

  • Data Analyst

    1 week ago


    Ottawa, Canada Work sell buy Full time

    OverviewWe are looking for a Data Analyst in Ottawa. Our client is based in Ottawa, Canada and is seeking a Data Analyst to join their team on a full-time basis.ResponsibilitiesPerform data analysis to support business decisions (responsibilities to be detailed by the employer).QualificationsAt least 3 years of experience in a similar role.A valid Canada...

  • Data Analyst

    3 weeks ago


    Ottawa, Canada Work sell buy Full time

    Overview We are looking for a Data Analyst in Ottawa. Our client is based in Ottawa, Canada and is seeking a Data Analyst to join their team on a full-time basis. Responsibilities Perform data analysis to support business decisions (responsibilities to be detailed by the employer). Qualifications At least 3 years of experience in a similar role. A valid...

  • Data Analyst

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