Data Engineer / Analyst

Job Description

Our ambitious Chief Data Office is spearheading the creation of a top-tier data team dedicated to tackling intricate business challenges and enhancing both our business operations and customer experiences through insightful analysis. We seek a creative data analytics developer adept at navigating complex datasets related to loan and deposit products, with a talent for crafting intuitive user interfaces and a strategic mindset for generating valuable business insights. Collaborating closely with key stakeholders such as Business Chief Information Officers and Chief Financial Officers, you will assess their reporting requirements and devise tailored solutions. Utilizing a range of data query and visualization tools such as SQL, Power BI, and SAS, you will access diverse data sources to craft impactful products for our business partners. Working alongside teams of diverse backgrounds and perspectives, you will drive solutions that deliver tangible benefits for both the bank and our customers.

Key Accountabilities

Execute primary responsibilities of a data analytics developer:

• Construct, enhance, and sustain data models, dashboards, reports, automation systems, and metrics assistance to facilitate critical business determinations.
• Actively assess data and trends to advise business collaborators on emerging prospects.
• Uphold data precision and standardized reporting through the development and implementation of efficient analytics code adhering to prescribed policies, procedures, and standards.
• Manage time-sensitive tasks and deliverables, necessitating a proactive stance to consistently meet deadlines.
  
  

• Establish a uniform dashboard, reporting, and analytics interface tailored for business users.
• Grasp the business needs within the BI framework and devise a data model to translate raw data into actionable insights.
• Translate business requisites into technical blueprints and execute them through reports that facilitate decision-making.
• Execute DAX queries and functions within Power BI to enhance data analysis capabilities.
  
  

• Collaborate with business users to gather requirements, pinpoint data sources, manipulate data through SQL and/or SAS to generate file extracts for integration into PowerBI Dashboards or dissemination to other systems.
• Craft personalized visualizations and user-defined computations as required.
• Devise, implement, and roll out business intelligence solutions utilizing SQL queries, filters, and graphs to comprehensively analyze data at various levels, thereby enhancing performance and offering recommendations.
  
  

• Completion of a Bachelor’s degree in a relevant field; completion of advanced coursework/training in computer science, management information systems, and mathematics/statistics
• Over 3 years of experience in the banking and finance sector
• Over 3 years of experience in developing analytics reports and dashboards, preferably utilizing PowerBI
• Over 3 years of experience working with and generating data extracts
• Over 3 years of experience in programming languages such as SQL, SAS, R, Python, etc.
• Over 3 years of experience in data visualization
• Proficiency in integrating various components of the Microsoft BI Stack, with a particular emphasis on Power BI, Power Apps, Power Automate, and Azure services
• Utilization of analytics techniques to contribute to company growth endeavors, including revenue increase and other significant business outcomes
• Familiarity with industry-leading practices in Analytics
• Strong written, verbal, and interpersonal communication skills
• Robust project management capabilities, with a preference for experience with agile methodologies
• Demonstrated ability to communicate and support initiatives aimed at fostering a data-centric culture
• Client-focused approach in collaborating with line of business stakeholders
• Demonstrated capability to engage directly with C-level executives when presenting data, reports, and presentations
• Strong preference for expertise in the banking domain
• Working knowledge of banking systems and tools (MeridianLink/LoansPQ, Encompass, Velocify, Fiserv Signature, Marquis Executrax MCIF) is advantageous