Senior Business Intelligence Engineer
Wilmer Cutler Pickering Hale and Dorr
- Miamisburg, OH
- Permanent
- Full-time
- Responsible to ensure alignment between the data analytics platforms (Data warehouse) environment and business requirements
- Extends existing and creates new MS SQL Analysis Services Tabular Cubes using new members, measures using DAX scripting languages, tables, relationships, and roles
- Extends existing and creates new PowerBI models using new members, measures, tables, relationships, and roles, in direct query and import models
- Creates and delivers end-user training and documentation and provides second-line support to power users who develop reports on behalf of their departmental colleagues
- Performs application deployments, upgrades, and patch planning
- Participate and contribute to daily scrum meetings
- Maintains awareness of technology developments and makes recommendations to the Manager, Data Analytics Services
- Participates in software licensing and support agreement discussions
- Assists with resolution of escalated incidents and participates in problem management activities. Assumes ownership of level 3 support and troubleshooting of assigned data solutions
- Assists in evaluating the business relevance and requirements of projects under consideration
- Maintain existing data solutions, design and build from the ground up new data solutions including data warehousing dimensional models
- Mentor junior developers
- Assumes additional responsibilities as assigned
- Contributes to the firm's Service Excellence initiative to consistently improve its image internally and externally. Displays professionalism, quality service and a "can do" attitude to internal members/departments of the firm as well as external clients and vendors via electronic and print correspondence, over the telephone and in-person.
- Excellent analytical skills, including the ability to perform advanced research that involves interpretation and analysis of data from a variety of sources
- Translation of business questions and requirements into reports, views, and SQL queries
- Expert knowledge of data warehouse architecture, data design patterns and data transformation best practices in environments of medium to large volume of data
- Advanced experience in tunning T-SQL query performance, identifying the need and creation of SQL indexes
- Advanced hands-on experience with T-SQL, data warehouse concepts including dimensional modeling
- Strong problem-solving and tenacity in creating solutions for complex and performant data challenges while handling hundreds of millions of records
- Intermediate to advance knowledge of DAX
- Knowledge in at least one scripting language for predictive analytics and data visualization. (R or Python) is a plus
- Hands on expertise with implementation of a MS Analyses Services Cube using the Tabular model and PowerBI data models is required
- Working knowledge in developing Azure Data Factory is a plus
- Good knowledge of server hardware, server storage and other infrastructure, client/server applications, and server utilities
- Expert knowledge of SQL Server 2016/2019/2022 and strong T-SQL skills is required
- Strong discipline in following SQL coding styles which improves code readability and supportability
- Experience supporting a 24x7 production environment
- Ability to work effectively with both users and technical staff in team-oriented environments
- Excellent oral and written communication skills and interpersonal skills including the ability to effectively communicate technical information to both technical and non-technical personnel
- Ability to work successfully and independently in an atmosphere of multiple projects, shifting priorities, and deadline pressures
- Working knowledge of Information Technology Infrastructure Library (ITIL), Microsoft Operations Framework, ISO 9000 or similar process discipline is preferred
- 8-10 years’ experience in data analysis and data warehousing, with significant specialization in one or more areas of the above-mentioned areas of technology
- Experience with legal financial data models is a plus
- 5 years of DAX scripting experience