Build scalable business intelligence and analytics solutions for manufacturing, engineering, and business operations. Responsibilities include designing Snowflake data models, developing Matillion ETL/ELT pipelines, integrating SAP data, optimizing SQL, creating Power BI and Tableau dashboards, and supporting AWS-based data services. The role collaborates with stakeholders to define KPIs and requirements, uses Agile Scrum tools and practices, and maintains ASP.NET applications supporting data integration and reporting.
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.
AT A GLANCE
RoleBI Developer & Data Analyst (Contract)Openings2LocationLachine (Montreal), QuebecPosition TypeFull time contract, 6 months, extendableScheduleOn site 3 days a week, remote 2 days a weekCompensationCompetitive, based on experienceExperienceMinimum 3 years full time in Business Intelligence, Data Engineering or Analytics EngineeringCore StackSQL, Snowflake, Matillion, AWS, Power BI, Tableau, SAP ECC or S/4HANA, ASP.NETELIGIBILITY REQUIREMENT
- 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
THE ROLE
You design and build scalable analytics that support manufacturing, engineering and business operations. You develop Snowflake data models, build pipelines in Matillion, integrate SAP data sources, and deliver business-critical dashboards in Power BI. The job takes strong SQL, time with business stakeholders, and the ability to turn complex operational data into insight people can act on.WHAT YOU'LL DO
- 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
REQUIRED QUALIFICATIONS
- 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
PREFERRED QUALIFICATIONS
- 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
APPLY
Submit your resume and a cover letter detailing your relevant experience with Snowflake, Matillion, SQL and SAP data. Qualified candidates will be contacted quickly.
Similar Jobs
Cloud • Security • Software • Cybersecurity • Automation
Lead the SSCS Add-On engineering team to develop security capabilities, managing delivery, team growth, and quality in a collaborative environment.
Top Skills:
Ci/CdDevsecopsSigstoreSlsa
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Manage end-to-end deployment and adoption of Samsara’s IoT solutions for mid-market customers. Create launch plans, track implementation progress and account health, deliver training and product demonstrations, define business outcomes and KPIs, and resolve challenges while coordinating with Sales, Support, Sales Engineering, Product, executives, and end users.
Top Skills:
Ai ToolsAutomationCloud SoftwareControl SystemsIotNetworkingPythonRestful ApisTelematics
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Owns US engagement and growth strategy for Afterpay, Cash App commerce, and lending products. Leads lifecycle marketing, cross-sell, incentives, experimentation, product launches, and AI-enabled automation. Partners cross-functionally with Product, Analytics, Martech, Creative, Brand, and business leadership; sizes opportunities, builds impact models, sets multi-quarter roadmaps, and optimizes for active customers and gross profit.
Top Skills:
BrazeClaude CodeGooseHightouchIterableSalesforce Marketing CloudSQL
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal



