CSO4 (Geomatics Data Administrator)
Competition # : 45225
Department: Service Nova Scotia
Location: AMHERST
Type of Employment: Permanent
Union Status: NSGEU - NSPG
Closing Date: 07-Mar-25 (Applications are accepted until 11:59 PM Atlantic Time)
About Us
At Service Nova Scotia, we impact every citizen, business, and municipality in Nova Scotia. Our mandate is to design and deliver programs and services to meet the needs of our clients and the public good through a culture of excellence. Service Nova Scotia’s vision is to be recognized leader in service and public protection that delivers trusted, accessible, modern programs, and contributes to Nova Scotia as a safe and desirable place to live, work and do business. To learn more about our department, please click here.
GeoNOVA is the provincial mapping program, providing geomatics solutions for departments and agencies across provincial government. GeoNOVA’s vision is to ensure geographic information supports the Government of Nova Scotia in achieving excellence in decision making and service delivery. Find more about GeoNOVA here.
About Our Opportunity
Do you want to make a huge impact and help deliver exciting geomatics solutions to partners? If you do, we are looking for someone like you to join our team. We are looking to strengthen our team with the addition of a Geomatics Data Administrator.
Primary Accountabilities
We are looking for a geomatics data administrator to work with teams with effective problem-solving skills and improving data management and data publishing tasks within government’s spatial data infrastructure, which is critical to delivering quality and trusted government programs and services.
Geomatics Data Administrator responsibilities include:
- Lead geographic data architecture for the provincial Spatial Data Infrastructure, ensuring optimal performance, security, and storage of geographic data.
- Work closely with contributors and users, lead the design and development of enterprise geographic data models, including transactional and warehousing models ensuring optimal performance, integrity and security.
- Manage Extract, Transform, and Load (ETL) processes for geographic data, including regular testing of ETL scripts for data updates.
- Supervision of a team of geomatics professionals.
- Processing of GIS data for distribution via various channels, including the Spatial Data Warehouse (SDW), data for web-applications, map services, Open Data, and downloadable distribution packages.
Qualifications and Experience
To be successful in this role, you will have a bachelor’s degree in a relevant field plus a minimum of six (6) years of experience or an equivalent combination of training and experience may be acceptable
- Oracle database expertise with knowledge of geospatial data management.
- Strong understanding of database structures, theories, principles, and practices.
- Demonstrated experience with data workflows and Extract, Transform, and Load (ETL) processes for geographic data
- Ability to troubleshoot basic to complex problems, and excellent interpersonal skills.
- Knowledge of structured query language (SQL).
- Understanding of Geographic Information Systems (Esri), geographic data, and related principals
Equivalency
Applicants relying on education and experience equivalencies must demonstrate such equivalencies in their application.
Benefits
Based on the employment status and union agreement, the Government of Nova Scotia offers its employees a wide range of benefits such as a Defined Benefit Pension Plan, Health, Dental, Life Insurance, General illness, Short and Long Term Disability, Vacation and Employee and Family Assistance Programs. For information on all our Benefit program offerings, click here: Benefits for government employees.
Working Conditions
- Normal work week is 35 hours/week, 7 hours/day.
- May be required to work overtime on occasion.
- Majority of time spent in an office environment.
- Travel within communities across Nova Scotia will may occasionally be required.
Additional Information
This is a permanent employment opportunity.
What We Offer
- Career development where you have access to career guidance, tools, resources, and ongoing training for every stage of your career
- Engaging workplace: our employees feel valued, respected, connected, and tuned in, we have forward-thinking policies and strategies
- Countless career paths
- Department specific flexible working schedules
Pay Grade: PR 17
Salary Range: $3,107.16 - $3,649.33 Bi-Weekly
Employment Equity Statement:
Our goal is to be a diverse workforce that is representative, at all job levels, of the citizens we serve. The Government of Nova Scotia has an Employment Equity Policy, and we welcome applications from Indigenous People, African Nova Scotians and Other Racially Visible Persons, Persons with Disabilities and Women in occupations or positions where they are under-represented. If you are a member of one of these equity groups, you are encouraged to self-identify on your electronic application.
This is a bargaining unit position initially restricted to current civil service employees represented by the Nova Scotia Government Employees Union (NSGEU). If applying from outside a government office, employees must apply correctly via this link:
Failure to apply correctly means that your application will not be given first consideration as a bargaining unit applicant, and will only be included if external applications are pursued.
External applicants and current casual employees will only be considered if there are no qualified civil service bargaining unit candidates. PLEASE NOTE: Candidates will not be considered for an interview if applications are incomplete or are missing information.
Offer of employment is conditional upon the completion of all applicable background checks and confirmation of credentials, the results of which must be satisfactory to the employer. We thank all applicants for the interest, however, only those selected for an interview will be contacted. All questions and concerns may be directed to Competitions@novascotia.ca.
