EC-02 - Data Analyst

Important messages

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you need to be accommodated during any phase of the evaluation process, please use the Contact information below to request specialized accommodation. All information received in relation to accommodation will be kept confidential.

Assessment accommodation

Your responses to the screening questions will be used as the primary source of information and your resume will only be used to validate this information. Lack of examples and details, or indicating "please refer to resume", will result in your
application being rejected as the Assessment Board will have insufficient information to determine if the requirement is met.

Provide a cover letter in 750 words (maximum) clearly demonstrating how you are the best person to fit this position.

Ensure that your cover letter contains the following:
• Your motivation! What motivates your interest in this position?
• Tell us how you meet the essential qualifications of Education and Experience related to this position.

Your cover letter WILL be used to assess Communication (written).

We are Synergy in Action! What does that mean? Who are we?

Synergy is defined as the creation of a whole that is greater than the sum of its individual parts. The Synergy in Action Directorate is comprised of four complementary teams with specialists in the areas of project management, business analysis, data analysis, development, internal operations and more! Our operations can be likened to an ecosystem – we are all interconnected and work dynamically.

Our goal is to help improve the quality of life of Canada’s Indigenous population by providing efficient, performant and accessible tools and products to our decision makers in the Canadian government. To achieve this, you can expect to see a high degree of collaboration, adaptability and relationship-building in our team. We strive for collective success and for making a positive difference - together. We are Synergy in Action.

Duties

Data Analyst (EC-02)
______________________________________________________________________________________________________
As a member of Synergy in Action (SIA)’s Business Analytics and Data Science team, you’ll be integral to the implementation of analytics driven projects that may have sweeping and immediate impacts on frontline operations and systematic service delivery issues faced by the Government in this new digital world. If you’re passionate about combining your experience in business intelligence, analytics, statistics, data mining, and/or data science with great people skills and a knack for seeing the “bigger picture”, you may be a perfect fit for this arm of SIA.

In this role, you will be responsible for supporting SIA’s many internal partners and program clients by building reporting products in PowerBI, fulfilling ad-hoc data requests, contributing to the development and quality assurance of the larger enterprise reporting environment, contributing to the development of key performance indicators, resolving technical and non-technical issues and working in a larger project team to deliver a data driven suite of operational solutions aligned to frontline realities. In addition, you will creatively find new data sources which complement operational stores, develop your own data models aligned with the clients strategic goals, work with data engineers to automate your logic into our enterprise environment, all the while synergizing with your project team to ensure they collectively have the information needed to ensure continuous stakeholder buy-in. As an entry-level position in the team, you will be part of larger projects led by Senior and Intermediate team members and provided plenty of opportunities to forge your own solutions to problems, while being guided and supported by various members of SIA.

Work environment

What’s the team like? How do we work?
_____________________________________________________________________________________________________
Collaboration is the key to staying successful and you can expect a lot of it here! Our team members are passionate, self-motivated and friendly! In our work, change is constant. We have a strong ecosystem that enables us to be skillful and be in a position to respond efficiently to operational pressures.

What do we offer?
_____________________________________________________________________________________________________
Career advancement and learning opportunities, work/ life balance, good salaries and benefits, meaningful work and more!

What are we looking for?
_____________________________________________________________________________________________________
Our ideal candidate is a leader that is able to adapt and work in uncertainty or new situations. Things change at a drop of a hat and they change frequently. This role will involve taking on new challenges and tackling many problems on behalf of the team for the first time. We value ideas and creativity, both in aesthetic design of our solutions and problem solving approaches. If you are self-motivated, have an internal desire to explore and learn, and enjoy connecting the dots – we want to hear from you.

What Analytical tools and platforms will I have access to as a member of your team?
_____________________________________________________________________________________________________
SIA currently uses an on premise Microsoft stack of analytical services, including, but not limited to Microsoft Analyses Services, Microsoft Management Studio, Microsoft Reporting Services, Microsoft PowerBI, Microsoft Sharepoint, Microsoft Dynamics and Microsoft Teams. Members of the Business Analytics arm may also be versed in and provided R, Python, or programs that use DAX and/or T-SQL.

What We Value
_____________________________________________________________________________________________________
We value technology, but we value people more; we value negotiation, but we value collaboration more; we value planning, but we value flexibility more; we value documentation, but we value results more.

Intent of the process

The immediate intent of this poster is to fill two (2) EC-02 English Essential indeterminately.

A pool of qualified candidates may be established and may be used to staff similar positions at this group and level with various language requirements (English Essential or Bilingual Imperative), various security requirements, various conditions of employment as well as various tenures (acting, assignment/secondment, deployment, term and/or indeterminate) within Indigenous Services Canada.

Positions to be filled: 2

Information you must provide

Your résumé.

A covering letter in 750 words (maximum)

In order to be considered, your application must clearly explain how you meet the following (essential qualifications)

Graduation with a degree from a recognized post-secondary institution with acceptable specialization in economics, sociology or statistics.

