Systems Analyst, System Integrations

Business Operations / IT Edmonton, Alberta


Description

Highlights of the job

We are hiring one (1) full time, permanent Systems Analyst, System Integrations position working out of Edmonton, AB.

The Systems Analyst position is accountable for system integration program support and data analytics 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 system integration requests, implementing, and integration security, enforcing data governance, keeping up to date on data analytics trends and performing system enhancements.

What you’d be responsible for

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

  • Providing input to EPCOR’s system integration and data analytics plans and directions as requested and ensures 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 / analysis techniques to meet integration and performance expectations
    • Supporting the system integration technical stack (Oracle SOA/OSB/ODI architecture/toolset)
    • 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. Ingestion/transformation/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
  • Concisely communicating and resolving issues and incidents within expected timeframes
  • Abiding by all Application Services departmental policies and processes for the purpose of consistent support and administrative practices throughout Application Services
  • Providing valuable contributions to documentation and knowledge base 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

What’s required to be successful

  • Degree in Computer Science or Diploma in Computer Engineering, System Technology or Management Information Systems (or equivalent) is required
  • 4+ years of directly related experience with IS applications, including experience with large, complex and mission critical applications with multiple interfaces
    • Candidates possessing less than the required years of experience may be considered for a developmental position
  • Demonstrated capability to design, develop and unit test IS solutions using one or more common programming languages
  • Technical proficiency in the technology stack and an excellent understanding of business process and requirements for applications
  • Demonstrated ability in SQL and python; knowledge of other object-oriented languages such as Java and C# are desirable
  • Knowledge of the following:
    • Oracle SOA/OSB
    • Weblogic Server Admin and Install (including patching)
    • General Linux capabilities - installing, searching, troubleshooting
    • SOAP/REST Services
    • XML transformation - XSLT
    • Json and Json transformation
    • Middleware Testing tools - SoapUI and Postman
  • Experience with Azure or other cloud platforms/services
  • Working knowledge of Azure Data Factory and Databricks
  • Demonstrated ability in process troubleshooting and performance tuning
  • Knowledge of the following would be 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
    • Azure Data Factory, Functions, LogicApps, API Manager, Event Grid/EventHub/ServiceBus
  • React with urgency to troubleshoot critical issues related to application availability
  • 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

Other important facts about this job

Jurisdiction: CSU52

Class: IT2

Wage: IT2 starting at $53.05 per hour; developmental (IT1) starting at $48.58 per hour (Final Wage and Step will be determined at the time of selection and are based on a combination of factors as outlined in the Collective Agreement.)

Hours of work: 75 hours biweekly

 

Application deadline: November 7, 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.