Data Engineering Business Analyst (San Francisco)

Data Engineering Business Analyst

Cooley is seeking a Data Engineering Business Analyst to join the Data Science & Engineering team.

Position summary: As the leading technology law firm in the world, Cooley is determined to become a leader in the digital practice of law. Reporting to the Director of Data Science, the Data Engineering Business Analyst will focus on data engineering analysis to support a data lake rollout and data migration initiative. This role will be responsible for collaborating with stakeholders to understand data requirements, document business needs, and translate them into actionable technical specifications. This role is crucial to ensuring the successful migration and integration of data while maintaining data quality, governance, and compliance standards. Specific duties and responsibilities include, but are not limited to, the following:

Position responsibilities:

• Collaborate with business stakeholders and clients to understand data requirements, objectives, and priorities for the migration project
• Conduct data analysis and profiling to gain insights into data pipelines, structures, and quality
• Document and prioritize business needs and requirements for the data lake and data migration
• Translate business requirements into detailed technical specifications and user stories for data engineering and development teams
• Partner with data engineers and architects to design and implement data pipelines, ETL processes, and data transformations
• Perform data validation, testing, and quality assurance to ensure accuracy, completeness, and consistency of migrated data
• Support business users and stakeholders during user acceptance testing (UAT) and post-migration activities
• All other duties as assigned or required

Skills and experience:

Required :

• After orientation at Cooley LLP, exhibit proficiency in the Microsoft Office suite, iManage and other firm applications
• Ability to work extended and/or weekend hours, as required
• Ability to travel, as required
• 3+ years of experience as a Business Analyst with a focus on data engineering, analysis, and requirements gathering for data migration projects
• Senior candidates must have 5+ years' directly applicable experience
• Strong understanding of data engineering concepts, methodologies, and tools, with hands-on experience with data lakehouses (e.g., Databricks, Snowflake, Azure Data Lake, Azure Data Factory, etc)
• Proficiency in SQL for data analysis, manipulation, and querying
• Familiarity with data governance and metadata management tools
• Exposure to cloud tools and integrations, particularly in enterprise-scale data management platforms.
• Understanding of relational, dimensional, and columnar data models
• Working knowledge of reporting tools such as Microsoft Power BI, Jupyter Notebooks, and similar platforms

Preferred :

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field
• Professional certifications related to Azure, Snowflake or Databricks integration
• Experience with Agile methodologies and project management practices
• Knowledge of performance tuning for large data volumes and enterprise-scale datasets
• Familiarity with Delta Live Tables, Databricks Unity Catalog, and other Databricks advanced features

Competencies :

• Comfortable assuming leadership roles in cross-functional, matrixed teams
• Excellent communication and interpersonal skills, with the ability to translate complex technical concepts to non-technical audiences
• Ability to influence and collaborate with multiple stakeholders across various departments (legal, IS, etc.)
• Strong analytical and critical thinking skills
• Strong written and verbal communication skills to collaborate with cross-functional teams and non-technical stakeholders effectively
• Ability to work independently and as part of a team in a dynamic, fast-paced environment
• Excellent analytical and problem-solving skills with attention to detail

Cooley offers a competitive compensation and excellent benefits package and is committed to fair and equitable employment practices.

EOE.

The expected annual pay range for this position with a full-time schedule is $100,000 - $145,000. Please note that final offer amount will be dependent on geographic location, applicable experience and skillset of the candidate. Senior level candidates may be considered for this position and would be eligible for a higher salary range based on experience.

We offer a full range of elective benefits including medical, health savings account (with applicable medical plan), dental, vision, health and/or dependent care flexible spending accounts, pre-tax commuter benefits, life insurance, AD&D, long-term care coverage, backup care for children and/or adults and other parental support benefits. In addition to elective benefit options, benefited employees receive firm-paid life insurance, AD&D, LTD, short term medical benefits as well as 21 days of Paid Time Off (PTO) and 10 paid holidays each year. We provide generous parental leave and fertility benefits. New employees will attend a detailed benefit orientation to learn more about our many benefits and resources.