Financial Applications Data Engineer - Mayer Brown LLP

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, and diverse 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 Information Technology department in our Chicago office as a Financial Applications Data Engineer.

The Financial Applications Data Engineer is responsible for the support and development of the Finance & Accounting department’s data analysis, dashboarding & reporting needs. The Data Engineer 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 Data Engineer will partner with existing analytic & reporting Finance & Accounting staff.

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 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 Microsoft Power BI and other tools
• Works with our Enterprise Data Architect in the design and implementation of new data models that may pertain to Finance & Accounting
• Designs and build sSQL queries, views, functions and stored procedures
• Develops and implements various Finance & Accounting and related dashboards
• Provides technical assistance and guidance to others, both within and outside of IT, helping them to locate and access the data they need
• Works 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 and reporting process/systems
• Accountable for software support related to department’s customized or packaged financial applications
• Participates in rotational 24 x 7 application support ensuring that the application portfolio uptime is maintained according to defined SLA’s
• Participates in the evaluation of new financial products/applications deemed to be appropriate for the Firm’s business
• Develops and reviews data design, interface, user, functional and technical design documentation
• Performs relevant support for financial applications supported by the Firm

Education/Training/Certifications:

• Bachelor’s degree in Computer Sciences. 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
• Data engineering certifications (e.g. Azure Certified Data Engineer) are a plus

Professional Experience: 

• Minimum 2 year previous professional experience as a Data 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

Technical Skills: 

• Proficiency in Microsoft Office products
• Experience with Enterprise Relational Database Technologies, including but not limited to:
  • Microsoft SQL Server (on-premises)
  • Azure SQL (cloud)
• Experience with Enterprise Data Management Technologies, including but not limited to:
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Reporting Services (SSRS)Microsoft Power Platform experience
  • Experience with Enterprise Data Warehousing Technologies, including but not limited to:
  • Azure SQL Data Warehouse / Azure Dedicated Pools
  • Iridium Dashboards experience a plus
  • Cognos Analytics experience a plus

Performance Traits:

• Strong written and verbal communication skills, able to communicate effectively and in a professional manner with all levels of the Firm and outside vendors
• Strong analytical and problem-solving skills with an ability to investigate and assess complex systems to propose technical solutions
• Strong organization and time management skills, priority-setting, and troubleshooting, 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, 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
• Willing to challenge the status quo

Physical Requirements:

• May require occasional lifting of up to 20 lbs.
• May require travel to other offices as needed

The above is a general description of the essential duties associated with this position and does not represent an exhaustive or comprehensive list of all duties.

The Firm may modify and amend this job description at any time at its sole discretion. Nothing herein creates a contract of employment or otherwise modifies the at-will nature of employment.

We offer 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.

Thank you for your interest in Mayer Brown. We are committed to providing equal opportunity and reasonable accommodations to applicants and employees with disabilities and disabled veterans. To request a reasonable accommodation related to the application process and/or job 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 status as a protected veteran.