Data Analyst

2 months ago

Red Deer, Canada The City of Red Deer Full time

**The Opportunity**:
The City of Red Deer is currently recruiting for a Data Analyst 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 the organization while ensuring high levels of data quality. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Where required, the Database Analyst will design, install, monitor, maintain, and performance-tune production databases.

The IT Data Analyst will liaise with others in data analyst roles across the organization, providing guidance and support in organizational standard methodologies, tools, and processes related to data analysis. This position plays a key role in supporting the core IT functional processes of Database Management, Business Intelligence and Reporting, and Data Quality.
- College diploma or university degree in the field of computer science or related field
- Must have 3 years’ experience in a comparable position:

- Querying in Transact-SQL
- Working in server-client computing and relational database environments.
- Techniques for data management and data processing flowcharting.
- Designing, building, installing, configuring and supporting database servers
- Troubleshooting and tuning databases.
- Providing database analysis and administration.
- Managing and developing databases and integration services using the MS SQL platform, including demonstrated ability with SQL Management Studio (SSMS), SQL Integration Services (SSIS) and SQL Reporting Services (SSRS).
- Performing Business requirements analysis, entity relationship planning, database design, and reporting structures.
- Working with SQL Server BI platform, including SQL Analysis Services (SSAS) and Power BI and Power BI Report Server.

Preferred additional experience:

