BI Developer & Data Analyst Contractor

Job Title: BI Developer & Data Analyst Contractor

Period 6 months with possibility for extension

Work Location: Lachine CAN H8T 3H1

Job Description: We are seeking for 2 experienced BI Developer & Data Engineer Contractor to design and implement scalable analytics solutions supporting manufacturing, engineering, and business operations. The successful candidate will develop Snowflake-based data models, build data pipelines using Matillion, integrate SAP data sources, and deliver business-critical dashboards using Power BI. This role requires strong SQL expertise, business engagement skills, and the ability to translate complex operational data into actionable insights.

Key Responsibilities:

• Design dimensional and analytical data models using star and snowflake schemas, and build scalable, reliable data pipelines to support analytics and business intelligence initiatives.
• Develop and optimize advanced SQL queries, views, stored procedures, and data models in Snowflake using Matillion for reporting and analytics solutions.
• Utilize AWS cloud services for data storage, computation, SQS queues, SNS notifications, and Lambda functions.
• Create and maintain interactive dashboards and reports in Tableau and PowerBI to provide actionable insights.
• Model complex SAP transactional data in Snowflake to enable advanced analytics, reporting, and cross-functional business insights.
• Collaborate with business stakeholders to gather reporting requirements, define KPIs, and translate business needs into technical solutions.
• Use Jira and Confluence within an Agile Scrum framework to manage sprint planning, backlog grooming, task tracking, and technical documentation, ensuring efficient project delivery and team collaboration.
• Develop and maintain applications using ASP.NET to support data integration and reporting needs.
• Support Rebranding efforts

Qualifications:

• Minimum 3 years full time work experience in Business Intelligence, Data Engineering, 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 PowerBI.
• Excellent collaboration and communication skills, with experience working in Agile Scrum environments.
• Hands-on experience analyzing and modeling SAP ECC or S/4HANA data structures, with the ability to transform transactional SAP data into business-friendly analytical models.
• Experience with ASP.NET or web application development.
• Knowledge of Machine Learning and LLM models would be preferrable for the long-term

Preferred Skills

• Snowflake certification
• AWS analytics services
• Power BI Data Modeling (DAX)
• Tableau
• SAP ECC or S/4HANA
• Python for automation and data processing
• Git version control
• Experience in manufacturing or energy industries
• Experience working with Agile Scrum teams

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.

Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https://dexian.com/.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.