Data Management Analyst

Job Information
Job Title: Data Management Analyst 
Job Requisition ID: 64699
Ministry: Municipal Affairs
Location: Edmonton
Full or Part-Time: Full Time
Hours of Work: 36.25 hours per week
Permanent/Temporary: Permanent
Scope: Open Competition
Closing Date: November 19, 2024
Classification: Program Services 3 Market Adjustment (024PSAMA)
Salary: $2,626.89 to $3,448.73 bi-weekly ($68,561 to $90,011 / year)

The Government of Alberta is committed to a diverse and inclusive public service that reflects the population we serve to best meet the needs of Albertans. Consider joining a team where diversity, inclusion and innovation are valued and supported. For more information on diversity and inclusion, please visit: https://www.alberta.ca/diversity-inclusion-policy.aspx

The Ministry of Municipal Affairs assists municipalities in providing well-managed, collaborative, and accountable local government to Albertans. Our main responsibilities are:

• Funding supports for municipalities
• A system that strives to ensure appropriate safety standards for the construction and maintenance of buildings and equipment
• Protections for new home buyers and required licensing for home builders
• Province-wide support for access to public library services for Albertans
• Management of about 2.6 million acres of public land in the province's three Special Areas
• Independent review and decisions on local matters by the Land and Property Rights Tribunal

To learn more about Municipal Affairs, follow the link to:  https://www.alberta.ca/municipal-affairs.aspx.

Role Responsibilities

• Exercising judgement when gathering internal and external data and then converting the data into meaningful information and reports in support of designated industrial property assessment;
• Investigating, analyzing, and solving reported data issues or errors and advising the team on the best course of action to correct the data;
• Fulfilling information requests by querying, filtering, modeling from Oracle tables and views, SAS datasets, Excel and CSV data sources;
• Researching and/or investigating other external sources to validate data reported by stakeholders (knowledge of descriptive and some inferential statistical methods is necessary);
• Providing technical and analytical support for branch initiatives;
• Preparing reports, publications, briefings, and action requests to support the use of evidence in policy development;
• Develop/Maintain/Enhance existing and new reporting initiatives and models required by the business;
• Maintaining and administering processes and applications developed by senior analysts.
• Coordinate system refreshed, troubleshoot system issues, collaborate with AMS and system vendor to find solutions and follow up on submitted tickets

Please click on this link to view the job description for this position.

APS Competencies

Competencies are behaviors that are essential to reach our goals in serving Albertans. We encourage you to have an in depth understanding of the competencies that are required for this opportunity and to be prepared to demonstrate them during the recruitment process.
 

This link will assist you with understanding competencies:  https://www.alberta.ca/system/files/custom_downloaded_images/psc-alberta-public-service-competency-model.pdf.
 

• Agility: Ability to anticipate, assess, and readily adapt to changing priorities, manage resilience in times of uncertainty and effectively work in a changing environment.
• Drive for Results: Knowing what outcomes are important and maximizing resources to achieve results that are aligned with the goals of the organization, while maintaining accountability to each other and external stakeholders.
• Develop Networks: Proactively building networks, connecting, and building trust in relationships with different stakeholders.
• Systems Thinking: The work done within the APS is part of a larger integrated and inter-related environment. It is important to know that work done in one part of the APS impacts a variety of other groups/projects inside and outside the APS. Systems thinking allows us to keep broader impacts and connections in mind.
• Creative Problem Solving: Investigate, analyze, and problem solve reported geospatial data issues or errors and advise the team on the best course of action to correct the data.
   

Qualifications

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification.  Refer to https://www.alberta.ca/alberta-public-service-minimum-recruitment-standards.
 

• University graduation in one of the following disciplines or related fields:  Statistics, mathematics, Economics, Engineering, Computer Science, Management Information Systems, Information Technology, Mathematics, GIS, Social Sciences with concentration in quantitative analysis.
• Plus, minimum 2 years progressively responsible directly related experience in:
  • Quantitative data collection, retrieval and storage, analysis techniques, statistics and methods, predictive analytics, data visualization and information reporting.
  • Experience with statistical techniques, statistical and economic modelling, spatial and non-spatial data analysis, and qualitative research
     

Equivalencies:
Directly related education or experience considered based on:

• 1 year of education for 1 year of experience; or
• 1 year of experience for 1 year of education.

Assets:

• A related certification/accreditation (SAS, GIS or any related software)
• Knowledge of R and Rstudio, Python, GIS technology, Esri’s ArcGIS suite of products and FME - Safe Software.
• Knowledge of application design, database maintenance and administration using various RDBMS (Relational Database Management Systems)
• Analytical, and technical skills to evaluate, perform, advise, and ensure the integrity of data, analysis, assembly, interpretation, and reporting of designated industrial property assessment inventory and information.
• GIS knowledge – Demonstrated technical expertise in GIS technology, Esri’s ArcGIS products (ArcGIS Pro, ArcGIS Portal, ArcGIS Enterprise), cartographic techniques and ArcPy
• Experience with industry such as oil & gas, electric power system/generation, telecommunication and /or Designated Industrial Property fields (machinery/equipment/railway/farm land/building/land etc.) 
• Knowledge in the area of property assessment and taxation. 
• Knowledge of legislation and regulations surrounding property assessment and taxation with particular emphasis on designated industrial properties.

Skills and Abilities:

• Proficient technical knowledge of database management systems (e.g.: Oracle), SQL, Python, and MS Excel. Base skills in SAS software.
• Knowledge of data and information management, including quality control, data modelling, data management, and business processes for the support and maintenance of data and reporting
• Strong interpersonal skills including effective oral and written communication skills, with the ability to translate complex spatial data into information that can be understood by peers and clients.
• Demonstrated proficiency in packaging and delivering cogent and timely spatial and non-spatial data analyses to management.
• Experience using multiple data sources to conduct complex data retrieval and analysis, expertise in writing and running database queries, experience in data mining techniques and procedures, their applicability and effectiveness. 
• Expertise in the communication and presentation of complex information to non-technical audiences.

Notes

Term of Employment: Permanent, Full-time position
   

Hours of Work: 7.25 hours daily / 36.25 weekly – Monday to Friday
 
Location: Commerce Place (Edmonton)
 

This position is eligible for remote work. You must reside in Alberta to work remotely.
 

Final candidates may be required to undergo a security screening.

This competition may be used to fill future vacancies, across the Government of Alberta, at the same or lower classification level. 

Applicants are advised to provide a cover letter summarizing information that clearly and concisely demonstrates how their qualifications meet the advertised requirements, including education, experience, and relevant examples of required competencies. 
 

Additional Information: 

In your resume, please include dates (including months and years) associated with all education and work experience. Also, please indicate whether your work experience is casual, part-time, or full-time. For example, January 15, 2006 - June 25, 2009: Assistant (PT three 8 hrs. shifts/week).

Any costs associated with obtaining the required documents/checks as noted or interview travel expenses, will be the responsibility of the candidate. Out-of-province applicants can obtain the required documents/checks from the province they currently reside in.

Links and information on what the GoA has to offer to prospective employees.

• Working for the Alberta Public Service - https://www.alberta.ca/advantages-working-for-alberta-public-service.aspx
• Public Service Pension Plan (PSPP) - https://www.pspp.ca
• Alberta Public Service Benefit Information - https://www.alberta.ca/alberta-public-service-benefits
• Professional learning and development - https://www.alberta.ca/professional-development-support-directive
• Research Alberta Public Service Careers tool – https://researchapscareers.alberta.ca
• Positive workplace culture and work-life balance
• Opportunity to participate in flexible work arrangements such as working from home up to two days per week and modified work schedule agreement
• Leadership and mentorship programs
   

How To Apply
Applicants are advised to provide information that clearly and concisely demonstrates how their qualifications meet the advertised requirements, including education, experience, and relevant examples of required competencies.

Candidates are required to apply for a job online. Please visit https://www.alberta.ca/job-application-resources#before for more information. Please visit Recruitment Principles, for more information.

It is recommended applicants who have completed post-secondary studies from outside of Canada obtain an evaluation of their credentials from the International Qualifications Assessment Service (IQAS)(https://www.alberta.ca/international-qualifications-assessment.aspx) or from a recognized Canadian Credential Evaluator; please visit the Alliance of Credential Evaluation Services of Canada for more information (https://canalliance.org/en/default.html).

It is recommended that applicants include the assessment certificate from IQAS or any other educational assessment service as part of their application.

Closing Statement
This competition may be used to fill future vacancies, across the Government of Alberta, at the same or lower classification level.

We thank all applicants for their interest. All applications will be reviewed to determine which candidates' qualifications most closely match the advertised requirements. Only individuals selected for interviews will be contacted.

If you require any further information on this job posting or require an accommodation during the recruitment process, please contact Shannon Nadeau at Shannon.Nadeau@gov.ab.ca.