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.