Data Analyst III

bankeasy; Sioux Falls (SD); On-site; USD 95,000 - 150,000; Full time

Job summary

First Bank & Trust is seeking a senior data analytics professional to design enterprise analytics solutions, build tabular models, and deliver data-informed insights across business lines. You will lead data engagement initiatives and collaborate with technology teams to align analytics with strategic goals.

Strong SQL Server, T-SQL, DAX, and Power BI skills are required; PL-300 certification must be achieved within six months. Knowledge of R or Python is preferred.

Qualifications

• Bachelor's degree plus six years of related work experience or equivalent.
• Experience building solutions using advanced analytics with financial data.
• Research-oriented with strong analytical and problem-solving skills.
• Experience leading development with multiple contributors.
• Extensive experience with tabular models, SQL Server, T-SQL, DAX, and BI visualizations.
• PL-300 certification required and to be obtained within six months of hire.
• Knowledge of R or Python is preferred.

Responsibilities

• Design and develop optimized enterprise data analytics solutions for client, market, product, and operations.
• Develop and use tabular models and continually improve analytics solutions and dashboards.
• Lead Data Engagement initiatives to provide accessible information via dashboards.
• Collaborate with technology team members to design and implement data storage/access.
• Build relationships with business lines to understand objectives and derive requirements.
• Advise on data best practices and improve automation of insights and efficiency.

Skills

Analytical thinking

Problem solving

Communication

Leadership

Education

Bachelor's degree

Tools

Microsoft SQL Server

T-SQL

DAX

Power BI

Relational databases

Non-relational databases

R

Python

Job description

Job Description

This person will de sign and develop advanced enterprise-scale data analytics solutions to identify patterns and trends, analyze root cause, and improve overall data quality, consistency, and accessibility. They will build solutions using current and emerging techniques to deliver client insights and perspectives to business lines enabling data-informed de cisions as well as increase efficiencies and innovation. This individual will consult directly with business lines to learn business objectives , understand key results, and derive requirements needed to d evelop solutions that will deliver positive business outcomes.

Qualifications

This person should have a bachelor's, plus six years of previous related work experience or the equivalent. Experience building solutions using advanced analytics and working with financial data is required . This candidate must be research oriented, possess strong analytical and problem-solving skills, be able to effectively communicate the value of company data to leaders at all levels, and have experience leading the development of solutions while working with multiple contributors. This person must have extensive experience working with tabular data models, using Microsoft SQL Server, writing T-SQL queries and DAX , performing data visualizations with Microsoft's BI stack , and understanding relational and non-relational databases . Microsoft Power BI Data Analyst Associate (PL-300) certification is req u ired and must be obtained within six months of hiring. K nowledge of R or Python is preferred.

Principal Responsibilities

Design and develop optimized enterprise data analytics solutions for client, market, product, and operational functions that deliver insights to generate data-informed decisions and actions . Develop and use tabular models and c ontinually improve analytics solutions, models , and strategies to provide outcome-based solutions, root cause analysis, and data analytics reporting and visualization s.Lead Data Engagement initiatives to make information accessible through dynamic reports and dashboards driven by universal tabular models. Design and develop tabular models through collaboration with technology team members . Ensure relevant data and analytics are available to meet initiatives by helping design and implement the storage and access of data .Build and manage relationships with business line managers to understand business objectives . Partner with stakeholders to derive requirements, scope data engagement solutions, and help drive data-informed decisions and results. Advise on data best practices, improve automation of insights, actions, decisions, and increase efficiencies and competencies with FBT technical capabilities.Provide technical leadership to technology team members working on data analytics projects and deliverables. Be knowledgeable of Database, Data Engineering, DevOps, and API concepts. Work closely with Technology teams to align projects and support the strategic direction of the organization.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.Build statistical and quantitative analysis to identify trends, patterns, and correlations that can be used to promote better business decision s .Maintain knowledge of innovative tools and resources to improve data strategy and governance. R emain on top of industry best practice and know what system and business process data comes from and remain current on changes within the data platform, data models, and systems used across the bank.Act in accordance with FBT policies and procedures as set forth in the employee handbook.Adhere to compliance procedures and attend required compliance training.

Compensation Grade

Salary Grade 7

First Bank & Trust is an Equal Opportunity, affirming that All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, or status as a protected veteran. Read our complete Equal Employment Opportunity Policy Statement .