Data Engineer – Power Bi Jobs in Montréal, Quebec

Underlying awareness of SQL Server, or any other Database Management system like Oracle or SAP

Experience gained or conceptual knowledge of Azure/ AWS Cloud architecture or any Cloud SaaS experience

Communication and senior stakeholder engagement skills, underpinned by an ability to communicate technical concepts to non-technical, senior business users with ease

Team-wide shift rotations to cover business needs, including “on-call” responsibilities and weekend work

Support experience delivering IT Application support or services

Excel skills with Power Query and Data Modelling

• Experience building automated reports and dashboards with the help of Power BI and other reporting tools

• Understand business requirements to set functional specifications for reporting applications

• Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

• Cloud environment experienced (Microsoft Azure), specifically with Databases

• English communication skills proficiently.

Power BI knowledge is must.

· Proficient in SQL and experience working with databases such as SQL Server, Oracle, and MySQL.

· Solid understanding of low-code development principles and experience building custom applications with Power Apps.

· Excellent verbal communication skills

Role: Senior Business Intelligence Developer / Power BI

· Perform data analysis, modeling, and profiling to identify data quality issues, anomalies, and trends.

· Utilize M development language to transform and shape data within Power BI and Azure Data Lakehouse.

Possess knowledge and experience in front to back Power BI solution architecture.

Experience in publishing contents to Power BI Service, setting up entitlements and rolling out contents to business users for production use.

Experience working in other Business Intelligence tools most importantly SAP BOXI version 4.x

Strong analytical and problem-solving skills

Experience in using Power BI against Snowflake in Azure, Hadoop Big Data platform and NoSQL databases

Certifications in one or more of Powe BI and Azure modules and SQL

Post-secondary education in Software Engineering, Computer Science, Information Technology, or other post-secondary education

Working knowledge implementing row-level security in Power BI

Strong working knowledge of data visualization options, including visualizations appropriate for leadership consumption

- Experience working with Stakeholders on a day to day basis to gather requirements

- Minimum 3 years of experience in Data Analyst

- Strong Experience with Power Query (Dax and M Language)

- Strong Experience with PowerBI creating dashboards and Power query

- Experience with Data Lake's and gathering data from two or more ERP

- Experience and understanding of Procurement Data

·Understand business requirements to set functional and technical specifications

·Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

·To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks.

·Build automated reports and dashboards with the help of Power BI and other reporting tools

·Be able to quickly shape data into reporting and analytics solutions

·To create dashboards and visual interactive reports using Power BI.

•Experience in data modeling and working with large datasets.

•Excellent analytical and problem-solving skills.

•Effective communication and presentation skills.

•Bachelor's degree in a related field such as data science, computer science, statistics, or a similar discipline.

•Strong proficiency in Amazon QuickSight or other data visualization tools.

•Proficiency in SQL and data querying languages.

Understand business requirements to set functional and technical specifications

Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

To understand business requirements in the BI context and design data models to convert raw data to meaningful insights.

To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks.

Build automated reports and dashboards with the help of Power BI and other reporting tools

Be able to quickly shape data into reporting and analytics solutions

· Consulting with data management teams to get a big-picture idea of the company’s data storage needs.

· 5+ years - Enterprise Data Management

· Translates data access, transformation, and movement requirements into functional requirements and mapping designs.

· 4+ years with Data Warehouse Architecture, Snowflake experience preferred

· 5+ years Python coding experience

· PL/SQL Server development experience

Deploy reports and applications through the Power BI service, managing security and access requirements with

5+ years of experience in a Power BI developer or data analyst position:

Solid experience in data modeling on Power BI and DAX, M and SQL Server languages.

Experience in Microsoft Dynamics AX or Dynamics 365 (asset)

Experience with modern software development techniques and methodologies: DevOps, Agile, etc.

Ability to meet deadlines and multi-task. Ability to manage competing priorities in a complex environment.

Full project management and development life cycle experience

Minimum 3+ years of combined experience in data warehousing/business intelligence/analytics and reporting systems.

Strong knowledge of Fixed Income, Equity and Derivative businesses

Strong ability to analyze user requirements, make recommendations and implement solutions

Strong oral and written communication skills

Strong presentation and interpersonal skills

Utilize business intelligence expertise, business knowledge and technical skills to successfully deliver solutions that help solve business challenges.

3+ years of knowledge and experience using database systems, SQL, and ETL tools, especially Pentaho, HPE Vertica and Amazon Redshift.

Experience working in a team-oriented, collaborative, and remote environment.

Professional experience using managed cloud services (AWS)

Define key metrics thoroughly understanding data streams; act as a subject matter expert and manage through obstacles to achieve program objectives

Analyze, design, and test BI front-end deployment and back-end ETL processes according to user requirements.

Location - Toronto, Canada (100% Remote)

Need to have team lead experience

Good to have Skills: Azure Analysis Services, Oracle DB, AWS Glue, Alteryx

Should have experience working in Onshore, nearshore and Offshore setup

Good interpersonal skills to function in a team environment.

Sr. Lead Power BI Developer

Créer et fournir des rapports et des informations pertinentes afin d’optimiser les décisions d’affaires;

Développer des interfaces et automatiser certaines tâches par la création d’outils d’automatisation;

Résoudre l’ensemble des problèmes et demandes liés à l’intelligence d’affaires;

Soutenir et former les utilisateurs à l’utilisation des outils d’intelligence d’affaires;

Forte capacité de synthétiser, modéliser et interpréter les informations;

Expérience avec des outils de visualisation de données (ex. tableau croisé).

· Understand business requirements to set functional and technical specifications

· Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

Role: Power BI (Data Services)

· Build automated reports and dashboards with the help of Power BI and other reporting tools

· Be able to quickly shape data into reporting and analytics solutions

· To create dashboards and visual interactive reports using Power BI.

Proficient in business and analytical skills and capable of comprehending business requirements

Certification in Tableau, Snowflake, or Data Engineering tools is also a plus

Capable of generating reports using various data sources and can uncover trends and insights beyond the data

Familiarity with the Cisco data landscape and Cisco technology and sales terminology is a big plus

Breadth of technical experience and knowledge across the Azure Data Platform, with depth Domain

Experience. 5+ years solving sophisticated technical data projects using the Microsoft Azure data stack is required

Relationship Building. A proven track record of building deep technical relationships. Experience in setting expectations across various partners.

-Excellent written, verbal, and presentation skills targeted at all levels of the organization

Teamwork. Motivated and keen to work in a collaborative environment with a focus on team success over and above individual success.

Expertise in two or more of the following Data Platform resources is required:

The candidate should have experience in creating dataflows using Azure Data Factory and familiarity with the Medallion Architecture is highly desirable

Experience. 5+ years solving sophisticated technical data projects using the Microsoft Azure data stack is required

Relationship Building. A proven track record of building deep technical relationships. Experience in setting expectations across various partners.

Excellent written, verbal, and presentation skills targeted at all levels of the organization

Designing and building interactive insightful data products using Power BI, ML and Azure

Developing and monitoring Azure data pipelines, Power BI Premium Dataflows to gather, transform and democratize structured and unstructured data assets

·10+ years of progressive experience in Data Engineering & Business Intelligence, ideally within consulting environment

·5+ years of experience in designing, architecture and implementing large scale BI projects within the cloud environment.

·Proven experience with building dimensional/semantic data models using SSAS or Azure Analysis Services or Power BI Premium

·Experience with Python and Spark would be a nice to have.

·Experience building data pipelines using Azure Data Factory and Azure Data-bricks would be nice to have.

·Experience with real-time data processing (using Kafka/Event Hubs) would be nice to have