data analyst Ottawa
Job description
DCC is proud to be recognized by Forbes on their 2022 list of Canada’s Best Employers!
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.
KEY AND PERIODIC ACTIVITIES
The duties and responsibilities listed below are representative but not all-inclusive:
Primary
- Analyse 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
SKILLS
General and Specific Knowledge
- 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 levels
DEVELOPMENT AND LEADERSHIP
- Provide functional direction and advice to employees
WORKING CONDITIONS
- Typical office environment
To begin a career with Defence Construction Canada (DCC), you must be a Canadian Citizen or a permanent resident of Canada. As a condition of employment with DCC, a minimum reliability security status clearance is required and some roles may require secret security status clearance.
DCC is responsible for the Personnel Security Clearance process. Typically to be eligible for a "Reliability" clearance, you must have five years of verifiable background information and to be eligible for a "Secret" clearance, you must have 10 years of verifiable background information. The process usually involves reference inquiries, verification of qualifications, criminal records checks, and credit checks (as required) and may require fingerprints. For more information about obtaining a security clearance, please review the Standard on Security Screening.
The appropriate security clearance is a condition of employment and it is the candidate’s or employee’s responsibility to ensure, they are able to obtain and maintain their required security level clearance to begin or continue their employment with DCC. Failure to obtain or maintain, the appropriate level of security clearance means either the candidate or employee will not receive a job offer, the conditional offer will be rendered null and void or their employment will be terminated with cause. A thorough security clearance process will be applied to all candidates or employees considered for an appointment; this process includes inquiries, verifications and assessments regarding matters such as, but not limited to:
- criminal record checks
reference checks
previous employment
open source checks
credit/financial status
DCC's Code of Business Conduct (Code) is a condition of employment. It serves to enhance public confidence in the integrity of DCC Employees and provides clarity to Employees on a number of issues, including real or perceived conflicts of interest. Before applying to this (or any) position at DCC, candidates shall familiarize themselves with the Code, because new employees are required to certify that they have read, understood, and agreed to observe the Code upon commencing work at DCC. Employees are further required to review their obligations under the Code and notify the President's Office of any changes in their circumstances at the earliest possible opportunity, and to complete the Annual Update once a year.
Be part of a diverse and inclusive workplace!
At DCC, we are committed to ensuring everyone has a voice and can be their authentic selves in our workplace. We actively encourage applications from all, including but not limited to, women, Indigenous Peoples, persons with disabilities, visible minorities and members of the LGBTQ2+ community. We also welcome applications from those who are not Canadian citizens who are eligible to work in Canada and have at least 5 years of verifiable background information.
DCC is an equal opportunity employer and will consider all requests for accommodation based on a medical contraindication, religion or another prohibited ground for discrimination under the Canadian Human Rights Act. Should you require accommodation, please email [email protected].
About Defence Construction Canada/Construction de Défense Canada
CEO: Derrick Cheung
Revenue: Unknown / Non-Applicable
Size: Unknown
Type: Government
Website: https://www.dcc-cdc.gc.ca/
Year Founded: 1950
