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

Handover specialist/Sales Support Executive - Mercedes-Benz of Chichester
Marshall Motor Group Chichester, England 14968 - 18374 GBP ANNUAL Today

Ensuring the processing of used car stock from dealership arrival to valeting to sales display within strict time lines. Colleague referral fee up to 2,000.

Media Workshop Leader (Unqualified Teachers accepted)
Junior Jam Blackburn, England 17.15 - 18.5 GBP HOURLY Today

You must hold a driving license and your own car to be considered for this position.*. *Driving license and car to be able to transport your resources (required

Trainee Fibre Engineer **STARTING MONDAY 27/03/23** [CF2023]
Capital Outsourcing Group Uxbridge 30000 - 40000 GBP ANNUAL Today

A Full UK Manual Driving Licence, held for at least 12months with no more than 6 points. Competitive Earning Potential *OTE 30000-40000+++*.

Area Cleaning Manager
Churchill Contract Services Ltd Brentwood, England 28000 - 30000 GBP ANNUAL Today

Hold regular contract and specification review meetings with customers. Hold a full driving license and be able to travel to sites.

barista
Marriott International Calgary 36930 - 31365 CAD ANNUAL Today

Additional Information Part Time
Job Number 23074033
Job Category Food and Beverage & Culinary
Location...