Junior Data Analyst Jobs

OnX is looking to engage a Junior Data Analyst on contract with one of our Utility clients in Calgary Alberta.

Client: Energy & Utility

Location: Calgary, Alberta

Duration: 6 months

Job Responsibilities/ Description:

• Assist in the triage of code and data issues

• Perform ad-hoc analysis to trouble-shoot data-related issues.

• Find and research problems for the data owners and review data quality thoroughly, by record and case.

• Assist in the design, and maintenance of the corporate relational databases and data solutions.

• Creating and maintaining operational support documentation and adding to the team knowledge base

• Performing various database related tasks, including SQL database queries and scripts

• Provide mapping, and support documentation for the existing data model, and any changes to the data models.

• Participate in meetings, reviews, and other discussions as required

• Consulting and collaborating with people to identify technical errors and requirements for resolution

• Identifying continuous improvement opportunities and willingness to work on implementing them

Skills – REQUIRED:

• Experience using SQL and T-SQL in a Microsoft SQL Server production environment.

• Understanding of data analysis, data migration, data modeling, and data architecture.

• Experience with Data Modelling and database scripting to build and extend databases required by transactional systems.

• Experience with industry standard data models and data warehouse methodologies and design.

• Background or knowledge of oil and gas upstream activities or the regulatory work associated with these activities (industry experience)

• Understanding of Agile methodologies (Scrum, Kanban) with previous practical experience in an agile/scrum project environment

• Strong writing skills and process documentation skills

• Strong analytical thinking and troubleshooting abilities

• Customer-service oriented, evidenced by a solution-focused, pro-active, self-starter mindset

• Friendly and outgoing with a positive and cooperative attitude

• Able to successfully work independently and as part of a team in a fast-paced and high pressure environment, with ability to multi-task

• Able to identify problems, creatively think of solutions, and decide on the best course of action regarding the situation.

• Experience and understanding of a variety of technologies and software, and the aptitude to expand their knowledge base as required.

• Ability to escalate a problem if and when necessary

• Working on a support team and understanding the role(s) of each person on the support team

Skills – RECOMMENDED:

• Experience in programming (2+ years)

• Experience in coding and scripting skills (MS SQL, PowerShell, Python)

• Experience working with SQL databases and relational databases (MS-QL & MYSQL).

• Experience with continuous integration / continuous deployment tools such as Git

• Experience using Jira

• Familiarity with cloud environments (AWS, Azure)