Lead Data Engineer

Annual Salary Range Lead IT Analyst: $112,497 - $149,972

FLSA Exempt / Union Represented

This position allows for up to four days of remote work per week

The Office of Information Technology (IT) is responsible for enabling State Bar’s internal and external stakeholders by the management, implementation, and maintenance of an organization's technology to support of State Bar’s mission and goals. The office’s primary goals are to build and maintain functional capabilities, to support innovation and to ensure that all systems are running smoothly, efficiently, and securely to support the needs of the organization and its stakeholders.

The Office of Information Technology is seeking a Lead Data Engineer to join our dynamic team at the State Bar of California. In this role, you will define and drive the modernization of our data infrastructure using Microsoft cloud technologies. As the technical authority for the Bar’s data platform, you will lead the development of scalable, automated data pipelines, establish governance standards, and guide cross-functional teams to deliver data driven solution that support Analytics, AI, compliance, and operational efficiency.

The ideal candidate is a hands‑on technical leader with experience in building scalable, cloud‑based data solutions. This individual brings a strong understanding of modern data architectures, data integration patterns, and secure design principles and is capable of driving architectural decisions that align with long‑term business goals.

They have demonstrated success in leading cross‑functional collaboration, setting standards for data quality and governance, and building reusable data frameworks that support analytics, automation, and decision making.

A clear understanding of compliance standards (e.g., PII, PCI, HIPAA, CPRA) and experience applying those principles in large scale environments is essential. Microsoft certification in one or more of the following is strongly desired:
Azure Data Engineer Associate;
Power BI Data Analyst Associate;
Azure Solutions Architect Expert; or any other data analysis‑related certifications.

With minimum direction, the Lead IT Analyst provides technical leadership and direction for major IT projects, and/or serves as the technical authority for one or more related functions, including: network operating systems; software applications; data analytics applications, project/program management; product management; desktop support; system engineering; network infrastructure; database management; cloud services administration; and web server management. The Lead IT Analyst performs advanced, highly specialized IT work involving the business requirements, analysis, product roadmaps, planning, project management, architecture, designing, implementation, maintenance, troubleshooting, and/or enhancement of complex IT systems and procedures, and may serve in a lead capacity over other IT analysts and support staff.

Duties may include, but are not limited to the following:

• Lead the design, development, and maintenance of scalable data pipelines using Azure Data Factory, Synapse Analytics, and Data Lake Storage to ingest, transform, and publish structured and unstructured data.
• Drive the automation of end‑to‑end and event‑driven workflows using Azure Logic Apps, ensuring real‑time or scheduled data synchronization and integration with external systems.
• Direct enterprise‑level data modeling and transformation efforts to support reporting, dashboards, and analytics, including validation and quality checks to ensure consistency and reliability.
• Guide and collaborate with IT and business teams to gather data requirements, define transformation logic, and develop shared documentation such as the data dictionaries.
• Develop and oversee enhancements of the Azure‑based data architecture, focusing on scalability, reusability, and long‑term maintainability.
• Establish and implement data governance standards, including metadata management, lineage tracking, and data privacy and security controls aligned with organizational compliance needs.
• Optim…