Data Analytics Developer

Johnston Group Inc.

Winnipeg

Hybrid

CAD 75,000 - 110,000

Full time

1 hour ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Johnston Group is seeking a Data Analytics Developer to design efficient ETL/ELT workflows using Airflow, Python, and dbt. You will create insightful reports and dashboards with Power BI and contribute to data modeling and SQL optimization.

This role offers a hybrid work model based in Winnipeg, MB with three days in the office per week. You will work closely with stakeholders to deliver reliable data solutions and documentation supporting business analytics initiatives.

Qualifications

  • Bachelor’s degree or diploma in Computer Science, IT, or related field.
  • Experience with SQL, relational databases (e.g., DB2 for IBM i, Postgres), stored procedures, dbt, and RESTful APIs.
  • 2 to 6 years of experience as a Developer or similar role.
  • Demonstrated experience with Airflow, Python, and dimensional data modeling.

Responsibilities

  • Design, develop, maintain, and optimize data integration and transformation processes that support reporting, analytics, and business operations.
  • Create, enhance, and troubleshoot data pipelines to ensure the accurate, timely, and reliable movement of data across enterprise systems.
  • Write, test, and optimize SQL queries, data models, and reports to support business intelligence and analytics requirements.
  • Collaborate with business stakeholders, developers, analysts, and technical teams to gather requirements and implement data solutions.
  • Deploy, monitor, and support data solutions in testing and production environments while following established development and change management practices.
  • Investigate, diagnose, and resolve data quality, performance, and system issues to minimize disruptions and ensure data integrity.
  • Monitor and maintain the performance, availability, and efficiency of data repositories and analytics platforms.
  • Participate in the planning, testing, implementation, and ongoing support of data and analytics initiatives.
  • Prepare and maintain technical documentation, including system designs, processes, procedures, and support materials.
  • Recommend and implement process improvements, automation opportunities, and technical enhancements that increase operational efficiency and scalability.
  • Stay current with emerging data technologies, industry trends, and best practices, applying new knowledge to improve solutions and processes.
  • Provide technical guidance, knowledge sharing, and support to team members and business users.

Skills

SQL
Python
Airflow
dbt
RESTful APIs
Dimensional data modeling
Excel
Git
Power BI

Education

Bachelor’s degree in Computer Science/Information Technology

Tools

Airflow
dbt
Power BI
Git
PostgreSQL
DB2 for IBMi

Job description

Johnston Group provides employee benefit solutions to over 30,000 companies, ranging from one employee to thousands across various product lines, including Chambers of Commerce Group Insurance Plan, Canada’s #1 employee benefits plan for small businesses. JG is a platinum member of Canada’s Best Managed Companies and was named one of Manitoba’sTop Employers. We support a positive work atmosphere where we value the diversity in the people we serve and are looking for talent who will contribute to our diverse and inclusive workplace; where individual differences are recognized, appreciated, and respected. JG believes in giving back and contributes significantly to local health, arts, sports, and other community organizations.

The Data Analytics Developer designs efficient ETL/ELT workflows using tools like Airflow, Python, and dbt. They create insightful reports and dashboards using tools like Power BI and are comfortable learning new BI tools. Working within the guidelines set by team leaders, they independently tackle well-scoped problems and begin to demonstrate growth in handling features and projects with a broad system or scope in areas such as database management, SQL, and data modeling. They ensure data sources are available, performant, secure, and meet business requirements, all while completing tasks in a timely manner.

*Hybrid working model based out of our Winnipeg, MB office, with three daysin-office per week.

Key Responsibilities
  • Design, develop, maintain, and optimize data integration and data transformation processes that support reporting, analytics, and business operations.
  • Create, enhance, and troubleshoot data pipelines to ensure the accurate, timely, and reliable movement of data across enterprise systems.
  • Write, test, and optimize SQL queries, data models, and reports to support business intelligence and analytics requirements.
  • Collaborate with business stakeholders, developers, analysts, and technical teams to gather requirements and implement data solutions.
  • Deploy, monitor, and support data solutions in testing and production environments while following established development and change management practices.
  • Investigate, diagnose, and resolve data quality, performance, and system issues to minimize disruptions and ensure data integrity.
  • Monitor and maintain the performance, availability, and efficiency of data repositories and analytics platforms.
  • Participate in the planning, testing, implementation, and ongoing support of data and analytics initiatives.
  • Prepare and maintain technical documentation, including system designs, processes, procedures, and support materials.
  • Recommend and implement process improvements, automation opportunities, and technical enhancements that increase operational efficiency and scalability.
  • Stay current with emerging data technologies, industry trends, and best practices, applying new knowledge to improve solutions and processes.
  • Provide technical guidance, knowledge sharing, and support to team members and business users.
Qualifications
  • Bachelor’s degree or diploma in Computer Science, Information Technology, or related field.
  • Training and experience working with SQL, relational databases (e.g., DB2 for IBMi, Postgres), stored procedures, dbt, and RESTful APIs.
  • Minimum 2 to 6 years of experience working as a Developer or similar role
  • Demonstrable experience with:
    • Orchestration tools such as Airflow.
    • Scripting languages such as Python.
    • Dimensional data modeling.
  • Strong proficiency in Excel for data analysis and reporting purposes.
  • Ability to understand and create solutions to business and technical requirements.
  • Ability to clearly communicate with managers, teammates and business stakeholders about technical and non-technical subject matter
  • Professional experience writing SQL.
  • Professional experience in Git.

The successful candidate must be legally eligible to work in Canada. We thank all applicants for their interest. Please note that only those selected for an interview will be contacted.

JG welcomes the opportunity to provide accommodation throughout the selection process. Please contact us to discuss your requirements by email at human.resources@johnstongroup.ca or by phone at 204-786-0421.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Market Services Representative & Reporting Analyst
Market Services Representative & Reporting Analyst

Johnston Group Inc. • Winnipeg

Hybrid
CAD 65,000 - 85,000
Senior IBMi Application Developer
Senior IBMi Application Developer

Johnston Group Inc. • Winnipeg

Hybrid
CAD 85,000 - 105,000
Technical Sales Enablement Coordinator (CRM Administrator)
Technical Sales Enablement Coordinator (CRM Administrator)

Johnston Group Inc. • Winnipeg

Hybrid
CAD 65,000 - 90,000
Bilingual Ratings Coordinator
Bilingual Ratings Coordinator

Johnston Group Inc. • Winnipeg

Hybrid
CAD 42,000 - 62,000
Group Marketing Renewal Analyst
Group Marketing Renewal Analyst

Johnston Group Inc. • Winnipeg

Hybrid
CAD 65,000 - 85,000
Accommodation during selection process
Hybrid work model (Winnipeg office)
Bilingual Risk Assessment and Reporting Analyst
Bilingual Risk Assessment and Reporting Analyst

Johnston Group Inc. • Winnipeg

Hybrid
CAD 52,000 - 76,000
Team Lead, Technical Services
Team Lead, Technical Services

Johnston Group • Winnipeg

On-site
CAD 90,000 - 120,000
Senior Data Engineer
Senior Data Engineer

Bridgenext • Toronto

Hybrid
CAD 120,000 - 180,000
Data & Analytics lead
Data & Analytics lead

Altis • Markham

Hybrid
CAD 100,000 - 125,000
Data Operations & Solutions Analyst
Data Operations & Solutions Analyst

Canaccord Genuity Group Inc. • Toronto

On-site
CAD 100,000 - 110,000