Engineer: Financial Services

Mayer Brown•Chicago, IL

1d•$94,000 - $124,000•Hybrid

About The Position

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 enjoy working with team members whose defining characteristics are exceptional client service, initiative, professionalism, responsiveness, and adaptability, you may be the person we are seeking to join 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 & 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. They 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 & IT staff, including the Revenue Cycle Operations, Billing Operations, AR, AP, FP&A, Pricing, Rates Management, Data & Analytics, Business Intelligence, Financial Systems, and Project Management teams.

Requirements

Bachelor’s degree in Computer Science, Finance, or another quantitative or technical field. 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
Minimum 3 years previous professional experience as a Data Analyst, Engineer, Financial Analyst, or similar role required
Experience working with organizational data warehouses, including the creation and management of the data residing within them required
Experience developing relationships with key business stakeholders to understand business requirements and support the adoption of new data and reporting solutions required
Proficiency in all Microsoft Office products required, including Visio
Experience with Enterprise Relational Database Technologies required, including but not limited to: Microsoft SQL Server Azure SQL
Experience with Enterprise Data Management Technologies required, including but not limited to: Microsoft SQL Server Integration Services (SSIS) Microsoft SQL Server Reporting Services (SSRS) Microsoft SQL Server Management Studio (SSMS) Microsoft Power Platform experience
Experience with Enterprise Data Warehousing Technologies, including but not limited to: Azure SQL Data Warehouse / Azure Dedicated Pools
Strong written and verbal communication skills, able to communicate with various audiences effectively and in a professional manner, at all levels of the Firm, and with outside vendors
Strong analytical and problem-solving skills with an ability to investigate and assess complex systems to propose technical solutions, and explain them to a non-technical audience
Strong organizational and time management, priority-setting, and troubleshooting skills, especially when responding to unanticipated business requirements
Ability 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
Ability to work under pressure, and meet deadlines with shifting priorities
Must be a self-starter with a high level of initiative
Strong customer service skills, able to anticipate needs and exercise independent judgment
Strong attention to detail, organizational skills and the ability to handle multiple projects
Maintains confidentiality and exercises discretion

Nice To Haves

Data engineering certifications (e.g. Azure Certified Data Engineer) are a plus
History of working with team members across multiple offices preferred, especially in a global setting
Cognos Analytics or Tableau experience preferred

Responsibilities

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 Data Architecture team, develops 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 the data they require
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 Enterprise Data Architect in the design and implementation of new data models that may pertain to Finance & Accounting, and the other teams mentioned above
Designs and build SQL queries, views, functions and stored procedures
Develops and implements various Finance & Accounting and related dashboards in Power BI and other platforms
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 Architect and Data Engineers in other functions to build a strong community of expertise that supports the development and delivery of the firm’s data strategy
Designs, builds and tests data structures, pipelines, and reporting process/systems in a sustainable manner, applying automation methods where appropriate
Accountable for software support related to department’s customized or packaged financial applications
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 documentation
Provides relevant support for financial applications supported by the Firm