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’s Top 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 days in-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 developing ETL/ELT processes.
- 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.