Data Analyst

Position Overview:

The Data Analyst role is a critical component of the City of Spruce Grove's data strategy, focusing on overseeing corporate data and expanding its use as a strategic enabler of corporate goals and objectives.

Responsibilities:

The successful candidate will be responsible for:

• 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 roadmap.
  • Establish processes for governing the identification, collection, and use of corporate metadata, focusing on quality, accuracy, and validity.
  • Conduct data capacity planning, life cycle, duration, and usage requirements.
  • Create strategies and plans for data security, backup, disaster recovery, business continuity, and archiving.
• Acquisition & Deployment:
  • Ensure the success of enterprise-level rollouts/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 metadata management tools.
  • Establish and maintain relationships with Business Unit staff to understand, clarify reporting needs, and develop solutions to meet those needs.
• 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 and 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:

The ideal candidate will possess:

• A minimum of 8 years of experience in a related field or equivalent combination of education and experience.
• A 2- or 3-year diploma in Computing Science, Electronic Engineering Technology, Information Systems, or equivalent.
• ITIL Certification is required.