BDO Canada is a firm built on a foundation of positive relationships with their people and clients, and they are seeking a Data Analytics/ Data Engineer New Grad to join their client-facing team. The role involves engaging with clients to implement analytics solutions, designing industry-specific data models, and maintaining data management systems.
Responsibilities
- Play an integral role in our delivery practice as we execute on enterprise level client engagements through our various industry specializations
- Engage directly with clients and drive the implementation and successful end user experience of analytics solutions; execute on engagements and collaborate with the client and delivery team to ensure that any applicable milestones and deliverables are met on time and on budget
- Design and develop industry-specific data models for client projects in industries such as Natural Resources, Finance, Manufacturing and Distribution, and Retail
- Work with other engineers to enhance data models and improve data query efficiency; create complex data queries to facilitate ad hoc and exploratory analytics
- Build real-time data capture and transformation functionality across all products and build out technology stack for Business Intelligence and Data Warehouse
- Clean data: review for data inconsistencies and identify opportunities to improve data collection process; Wrangle/Munge data: transform or map data from one raw data form into another format with the intent of making it more appropriate and valuable for analytics
- Develop, construct, test and maintain architectures such as databases and large-scale data processing systems; design, construct, install, test and maintain highly scalable data management systems
- Employ a variety of languages and tools (e.g. scripting languages) to marry systems together
- Build or recommend data visualization tools and business intelligence tools such as interactive dashboards and automated reports, to enable leaders to make swift, fact-based decisions
- Remain up to date of development technologies, both current and future in order to deliver state-of-the-art Analytics solutions for our customers
Skills
- Post-secondary education in engineering or computer science or equivalent work experience
- Good experience working with Azure Databricks, Azure Data Factory and Azure Data Lake
- Programming experience in Python
- Strong attention to the quality of work delivered (attention to detail)
- Able to adapt quickly to changing client requirements
- Experience using the Apache Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala) to tackle 'big data' problems
- Knowledge of ETL, ELT, Lambda and Kappa data architectures
- Experience with the Microsoft SQL Server Analytics stack including: Core SQL, SSIS, SSRS, SSAS
- Experience working with SQL and NoSQL databases
- Knowledge of Continuous Integration and Source Control systems (e.g. Gradle, Maven, Bamboo, TeamCity, Git)
- Data Visualization experience in Power BI, Tableau, or similar
- Exposure to data science, machine learning or statistics
- Some experience using Docker
Benefits
- Flexible benefits from day one
- Market leading personal time off policy
- Reimbursement for wellness initiatives that fit your lifestyle
Company Overview
- BDO Canada is a consulting firm that provides auditing, outsourcing, taxation, assurance, and financial advisory services. It was founded in 1921, and is headquartered in Toronto, Ontario, CAN, with a workforce of 1001-5000 employees. Its website is http://www.bdo.ca/en/pages/default.aspx.