Úta Engineer (Intern/Co-op), Lighthouse Canada

Overview At KPMG, you’ll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world. Do work that matters, supported by a community that values difference and cares about you. Gain learning that’ll last you a lifetime and be recognized for the impact you make. With a focus on encouraging employees to come as they are, KPMG provides its employees with a variety of unique tools and support systems that ensure they thrive and make their mark in their career and in their communities. Why KPMG Lighthouse? KPMG Canada’s Center of Excellence for Data & Analytics + Intelligent Automation applies exponential thinking and emerging technologies to solve today’s challenges. Join a diverse team that is always curious and learning, thinking independently and working collaboratively, has a passion to solve difficult problems and has fun doing it. Our teams apply exponential thinking and emerging technologies to solve today’s challenges We are comprised of a global network of over 12,500 experts including data scientists and engineers Our teams build and deliver solutions that transform the business of our clients Our regional hubs are in strategic markets and provide specialty services to local teams KPMG Lighthouse Canada has an exciting opportunity for Data Engineers (Intern/Co-op) to join our team for a 4-8 month term starting in May 2023. ** Please note that you must be enrolled in a Canadian post-secondary educational institution to be eligible for this opportunity. What you will do Work in teams or in an individual capacity to perform ETL/ELT (extract, transform and load) of data from a variety of databases, SQL, NoSQL, Hadoop, Neo4j, etc. Strong experience with large-scale and or distributed processing methodologies such as Storm, Spark and many others. Build data pipelines using cloud and traditional ETL tools. Review data quality and definitions, and perform data cleansing and data management tasks. Work with the engagement team to translate business and analytics requirements into a data strategy for the engagement including ETL, data model and staging data for analysis Architect the data platform for scalability, repeatability and performance. Develop standards for data processes and automate routine tasks and Data Governance around them. Run SQL queries for descriptive analytics and provide formatted result sets. Proactively contribute to the creation of presentation materials relating to data activities for stakeholder discussions. Support application testing and production implementation as required. Bridge the gap between technical platform needs and business issues. Design software architecture following best practices after understanding customer requirements in enterprise environments. What you bring to the role Strong experience working on ETL/ELT (extract, transform and load) of data from a variety of databases from SQL, NoSQL, Hadoop, Neo4j, MPP databases etc. Independent ability to review the data quality and data definitions, and perform data cleansing and data management tasks Experience working in a multi-disciplinary team to tack unstructured data processing problems across a diverse range of industries Strong ability to use Python, Pandas and NumPy for data analysis and cleansing tasks Experience with visualization tools such as Tableau, PowerBI, QlikView, etc. Strong understanding of Data Warehousing and Data Modeling. Experience or knowledge in one major cloud service: AWS, MS Azure and GCP. Keys to your success: Ability to explain data and analytics concepts to non-technical team members. Ability to apply data and analytics concepts to business problems. Ability to understand and explain the business value of data and analytics concepts. Knowledge of basic machine learning to collaborate with the team on ML projects Experience in visual exploration to perform data discovery and highlight insights Knowledge of how specific visual components drive usability and understanding A knack for telling a story with a purpose. Strong facilitation and collaboration abilities to conduct discussions and workshops with engineers and business analysts to advocate for positive user experience and recommend potential solutions to identified problems To apply: Please apply directly to KPMG at kpmg.ca/careers Applications close on January 17th, 2023 at 11:59 PM ET. Our online application system will allow you to include up to five documents without losing your formatting. Applications can be addressed to Hiring Manager and must include a cover letter, resume and an electronic copy of your most recent transcript. If you do not have access to an electronic copy of your transcript, we ask that you attach a screenshot of your grades from your school’s website. In the application questionnaire, you’ll be able to indicate your preference for position type and office location. For an easy application process, please PDF all documents into one PDF file. If you experience any difficulties, please contact [email protected]. KPMG individuals Deliver Impact | Seek Growth | Inspire Trust and understand that a diverse workforce enables us to deepen relationships and strengthen our business. Providing you with the support you need to be at your best For more information about KPMG in Canada’s Benefits and well-being, click here. Our Values, The KPMG Way Integrity, we do what is right | Excellence, we never stop learning and improving | Courage, we think and act boldly | Together, we respect each other and draw strength from our differences | For Better, we do what matters KPMG in Canada is a proud equal opportunities employer and we are committed to creating a respectful, inclusive and barrier-free workplace that allows all of our people to reach their full potential. A diverse workforce is key to our success and we believe in bringing your whole self to work. We welcome all qualified candidates to apply and hope you will choose KPMG in Canada as your employer of choice. For more information about Inclusion, Diversity & Equity in Recruitment, please click here. For general recruitment-related inquiries, please contact the HR Delivery Centre at [email protected]. If you have a question about accessible employment at KPMG, or to begin a confidential conversation about your individual accessibility or accommodation needs through the recruitment process, we encourage you to contact us at [email protected] or phone: 416-777-8002 or toll free 1-888-466-4778.