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

non title
Serene by Dr.Safa- Dental and Facial Aesthetics London, England 30000 - 26000 GBP ANNUAL Today

About Serene Dental: -

Serene by Dr. Safa presents an exciting opportunity for a professional and empathetic professional to...

Cleaner (part-time)
Krystal Kleaning Limited Wisbech, England 10.42 GBP HOURLY Today

In addition to this the candidate would also clean on a Friday morning 10am-4pm another premises to high standards. Part-time hours: 12 per week.

customer relations
Orbit Group Stratford-upon-Avon, England 31000 - 25850 GBP ANNUAL Today
Store Assistant - Days
ASDA London, England 11.27 GBP HOURLY Today

On the Our Asda' benefits site, you will have access to a wide range of discounts across various activities and services, anything from airport parking to

Front of House Restaurant Staff
Woodys Bar Lakeview Restaurant Grantham, England 10.42 GBP HOURLY Today

The successful candidates will be responsible for greeting customers, providing exceptional customer service, serving food and beverages, answering phones,