Developer (Stream 1) / Database Analyst (Stream 2)

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

Work environment

Do you want to be a key player in an organization that ranks as one of the best places to work in the federal government? Do you want a career working alongside people who enjoy their work? Where there are chances to grow, learn, and develop? Then keep reading – you may be who we are looking for!

At the Atlantic Canada Opportunities Agency, we are invested in our people, our communities, and our economy. Every single one of our employees contributes to our success – and the success of our region. We work together to help businesses become more competitive, innovative, and productive, to develop and diversify local economies in our communities, and to champion the strengths of Atlantic Canada.

We are currently looking for candidates for two teams within ACOA’s Chief Information Officer Directorate.

Stream 1 - Developer, Application Development:
The Application Development team is responsible for development and operation of custom software that supports program delivery and internal services. The main duties of a Developer include:

• End-to-end development and maintenance of custom software in an agile environment
• Technical support of custom software
• Engagement and collaboration with clients and other stakeholders
• Project coordination and technical leadership
• Application platform administration (on-premises and cloud)
• Provision of expert advice, guidance, and coaching to team members, management, and clients

Stream 2 - Database Analyst, Database and Data Administration:
The Database and Data Administration team is responsible for building reports and dashboards, supporting information systems, and managing corporate data, databases, and business intelligence (BI) platforms. The main duties of a Database Analyst include:

• End-to-end development and maintenance of BI solutions
• Technical support of BI solutions and corporate information systems
• Management of data sources to enable self-service BI and data analytics
• Engagement and collaboration with clients and other stakeholders
• Project coordination and technical leadership
• Database and BI platform administration (on-premises and cloud)
• Provision of expert advice, guidance, and coaching to team members, management, and clients

ACOA is committed to creating a diverse and inclusive workplace. We want our employees to be who they are – people with a variety of ideas, abilities, and lived experiences. Our differences are what make us strong and innovative. We are also committed to your well-being and work-life balance. As a federal organization, we offer:

• Flexible work arrangements
• Excellent benefits that include pensions, medical and dental plans
• Opportunities for growth, skill and career development

This is who we are. If you want to be part of an innovative and inclusive team, ACOA could be the place for you. Come build a stronger Atlantic economy with us!

Intent of the process

A pool of qualified candidates will be established through this process and used to fill future openings for permanent and/or temporary* positions. The positions may be located at ACOA’s Head Office in Moncton, New Brunswick or in an ACOA office in one of the other cities listed. Due to COVID-19, our teams currently work virtually from home using the latest technologies to stay connected. Potential employees may work virtually from one of these cities depending on the position to be staffed.

* Permanent, temporary, acting, deployment, assignment and/or secondment

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)

We are looking for candidates who really want to be part of an incredible team and contribute to its continued success. To begin, we need to make sure you meet the essential qualifications below.

ESSENTIAL EDUCATION:
You have graduated with a bachelor's or graduate degree from a recognized post-secondary institution with specialization in computer science, information technology, information management or another specialty relevant to the position OR have an acceptable combination of education, training, and/or experience related to the position.

Degree equivalency

ESSENTIAL EXPERIENCE:

For STREAMS 1 & 2, you must have significant* and recent** experience in the following:
• Developing and maintaining software, including analysis, design, build, testing, delivery, and support
• Analyzing and documenting client requirements, and recommending solutions
• Troubleshooting software and technical issues

Candidates for STREAM 1 (Developer) must also have:
• Significant* and recent** experience in web development
• Experience working with relational databases (e.g. development, design, management)

Candidates for STREAM 2 (Database Analyst) must also have:
• Significant* and recent** experience in relational database development
• Recent** experience in relational database design and management
• Recent** experience in building business intelligence solutions (e.g. reports, dashboards, data warehousing, data visualization, machine learning)


* Significant experience is defined as experience normally associated with having performed a broad range of related activities for a period of at least three (3) years.

** Recent experience is defined as experience normally acquired within the last three (3) years.

If you possess any of the following, your application must also clearly explain how you meet it (other qualifications)

The following qualifications are considered assets. They are not required but we want to know more about you if you meet them.

• Do you have experience leading projects or initiatives, or being responsible for key deliverables throughout a project or initiative?
• Do you have experience with Microsoft technologies? (Please be specific about your experience with each product and/or service.)
• Do you have experience with Oracle Database?

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

Various language requirements
English Essential, Bilingual imperative BBB/BBB or higher

Information on language requirements

As part of the assessment process, you will need to demonstrate these competencies:
• Analytical Thinking
• Client Focus
• Communication
• Continuous Learning
• Resilience
• Results Orientation
• Teamwork

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

ORGANIZATIONAL NEEDS:
In support of achieving a represented workforce, current or future organizational needs may require consideration be given to candidates self-identifying as belonging to one of the following Employment Equity groups: Aboriginal peoples, members of visible minorities, persons with disabilities, and women.

OPERATIONAL REQUIREMENTS:
• Ability and willingness to work remotely
• Ability and willingness to work overtime on short notice and to be on call as required
• Ability and willingness to lift computers, monitors, and other peripherals as required

Conditions of employment

Reliability Status security clearance - You will have to meet the condition of employment which is a Reliability Status security clearance. Our team would help you with that at a later date.

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

APPLICANTS INFORMATION:
• We are committed to providing an inclusive and barrier-free hiring process. If you require accommodation at any stages in the selection process, including technical aid to ensure an equitable assessment of your qualifications, please use the contact information below.
• You are encouraged to apply online via the jobs.gc.ca site. To submit an application, please select the button “Apply Online” below.
• You must meet all essential qualifications to be qualified. Asset qualifications, under the "other qualifications" sections, are not essential, but may be deciding factors at any stages of the process.
• When communicating with us, you may use the official language (English or French) of your choice.
• We will be reaching out via email. You must include a valid email address in your application. Be sure to check your spam folder.
• If you currently work in the Public Service of Canada, please state this in your application. Please indicate your substantive group and level and your employment status.

PROCESS INFORMATION:
• Random and/or top-down selection may be used to decide who will be assessed further.
• All communication during the process may be used to evaluate you.
• Various assessment tools may be used.
• You will have to provide proof of your education credentials.

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.