Sr Data Engineer

Application Deadline: 11/12/2023 Address: 33 Dundas Street West Job Family Group: Data Analytics & Reporting Responsibilities: Power Business Intelligence (BI) experience and a good understanding of BI architecture. Use best practice standards and methods in data modelling, data architecture, data platforms and agile delivery Work independently as a senior lead and direct activities related to analysis, design and support of technical data management solutions on various projects ranging in complexity and size Utilizes an advanced understanding of multiple data structures and sources to lead the design, development and implementation of decision solutions, which may include data visualization, business intelligence, or data collection Leverage data to provide meaningful insights to business leaders and use BI tools to support operational processes by delivering data visualization reports and dashboards Use statistical and machine learning techniques to build and maintain effective and efficient transaction monitoring, user behavior, and risk scoring models Develops innovative approaches to address complex business problems and solutions, assisting with business cases Work with business leadership to define business intelligence requirements, Key performance indicators (KPI), priorities and data solutions Expert knowledge of Python, SAS, SQL and R are essential Extensive work experience building predictive models with machine learning methods Ability to apply statistical techniques and data mining tools to solve business problem Significant experience building UI mockups and optimizing dashboard for user experience Intermediate to advanced understanding of MDX/DAX language for improving visuals and formatting numbers, dates, and text. Experience with row level security and custom visuals,Power Query, Power Apps and keeping up to date on the new features of Power BI Hands-on experience of SQL and Python for data access and basic transformation Experience in various forms of data modeling of relational schema, including both physical and conceptual modeling Experience in query optimization, debugging and automation Excellent written and oral communication, analytical and presentation skills, including ability to communicate with individuals from various backgrounds Familiarity with an agile development process Preferred Qualification 7 years of experience in data analytics environments Microsoft PowerBI, Extensive DAX and PowerQuery (M) language experience in PowerBI Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets Experience with data modeling, warehousing and building ETL pipelines Experience with AWS solutions - Azure data platform, experience with Azure functions and services Ability to test, identify and troubleshoot report and dataset issues General understanding of Relational database functionality including security, table structures, data modelling, user management, etc. ITSM Asset/CMDB knowledge is an asset Dynatrace, Aternity, lakeside knowledge is an added advantage Certifications(atleast 1): Microsoft Certified: Azure Enterprise Data Analyst Associate PL-500 Microsoft Certified: Power BI Data Analyst Associate PL-300 We’re here to help At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world. As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset. To find out more visit us at https://jobs.bmo.com/ca/en. BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter. Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes. BMO is a leading bank driven by a single purpose: to Boldly Grow the Good in business and life. Everywhere we do business, we’re focused on building, investing and transforming how we work to drive performance and continue growing the good. Who we are We’re proud to be fueling growth and expanding possibilities for individuals, families and businesses. More than 12 million customers count on us for personal and commercial banking, wealth management and investment services. As the 8th largest bank in North America by assets, we provide personal and commercial banking, wealth management and investment services to more than 12 million customers. In Canada, the United States and across the globe, we’ll continue to build, invest and transform to drive performance that serves the good that grows.