Senior BI / Data Engineer

Vantix Systems Inc.; Edmonton; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company is seeking a Data Analyst to support analytics initiatives and enhance the Data Management Program. The position involves delivering data-driven solutions, working with various analytical models, and ensuring high-quality data management practices. Candidates must have strong proficiency in Python or R and be adept with data architecture and visualization tools. This role requires a blend of independent work and collaboration in a fast-paced environment.

Qualifications

• Very strong proficiency in Python and/or R required.
• Knowledge of analytics standards and best practices essential.
• Experience using business intelligence tools and performing various analysis types.

Responsibilities

• Build full-function dashboards and solutions leveraging technology.
• Collect and process data for business intelligence and analytics.
• Document all data pipelines and transformations created.

Skills

Python

Data Architecture

Problem Solving

Analytical Skills

Data Wrangling

Business Intelligence

Statistical Analysis

Feature Engineering

Text Analysis

Agile Methodologies

Teamwork

Tools

Power BI

Hadoop

Team Foundation Server

Job description

Our client is seeking contracting services for a Data Analyst to support the analytics initiatives prioritized by the BISC for 2024 and supplement other work required on the Data Management Program (DMP).

The scope of the work will include (but is not limited to):

1. Understand the business requirements to devise a technical solution that aligns with the business's objectives.
2. Understand the nuances of the data and its relationships to build reputable results.
3. Leverage the technology to build full-function, easy-to-use dashboards and solutions.
4. Collect, transform, and store data required for business intelligence and analytics (including internal and external data sources).
5. Build, test, and maintain database pipeline architectures.
6. Streamline data collection methods to create automated and easy-to-use routines.
7. Perform cleansing, processing, and validating the data to be analyzed to ensure its quality.
8. Explore and visualize data using Python and business intelligence tools.
9. Document all data pipelines and transformations created.
10. Follow standards for data analysis at APS to promote maintainability and testability. Recommend improvements to practices where appropriate.

MUST reside in Alberta.

• Very strong proficiency in Python and/or R.
• Very strong proficiency with data architecture and best practices.
• Strong problem-solving and analytical skills.
• Knowledge of statistics and experience using statistical packages for analyzing datasets.
• Data wrangling.
• Experience using business intelligence tools (e.g., Power BI, Incorta) and data frameworks (e.g., Hadoop).
• Understanding of analytical models and how to structure data for model usage.
• Experience doing feature engineering and topic modeling.
• Experience doing the following types of analysis: text analysis, comparative analysis, trend analysis, sentiment analysis.
• Excellent communication and presentation skills.
• Strong multi-tasking skills, with an ability to adapt to and manage changing priorities.
• Ability to work within a team environment or independently as needed.
• Ability to manage your time efficiently and work with little supervision.
• Ability to manage stress in an environment with high expectations, tight deadlines, and changing priorities.
• Understanding best practices, methods, and standards for business intelligence, analytics, and visualizations.
• Agile Methodologies.
• Team Foundation Server (TFS) - Code Management.