Data Analyst

Position Overview :

Reporting to the Business Systems Supervisor, the Data Analyst is responsible for corporate oversight of City of Spruce Grove Data.

This position's focus is on expanding the City's use of data as a strategic enabler of corporate goals and objectives. This will be accomplished through directing, evaluating, reviewing, integrating and managing data resources and services across the organization.

Data solutions will be designed and implemented with a focus on quality.

This is a full-time temporary position for 6 months.

Responsibilities :

Responsibilities for this position include :

1.Strategy & Planning

• Develop and administer strategies for use-case-specific modeling.
• Develop long term goals for production databases in conjunction with data / system owners.
• Develop and deliver strategic goals for data architecture vision and standards.
• Create tactical solutions to achieve long term objectives and an overall data management road map.
• Establish processes for governing the identification, collection, and use of Corporate metadata, focusing on quality, accuracy, validity.
• Conduct data capacity planning, life cycle, duration, usage requirements.
• Create strategies and plans for data security, backup, disaster recovery, business continuity and archiving.

2.Acquisition & Deployment

• Ensure the success of enterprise level roll out / consumption of data.
• Liaise with vendors and service providers to select products or services to meet company goals.
• Conduct research and make recommendations on database products, services, protocols and standards in support of reporting development / publishing.
• Conduct research and make recommendations on data lake products, services, protocols and standards.
• Evaluate, recommend, select data lake components and meta data management tools.
• Establish and maintain relationships with Business Unit staff to understand, clarify reporting needs and develop solutions to meet those needs.

3.Operations Management

• Work with Business Unit staff to identify, create, and deliver reports according to requirements.
• Assess and determine governance, stewardship, and frameworks for managing data across the organization.
• Design and manage data lake improvement and growth projects.
• Identify inefficiencies and gaps in current data lake and leverage solutions.
• Identify data discrepancies and data quality issues and work to ensure data consistency & integrity.
• Develop, implement and maintain change control and testing processes for modifications to data systems.
• Ensure the stability and reliability of data access and data quality across the organization.
• Respond to and resolve database access and performance issues.

Qualifications :

• Two (2) or Three (3) year diploma in Computing Science, Electronic Engineering Technology, Information Systems or equivalent with a minimum of 8 years’ experience or;
• University Degree in Computer Science, Information Systems or Computer Engineering with 4 to 6 years’ experience.
• ITIL Certification required.

For more information, please review the attached job description.