Data Analyst

The Opportunity :

The City of Red Deer is currently recruiting for a DataAnalyst to fill a permanent full-time position. The Data Analyst’s role is to work on evaluating, reviewing, and managing database resources and services across theorganization while ensuring high levels of data quality.

This individual isalso responsible for developing, implementing, and overseeing database policiesand procedures to ensure the integrity and availability of databases and theiraccompanying software.

Where required, the Database Analyst will design,install, monitor, maintain, and performance-tune production databases.

This analyst will work with department subject matterexperts and Application Systems Analysts to gather business requirements tostrategically design and implement BI software and solutions, includingintegration with databases and data warehouses by working closely with the DataArchitect for the development of BI data models.

This may involve thedevelopment of reports, graphs and dashboards and to be responsible forensuring high levels of BI availability through support functions and in-depthtesting.

The IT Data Analyst will liaise with others in dataanalyst roles across the organization, providing guidance and support inorganizational standard methodologies, tools, and processes related to dataanalysis.

This position plays a key role in supporting the core IT functionalprocesses of Database Management, Business Intelligence and Reporting, and DataQuality.

As our preferred candidate, youwill have :

• College diploma or university degree in the field ofcomputer science or related field
• Must have 3 years’ experience in a comparableposition :
• Querying in Transact-SQL
• Working in server-client computing and relationaldatabase environments.
• Techniques for data management and data processingflowcharting.
• Designing, building, installing, configuring andsupporting database servers
• Troubleshooting and tuning databases.
• Providing database analysis and administration.
• Managing and developing databases and integrationservices using the MS SQL platform, including demonstrated ability with SQLManagement Studio (SSMS), SQL Integration Services (SSIS) and SQL ReportingServices (SSRS).
• Performing Business requirements analysis, entityrelationship planning, database design, and reporting structures.
• Working with SQL Server BI platform, including SQLAnalysis Services (SSAS) and Power BI and Power BI Report Server.

Preferred additional experience :

• Strong ability to analyse user requirements and buildfront-end BI applications according to specifications.
• Strong knowledge of database security, backup andrecovery, and performance monitoring standards.
• Strong understanding of database structures, theories,principles, and practices.
• Good knowledge of applicable data privacy practicesand laws.
• Ability to manage data and metadata migration.
• Experience with other database platforms (Oracle) andservices (AWS, Microsoft Azure).
• PowerShell scripting skills.
• Understanding of Web services (SOAP, XML, UDDI, WSDL).
• Object oriented programming experience (e.g. using,.NET, WebSphere, Java, etc).
• Working with Microsoft operating systems, networkproducts and desktop products.
• Working with business purchased applications.
• Project management or lead experience.
• An equivalent combination of education and experiencemay also be considered.
• Excellent written and verbal communication skills.
• Exceptional analytical, conceptual, andproblem-solving abilities with keen attention to detail.
• Strong technical documentation skills.
• Ability to establish and maintain effective workingrelationships with departmental staff, other City departments, customers,outside vendors and consultants.
• Ability to work independently or in a team situationin a collegial atmosphere.
• Ability to work independently and act on an initiativewithin given guidelines.
• Strong computer skills, including familiarity withMicrosoft Office 365.
• Must have the ability to work in a demanding andfrequently stressful environment.
• Must be available to perform call out duties whenapplicable.

Affiliation :

Canadian Union of Public Employees, Local 417

Remuneration :

$34.62 to 52.53 per hour

Hours of Work :

75hours biweekly; Monday to Friday, some evening andweekend work may be required when needed.

AdditionalInformation :

Useof a personal vehicle may be required for service calls and offsite meetings. This position mayrequire availability for call-out or standby outside regular hours.

Hybrid remotework may be considered for this role.*

We thank you for your application.Only those selected for an interview will be contacted.