Engineer: Financial Services

About the role

Mayer Brown is seeking an Engineer: Financial Services to join our Accounting and Analysis department in Chicago. This role supports and develops the Finance and Accounting department's data analysis, dashboarding, and reporting needs.

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 Enterprise Data team to develop scalable, reliable pipelines and ETL processes to manage the flow of data into, out of, and between these systems
• Acquires and feeds systems with appropriate data, maintains data cleanliness and accuracy, joins and relates data from disparate systems, prepares data for modelling, reporting, visualization and analysis, generates a variety of reporting outputs, leverages the Microsoft Power Platform and other tools
• 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
• 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, applies automation methods where appropriate
• 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 documentation, including process maps

Qualifications, Experience and Personal Attributes

• Bachelor’s degree in Computer Science, Finance, or another quantitative or technical field required. 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
• 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 3 years previous professional experience as a Data Analyst, Financial Analyst, Engineer, or similar role is 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 requirements and support the adoption of new data and reporting solutions is required
• History of working with team members across multiple offices is preferred
• Past experience with a law or other professional services firm is welcome, but not required

Technical Skills

• Proficiency in all Microsoft Office products required, including Visio
• Experience with enterprise relational database technologies is required, including but not limited to Microsoft SQL Server
• 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), Microsoft Power Platform experience, Scripting experience using SQL, Python, R, Power Query M, or PowerShell is preferred
• Knowledge of law firm practice management systems (Aderant or Elite) is preferred

Performance Traits

• 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
• 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
• Able 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
• Willing to challenge the status quo, and knows when to speak up while demonstrating tact

Physical Requirements

May require travel to other offices as needed

Compensation and Benefits

The typical pay scale for this position is between USD $95,000.00/Yr. and USD $126,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.