Data Analyst II

First Bank & Trust•San Francisco, SD

About The Position

This person is responsible for conceptualization, design, planning, creation, implementation , and maintenance of automated and customized data solutions and tabular models . Work includes designing, maintaining , and automating reports ; validating query and solution results; leading the development and use of automated data engagement solutions, tools , and technology. This person is expected to consult with stakeholders and business lines to manage and bring to conclusion multiple projects , contribute to d ata governance initiatives , develop tabular models, use advanced analytics tools and techniques , and de sign scalable solutions that make data more accessible to users as well as drive data informed decision s .

Requirements

b achelor’s degree , plus four years of related work experience or the equivalent
strong knowledge of the Microsoft Office Suite
demonstrated experience using data analysis and visualization techniques
knowledge of database and data modeling concepts
accomplished coding skills in SQL, R, Python, or similar
aptitude for data informed insights and actions
project management skills
decision-making skills
quality - improvement skills
problem-solving skills
strong interpersonal, verbal , and written communication skills

Nice To Haves

Experience with Financial Services
Microsoft SQL Server and Power BI
tabular data model s
m achine l earning or predictive analytics

Responsibilities

Resear ch and understand business problems, write SQL queries , creat e stored procedures, build tabular models, and use tabular models or other methods to access data.
Develop reports and visualizations to process and organize data for end-users into more easily consumable formats.
Analyze information and automate insights to help generate data informed decisions and actions where possible.
B ecome a power user of the applications and tools used to produce queries , reports , and insights.
Work effectively with internal customers to improve the quality of data and reporting , access to data , tabular models , and processing of information for business decisions.
Proactively identify and evaluate improvements and benefits that could be derived from modifications or automation of existing reports and manual processes.
Collaborate with business and technology teams to implement enhanced solutions.
Plan and facilitate quarterly stakeholder meetings to effectively develop and manage analytics and reporting for key business lines as assigned.
Proactively s eek out, identify , and respond to opportunities to enhance the delivery of information, automation of insights, and enable end-users to analyze data without requiring outside help.
Lead Data Engagement initiatives to make information accessible through dynamic reports and dashboards driven by univers al tabular models .
Work with technology team members to build and enhance universal tabular models as well as help de sign and implement the storage and access of data for the creation and production of automated reports and solutions .
M aintain knowledge of innovative tools , remain on top of industry best practice, and know what system and business process data comes from .
Use advanced analytics techniques i n development of new solutions and have knowledge of machine learning methods .
R emain current on changes within the data models and systems used across the bank .
Manage multiple data and reporting projects simultaneously , prepare project timelines , organize solution development specifications , monitor, review, and report on project progress.
P rovide onboarding and technical support for analysts and department intern s as needed.
Successfully develop and execute validation plans t hat thoroughly test data and allow for quality implementation of new or modified reports and solutions .
Follow procedures for change management controls, maintaining metadata, and creating or updating technical spec docs.
Support data governance, data literacy, and data stewardship initiatives established by the Data Governance Committee to improve data integrity, usability, and access across the organization.
Lead data governance initiatives and key results on behalf of Data Engagement Team as assigned.
Consult with Learning and Development on data literacy training needs.
Demonstrate continuous effort to improve operational efficiency, productivity, and a ccuracy; decrease turnaround times, streamline work processes, and work collaboratively with team members to provide quality seamless customer service .