Systems Analyst, System Integrations

Highlights of the job

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

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:

- 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
- 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
- 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
- Demonstrated capability to design, develop and unit test IS solutions using one or more common programming languages
- 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
- 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**

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 fo