Bi Data Engineer With Azure Data Engineering Experience | Toronto | Hybrid

We are looking for a BI Data Engineer with Azure Data Engineering experience to join our team. As a key member of the Enterprise Data and Advanced Analytics team, this role is instrumental in enhancing data & analytics capabilities by championing industry best practices and delivering high quality reports and training to enhance business decision making. They help translate complex solutions to digestible business-centric outcomes and will do so by building interactive data visualizations using Power BI and sophisticated data models.

They will work with business-unit leaders to identify and prioritize problems that analytics is suited to solve and help identify the data (internal or external) needed to produce the most useful insights. In addition to being responsible for end-to-end solutions that business users can execute on, they also work towards driving adoption among business users. The individual will support and collaborate with data engineers, data scientists and business users and engage in technical support, research and knowledge sharing through the implementation lifecycle of projects and solutions. The ideal candidate is one that strives to evolve through their career and transition into a data scientist role in the near future by taking advantage of the tremendous learning and collaboration opportunity this role provides.

Key Responsibilities

• Designing and developing ETL pipelines to achieve a high level of reliability, scalability, and security. Sourcing, transforming, and delivering structured and unstructured assets for use in Azure Synapse Analytics, Azure Data Factory, SQL Server, Azure Data Lake
• Knowledge of Postman, the candidate should be able to effectively design, test, and debug APIs, ensuring their functionality and reliability within our software ecosystem
• Identifying, defining, and implementing opportunities for enhancing existing processes
• The ideal candidate will possess strong communication and leadership skills to guide and support the team in adopting and implementing industry-leading data engineering practices
• Managing change and communicating impacts to stakeholders and fellow team members
• Operating in an Agile development environment
• The candidate should be well-versed in the concepts and techniques of the Kimball Methodology, which emphasizes building data warehouses that are optimized for business intelligence and reporting. Proficiency in dimensional modeling, including the creation of star schemas and snowflake schemas, is essential
• Deploying ETL pipelines to achieve a high level of reliability, scalability, and security.
• The candidate should have a strong command of Pyspark, a Python library for distributed data processing and analysis
• Designing and building interactive insightful data products using Power BI, ML and Azure
• The candidate should have experience in creating dataflows using Azure Data Factory and familiarity with the Medallion Architecture is highly desirable
• The ideal candidate will have the ability to document technical specifications, workflows, and guidelines, ensuring clear and concise communication across the team and stakeholders
• Developing and monitoring Azure data pipelines, Power BI Premium Dataflows to gather, transform and democratize structured and unstructured data assets
• Defining and implementing technical test plans and perform unit and integration testing
• Leading multiple projects simultaneously and ensuring on-time delivery

Qualifications

• Industry Knowledge. The ability to quickly propose Azure Data Platform solutions by recalling the latest standard processes learned from MVP & Product Team articles, MSFT documentation, whitepapers, and community publications is required
• Breadth of technical experience and knowledge across the Azure Data Platform, with depth Domain Expertise in two or more of the following Data Platform resources is required:
• Azure Synapse & Azure Data Factory
• Excellent written, verbal, and presentation skills targeted at all levels of the organization
• Relationship Building. A proven track record of building deep technical relationships. Experience in setting expectations across various partners.
• Problem-Solving. Must be able to trace data lineage / workflows and resolve technical issues with minimal supervision. Demonstrated proficiency in understanding and implementing business workflows is a plus.
• SQL Server Data Tools
• Azure Machine Learning
• Azure Databricks using PySpark
• Experience. 5+ years solving sophisticated technical data projects using the Microsoft Azure data stack is required
• Teamwork. Motivated and keen to work in a collaborative environment with a focus on team success over and above individual success.

Alybyte Inc. is an independent firm providing business and technical service to the United States and Canada customers. We specialize in the design, procurement and delivery of digital services and associated business change activities.

Our technical services focus on ensuring that our customers make best use of emerging information and communications technologies in achieving their business objectives. We combine our strong technical expertise with an excellent understanding of process transformation to harness technology to create solutions that deliver substantial business benefits to our clients.

Our business services combine knowledge of best practice in transformational and process change with 'real world' experience of project delivery to manage and deliver the practical outcomes required to ensure benefits realization.