Business Intelligence Developer
MassMutual Data Analytics is seeking an experienced, versatile, highly motivated BI Developer to join our team. The Business Intelligence (BI) Developer's role is to support implementation of BI software and systems, including integration with databases and data warehouses. This includes gathering report requirements, report designing, and rolling out BI solutions to end users. The Business Intelligence Developer is also responsible for ensuring high levels of BI availability through advanced support functions
Responsibilities
Advanced understanding and development of MicroStrategy Platform
Develop the semantic layer, metadata, report objects, and user/system hierarchies.
Gather and Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.
Leadership and technical ownership of large, complex reporting initiatives
Writing SQL Queries and Stored Procedures for Report development
Troubleshoot other BI tools (MicroStrategy, IBM Cognos, Tableau, Alteryx), systems, and software; performance-tuning of these applications and Queries for reports as necessary.
Assist with end-user training and BI governance materials; provide technical support as necessary.
Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
Mentorship and peer review of junior and mid-level work
Basic Qualifications
- B.S. degree in computer systems design, computer science, engineering, mathematics, or statistics.
- 8 years of experience with Business Intelligence or Data Analysis
- 4+ years direct work experience with the Microstrategy BI Platform
- Familiarity with BI tools such as Tableau, Alteryx, Looker, etc.
- Intermediate knowledge with relational database concepts, SQL Queries, Views, Store Procedures and Triggers.
- Experience writing complex SQL to validate reports and tuning Reports to SQL query performance.
- Strong ability to analyze user requirements and build front-end BI applications according to specifications.
- Strong written and oral communication skills.
- Exceptional analytical, Conceptual, and problem-solving abilities.
- Able to prioritize and execute tasks in a high-pressure environment.
- Experience working in a team-oriented, collaborative environment.
- Authorized to work in the United States without sponsorship now or in the future.
Preferred Qualifications
- Masters degree in computer systems design, computer science, engineering, mathematics, or statistics.
- 2+ years direct work experience with the Looker BI Platform
- 2+ years direct work experience with Tableau
- 2+ years direct work experience with SSRS
- Familiarity with data warehouse analysis and design experience, with some knowledge of data architecture and dimensional modeling.
- Theoretical and functional proficiencies in metadata modeling (Relational and Dimensional) utilizing MicroStrategy Architect.
- Perform detailed documentation of design, development, testing and deployment activities.
- Programming experience in Python or R
MassMutual is an Equal Employment Opportunity employer Minority/Female/Sexual Orientation/Gender Identity/Individual with Disability/Protected Veteran. We welcome all persons to apply. Note: Veterans are welcome to apply, regardless of their discharge status.