Data Engineer, Finance Technology & Digital Transformation
Company: Wilson Sonsini Goodrich & Rosati, Professional
Location: Palo Alto
Posted on: April 2, 2026
|
|
|
Job Description:
Wilson Sonsini is the premier legal advisor to technology, life
sciences, and other growth enterprises worldwide. We represent
companies at every stage of development, from entrepreneurial
start-ups to multibillion-dollar global corporations, as well as
the venture firms, private equity firms, and investment banks that
finance and advise them. The firm has approximately 1,100 attorneys
in 17 offices: 13 in the U.S., two in China, and two in Europe. Our
broad spectrum of practices and entrepreneurial spirit allow
exceptional opportunities for professional achievement and career
growth. We are currently seeking a Data Engineer to join the
Finance Technology and Digital Transformation team in our Finance
Department. This role will support the rapid growth of FinTech
across many departments at the firm. This position is available for
a hybrid work schedule (two days per week onsite). Essential Duties
and Responsibilities: Adapt and optimize firm-standard ETL/ELT data
pipelines to ensure accurate and timely data integration to and
from firm data repositories. Manage finance-related data models,
schemas, and structures to support analytics and reporting needs.
Translate complex business requirements into intuitive and
actionable reports. Partner with business stakeholders to define
KPIs and ensure consistent reporting standards. Integrate
firm-level information security policies and processes to ensure
data accuracy, integrity, and security. Monitor and troubleshoot
data workflows, ensuring performance optimization. Support firm
data governance practices and DLP policies, including data
classification, access controls, documentation and change
management procedures. Work closely with business analysts, data
scientists, and IT teams to ensure compliance, mitigate risk and
deliver full-cycle data solutions. Mentor junior data specialists,
analysts, and other engineers, and contribute to the firm’s best
practices and technical standards. Be a key contributor and
resource to the firm’s overall data strategy and architecture,
including the development of best practices and procedures for
developing and providing reports, dashboards and other data
services throughout the firm. Education and Work Experience
Requirements: Bachelor’s or master’s degree in computer science,
Information Systems, Data Engineering, or related field. 8 years of
hands-on experience in data warehouse development and optimization,
ETL/ELT development, and SSRS reporting solutions. Strong expertise
in SQL (query optimization, stored procedures, indexing).
Proficiency with Azure data lake/warehouse technologies (Azure
Synapse, Azure Databricks, Microsoft Fabric, etc.). Experience with
ETL tools (Informatica, Talend, SSIS, dbt, or similar). Solid
understanding of data modeling (star schema, snowflake schema,
OLAP/OLTP concepts). Knowledge of cloud platforms (Azure) and
modern data stack tools. Strong problem-solving, analytical, and
communication skills. The primary location for this job posting is
in Palo Alto, but other locations may be listed. The actual base
pay offered will depend upon a variety of factors, including but
not limited to the selected candidate’s qualifications, years of
relevant experience, level of education, professional
certifications and licenses, and work location. The anticipated pay
range for this position is as follows: Palo Alto, San Francisco:
$131,750 - $178,250 per year.&xa; The compensation for this
position may include a discretionary year-end merit bonus based on
performance. We offer a highly competitive salary and benefits
package. Benefits information can be found here . Equal Opportunity
Employer (EOE).
Keywords: Wilson Sonsini Goodrich & Rosati, Professional, Vallejo , Data Engineer, Finance Technology & Digital Transformation, IT / Software / Systems , Palo Alto, California