Senior / Lead Data Software Engineer (Analytics & AI)

Summary

The Senior / Lead Data Software Engineer is responsible for the technical leadership, design, and delivery of the Bank's analytics and AI-enabled software solutions. This role combines hands-on engineering with architectural ownership and mentoring responsibilities.

The position leads development of Power BI analytics solutions and AI-assisted applications built on large language models, while establishing engineering standards, guiding other engineers, and ensuring solutions meet the Bank's security, data governance, and regulatory expectations - including strong protection of customer nonpublic personal information (NPI).

Essential Duties and Responsibilities

Technical Leadership & Architecture

• Serve as the technical lead for analytics and AI software solutions, owning design, implementation quality, and long-term maintainability.
• Architect, develop, and optimize Power BI solutions, including semantic models, datasets, DAX, row-level security, and performance tuning.
• Define and enforce standards for data modeling, Power BI development, version control, secure SDLC, and deployment practices - aligned to the Bank's ITIL-based change management process.

AI/LLM Solution Development

• Design and implement AI-powered applications and workflows leveraging large language models.
• Lead AI agent buildout, including agent architecture, orchestration logic, prompt engineering, evaluation, and operational guardrails.

AI Risk, Governance & Data Protection

• Implement controls that prevent exposure of customer nonpublic personal information (NPI) to external AI services, including data minimization, masking/redaction in prompts, and prompt/response logging and retention.
• Ensure AI solutions are secure, auditable, and explainable, with defined human review before AI output enters a system of record or customer-facing use; establish AI/model risk practices appropriate to the Bank, including documentation, validation, and ongoing monitoring for accuracy, drift, and unintended outcomes.
• Ensure AI and analytics access to governed data honors least-privilege and data-masking controls, without bypassing row- or column-level protections.

Cross-Functional Partnership & Delivery

• Partner with data platform, infrastructure, information security, and compliance stakeholders to align analytics and AI solutions with the Bank's architecture and risk expectations.
• Translate complex business problems into scalable software and AI solutions with measurable outcomes.

Mentorship, Documentation & Innovation

• Mentor and coach other engineers through code reviews, design guidance, and ongoing technical development, ensuring adherence to architectural standards and best practices.
• Lead troubleshooting and root-cause analysis for complex production issues across analytics and AI systems.
• Maintain comprehensive technical documentation, including architecture diagrams, standards, and operational runbooks.
• Evaluate emerging analytics and AI technologies and provide recommendations on adoption and roadmap alignment.
• Other duties as assigned.

Education And/Or Experience

• Bachelor's degree in Computer Science, Software Engineering, Information Technology, or a related field (or equivalent experience).
• Minimum of seven (7) years of experience in data engineering, analytics engineering, or software development roles.
• Demonstrated experience leading technical design and delivery of production Power BI solutions.
• Hands-on experience designing and implementing AI-driven applications using large language models (experience with Anthropic Claude strongly preferred).
• Prior experience serving as a technical lead or senior engineer with mentoring responsibilities.

Knowledge/Skills/Abilities

• Expert-level proficiency with Power BI, including semantic modeling, advanced DAX, row-level security, and performance optimization.
• Strong SQL skills and experience working with enterprise data warehouse platforms (e.g., Snowflake).
• Strong software engineering background with one or more programming languages (e.g., Python, C#, or similar).
• Deep understanding of LLM-based systems, including prompt engineering, agent design patterns, evaluation, and safety controls.
• Experience integrating AI agents with internal systems, APIs, and governed data sources under access and data-protection controls.
• Familiarity with protecting customer NPI in analytics and AI workflows (data classification, masking/redaction, and least-privilege access).
• Ability to establish and enforce engineering standards and guide architectural decision-making.
• Strong leadership, mentoring, and communication skills with the ability to influence without direct authority.
• Highly analytical, detail-oriented, and able to work under pressure of deadlines in a regulated environment.
• All candidates will be required to complete a pre-employment background check, credit check, and drug screening.

Preferred Skills

• Experience integrating AI capabilities into analytics or business intelligence platforms.
• Familiarity with cloud-based data platforms (e.g., Azure/Snowflake) and CI/CD practices.
• Experience in financial services or other regulated industries.
• Knowledge of data governance, security, and AI/model risk practices as applied to analytics and AI.

Physical Requirements

• Must exert up to 10 pounds of force occasionally and/or a negligible amount of force frequently.
• Sitting for long periods.
• Specific vision abilities required by this job include close vision and the ability to adjust focus.

Working Conditions

The working conditions are generally comfortable, with minimal exposure to noise, heat, dust, and other related items. All employees are required to maintain a neat and safe work area.