Senior Data Architect

April 27, 2026

Other Jobs To Apply

Location: Seattle, WA or San Francisco, CA or Remote (Full-time and Remote or Partially Remote) We are seeking a highly skilled Senior Data Architect to lead the design, management, and maturity of the firm’s enterprise data ecosystem. This role owns the architecture and reliability of the LNW data warehouse, reporting platforms, and integration pipelines that power analytics across the organization. The ideal candidate will combine deep SQL and data engineering expertise with a strong understanding of financial services, data flows, and reporting needs of a wealth management firm. Your Role and Responsibilities Data Architecture & Engineering <ul><li class="MsoNoSpacing">Own the design and long-term architecture of the firm’s enterprise data warehouse and data pipelines </li><li class="MsoNoSpacing">Develop and maintain scalable SQL data models supporting firm metrics, critical data needs, client reporting, and operational analytics. </li><li class="MsoNoSpacing">Build and maintain ETL/ELT pipelines, replication strategies, and processes to align data across portfolio accounting, CRM, trading, and operational systems. </li><li class="MsoNoSpacing">Design data ingestion frameworks for large structured files, API integrations, and replication feeds. </li></ul>Reporting & Analytics Platforms <ul><li class="MsoNoSpacing">Maintain and optimize reporting infrastructure including Power BI, SSRS, and related semantic models. </li><li class="MsoNoSpacing">Partner with business leaders to deliver dashboards supporting firm metrics, revenue reporting, and operational insights. </li><li class="MsoNoSpacing">Develop & maintain Bulk Document Management Dashboard for portal delivery of performance reporting and other document types currently operationalized. </li><li class="MsoNoSpacing">Ensure reporting models are performant, well documented, and scalable. </li></ul>Data Governance & Quality <ul><li class="MsoNoSpacing">Establish standards for data quality, lineage, documentation, and lifecycle management. </li><li class="MsoNoSpacing">Implement monitoring and validation processes to ensure accuracy of critical financial and operational data. </li><li class="MsoNoSpacing">Partner with compliance and leadership to ensure proper governance and obfuscation of sensitive client data. </li><li class="MsoNoSpacing">Manage Data Backup and retention policies, Recovery Time Objectives (RTO). </li></ul>Integration, Automation, & Agentic AI <ul><li class="MsoNoSpacing">Design integration frameworks using SQL, APIs, and automation platforms such as Azure Data Factory (ADF), SSIS and Workato. </li><li class="MsoNoSpacing">Support data synchronization between systems including CRM, portfolio accounting, billing, and trading platforms. </li><li class="MsoNoSpacing">Leverage Autonomous AI into integration frameworks using MCP or 3rd party harnesses to support decision-driven automation and delivery. </li><li class="MsoNoSpacing">Enable LNW’s responsible use of AI and advanced analytics by ensuring enterprise data is accurate, well-structured, and accessible to analytical tools. </li><li class="MsoNoSpacing">Deliver high-quality datasets for AI consumption, implementing governance and lineage controls to ensure trustworthy outputs, and supporting integration with platforms such as Microsoft Copilot, Power BI AI features, and other approved analytical tools. </li><li class="MsoNoSpacing">Automate data processing workflows to improve operational efficiency and reduce manual intervention. </li></ul>More About You Experience and Education <ul><li class="MsoNoSpacing">7+ years of experience in data engineering, data architecture, or data warehouse development. </li><li class="MsoNoSpacing">Expert-level SQL skills with deep experience designing relational data models. </li><li class="MsoNoSpacing">Strong experience with Salesforce SOQL, SQL Stored Procedures, Views, Keys, Indexes and Constraints. </li><li class="MsoNoSpacing">Strong experience with data warehouse architecture and ETL/ELT pipeline design. </li><li class="MsoNoSpacing">Hands-on experience with reporting tools such as Power BI and SSRS. </li><li class="MsoNoSpacing">Experience integrating enterprise SaaS platforms using APIs and automation tools. </li><li class="MsoNoSpacing">Strong analytical thinking and ability to translate business reporting needs into scalable data models. </li></ul>Preferred Skills & Attributes <ul><li class="MsoNoSpacing">Experience in wealth management, investment management, or financial services. </li><li class="MsoNoSpacing">Experience with portfolio accounting systems, CRM platforms, and trading systems. </li><li class="MsoNoSpacing">Experience managing enterprise data warehouses on Microsoft SQL Server. </li><li class="MsoNoSpacing">Experience with SSIS, Python data pipelines, and/or similar integration tools. </li></ul>Candidates must meet all employment qualifications in force at time of hiring, including successful passing of background & credit checks and any pre-employment examinations, signing of all employee agreements, and have the ability to perform the essential functions, duties and responsibilities set forth in a consistent and efficient manner. Reports to: Chief Operating Officer and General Counsel Compensation and Benefits We provide a competitive salary commensurate with your experience and skills and offer an annual bonus based on company and individual performance. The hiring salary range for this position in Seattle is $115,000 to $150,000, in San Francisco is $130,000 to $170,000, and Remote from $100,000 to $135,000 depending on experience. The salary range applies to the current posting and may change in the future. The range may vary based on key factors such as education, job-related knowledge, experience, skill set, and geographic location. We offer excellent benefits including medical, dental and vision coverage, generous time off (including sabbaticals), flexible spending plans for health care and dependent care, 401(k) plan, educational reimbursements. For details of all benefits, please visit our website <a href="https://lnwadvisors.com/people/careers/" target="_blank" rel="noopener">here</a>. About Us For more than five decades, Laird Norton Wetherby (LNW) has served the interests of exceptional families and individuals. As both an RIA and trust company, LNW offers a full spectrum of specialized wealth & legacy planning, investment management and trust & estate services that advance the aspirations and long-term, multigenerational financial ambitions of its clients. LNW has offices in Seattle, San Francisco, New York, Los Angeles and Philadelphia, as well as an affiliate trust company in South Dakota, empowering clients across the U.S. LNW is majority owned by Laird Norton Company, one of the longest-sustained family enterprises in the United States, as well as by active employees. Additional Information Our firm aims to cultivate an inclusive environment and culture that fosters growth, collaboration and acceptance; where we celebrate the diverse voices and perspectives of our employees; and where employees feel empowered to bring their full, authentic selves. Our diversity drives us forward and helps us build deeper relationships with our clients and our community. The firm is an equal opportunity employer and prohibits discrimination against employees, applicants for employment, individuals providing services in the workplace pursuant to a contract, unpaid interns and volunteers based on their actual or perceived sexual orientation, gender, gender identity, gender expression, ancestry, marital status, registered domestic partner status, military and veteran status, civil air patrol status, national origin, immigration status, pregnancy (including childbirth and related medical conditions, and including medical conditions related to lactation) or medical condition (cancer and genetic characteristics). *As of 04/13/2026

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...

DISCLAIMER