Data Analyst

21 hours ago

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

The City of Red Deer is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will play a critical role in evaluating, reviewing, and managing database resources and services across the organization, ensuring high levels of data quality.

Key Responsibilities
  • Develop, implement, and oversee database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
  • Design, install, monitor, maintain, and performance-tune production databases.
  • Work with department subject matter experts and Application Systems Analysts to gather business requirements to strategically design and implement BI software and solutions.
  • 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.
Requirements
  • College diploma or university degree in the field of computer science or related field.
  • 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.
  • 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 Qualifications
  • Strong ability to analyze user requirements and build front-end BI applications according to specifications.
  • 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.
  • Working with business-purchased applications.
  • Project management or lead experience.
  • 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.

  • Data Analyst

    4 days ago

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

    About the OpportunityThe City of Red Deer is seeking a highly skilled Data Analyst to join our team. As a key member of our organization, you will play a critical role in evaluating, reviewing, and managing database resources and services to ensure high levels of data quality.Key ResponsibilitiesDevelop, implement, and oversee database policies and...

  • Data Analyst

    4 days ago

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

    About the OpportunityThe City of Red Deer is seeking a highly skilled Data Analyst to join our team. As a key member of our organization, you will play a critical role in evaluating, reviewing, and managing database resources and services to ensure high levels of data quality.Key ResponsibilitiesDevelop, implement, and oversee database policies and...

  • Data Engineer

    1 week ago

    Red Deer, Alberta, Canada Liberty Utilities Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our Energy Services team at Liberty Utilities. As a Data Engineer, you will play a critical role in designing, developing, and maintaining our data infrastructure to support business analytics and decision-making.Key ResponsibilitiesData Ingestion and Processing: Design and implement...

  • Data Engineer

    1 week ago

    Red Deer, Alberta, Canada Liberty Utilities Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our Energy Services team at Liberty Utilities. As a Data Engineer, you will play a critical role in designing, developing, and maintaining our data infrastructure to support business analytics and decision-making.Key ResponsibilitiesData Ingestion and Processing: Design and implement...

  • Application Support Team Supervisor

    4 weeks ago

    Red Deer, Alberta, Canada Alberta Health Services Full time

    Your Opportunity: The Application Support Team Supervisor plays a pivotal role in overseeing the efficiency, structure, and guidance of a team comprising System Administrators and Report Developers dedicated to supporting enterprise staff scheduling applications and databases. This position entails providing operational leadership to the Application...

  • Application Support Team Supervisor

    4 weeks ago

    Red Deer, Alberta, Canada Alberta Health Services Full time

    Your Opportunity: The Application Support Team Supervisor plays a crucial role in overseeing the performance, organization, and leadership of a dedicated team of System Administrators and Report Developers. This team is responsible for supporting enterprise-level staff scheduling applications and databases. The Supervisor is tasked with providing...

  • Financial Analyst for Community Services

    4 weeks ago

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

    Position Overview: The City of Red Deer is seeking a Community Services Accountant to fulfill a term role. This position is essential for maintaining the accuracy of the financial and accounting records within the Community Services Division. The accountant will provide guidance and support to the Director of Community Services, Director of Protective...

  • Financial Analyst for Community Services

    4 weeks ago

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

    Position Overview: The City of Red Deer is seeking a Community Services Accountant to undertake a term position. This role is pivotal in maintaining the accuracy of the financial and accounting records for the Community Services Division. The accountant will provide guidance and support to various leaders including the Director of Community Services,...

  • Data Analyst

    4 days 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,...

  • Data Analyst

    4 days ago

    Red Deer, Canada City of Red Deer Full time

    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,...

  • Csv Data

    3 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...

  • Csv Data

    3 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

    3 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

    3 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...

  • Data Analyst

    3 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**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management...

  • Power Markets Data Engineer

    1 month ago

    Red Deer, Canada Liberty Utilities Full time

    PurposeThe mandate of the Energy Services (ES) team is to maximize the company's risk adjusted asset return by providing portfolio management (hedging/optimization) and market advisory services. The ES team consists of three pillars:Portfolio Management (Trading/Hedging)Client & Asset SupportMarket AnalyticsReporting to the leader of Market Analytics, the...

  • Power Markets Data Engineer

    1 month ago

    Red Deer, Canada Liberty Utilities Full time

    PurposeThe mandate of the Energy Services (ES) team is to maximize the company's risk adjusted asset return by providing portfolio management (hedging/optimization) and market advisory services. The ES team consists of three pillars:Portfolio Management (Trading/Hedging)Client & Asset SupportMarket AnalyticsReporting to the leader of Market Analytics, the...

  • Csv Financial Analyst

    3 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...

  • Financial Analyst

    3 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

    3 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

    3 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**: -...

  • Systems Analyst

    2 months ago

    Red Deer, Canada Collicut Energy Full time

    Collicutt Energy Services Corp., a leading the industry in engine related service and manufacturing, is currently seeking a background in programming and database management. As a Systems Analyst, you will be responsible for creation and expected to work from our Red Deer Head Office 2-3 days per week and then remotely the remaining days. Angular, Visual...

  • Construction Cost Analyst

    4 weeks ago

    Red Deer, Canada Federated Co-operatives Limited Full time

    Are you detail-oriented with a practical approach? We are seeking a full-time Construction Cost Analyst to become a part of our dedicated team.Full-time: 40 hours/week. Eligible for benefits after a probationary period. Please ensure you have the necessary health coverage to participate in our benefits program.Availability requirements: Weekdays and weekends...

  • Police Criminal Intelligence Analyst

    3 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...

  • Production Information Coordinator

    3 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...

  • Database Analyst

    4 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...

  • Power Markets Data Engineer

    1 month ago

    Red Deer, Alberta, T0M, Red Deer region, Canada Liberty Utilities Full time

    PurposeThe mandate of the Energy Services (ES) team is to maximize the company's risk adjusted asset return by providing portfolio management (hedging/optimization) and market advisory services. The ES team consists of three pillars:Portfolio Management (Trading/Hedging)Client & Asset SupportMarket AnalyticsReporting to the leader of Market Analytics,...

  • Analytics Manager

    3 months ago

    Red Deer, Canada Roken solutions Full time

    We are looking for an **Analytics Manager** to organize our analytics function and manage our team of analysts. You will implement tools and strategies to translate raw data into valuable business insights. In this role, we expect you to have strong logical reasoning skills and business intelligence. The ability to communicate effectively is essential. If...