Share this Job

Business Intelligence Data Engineer - Remote 

 As a member of the Business Intelligence & Analytics team, the successful candidate will possess very strong technical and analytical skills to gather and analyze all forms of data in detail. You will support the cloud base enterprise data warehouse maintenance and modernization through your advanced knowledge of data orchestration, ingestion, and reporting. You will identify the business needs and requirements, assemble data sets through efficient data processing pipelines that balance speed and reliability. You will develop automated reporting solutions and deliver analytical results for the business across the company. You will be a key contributor who enables Aurora to make data driven decisions.


Join an enthusiastic team that always enjoys learning, working collaboratively, and solving complex business problems with data.


•    Maintain strong relationships with business stakeholders and work closely with Data Scientists, Analysts and Developers to ensure business needs are addressed.
•    Maintain cloud base enterprise data warehouse and data marts.
•    Automate reporting solutions and operationalize machine learning models.
•    Implement optimised pipelines to extract and merge data sets from multiple sources.
•    Perform data cleansing and transformation using advanced Azure tools.
•    Work with the team to deploy new cloud-based reporting and analytics tools.
•    Work side-by-side with the business SME’s, iterate the development in an agile fashion to build and test solutions with incremental changes.
•    Set up automated deployment processes.
•    Implement data process improvements such as optimizing data delivery and scalability.
•    Execute multiple tasks simultaneously while exhibiting professionalism to ensure an incredible stakeholder experience.
•    Very strong experience in database systems including data warehouses and multi-dimensional analytic solutions.
•    Deep understanding of cloud technologies and infrastructure for data retention and processing such as Microsoft Azure Data Lake, Functions, Data Factory and Databricks.
•    Proficiency in scripting and programming using R and/or Python, C#.
•    Strong experience with Microsoft Azure data ingestion. Demonstrated via hands-on project experience.
•    Outstanding skills in Microsoft full BI Stack in Azure environment. Excellent SQL development skills to write complex queries involving multiple tables and develop stored procedures, triggers, user defined functions.
•    Proficiency in Extracting, Transforming and Loading (ETL) data between data systems/ data warehouses. Experience in ETL change data capture methodologies and techniques, ETL data quality validation for mission critical data migrations.
•    Experience in managing and deploying code to cloud services, including Azure DevOps experience.
•    Working knowledge of Linux, Visual Studio.
•    Hand on experience with deployment and monitoring of machine learning models.
•    Hand on experience with Microsoft Power Suite – Power Apps and Power BI.
•    Knowledge in statistics and data mining.
•    Strong Agile project execution experience with proven ability to prioritize and manage time.
•    Display teamwork and integrity with excellent interpersonal skills and the ability to interact with internal and external stakeholders, and directly influence them in a positive and effective manner.
•    Ability to work independently and in a cross-functional team environment and be comfortable in a dynamic, high growth environment.
•    Excellent organizational skills and attention to detail with ability to meet tight deadlines.


We would like to thank all applicants for their interest but only those selected for an interview will be contacted.


If applicable, Aurora Human Resources will contact you via your email address provided. We do not contact candidates over Facebook or other Social Media apps. You will never be requested to provide confidential information such as banking information or your Social Insurance Number in the interview process.


Aurora is an equal opportunity employer. At Aurora, we are committed to do business inclusively and accommodate applicants with disabilities. If you require accommodation (including, but not limited to, an accessible interview site, alternate format of job posting) during the recruitment and selection process, please let our Recruitment team know.

Job Segment: Database, Business Intelligence, Warehouse, Social Media, Engineer, Technology, Manufacturing, Marketing, Engineering