Data Engineer, Finance Technology & Digital Transformation

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. 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). careers.wsgr.com Wilson Sonsini is the premier legal advisor to technology, life sciences, and growth enterprises worldwide, as well as the venture firms, private equity firms, and investment banks that finance them. We represent more than 300 public enterprises and 3,000 private companies in a wide range of today’s cutting-edge industries, from AI and fintech to life sciences and mobility. For more than 60 years, our attorneys and professional staff have created a unique working environment. With deep roots in the fast-paced and innovative world of Silicon Valley, the firm fosters an entrepreneurial spirit and team-oriented approach for all employees, providing professional and personal development opportunities and encouraging all departments to promote a stable and optimal work/life balance. Wilson Sonsini is committed to creating a diverse and inclusive workforce globally. We have built a culture in which employees of all backgrounds, viewpoints, and experiences are encouraged and empowered to achieve their maximum potential. Our firm is consistently recognized among the top law firms in annual diversity rankings. For example, Wilson Sonsini ranked No. 2 among firms with more than 601 attorneys in Law360’s 2025 Diversity Snapshot. Additionally, in 2025, for the seventh consecutive year, Wilson Sonsini achieved Mansfield Plus Certification, and in 2026, for the sixth consecutive year, the firm achieved a top score of 100 on the Human Rights Campaign Foundation’s Corporate Equality Index. We are also dedicated to enhancing the communities in which we live and work by providing legal services, financial support, and volunteer services to worthy agencies and individuals in need. In 2025, Wilson Sonsini attorneys and staff provided more than 80,500 pro bono hours, participated in 125 community service projects, and raised over $130,000 for charitable organizations and causes. In addition, the Wilson Sonsini Foundation contributed more than $2.35 million to 112 law-related organizations and 129 community organizations in 2025. Wilson Sonsini has 17 offices in 16 technology and business hubs worldwide. Austin, TX Boston, MA Boulder, CO Brussels, Belgium Century City, CA Hong Kong London Los Angeles, CA New York, NY Palo Alto, CA Salt Lake City, UT San Diego, CA San Francisco, CA Seattle, WA Shanghai (China) Washington, D.C. Wilmington, DE