Engineer: Financial Services

Mayer Brown is an international law firm positioned to represent the world’s major corporations, funds, and financial institutions in their most important and complex transactions and disputes. We are recognized by our clients as strategic partners with deep commercial instincts and a commitment to creatively anticipating their needs and delivering excellence in everything we do.
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 all while supporting the Firm’s client service principles of excellence, strategic partnership, commercial instinct, integrated strengths, innovation, and collaboration across our international firm.
If you thrive in a collaborative environment that values exceptional client service, initiative, professionalism, responsiveness, and adaptability, we invite you to consider joining our Accounting and Analysis department in our Chicago office as an Engineer:
Financial Services.
The Engineer:
Financial Services is responsible for the support and development of the Finance and Accounting department’s data analysis, dashboarding & reporting needs. The incumbent will move and transform data so that it can be easily analyzed, visualized and worked upon by the business user community.
The Engineer will guide both business and technical users through the process of identifying and locating the data they need to solve their business needs, and to ensure that the users are able to securely access that data. The incumbent will partner and work closely with existing Finance and IT leadership and subject-matter experts, including the Enterprise Data, FP&A, Revenue Cycle Operations, Pricing & Matter Performance, Rates Management, Billing Operations, AR, AP, Business Intelligence, Financial Applications, and Project Management teams.

Extensive collaboration with these teams will be a key driver for success in this role.
Responsibilities

Essential Functions:

• Rapidly builds and maintains an 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
• Works with the Enterprise Data team to develop 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
• Maintain data cleanliness and accuracy
• Join and relate data from disparate systems
• Prepare data for modelling, reporting, visualization and analysis
• Generate a variety of reporting outputs, leveraging the Microsoft Power Platform and other tools
• Works with our Senior Engineer in the design and implementation of new data models that may pertain to Finance & Accounting, and the other teams mentioned above
• Designs and builds SQL queries, views, functions, and stored procedures
• Develops and implements various Finance & Accounting and related dashboards in Power BI and other platforms
• Adheres to established data modeling and information governance standards
• Provides technical assistance and guidance to others, both within and outside of IT, helping them to locate and access the data they need, exercising judgment to choose between self-service and more interactive solutions
• Collaborates with our Enterprise Data team to build a strong community of expertise to support the development and delivery of the firm’s enterprise data strategy
• Designs, builds and tests data structures, pipelines, and reporting process/systems in a sustainable manner, applying automation methods where appropriate
• Participates in vendor engagements and solution assessments in coordination with the team
• Builds knowledge and expertise to support the solutions and applications built by the Global Financial Technology & Strategy team
• Participates in the evaluation of new financial products/applications deemed to be appropriate for the Firm’s business, as required
• Writes, develops and reviews design, interface, user, functional, and technical design…