Support Analyst: SQL Server/Programmer - Architect

Important messages

Western Economic Diversification Canada (WD) is looking for an individual to join our team. WD is routinely ranked as one of the Best Place to Work according to the Public Service Employee Survey, and we have been recognized as one of Alberta's Top 75 Employers in 2020. If you want to be part of a great organization that gets things done for Western Canadians, you want to work here!

Please note: as a result of the COVID-19 pandemic, we are primarily working remotely for the time being. Interviews and related assessments will be conducted virtually throughout this staffing process. Applicants are responsible to ensure they have a reliable internet connection and access. If you are appointed to a position, WD will provide tools and/or equipment to support remote work.

Duties

Western Economic Diversification is looking for a Support Analyst: SQL Server/Programmer - Architect to join our team. If you are motivated and interested in an exciting opportunity for growth in a dynamic department please apply.

We are looking for people who think independently, work creatively and enjoy working in a team environment to support the priorities of the department. As a Support Analyst: SQL Server/Programmer - Architect you will be responsible for providing technical support in systems development and testing services in support of Western Economic Diversification Canada (WD) program delivery. You will be challenged to connect with people, build relationships, and develop creative approaches to addressing unique opportunities.

Work environment

Western Economic Diversification Canada (WD) works to develop and diversify the economy of Western Canada by delivering grants and contributions programs and advocating on behalf of the West.

WD is recognized as one of Alberta’s top employers because of its support for employees, innovative workplace and ability to make a difference in the lives of Western Canadians. In the annual public service employee survey, WD employees consistently rank the department as one of the best places to work in the federal government.

Why Choose WD:
• Work with amazing people who support each other
• Meaningful work that makes a difference to the country
• Excellent compensation package
• Flexible work arrangements
• Modern work tools and technology

Intent of the process

A pool of qualified candidates (fully assessed or partially assessed) will be established and may be used to staff similar positions at this group and level. This process may be used for various positions and tenures (including but not limited to term and indeterminate appointments, internal assignments, secondments, deployments, acting appointments, casual) as well as various locations, security requirements, language requirements and conditions of employment. The pool of qualified candidate may also be shared and accessed with other federal government departments.

Positions to be filled: Number to be determined

Information you must provide

Your résumé.

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

Essential Qualifications:
• Successful completion of an acceptable two-year, post-secondary education program in computer science, information technology, information management or another specialty relevant to the position to be staffed.

NOTE: Indeterminate incumbents of CS positions on May 10, 1999, who do not possess the education described above, are deemed to meet the minimum education standards based on their education, training and/or experience.

Degree equivalency

Experience:
• Significant* experience developing, testing and maintaining Microsoft SQL Server Integration Services (SSIS), SQL Server's Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). *
• Significant* experience Accessing / programming Microsoft SQL Server and/or Oracle databases. *
• Experience developing, testing and maintaining Microsoft Power Apps / Power Automate.
• Experience developing, delivering and/or supporting IM/IT solutions using defined methodologies and best practices.
• Experience analyzing business/client requirements; providing advice, options and/or recommendations in the definition, development and/or implementation of IM/IT solutions.

* Significant is defined as the depth and breadth of experience normally associated with the performance of the duties for a period of two (2) years.

Knowledge
• Knowledge of PowerBI
• Knowledge of SSIS, SSAS and SSRS
• Knowledge of Microsoft SQL Server and/or Oracle Application Server.
• Knowledge of computer systems programming techniques, methods and practices.

Competencies
• Communication – Oral and Written
• Values and Ethics
• Engagement
• Analytical Thinking

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

English essential

Information on language requirements

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

Certification(s) in any of the following:
• MSC (Microsoft Certified. Any)
• Oracle and/or SQL

Asset Experience:
• Experience programming in one or more of the following: .Net, ASP.NET, PL / SQL, JavaScript, C#, CSS, HTML, or XML.
• Experience with SQL Server Integration Services (SSIS).
• Experience with DevOps
• Experience with SQL Server Reporting Services (SSRS)
• Experience with PowerApps / PowerAutomate
• Experience with Microsoft D365
• Depth, breadth and scope of experience in any one or combination of the experience requirements.

Knowledge:
• Knowledge of Microsoft Power Apps / PowerAutomate
• Knowledge of Microsoft D365

Organizational Needs:
• In support of achieving a diversified workforce, consideration may be given to candidates self identifying as belonging to one of the following Employment Equity groups: Aboriginal peoples, persons with a disability, visible minorities and women.

Conditions of employment

• Reliability Security Clearance
• Candidates may be required to work overtime on short notice with appropriate compensation from time to time.
• Candidates may be required to travel outside of the Edmonton area for periods up to 5 days.

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

TIPS FOR APPLICANTS: When answering the screening questions ensure that you provide complete and thorough details of your experience. Do not assume that the screening board has any previous knowledge of your background, qualifications, or work history. You must be specific and provide concrete examples/details for each Experience element, as applications will be screened only on the information provided. Failure to provide sufficient information may result in your application being screened out of the competition.

Depending on the number of applicants, the needs and/or Human Resources plans, volume management strategies such as random selection, top-down approach and/or establishing cut-off scores to determine who will continue in the staffing process, MAY BE USED for the purpose of managing applications.

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.