Systems Analyst, Data Analytics

We are hiring two (2) full time, permanent Systems Analyst, Data Analytics position working out of Edmonton, AB.

The Systems Analyst position is accountable for data analytics program support, application maintenance, process improvement, governance development and maintenance, and documentation. This role is responsible for providing exceptional customer support for operational and capital project data analytics requests, implementing, and enforcing data governance, keeping up to date on data analytics trends, and performing system enhancements.

This position may be eligible for EPCOR’s hybrid work program.
What you’d be responsible for

Reporting to the Manager, GIS, ADMS & Data Analytics, you would be accountable for but not limited to:

• Providing input to EPCOR’s Data Analytics plans and directions as requested ensuring on-going relationships with other positions
• Analyzing internal and external technology changes including:
  • Monitoring and identifying the impact of recent and upcoming changes to data sources, technologies, and product offerings that may impact the supported cloud applications and integrations
  • Contributing to the on-going development of EPCOR’s data governance maturity
• Ensuring the delivery of optimal results against appropriate performance metrics:
  • Delivery on Change Request estimates
  • Incident Delivery and Responsiveness
  • Customer Satisfaction Surveys
  • System Availability
  • Knowledge Management KPI’s
• Applying data modeling and analysis techniques to meet integration and performance expectations
• Supporting the data analytics technical stack (Azure Data Factory, Databricks, lakeFS, Azure resources, custom Python libraries, Snowflake, and Power BI)
• Supporting the data analytics platform and data scientists ie. Data ingestion, transformation and presentation, custom monitoring, performance considerations, environment setups (configure new data source connections, source schema changes, cluster/warehouse configuration, access control), cost management, ensuring data quality
• Providing technical assistance in troubleshooting. Utilizing open communication and problem-solving skills to identify defects and resolve issues efficiently and effectively within expected timeframes. Includes:
  • Sharing domain and technical expertise
  • Providing technical mentorship and cross-training peers and team members
  • Assisting with problem resolution
  • Recommending improvements
• Maintaining middleware using Oracle Fusion Middleware Suite 12c, which includes monitoring performance, server restarts, data source configurations, deployments, and some development
• Concisely communicating and resolving issues and incidents within expected timeframes
• Abiding by departmental policies and processes for the purpose of consistent support and administrative practices throughout Application Services
• Providing valuable contributions to documentation and knowledge bases to allow for the long-term sustainability of EPCOR IS
• Providing expert advice and collaborating with other members of Application Services to allow for the creation and maintenance of dependable, efficient, and quality application solutions
• Executing daily job duties with a focus on continuous improvement of processes and systems
• Reacting to system availability issues with the required urgency
• Conducting root cause analysis on issues to proactively prevent them in the future

• Degree in Computer Science or Diploma in Computer Engineering, System Technology or Management Information Systems (or equivalent)
• 4 years of directly related experience with large, complex, mission critical applications with multiple interfaces

• Candidates possessing less than the required years of experience may be considered for a developmental position

• Demonstrated intermediate ability in SQL and python
• Knowledge of other object-oriented languages such as Java and C#
• Experience with Azure or other cloud platforms/services
• Working knowledge of Azure Data Factory and Databricks
• Ability to maintain middleware - General familiarity with Linux OS including running linux scripts, running java based programs, finding and killing processes, searching logs etc.
• Demonstrated ability in troubleshooting and performance tuning
• Strong work ethic and critical thinking skills, ensuring success in a highly visible area of IS
• Ability to continually adapt to changing technology and business requirements
• Ability to develop lasting relationships and provide exceptional, high quality customer service to all levels of the organization and external clients
• Knowledge of the following is highly desirable:
  • Microsoft Certification: Azure Data Engineer Associate
  • Distributed computing and ETL processing with Spark
  • Power BI or other data visualization tool
  • Experience with agile software development using Azure DevOps to manage backlogs, workboards, system artifacts, test suits, code repositories, and deploy changes via CICD pipelines
  • Dimensional data modelling

Jurisdiction: CSU52

Class: IT2

Wage: Starting at $53.05 per hour, developmental (IT1) starting at $48.58 per hour. (Wage placement will be determined at the time of selection and is based on a combination of factors as outlined in the Collective Agreement)

Hours of work: 75 hours biweekly

Application deadline: June 12, 2024

Internal Applicants: please ensure that you are using your “@epcor.com” email address.

Learn more about Working at EPCOR!

Follow us on LinkedIn, Twitter, Glassdoor or Facebook!

Please note the following information:

• A requirement of working for EPCOR is that you are at least 18 years of age, successfully attained a high school diploma (GED, or equivalent level of secondary education) and legally entitled to work in Canada. (A copy of a valid work permit may be required.)
• If you are considered for the position, clearance on all applicable background checks (which may include criminal, identity, educational, and/or credit) and professional reference checks is required. Some EPCOR positions require an enhanced level of background assessment, which is dictated by law. These positions require advanced criminal record checks that must also be conducted from time to time after commencement of employment.
• A technical/practical assessment may be administered during the selection process and this exercise will be used as a part of the selection criterion.
• To meet the physical demands required of some positions, candidates must be in good physical condition and willing to work in all weather conditions. Clearance on pre-placement medical and drug and alcohol testing may be required.

 
Follow us on LinkedIn, Twitter or Facebook!