Notes:
Candidates must always have a degree. The courses for the specialization must be acceptable and may have been taken at a recognized post-secondary institution, but not necessarily within a degree program in the required specialization. The specialization may also be obtained through an acceptable combination of education, training and/or experience.

Degree equivalency

Experience:
E1. Experience executing analytical projects using the following components: Data management, Data integration and Data analysis.

The following will be applied / assessed at a later date (essential for the job)

Various language requirements

Information on language requirements

Knowledge:
K1.Knowledge of how to execute analytical projects using the following components:
• Data management
• Data integration
• Data analysis

Essential Competencies:
1. Demonstrating Integrity and Respect
2. Thinking things through
3. Working Effectively with Others
4. Showing Initiative and being action-oriented
5. Oral communication
6. Written communication

The following may be applied / assessed at a later date (may be needed for the job)

Asset Experience Criteria:
AE1. Experience designing, planning and implementing projects, which include data collection, data modelling, data integration, data analyses and knowledge translation.
AE2. Experience in one or more of the following: T-SQL, Python, R, SAS, STATA.
AE3. Experience developing reporting products using one or more of the following: Microsoft SSRS, Microsoft Management Studio, Microsoft Analyses Services (e.g. OLAP Cube), or Microsoft PowerBi.

Asset Knowledge Criteria:
AK1. Knowledge in the policies, operational complexities and business environment of one or more of Indigenous Services Canada’s programs (e.g. Jordan’s Principle, Non-Insured Health Benefits, eHealth, etc.)

Asset Competencies:
1. Analytical Thinking
2. Creative Thinking
3. Adaptability

Organizational Needs:
Indigenous Service Canada is committed to having a skilled and diversified workforce representative of the population it serves. In support of our strategy to achieve our employment goals for Aboriginal peoples, preference may be given to candidates who, at the time of application indicate that they are an Aboriginal person (self- declaration).

Operational Requirements:
• Ability and willingness to travel as required.
• May be required to work overtime on weekdays or weekends.

Conditions of employment

Reliability Status security clearance

Other information

The Public Service of Canada is committed to building a skilled and diverse workforce that reflects the Canadians we serve. We promote employment equity and encourage you to indicate if you belong to one of the designated groups when you apply.

Information on employment equity

Frequently Asked Questions
_____________________________________________________________________________________________________
Q. Where are your staff located?
A: We currently have staff located in Edmonton, Montreal, Regina and Ottawa. As our team continues to grow, we anticipate being even more flexible.

Q: Why was my application automatically rejected when I submitted it?
A: You must meet all essential qualifications at the time you submit your application. If you receive a message "Application rejected at screening" immediately after submitting your application, you answered "No" to one of the essential qualifications. If you have incorrectly indicated "No", simply retrieve your application and update your answer to the screening question.

Q: What is the start date for the position?
A: We will be able to offer an approximate start date after the assessment phase (testing, interview, and reference checks) is completed.

Q: How do I apply?
A: Applications are accepted through the GC Jobs website. Treasury Board of Canada Secretariat's video: Cracking the Code helps people who are looking for a new career with the Government of Canada to navigate the application process step by step.

Q: How will you communicate with me?
A: We will contact you at the email address that you have listed on your GC Jobs account. Please ensure that you regularly check your email inbox, junk mail folder and your GC Jobs account.

Q: Who can I contact if I have technical difficulties with the GC Jobs website?
A: You can contact the Public Service Commission of Canada's support centre. Select the "Contact Us" link below, in the left corner of this window, or by calling 1-888-780- 4444.

IMPORTANT APPLICATION INFORMATION
_____________________________________________________________________________________________________
1. Candidates must meet all of the essential qualifications noted in the Statement of Merit Criteria to be appointed to a position. A candidate may be appointed to a position even though he/she does not meet any or all of the asset qualifications or operational requirements. However, meeting these criteria is desirable and may be a deciding factor in choosing the person to be appointed.

2. Depending on the number of applicants, needs and/or plans, the following may be applied during the assessment and/ or selection of candidates in the staffing process: top-down approach, cut-off scores, asset selection, organizational needs and/or operational requirements.

3. You will be required to provide proof of education credentials in the form of a diploma or official transcript at the interview stage. Candidates with foreign credentials must provide proof of Canadian equivalency. Please contact the Canadian Information Centre for International Credentials for further information at http://www.cicic.ca/.

4. Several methods of assessment will be used to assess potential candidates (e.g. written exam, interview, reference check, etc.).

5. Acknowledgement of receipt of applications will not be sent.

6. Persons are entitled to participate in the appointment process in the official language of their choice with the exception of the assessment of their linguistic capacity.

7. All communications related to the process, including e-mail correspondence and telephone conversations, may be used to assess candidates' qualifications.

8. Candidates must provide three supervisory references, one of which must be your current supervisor.

Preference

Preference will be given to veterans and to Canadian citizens, in that order, with the exception of a job located in Nunavut, where Nunavut Inuit will be appointed first.

Information on the preference to veterans

We thank all those who apply. Only those selected for further consideration will be contacted.