Leads enterprise data architecture, SQL Server administration, data warehouse design, ETL/ELT pipelines, Azure data platforms, data governance, master data management, and business intelligence strategy. Partners with business and IT stakeholders to deliver scalable analytics solutions across financial, HR, CRM, operational, and practice management systems. Provides technical leadership, vendor coordination, architecture documentation, and mentorship.
JOB TITLE: Senior Enterprise Data Architect
OFFICE LOCATION: Open
DEPARTMENT: Information Systems
REPORTS TO: Director of Development Services
FLSA STATUS: Full time/ Exempt
JOB SUMMARY: Saul Ewing is seeking a Senior Enterprise Data Architect to serve as the firm's senior technical authority for enterprise data architecture, governance, analytics, and platform engineering. Reporting to the Director of Development Services, this individual will lead the strategic design and administration of the firm's SQL Server environments, enterprise data warehouse, ETL/ELT pipelines, and Azure cloud capabilities while establishing data governance standards and delivering scalable business intelligence solutions across financial, operational, HR, CRM, and practice management platforms firmwide.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIES:
Data Architecture & Platform Engineering
- Design and govern the firm's enterprise data architecture, including data warehouse, data integration, and analytics platforms
- Lead SQL Server environment administration, performance tuning, and database architecture across enterprise systems
- Develop and maintain dimensional data models, entity-relationship models, and enterprise data structures
- Architect and implement ETL/ELT pipelines, API integrations, and data feeds connecting core firm systems
- Evaluate and integrate Azure data technologies and cloud data platform capabilities into the firm's data strategy
Data Governance & Standards
- Establish and maintain authoritative system-of-record designations, data definitions, and metadata standards across the enterprise
- Implement and evolve master data management (MDM) practices, data ownership models, and data quality frameworks
- Define and enforce data governance policies in accordance with firm information security and compliance requirements
- Collaborate with stakeholders to ensure consistent, reliable data across financial, HR, CRM, and operational platforms
Reporting & Analytics Enablement
- Lead the strategy, design, and delivery of the firm's reporting platforms and business intelligence infrastructure
- Partner with firm leadership and department heads to translate business requirements into scalable data solutions
- Improve and expand access to reliable business information to support executive and operational decision-making
- Assess emerging data technologies and recommend adoption strategies aligned with the firm's long-term data roadmap
Collaboration & Technical Leadership
- Serve as the firm's senior technical resource on all enterprise data matters, acting as a trusted advisor to IT and business stakeholders
- Engage with vendors, system integrators, and professional services partners to evaluate and implement data solutions
- Document data architectures, integration specifications, and governance standards to support institutional knowledge
- Provide technical guidance and mentorship across the IT team on data-related disciplines
KNOWLEDGE AND SKILLS REQUIRED:
- Proven experience designing enterprise data warehouses using dimensional modeling methodologies (Kimball, Inmon, or hybrid)
- Demonstrated experience with ETL/ELT development, data pipeline architecture, and API-based system integrations
- Hands-on experience with Azure data technologies (e.g., Azure SQL, Azure Data Factory, Azure Synapse, or equivalent)
- Strong knowledge of data governance principles, master data management, metadata standards, and data quality practices
- Experience supporting enterprise systems spanning finance, HR, CRM, and operations within a professional services environment
- Excellent communication and stakeholder engagement skills, with the ability to translate complex technical concepts for non-technical audiences
EDUCATION AND EXPERIENCE REQUIREMENTS:
- Bachelor's degree in Computer Science, Information Systems, or a related field; equivalent professional experience will be considered
- 7+ years of progressive experience in enterprise data architecture, data engineering, or a closely related discipline
- Expert-level proficiency in Microsoft SQL Server administration, database design, and advanced T-SQL development
Preferred
- Experience in a legal, professional services, or similarly complex, multi-office organization
- Familiarity with legal technology platforms and practice management or financial management systems
- Microsoft Azure or other relevant cloud data platform certifications
- Experience with modern BI reporting platforms and analytics visualization tools
- Knowledge of information security frameworks and data privacy compliance practices
PAY TYPE: Salaried
COMPENSATION:
The pay for this position will be determined based on relevant skills, experience, education, external market data, internal equity, and other job-related factors. The anticipated pay range for this role is between $140,000 - $170,000 annually.
Saul Ewing follows a hybrid work schedule. Candidates must reside within a reasonable commuting distance of one of our office locations.
Similar Jobs
Financial Services
Provides high-level administrative support to the Business Banking team through complex calendar management, meeting and event coordination, domestic and international travel arrangements, expense processing, onboarding and offboarding support, document maintenance, communications, and presentation preparation. The role requires discretion, strong organization, professional communication, and the ability to manage competing priorities while working fully onsite five days per week.
Top Skills:
MS Office
Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Conducts on-site factory inspections and audits to verify products, components, markings, records, testing, calibration, and certification compliance. Prepares inspection and non-conformance reports, schedules site visits, witnesses tests, and supports corrective actions. Builds customer relationships, resolves technical and administrative issues, supports product launches and certification services, and promotes additional UL Solutions offerings. Requires extensive travel, including driving and air travel, within an assigned territory.
Top Skills:
Calibration And Measurement EquipmentUl Solutions Certification Standards
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handles inbound calls and warm leads, consults customers on insurance needs, recommends appropriate property and casualty coverage, and converts prospects into policyholders. The role includes paid licensing and training, customer service, sales closing, and schedule flexibility. Employees must complete remote-work requirements, maintain high-speed wired internet, and work four weekdays plus one weekend day. A Property and Casualty license is required after hire.
Top Skills:
PcWired High-Speed Internet
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
