Senior Engineer: Financial Services

About the role

Mayer Brown is an international law firm representing major corporations, funds, and financial institutions in their most important and complex transactions and disputes. We are a collegial, collaborative firm where highly motivated individuals with an unwavering commitment to excellence receive the opportunity, support, and development they need to grow, thrive, and realize their greatest potential.

Responsibilities

• Rapidly builds and maintains a deep, current understanding of the firm’s “data landscape” – the key systems and databases used across the firm, how they are used, their data, data models and data integrations, with a specific focus on Finance & Accounting data
• Uses this understanding and knowledge to anticipate future needs and guide solution designs
• In partnership with the Enterprise Data team, leads the design and development of scalable, reliable pipelines and ETL processes to manage the flow of data into, out of, and between these systems in order to:
• Acquire and feed systems with appropriate data, using best practices
• Maintain data cleanliness, lineage, and accuracy while minimizing the potential for errors
• Join and relate data from disparate systems in an efficient manner
• Provide reliable environments for modelling, reporting, visualization and analysis
• Support a variety of reporting outputs, leveraging the Microsoft Power Platform and other tools
• Designs, optimizes, and provides governance of Finance data and semantic models supporting analytics, forecasting, and reporting, with a strong emphasis on scalability and maintainability
• Architects and tunes SQL, Python, and related data frameworks to build and optimize queries, views, functions, and pipelines, leveraging deep expertise in data schemas and tabular models
• Develops and oversees advanced Finance & Accounting and related dashboards and analytic applications in Power BI and other platforms, to enhance reporting, forecasting, and analysis capabilities
• Establishes and maintains standards for data modelling, DAX, information governance, deployment pipelines, and lifecycle management
• Ensures data is appropriately secured and compliant with firm policies, including access controls, entitlements, and auditability, and partners with IT and Financial Applications as needed
• Serves as a technical mentor to colleagues and elevates engineering standards and practices, proactively driving continuous improvement, automation, and governance across all Finance data products, services, and platforms

Qualifications, Experience and Personal Attributes

• Bachelor’s degree in Computer Science, Finance, or another quantitative or technical field required. An equivalent combination of education and/or experience may be considered in lieu of the degree when the experience has been directly related to the functions of the job.
• Advanced training or certifications in data engineering, cloud data platforms, data science, or analytics (e.g., Fabric Data Engineer, Azure Solutions Architect, Power BI) are preferred.
• Minimum 5 years of progressive experience as a Data Engineer, Financial Analyst, Data Analyst, or similar role, with demonstrated ownership of enterprise-grade data solutions supporting Finance functions is required.
• A strong track record of partnering with senior business stakeholders to elicit requirements, design scalable solutions, and drive adoption and organizational change is required.
• Experience working with organizational data warehouses, including the creation and management of the data residing within them, is required.
• Experience leading technical workstreams, mentoring engineers or analysts, and influencing cross-functional teams is preferred.
• History of working with team members across multiple offices, especially in a global setting, is preferred.
• Past experience with a law or other professional services firm is welcome, but not required.

Education/Training/Certifications

• Proficiency in all Microsoft Office products required, including Visio
• Deep expertise with enterprise relational database technologies is required, including but not limited to: Microsoft SQL Server Azure SQL Performance tuning for SQL queries and procedures
• Extensive experience with enterprise data management, integration, and analytical technologies is required, including but not limited to: Microsoft SQL Server Integration Services (SSIS) and other ETL tools Microsoft SQL Server Reporting Services (SSRS) Microsoft SQL Server Management Studio (SSMS)
• Advanced Microsoft Power Platform experience Power BI data modeling, metrics development, and information governance
• Experience with enterprise data warehousing platforms is preferred, including but not limited to: DataBricks (including PySpark)
• Scripting in Python, R, Power Query M, or PowerShell
• Fabric Lakehouse / Azure environments
• Knowledge of law firm practice management systems (Aderant or Elite) is preferred

Technical Skills

• Proficiency in all Microsoft Office products required, including Visio
• Deep expertise with enterprise relational database technologies is required, including but not limited to: Microsoft SQL Server Azure SQL Performance tuning for SQL queries and procedures
• Extensive experience with enterprise data management, integration, and analytical technologies is required, including but not limited to: Microsoft SQL Server Integration Services (SSIS) and other ETL tools Microsoft SQL Server Reporting Services (SSRS) Microsoft SQL Server Management Studio (SSMS)
• Advanced Microsoft Power Platform experience Power BI data modeling, metrics development, and information governance
• Experience with enterprise data warehousing platforms is preferred, including but not limited to: DataBricks (including PySpark)
• Scripting in Python, R, Power Query M, or PowerShell
• Fabric Lakehouse / Azure environments
• Knowledge of law firm practice management systems (Aderant or Elite) is preferred

Performance Traits

• Excellent written and verbal communication skills, with an ability to clearly articulate complex technical concepts to non-technical stakeholders at all levels of the firm and to external partners, and to communicate with various audiences effectively and in a professional manner
• Strong analytical and problem-solving abilities and able to approach complex systems with rigor and propose pragmatic, efficient solutions grounded in best practices.
• Strong organizational and time management, priority-setting, and troubleshooting skills, especially when responding to unanticipated business requirements, exercising sound judgment when operating under pressure in situations without perfect information or with shifting priorities
• Able to work in a diverse team environment and effectively support the demanding needs of the Firm
• Able to effectively communicate and influence others outside the direct chain of reporting
• Must be a proactive self-starter who anticipates needs, exercises a high level of initiative, and demonstrates strong customer service skills and independent judgment
• Exceptional attention to detail, organizational skills, and the ability to handle multiple projects
• Maintains confidentiality, exercises discretion, and models the firm's values
• Thoughtfully challenges the status quo, mentors others generously, and knows when to speak up while demonstrating a high level of tact

Physical Requirements

• May require travel to other offices as needed

Benefits

• Competitive compensation and comprehensive benefits, including medical/dental/vision/life/and AD&D insurance, 401(k) savings plan, back-up childcare and eldercare, generous paid time off (PTO), as well as opportunities for professional development and growth.
• We are committed to providing equal opportunity and reasonable accommodations to applicants and employees with disabilities and disabled veterans.

Contact Information

• To request an accommodation related to the application process or interview, please email uslateralrecruiting@mayerbrown.com.
• All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Pay Range

The typical pay scale for this position is between USD $113,000.00/Yr. and USD $150,000.00/Yr., although the actual wage or salary could be lower or higher if the candidate's education, experience, skills and internal pay alignment are different from those specified.