Data Analytics Developer
Data Analytics Developer
We are looking for an innovative data analytics developer who has a knack for seeing solutions in sprawling data sets across loan and deposit products, a flair for building consistent business user experiences, and the business mindset to perform detailed analysis to produce genuine business insights that will find and fuel strategic opportunities.
You will work directly with the Business Data Officer and partner with line of business peers and leaders to assess and interpret their reporting needs. You will identify and design reporting solutions based on their requirements. You will use various data query and visualization tools (SQL, Python, Power BI, SAS, etc.) to access multiple data sources and design insightful products for our business partners. You will work with various teams, each with unique backgrounds and perspectives, to develop solutions that will have a real impact for the bank and for our customers.
Key Accountabilities
Fulfill core data analytics developer accountabilities:
• Build, develop and maintain data models, dashboards, reports, data automation systems, and performance metrics support that support key business decisions
• Proactively evaluate data & trends to guide business partners on emerging opportunities
• Ensure data accuracy and consistent reporting by designing and creating optimal analytics code with data controls defined as defined within the policy, procedure, and standards
• Tasks and deliverables are often time-sensitive and require a proactive approach to ensure deadlines are consistently met
Develop and implement Power BI Reports:
• Creates a consistent dashboard, reporting, and analytics experience for the business users
• Understand business requirements of BI context and design a data model to transform raw data into meaningful insights
• Convert business requirements into technical specifications and implement them through reports that support decision-making
• Perform DAX queries and functions in Power BI
Develop data extracts & ad-hoc reporting:
• Partner with business users to derive requirements, identify data sources, wrangle data and/or transform data via SQL and/or SAS to produce file extracts for use within PowerBI Dashboards or distribution to other systems
• Drive efforts on ad hoc, time-sensitive exploratory data analysis and/or qualitative analysis to provide insights on trends, client behaviors, system troubleshooting or non-recurring reporting needs.
• Creating customized diagrams and user-defined calculations as needed
• Design, develop and deploy business intelligence solutions with SQL queries for best results, filters, and graphs to better understand your data at all levels for performance improvements and suggestions
Qualifications and Education Requirements
• Bachelor's degree in related field; advanced coursework/training related to computer science, management information systems, and mathematics/statistics
• Thorough knowledge of the retail bank business line
• 5+ years' experience in banking and finance
• 5+ years' experience programming skills with querying languages: SQL, SAS, R, Python, etc.
• 3-5 years' experience in developing analytics reports and dashboards, preferably PowerBI
• 3-5 years' experience working with and creating data extracts
• 3+ years' experience in Data visualization
• Experience integrating multiple components of the Microsoft BI Stack, with specific emphasis on Power BI, Power Apps, Power Automate and Azure services
• Experience with both on-prem SQL server and Azure Databricks cloud data environments
• Experience using analytics techniques to contribute to company growth efforts, increasing revenue and other key business outcomes
• Knowledge of industry leading practices in Analytics
• Solid written, verbal, and interpersonal skills
• Strong project management skills and experience with agile methodologies preferred
• Demonstrated ability to communicate and support data culture change initiatives
• Client-centered approach to working with line of business stakeholders
• Demonstrated ability to engage directly with C-level executives when sharing data, reports and presentations
• Strong banking domain expertise preferred
• Working knowledge of banking systems and tools (MeridianLink/LoansPQ, Encompass, Velocify, Fiserv Signature, Marquis Executrax MCIF) preferred
About Korn Ferry
Korn Ferry unleashes potential in people, teams, and organizations. We work with our clients to design optimal organization structures, roles, and responsibilities. We help them hire the right people and advise them on how to reward and motivate their workforce while developing professionals as they navigate and advance their careers. To learn more, please visit Korn Ferry at www.Kornferry.com
Data Analytics Developer
We are looking for an innovative data analytics developer who has a knack for seeing solutions in sprawling data sets across loan and deposit products, a flair for building consistent business user experiences, and the business mindset to perform detailed analysis to produce genuine business insights that will find and fuel strategic opportunities.
You will work directly with the Business Data Officer and partner with line of business peers and leaders to assess and interpret their reporting needs. You will identify and design reporting solutions based on their requirements. You will use various data query and visualization tools (SQL, Python, Power BI, SAS, etc.) to access multiple data sources and design insightful products for our business partners. You will work with various teams, each with unique backgrounds and perspectives, to develop solutions that will have a real impact for the bank and for our customers.
Key Accountabilities
Fulfill core data analytics developer accountabilities:
• Build, develop and maintain data models, dashboards, reports, data automation systems, and performance metrics support that support key business decisions
• Proactively evaluate data & trends to guide business partners on emerging opportunities
• Ensure data accuracy and consistent reporting by designing and creating optimal analytics code with data controls defined as defined within the policy, procedure, and standards
• Tasks and deliverables are often time-sensitive and require a proactive approach to ensure deadlines are consistently met
Develop and implement Power BI Reports:
• Creates a consistent dashboard, reporting, and analytics experience for the business users
• Understand business requirements of BI context and design a data model to transform raw data into meaningful insights
• Convert business requirements into technical specifications and implement them through reports that support decision-making
• Perform DAX queries and functions in Power BI
Develop data extracts & ad-hoc reporting:
• Partner with business users to derive requirements, identify data sources, wrangle data and/or transform data via SQL and/or SAS to produce file extracts for use within PowerBI Dashboards or distribution to other systems
• Drive efforts on ad hoc, time-sensitive exploratory data analysis and/or qualitative analysis to provide insights on trends, client behaviors, system troubleshooting or non-recurring reporting needs.
• Creating customized diagrams and user-defined calculations as needed
• Design, develop and deploy business intelligence solutions with SQL queries for best results, filters, and graphs to better understand your data at all levels for performance improvements and suggestions
Qualifications and Education Requirements
• Bachelor's degree in related field; advanced coursework/training related to computer science, management information systems, and mathematics/statistics
• Thorough knowledge of the retail bank business line
• 5+ years' experience in banking and finance
• 5+ years' experience programming skills with querying languages: SQL, SAS, R, Python, etc.
• 3-5 years' experience in developing analytics reports and dashboards, preferably PowerBI
• 3-5 years' experience working with and creating data extracts
• 3+ years' experience in Data visualization
• Experience integrating multiple components of the Microsoft BI Stack, with specific emphasis on Power BI, Power Apps, Power Automate and Azure services
• Experience with both on-prem SQL server and Azure Databricks cloud data environments
• Experience using analytics techniques to contribute to company growth efforts, increasing revenue and other key business outcomes
• Knowledge of industry leading practices in Analytics
• Solid written, verbal, and interpersonal skills
• Strong project management skills and experience with agile methodologies preferred
• Demonstrated ability to communicate and support data culture change initiatives
• Client-centered approach to working with line of business stakeholders
• Demonstrated ability to engage directly with C-level executives when sharing data, reports and presentations
• Strong banking domain expertise preferred
• Working knowledge of banking systems and tools (MeridianLink/LoansPQ, Encompass, Velocify, Fiserv Signature, Marquis Executrax MCIF) preferred
About Korn Ferry
Korn Ferry unleashes potential in people, teams, and organizations. We work with our clients to design optimal organization structures, roles, and responsibilities. We help them hire the right people and advise them on how to reward and motivate their workforce while developing professionals as they navigate and advance their careers. To learn more, please visit Korn Ferry at www.Kornferry.com
