Description du poste
**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 techn