BI Developer & Data Analyst
At a glance
Mid-level Data Analysis & BI role at Grizzlytrek Group. Montreal · contract.
Pay not stated Data Analyst salary
dataroles summary, based on the employer's posting.
What you'll do
- Shape star and snowflake schemas in Snowflake, then build dependable Matillion pipelines for analytics
- Develop and improve advanced SQL queries, views, stored procedures and Snowflake data models
- Apply AWS storage, compute, SQS, SNS and Lambda services to data and pipeline tasks
- Build Tableau and Power BI dashboards, translating SAP transactions into useful analytical models
- Gather stakeholder reporting needs, define KPIs and turn them into technical work, including ASP.NET applications
What you bring
- At least three years of full-time work in business intelligence, data engineering or analytics engineering
- Expert SQL ability, including evidence of tuning complex analytical queries, and substantial Snowflake warehousing experience
- Hands-on AWS cloud and data pipeline skills, plus experience with Matillion ETL or ELT processes
- Experience interpreting SAP ECC or S/4HANA data and shaping it into business-ready analytical models
Who this fits
This mid-level contract suits someone who can build BI data systems and work with business stakeholders. The six-month engagement may be extended and follows a split schedule: three days on site in Lachine and two remotely. You must meet Canadian eligibility rules for handling controlled goods, technical information and related systems.
From the employer
BI DEVELOPER & DATA ANALYST (CONTRACT) | LACHINE, QC
Lachine (Montreal), Quebec | 6 Month Contract, Extendable | 2 Openings
Hiring now.
A global energy sector organization is hiring two BI Developer & Data Analyst contractors for its digitalization team in Lachine, Quebec. If you write expert-level SQL and have built on Snowflake, Matillion, AWS and Power BI with SAP data underneath, we want to hear from you.
- Must be eligible to access and work with Canadian Export-Controlled Goods, technical data and related systems, in accordance with applicable Canadian regulations and company policies
- Design dimensional and analytical data models using star and snowflake schemas
- Build scalable, reliable data pipelines to support analytics and business intelligence work
- Develop and optimize advanced SQL queries, views, stored procedures and data models in Snowflake using Matillion
- Use AWS cloud services for data storage, computation, SQS queues, SNS notifications and Lambda functions
- Create and maintain interactive dashboards and reports in Tableau and Power BI
- Model complex SAP transactional data in Snowflake for advanced analytics, reporting and cross-functional business insight
- Work with business stakeholders to gather reporting requirements, define KPIs and turn business needs into technical builds
- Use Jira and Confluence within an Agile Scrum framework for sprint planning, backlog grooming, task tracking and technical documentation
- Develop and maintain ASP.NET applications that support data integration and reporting
- Support corporate rebranding work
- Minimum 3 years of full time work experience in Business Intelligence, Data Engineering or Analytics Engineering
- Expert-level SQL development skills with a proven track record of optimizing complex analytical queries
- Strong experience with Snowflake data warehousing
- Proficiency in AWS cloud services and data pipeline development
- Experience with ETL/ELT processes and tools, specifically Matillion
- Familiarity with data visualization tools such as Tableau and Power BI
- Hands-on experience analyzing and modeling SAP ECC or S/4HANA data structures, and turning transactional SAP data into business-friendly analytical models
- Experience with ASP.NET or web application development
- Excellent collaboration and communication skills, with experience in Agile Scrum environments
- Snowflake certification
- AWS analytics services
- Power BI data modeling (DAX)
- Tableau
- Python for automation and data processing
- Git version control
- Experience in manufacturing or energy industries
- Knowledge of Machine Learning and LLM models, for the long term
Submit your resume and a cover letter detailing your relevant experience with Snowflake, Matillion, SQL and SAP data. Qualified candidates will be contacted quickly.