Analytics Engineer

Embedded in a lean data team at a privately held $11billion bank, the Analytics Engineer turns disparate data into a single source of truth that drives revenue growth, expense discipline, and risk management. Partnering with data engineers, you architect reusable models that align deposits, loans, and operational metrics to executive KPIs. Rigorous testing, documentation, and peer review make these assets dependable enough for regulators yet agile enough for daily forecasting. Workshops and clear guides empower business, operations, and financial analysts to run their own analyses without IT intervention. Ultimately, you transform raw data into confident decisions that protect the bank and propel its strategy.

Essential Functions:

• Model & Transform-Translate user stories into datamodel designs, then write SQL/Python/dbt transformations that turn raw corebanking, lending, and operational feeds into governed, reusable assets (Fabric semantic models, data marts, SQL views, AS tabular models).
• Engineer with Rigor-Apply softwareengineering best practices-Git branching, pullrequest code reviews, automated unit/integration tests, and CI/CD pipelines-to guarantee every dataset is versioned, auditable, and production
• Partner & Plan-Work shouldertoshoulder with Data Engineers on ingestion architecture and with business stakeholders to refine acceptance criteria, ensuring models answer the right questions at the right granularity.
• Monitor & Remediate-Implement dataquality tests and realtime alerts so freshness, accuracy, and uptime meet expectations; troubleshoot incidents endto
• Enable SelfService-Coach financial, business, and operations analysts on BI tools and storytelling best practices; create workshops, playbooks, and template dashboards that raise data literacy across the bank.
• Govern & Document-Contribute to business glossaries, data dictionaries, lineage diagrams, and Purview catalogs so every field is traceable from source to report and compliant with FFIEC/FDIC expectations.
• Continuously Improve-Lead retrospectives to refine delivery methodology, evaluate emerging tooling (e.g., Fabric Copilot, dbtMesh, Data Contracts), and pursue certifications or training that keep the team ahead of industry trends.

Situational Functions:

• Perform adhoc/statistical analyses and present insights to decision
• Design lightweight workflow automations (Power Automate/Power Apps) where data pipelines intersect business processes.
• Estimate solution cost, effort, and complexity for new initiatives.
• Enforce and help evolve IT standards, controls, and Secure SDLC procedures.
• Participate in special projects, compliance reviews, and risk assessments as assigned.
• Stay current through conferences, research, and peer learning; share findings with the team.
• Maintain regular, reliable attendance.

Required Skills:

• Education & Experience - Bachelor's in Data Analytics, MIS, Computer Science, or related field or equivalent professional experience; 3+years delivering production data models or pipelines.
• SQL & Data Modeling - Expert at writing performant SQL (TSQL or ANSI), dimensional modeling, and building semantic layers (Fabric, SSAS Tabular, or dbt).
• Version Control & CI/CD - Daily Git workflow (branching, PR review) plus automated testing and deployment via Azure DevOps, GitHub Actions, or similar.
• BI & Visualization - Strong PowerBI skills (DAX, model optimization, rolebased security); ability to translate business questions into dashboards and reports.
• Quality & Monitoring - Experience with dataquality tests, lineage tools, and alerting to maintain highuptime, auditready pipelines.
• Cloud & Orchestration - Exposure to Azure Fabric, Synapse, Databricks, ADF, or comparable cloud data platforms.
• Soft Skills - Proven ability to prioritize multiple initiatives, communicate with technical and nontechnical stakeholders, and thrive under tight deadlines in a regulated environment.

Preferred Skills:

• Banking / FinTech Domain - Familiarity with data structures, payment, credit and other functions relating to financial services.
• Programming & Scripting - Proficiency in Python for data transformation, orchestration, or testing.
• Workflow Automation - Power Automate, PowerApps, or other lowcode tools to streamline business processes.
• Programming & APIs - REST API integration, basic .NET or JavaScript/Node for niche automation needs.
• Methodologies - Experience working in Agile/Scrum, story point estimation, and writing clear acceptance criteria.
• Professional Development - Relevant certifications (e.g. Microsoft Fabric Analytics Engineer, dbt Certified Developer or Azure Data Engineer).

Associate Analytics Engineer

Entry-level position within job family. Requires appropriate education and required technical skills. Might not have a strong aptitude for reporting and analytics but is willing and capable of learning. Requires direction from Manager and senior team members on priorities, approaches to problem solving, interactions with employees outside the division and with vendors.

Analytics Engineer

Mid-level position within job family. Requires appropriate education, on-the-job training/work experience, required technical skills. Strong aptitude for reporting and analytics. Assists in the development and preparation of reporting and analysis. Participates in the design and implementation of business intelligence solutions. Able to effectively use resources and skill to accomplish work independently and make decisions with minimal manager input.

Senior Analytics Engineer

Senior-level position within job family. Requires appropriate education, on-the-job training/work experience, required technical skills. Has built a solid foundation around reporting and analytics and is capable of more complex effort. Capable of developing and successfully executing a training session for a solution developed by the BI team. Designs and implements enhancements to business intelligence solutions. Requires minimal direction from Manager on priorities, approaches to problem solving, interactions with employees outside the division and with vendors.

Compensation:

Associate Analytics Engineer - $63,773 - $95,659
Analytics Engineer - $73,040 - $109,561
Senior Analytics Engineer - $83,743 - $125,670

The compensation range represents the low and high end of the base compensation range for this position located in Spokane, WA. Actual compensation will vary and may be above or below the range based on various factors including but not limited to location, experience, and performance. This position is eligible to participate in an applicable annual bonus plan.

What Our Culture Can Offer You:

Our benefit philosophy is to provide you with a comprehensive package to secure your overall wellness and help you become and remain a fulfilled and productive employee. Our benefits include Health, Financial, Retirement and Work/Life Benefits. We are proud to share an overview of our benefits HERE as part of your total compensation.

Washington Trust Bank celebrates diversity in the workplace and actively recruits talent to help reflect the unique communities where we live and work. We are proud to be an equal opportunity employer and prohibit discrimination or harassment based on race, religion, sex, gender identity, sexual orientation, national origin, age, pregnancy, disability, genetic information and any other protected characteristics outline by state, federal and local laws. We believe strength comes from the diverse backgrounds and experiences of our team, and we are dedicated to fostering a supportive and inclusive work environment.