An excellent opportunity to join this dynamic team and apply your technological skills

Citizens’ Services plays an integral role in the delivery of services to British Columbia’s citizens, businesses and government. The Ministry of Citizens’ Services (CITZ) delivers key services that people rely on. CITZ delivers accessible, multi-channel services, through a single-point-of-contact service approach to people in urban and rural communities through Service BC, and delivers the digital face of government at www.gov.bc.ca.

BC Registries & Online Services facilitates and supports commerce in the province through the administration and verification of business, personal property and manufactured home registrations. BC Online is government’s electronic service delivery channel for online access to information products and services.

Reporting to the Senior Database Administrator, the Database Analyst is responsible for establishing and managing data warehouse and related technologies to meet the information needs of branch leadership.

Job Requirements:

• Degree, diploma, certification in the computer science or equivalent field such as Information Management/Information Technology, Information Science, Software Engineering or equivalent combination of education and experience.
• Minimum 2 years experience in a technical role administering and supporting complex business applications serving a large, geographically distributed user base.
• Experience in relational database administration, and with data warehouse or data lake administration.
• Experience at assessing the effectiveness and accuracy of new data sources and data gathering techniques.
• Experience with data management and extract/transform/load technologies.
• Experience creating and delivering presentations for the purpose of decision making.
• Experience in data modelling, process modelling, and business analysis techniques.
  

Preference may be given to applicants with:

• Experience using Google Cloud Platform, Power BI, R, Python, SQL, Java, Go, JavaScript, and Excel
• Experience with cloud and distributed data/computing tools such as Redshift, BigTable, DigitalOcean, Map/Reduce, Hadoop, Hive, Spark, Gurobi, Beam.
• Experience with visualization and presentation tools such as Periscope, Business Objects, D3, ggplot
• Experience with Oracle and Postgres Enterprise Database Administration
• Experience leveraging structured and unstructured data sources and using statistical computer languages to conduct quantitative analysis.
  

For questions regarding this position, please contact ian.bott@gov.bc.ca.

About this Position:
An eligibility list may be established to fill future permanent and/or temporary vacancies across the Ministry of Citizens’ Services.
Remote work is allowed, this position can work up to full time from their home in British Columbia subject to an approved telework agreement. The locations listed above are to assist applicants in searching for this opportunity and are not a complete list of locations.

Working for the BC Public Service:

The BC Public Service is committed to creating a diverse workplace to represent the population we serve and to better meet the needs of our citizens. Consider joining our team and being part of an innovative, inclusive and rewarding workplace.

The Indigenous Applicant Advisory Service is available to applicants that self-identify as Indigenous (First Nations, status or non-status, Métis, or Inuit) seeking work or already employed in the BC Public Service. For guidance on applying and interviewing, please contact IndigenousApplicants@gov.bc.ca or 778-405-3452.

The BC Public Service is an award-winning employer and offers employees competitive benefits, amazing learning opportunities and a chance to engage in rewarding work with exciting career development opportunities. For more information, please see What We Offer.

How to Apply:
Your application must clearly demonstrate how you meet the job requirements listed above.

Cover Letter: NO - Please do not submit a cover letter as it will not be reviewed.

Resume: YES - A resume is required as part of your application, however, it may not be used for initial shortlisting purposes.

Questionnaire: YES - You will need to complete a comprehensive questionnaire to demonstrate how you meet the job requirements. Include all relevant information about your educational accomplishments and employment history including job titles, start and end dates (month and year) of your employment, and how you obtained your relevant experience. The questionnaire will take approximately 60 minutes to complete.

Helpful tips, videos and more regarding the application process can be found on the Your Job Application page of MyHR. If you are experiencing technical difficulty applying, e-mail BCPSA.Hiring.Centre@gov.bc.ca, before the stated closing time, and we will respond as soon as possible.

Additional Information:
A Criminal Record Check (CRC) will be required.

Applicants selected to move forward in the hiring process may be assessed on the Knowledge, Skills, Abilities and Competencies as outlined in the attached Job Profile located at the bottom of the posting.

Applications will be accepted until 11:00 pm Pacific Standard Time on the closing date of the competition.