About this role
<p style="text-align:justify"><span style="font-size:12.0pt;font-family:arial, helvetica, sans-serif">At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. </span></p> <p style="text-align:justify"> </p><p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif"><strong>The opportunity</strong></span></p> <p style="text-align:justify"><br><span style="font-family:arial, helvetica, sans-serif">We are looking for a Data Engineer. Our AI & Data practice works collaboratively with our clients to enhance their ability to use and interpret data and develop their own enhanced information management capabilities to support better decision making, along with regulatory compliance within their business. Our clients need the vision to articulate the big picture and the precision to see the smallest of details.</span></p> <p style="text-align:justify"> </p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif"><strong>Our Data and Analytics practice provides expertise and delivery in four core areas of competency</strong></span></p> <ul style="text-align:justify"> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Data Management and Integration providing the foundational layers for enterprise data accessibility, covering data sourcing and integration, data warehouse and modelling, master data management and data rationalisation and migration. Design and implementation ETL solutions using one of the leading ETL packages (e.g., Informatica, Ab Initio, DataStage).</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Data Quality and Governance developing an organisation that treats data as a critical enterprise asset and sources quality data for business use and regulatory compliance. This includes examining the fitness for purpose of data for specific business needs, data remediation, and the strategy, roles, policies and processes to effectively manage data through its lifecycle;</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Reporting design, architecture and implementation of enterprise reporting solutions. This includes the end-to-end reporting lifecycle across advisory and strategy, identifying compliance reporting trouble spots and delivering achievable roadmaps, to vendor selection, design and implementation. Demonstrated experience and knowledge of at least one of the leading Business Intelligence Packages (e.g., Cognos, Business Objects, MicroStrategy, Tableau, SPSS, SAS); and</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Analytics covers operational analytics, predictive analytics, industry models and analytics enablement, and provides actionable enterprise insight and delivers value from an enterprises data. The area of Analytics and Data Science is expected to be a key driver for growth in the coming year.</span></li> </ul> <p style="text-align:justify"> </p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif"><strong>Your key responsibilities</strong></span></p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif">As a Data Engineer, you will:</span></p> <ul style="text-align:justify"> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Lead event stream analytics initiative and create the foundation for event data collection at EY Canada.</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Design and build highly scalable and responsive platform to collect the data across all the brands and all devices (mobile apps, desktop …)</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Work with teams across EY to drive the new platform adoption</span></li> </ul> <p style="text-align:justify"> </p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif"><strong>Skills and attributes for success</strong></span></p> <ul style="text-align:justify"> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Strong analytical and creative thinking skills, must be a team player</span></li> </ul> <p style="text-align:justify"> </p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif"><strong>To qualify for the role you must have </strong></span></p> <ul style="text-align:justify"> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">CS Degree or equivalent experience</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Databricks</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Data Platform</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Data Engineering</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">5-10 years of experience building and shipping highly scalable clickstream data pipelines and analytics systems on distributed data systems and cloud platforms (AWS/Azure/GCP)</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience with Java, Scala, Python etc.</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Solid experience in streaming technologies like Kafka or Spark Streaming.</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience building batch, real-time and streaming analytics pipelines with data from event data streams, NoSQL and APIs.</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience with batch & stream processing technologies such Spark, KStreams, Samza etc.</span></li> </ul> <p style="text-align:justify"> </p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif"><strong>Ideally, you’ll also have</strong></span></p> <ul style="text-align:justify"> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience with ETL tools/ ETL flows with complex Transformations/Routines using Python, PySpark, Java, Javascript, Bash Shell Scripting;</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">User interface and query software (IBM DB2);</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Enterprise application integration software (e.g. XML);</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Data modeling tools (ERWin, Enterprise Architect and Visio);</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience in business intelligence fields - strong analytical skills with the ability to collect, analyze, design and disseminate significant amounts of information with high attention to detail and accuracy;</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Application server software (Oracle)</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Exceptional Database management - SQL skills/experience using MS SQL Server, MySQL, SSIS, SSMS, SQL Server Management Studio, PostgreSQ;</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Advanced skill in Scala</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Applied knowledge in Big Data platforms, ideally with exposure to Hadoop ecosystem (HDFS, Pig, Hive, SPARK, Big SQL, NoSQL, YARN);</span></li> <li style="font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience in designing efficient and robust pipelines.</span></li> </ul> <p style="text-align:justify"> </p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif"><strong>Diversity and Inclusion at EY </strong></span></p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif"> </span></p> <p style="text-align:justify"><span style="font-family:arial, helvetica, sans-serif">Diversity and inclusiveness are at the heart of who we are and how we work. We’re committed to fostering an environment where differences are valued, policies and practices are equitable, and our people feel a sense of belonging. We embrace diversity and are committed to combating systemic racism, advancing gender equity and women in leadership, advocating for the 2SLGBTQIA+ community, promoting our neuroinclusion and accessibility initiatives, and are dedicated to amplifying the voices of Indigenous peoples (First Nations, Inuit, and Métis) nationally as we strive towards reconciliation. Our diverse experiences, abilities, backgrounds, and perspectives make our people unique and help guide us. Because when people feel free to be their authentic selves at work, they bring their best and are empowered to build a better working world. </span></p><p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:12.0pt"><strong>EY | Building a better working world </strong></span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:12.0pt"><br>EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets. </span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:12.0pt"><br>Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. </span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:12.0pt"><br>Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today. </span></p>