McDermott Will & Emery is a leading global law firm helping to propel the success of today’s most respected, dynamic, and important organizations. More than 1,200 lawyers strong, we bring our personal passion and legal prowess to bear in every matter for our clients and the people they serve. Pride and determination abound here because every member of our team is respected, supported, and inspired to exceed. We have been recognized as a top firm to work by The American Lawyer, Working Mother Magazine, Vault, and the Human Rights Campaign for both lawyers and business professionals.

As part of our ongoing commitment to be #AlwaysBetter for our people, clients, and communities, we have created a culture of belonging that champions your individuality and authenticity as both a person and a professional. From our competitive compensation, top benefits and award-winning professional development programs to industry-leading wellness initiatives, we support you through every stage of your life and career so you can live a life you love both in and outside of the office.

Position Summary:

The Business Intelligence Engineer facilitates the adoption and use of enterprise data to provide reporting and insights to improve business operations and decision making. This position advises on best practices for life cycle management of the BI environment, works with leadership to develop and refine a BI strategy around governance and adoption, and contributes to development of specific BI reports, dashboards and data driven solutions. The Business Intelligence Engineer engages with stakeholders to gain an understanding of their BI goals and objectives and to ensure successful implementation.

As a Business Intelligence Engineer, you will:

• Gather, document, and prioritize business requirements and assist in developing solution design specifications
• Collaborate with data architect(s) to identify systems of record for key enterprise data, define data cleansing and completeness processes for source systems
• Evaluate and report on effectiveness and usability of solutions based on quantitative usage data and qualitative discussions with end-users and business stakeholders
• Analyze and validate data warehouse contents (key dimensions and facts) relative to source enterprise systems
• Partner with business stakeholders to understand their specific reporting needs and requirements, and develop interactive reports and dashboard using the Microsoft Power BI platform (including DAX)
• Coordinate with technical team in specifying data needs for solutions and provide associated ETL requirements for Data Warehouse, Data Mart, SharePoint List, or other structured data sources
  Advise leadership in establishing and refining a firm wide Analytics governance and adoption strategy
• Provide thought leadership, best practices, and standards related to effectively managing an analytics technology platform based on Power BI and an Enterprise Data Warehouse
• Advise on approaches to evaluate and measure the effectiveness of solutions based on quantitative usage data and qualitative discussions with end-users and business stakeholders
• Provide meaningful feedback and coaching of technical and non-technical team members in appropriate use of Microsoft analytics technologies

Job Specifications:

• At least four (4) years of experience in business intelligence and/or information management
• At least two (2) years of experience with data visualization and implementing high-value solutions
• Advanced knowledge of Microsoft Analytics technologies (Power BI, DAX, Power Query, Azure Analysis Services)
• Advanced knowledge of Analytics data management concepts and techniques, including Data Warehouse, Data Marts, ETL and associated best practices
• Advanced Knowledge of SQL and database concepts
• Knowledge of other M365 technologies (Power Apps, Power Automate, Teams, SharePoint) and how they can used in conjunction with Power BI to provide comprehensive solutions
• Knowledge of change management around adopting a large-scale analytics program
• Strong written and verbal communication skills
• Strong analytical and organizational skills
• Ability to work in an agile development environment
• Ability to work effectively in a fast-paced and changing environment

Physical Demands and Work Environment:

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical Demands:

• While performing the duties of this job, the employee is required to sit, use hands, reach with hands and arms, stoop, talk and hear
• Employee must occasionally lift up to twenty (20) pounds

Work Environment:

Typical indoor office environment

Disclaimer:

The above statements are intended to describe the general nature and level of the work being performed by people within this classification. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of employees assigned to this job..

• GQ1

Successful candidates will be provided with outstanding career opportunities and will receive a competitive total rewards package with the opportunity to earn performance-based bonuses.

Expected Pay Range in New York $120,000 – 152,000

Expected Pay Range in Los Angeles & Orange County $109,000 – 139,000

Expected Pay Range in San Francisco & Silicon Valley $125,000 – 159,000

Please note that quoted salary ranges are not guarantees of what final salary offers may be. Base pay is based on market location and may vary depending on job-related knowledge, skills, and experience. Base pay is only one part of the Total Rewards that MWE provides to compensate and recognize our staff professionals for their work. Full time positions are eligible for a discretionary bonus and a comprehensive benefits package.