- Strong knowledge of database security, backup and recovery, and performance monitoring standards.
- Strong understanding of database structures, theories, principles, and practices.
- Good knowledge of applicable data privacy practices and laws.
- Ability to manage data and metadata migration.
- Experience with other database platforms (Oracle) and services (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, network products and desktop products.
- Project management or lead experience.
- An equivalent combination of education and experience may also be considered.
- Excellent written and verbal communication skills.
- Exceptional analytical, conceptual, and problem-solving abilities with keen attention to detail.
- Strong technical documentation skills.
- Ability to establish and maintain effective working relationships with departmental staff, other City departments, customers, outside vendors and consultants.
- Ability to work independently or in a team situation in a collegial atmosphere.
- Ability to work independently and act on an initiative within given guidelines.
- Strong computer skills, including familiarity with Microsoft Office 365.
- Must have the ability to work in a demanding and frequently stressful environment.
- Must be available to perform call out duties when applicable.

**Affiliation**:
Canadian Union of Public Employees, Local 417

**Remuneration**:
$34.62 to 52.53 per hour

**Hours of Work**:
75 hours biweekly; Monday to Friday, some evening and weekend work may be required when needed.

**Additional Information**:
Use of a personal vehicle may be required for service calls and offsite meetings. This position may require availability for call-out or standby outside regular hours.

*Hybrid remote work may be considered for this role.*

  • Csv Data

    5 months ago

    Red Deer, Canada The City of Red Deer Full time

    **The Opportunity**: This position performs data analysis, transformation, modelling and provides reports, materials and data visualization to CSV leadership. This position is responsible for facilitating daily responsibilities to CSV Information Systems (examples may include: SmartSimple, Efforts to Outcomes Database, Intelli, Transit suite (SWIT)). The...

  • Data Analyst

    5 months ago

    Red Deer, Canada Nutrien Full time

    At Nutrien, our purpose is **Feeding the Future **and we do so with safety, inclusion, integrity and results as our core values. Nothing is more important than sending our people home safe, every day. Nutrien is a leading provider of agricultural products, services, and solutions. With over 26,000 employees world-wide, we are the largest producer of potash...

  • Data Analyst

    5 months ago

    Red Deer, Canada Nutrien Full time

    At Nutrien, our purpose is **Feeding the Future **and we do so with safety, inclusion, integrity and results as our core values. Nothing is more important than sending our people home safe, every day. Nutrien is a leading provider of agricultural products, services, and solutions. With nearly 25,000 employees world-wide, we are the largest producer of...

  • Reporting Analyst

    2 months ago

    Red Deer, Canada Red Deer Polytechnic Full time

    **Please see Special Instructions for more details.**: There is a possibility this position will be extended.** **The internal title for this position is Market Research and Reporting Analyst. The posting title has been updated to match industry standards. **Posting Details**: Position Information **Position Title** - Reporting Analyst**Position...

  • Financial Analyst

    3 weeks ago

    Red Deer, Canada Precision Well Servicing Full time

    Precision Well Servicing is the largest service rig provider in Canada, with an impressive fleet of equipment, service rig professionals and strong relationships with top-tier companies. Precision is currently seeking an experienced payroll Supervisor to join our team. The **Financial Analyst** will assist the Accounting Supervisor and Controller with...

  • Financial Analyst

    3 weeks ago

    Red Deer, Canada Precision Well Servicing Full time

    Precision Well Servicing is the largest service rig provider in Canada, with an impressive fleet of equipment, service rig professionals and strong relationships with top-tier companies. Precision is currently seeking an experienced Financial Analyst to join our team.  The Financial Analyst will assist the Accounting Supervisor and Controller...

  • Financial Analyst

    1 week ago

    Red Deer, Canada Precision Well Servicing Full time

    Precision Well Servicing is the largest service rig provider in Canada, with an impressive fleet of equipment, service rig professionals and strong relationships with top-tier companies. Precision is currently seeking an experienced Financial Analyst to join our team.  The Financial Analyst will assist the Accounting Supervisor and Controller...

  • Csv Financial Analyst

    6 months ago

    Red Deer, Canada The City of Red Deer Full time

    **The Opportunity**: The City of Red Deer is currently recruiting for a **Community Services Financial Analyst**. Community Services is a broad and exciting division. It serves our citizens with services such as water, waste and electrical utilities, transit, fleet, recreation, public works, parks and community development services. The environment is...

  • Parks & Public Works Operations Analyst

    1 month ago

    Red Deer, Canada The City of Red Deer Full time

    **The Opportunity**: The City of Red Deer is currently recruiting for a **Parks & Public Works Operations Analyst** to fill a permanent full-time position. The Parks & Public Works Operations Analyst will be responsible for monitoring, forecasting, providing quantitative analysis, contract monitoring and compliance, and coordinating activities for a variety...

  • Police Intelligence Analyst

    2 weeks ago

    Red Deer, Alberta, Canada City of Red Deer Full time

    The Opportunity:This role involves producing, preparing, and disseminating information relevant to local criminal activity to increase operational effectiveness, prevent crime, and apprehend suspects. The position also provides assistance for strategic planning by identifying, gathering, and preparing information related to statistics, demographics, and...

  • Financial Analyst

    5 months ago

    Red Deer, Canada Proall International Mfg. Inc. Full time

    ProAll International Manufacturing Ltd. a Terex Brand, _**located in Olds, AB (approximately 45 minutes South of Red Deer)**_, is seeking an experienced Financial Analyst. This is an excellent opportunity to join a positive team in a fast-paced environment. - Please note that this position is based out of our Olds, Alberta location**_ **What we offer**: -...

  • Financial Analyst

    6 months ago

    Red Deer, Canada Proall International Mfg. Inc. Full time

    ProAll International Manufacturing Ltd. a Terex Brand, _**located in Olds, AB (approximately 45 minutes South of Red Deer)**_, is seeking an experienced Financial Analyst. This is an excellent opportunity to join a positive team in a fast-paced environment. - Please note that this position is based out of our Olds, Alberta location**_ **What we offer**: -...

  • Financial Analyst

    5 months ago

    Red Deer, Canada Proall International Mfg. Inc. Full time

    ProAll International Manufacturing Ltd. a Terex Brand, _**located in Olds, AB (approximately 45 minutes South of Red Deer)**_, is seeking an experienced Financial Analyst. This is an excellent opportunity to join a positive team in a fast-paced environment. - Please note that this position is based out of our Olds, Alberta location**_ **What we offer**: -...

  • Field IT Analyst

    2 months ago

    Red Deer, Canada Trican Well Service Full time

    **TRICAN** is Canada’s leading pressure pumping company; we prioritize our people, customers, innovation, and the environment. Trican offers more than just great jobs, we offer long term careers. At Trican, we believe success begins with our people, as our name and reputation are reflected in the excellence demonstrated by our employees. Come try Trican...

  • Database Analyst

    6 months ago

    Red Deer, Canada Pacificwest Technologies Inc. Full time

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Operate database management systems to analyze data - Research and document data requirements, data collection and...

  • Production Information Coordinator

    5 months ago

    Red Deer, Canada Olymel Full time

    Job Overview: We are seeking a passionate and experienced Production Information Coordinator to join our team. The incumbent supports the management team of the facility, particularly in the production and customer quotation processes. They work closely with production managers to understand data needs with the aim of enhancing overall performance. **Key...

  • Police Criminal Intelligence Analyst

    4 weeks ago

    Red Deer, Canada The City of Red Deer Full time

    **The Opportunity**: The primary function of this position, through tactical and strategic analysis is to produce, prepare and disseminate a variety of information relevant to actual or anticipated local criminal activity in order to increase operational effectiveness, prevent crime and apprehend suspects. The position also provides assistance for Policing...

  • Police Criminal Intelligence Analyst

    5 months ago

    Red Deer, Canada The City of Red Deer Full time

    **The Opportunity**: The primary function of this position, through tactical and strategic analysis is to produce, prepare and disseminate a variety of information relevant to actual or anticipated local criminal activity in order to increase operational effectiveness, prevent crime and apprehend suspects. The position also provides assistance for Policing...

  • Police Criminal Intelligence Analyst

    4 weeks ago

    Red Deer, Canada City of Red Deer Full time

    The Opportunity: The primary function of this position, through tactical and strategic analysis is to produce, prepare and disseminate a variety of information relevant to actual or anticipated local criminal activity in order to increase operational effectiveness, prevent crime and apprehend suspects. The position also provides assistance for Policing...

  • Systems Analyst

    5 months ago

    Red Deer, Canada Black Bird Automation Ltd. Full time

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years - Experience: 1 year to less than 2 years **Tasks**: - Confer with clients to identify and document requirements - Design, develop and implement information systems business solutions - Provide advice on information systems strategy, policy,...