data analyst

data analyst Ottawa

Compugen (Canada)
Full Time Ottawa 79415 - 52404 CAD ANNUAL Today
Job description

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 in Power BI and supports the administration of the Power BI reporting environment. The incumbent supports business users with respect to the corporate data warehouse and facilitates the creation of business user reporting.

The Data Analyst acts as a backup support for database administration and provides troubleshooting and second-level support for database-related issues. The incumbent designs data sources for corporate and self-serve report creation and develops user-friendly dashboards with a common visual style and user experience.

Requirements:

  • Analyze business requirements and design technical solutions for reporting
  • Produce and maintain documentation for the reporting life cycle
  • Design, optimize, and monitor automated reporting data sources
  • Design and manage dashboards, reports, and reporting infrastructure
  • Provide troubleshooting of issues related to data integration and loads
  • Support the daily loads and understand the transformation and aggregation of data within the data warehouse
  • Establish and maintain data governance to protect sensitive data
  • Manage security on workspaces, applications, dashboards, and reports
  • Provide database support for integration of data between business applications Other
  • Act as a backup resource for Microsoft SQL Server database administration
  • Act as a backup resource for Power BI Administration
  • Other duties as assigned

Qualifications:

  • SQL Server Databases and Business Intelligence tools
  • Business Intelligence fundamentals and techniques
  • SQL Server integration Services, SQL Server Analysis Services
  • Power BI reporting Formal Education and/or Certification(s) and Experience
  • Minimum: college diploma in computer science or related field with eight years’ experience in information technology and Business intelligence or the equivalent
  • Preferred: university degree in computer science or related field Abilities
  • Effective communication and analytical skills to record business requirements and transform them to technical requirements
  • Ability to document requirements at both business and technical level

Consistent with our commitments to equity and diversity, we actively recruit from all designated groups. We also provide employment accommodation upon request to current staff members and to applicants during the recruitment process. We aim to provide a work environment where excellence is allowed to flourish and diversity is prized. Compugen is committed to providing accommodation throughout the interview and employment process. If you require an accommodation, the hiring manager and the human resources contact will work with you to meet your needs.
#LI-PP1

About Compugen (Canada)

CEO: Harry Zarek
Revenue: $500 million to $1 billion (USD)
Size: 1001 to 5000 Employees
Type: Company - Private
Website: www.compugen.com
Year Founded: 1981

data analyst
Compugen (Canada)

www.compugen.com
Richmond Hill, Canada
Harry Zarek
$500 million to $1 billion (USD)
1001 to 5000 Employees
Company - Private
Information Technology Support Services
1981
Related Jobs

All Related Listed jobs

Sawmill Worker
M R Ellis (Timber) Ltd Norwich, England 12 GBP HOURLY Today

Experience working in a busy sawmill is necessary. Job Types: Full-time, Permanent. Norwich, NR10 5LX: reliably commute or plan to relocate before starting work

Developments and Costing Data Analyst
Guy's and St Thomas' NHS Foundation Trust London 49036 - 55049 GBP ANNUAL Today

With the approaching implementation of RBH finance could system and the EPIC electronic patient record system, the Trust progresses to a more digital service.

University of Glasgow Graduate Apprenticeship Programme– BSc (Hons) Software Engineering
Linn Products Glasgow, Scotland Today

You will be working within our development team writing software for every part of the business including cloud support for products, websites and website

Order Picker/Packer
HAYA Sheffield, England 10.42 - 10.99 GBP HOURLY Today

We're a Modest gymwear brand (www.haya-active.com) that's growing & we're looking to hire our first employee to help pick and pack orders.

medical assistant
VIP Medical Group New York, NY 41600 - USD HOURLY Today

VIP Medical Group is a premier Pain Management medical practice with office locations in New York and New Jersey.

We are looking for a...