Business Intelligence (BI) Developer

Developer, Business Intelligence, Engineer, SQL, Performance, Cognos, API, JavaScript, HTML, Computer, Engineering, IBM, Quality, Modeling
Full Time
Work from home not available Travel not required

Job Description

At MassMutual, we're passionate about helping millions of people find financial freedom and this passion has driven our approach to developing meaningful experiences for our customers. The Data Science Team, part of Enterprise Technology and Experience, is comprised of highly skilled, collaborative, problem solvers who are motivated to create innovative solutions that exceed the changing needs of our customers and move MassMutual " and the industry " forward.

To continue our cutting-edge work, we are hiring a BI Intelligence Developerto join our Team.

What great looks like in this role
Our ideal candidate is a versatile, highly motivated Business Intelligence (BI) Developer who will become part of the enterprise scrum team offering support to the MassMutual Enterprise.
The incumbent will have the opportunity to create, disseminate, and maintain intelligence objects for the organization using enterprise security, data, and application objects to ensure a single version of the truth.
The individual will use their creativity to build and maintain schema objects and abstraction layer on top of various, changing enterprise data assets. Create, share, and maintain intelligence applications for the enterprise. Publish standardized application objects, and promote departmental applications from self-service into the enterprise environment.

Duties and Responsibilities:
  • Lead business intelligence solution architecture, design, development, implementation, and administration for a mid-sized federal client across a complex data landscape.
  • Analyze user requirements and, based on findings, design, develops metadata solutions. Partner with BI Engineer in the design of databases and data warehouses to ensure interoperability with BI solutions.
  • Interpret and assist in designing normalized and dimensional data modeling as well as experience implementing metadata solutions, and bi-temporal data models.
  • Perform metadata modeling, and develop complex integrated data sets from disparate data sources with an expert utilization of SQL and optimization of BI objects.
  • Lead data analysis, data modeling and evaluation of new BI technologies, features and products to synthesize innovative production solutions. Perform detailed documentation of design, development, testing and deployment activities. Conduct troubleshooting, analysis and enhancement development based on issues reported. Prepare ad-hoc reports/analysis as needed. Write complex SQL queries and stored procedures for report or dashboard development. Assist with the curating enterprise BI governance materials. Provide technical support as needed within the team and amongst user. Perform BI server upgrades, installations and maintenance. Applying standards and governance of Business Intelligence processes. Monitor environment performance and responsible for environment availability
  • Developing user interactive reports and dashboards and providing technical solutions to team members. Admin tasks like managing security and migrations. Performance tuning and troubleshoot report issues in MicroStrategy and Cognos. Automating processes using powershell, shell and batch scripts. Customizing applications using SDK, API, JavaScript, HTML, CSS. Gather and analyze user requirements and, based on findings, design functional specifications for report or dashboard development. Perform data exploration and analysis using all available tools, including MicroStrategy, Tableau, Alteryx, SQL and other BI tools, spreadsheets and databases. Collaborate with business users to define requirements and reporting specifications and provide technical report assistance. Support end user training and provide second-line support for users who develop reports on behalf of their departmental colleagues. Perform detailed documentation of design, development, testing and deployment activities.
  • Conduct trouble-shooting, analysis and enhancement development based on issues reported. Prepare ad-hoc reports/analysis as needed. Write SQL queries and stored procedures for report or dashboard development. Assist with the curating enterprise BI governance materials. Provide technical support as needed within the team and amongst user.

Basic Qualifications:
  • Bachelor's degree or equivalent in Information Technology, Computer Science, CIS, Engineering, or Math required with 7+ years professional experience
  • Minimum of 5 years direct work experience with the MicroStrategy v10 or greater.
  • Experience writing SQL to validate reports and tuning reports query performance.
  • Strong written and verbal communication skills
  • Experience in Microsoft Office programs
  • Authorized to work in the United States without sponsorship now or in the future

Preferred Qualifications:
  • Master's degree or equivalent in Information Technology, Computer Science, CIS, Engineering, or Math preferred.
  • Must be comfortable working with large amounts of data.
  • Ability to work individually and in a team-oriented, collaborative environment.
  • Ability to handle multiple tasks delivering under the Agile methodology.
  • Entrepreneurial mind-set with strong financial acumen and personal integrity.
  • Familiarity with IBM Cognos, Tableau, Alteryx, Looker, ChartIO, other BI software etc. is a plus.
  • Knowledge with ETL, solutions, relational databases, columnar databases, time series databases, BI Platforms, Big data technology, Metadata, Lineage Quality Modeling, Sanitization, Analytics, ETL and Reporting.
Dice Id : masma002
Position Id : R4194
Originally Posted : 8 months ago
Have a Job? Post it

Similar Positions

Sr. BI Lead Developer
  • Corporate Systems Associates
  • Hartford, CT
Business Intelligence Developer
  • Hartford Healthcare
  • Farmington, CT
BI Developer
  • The Tri-Com Consulting Group
  • Glastonbury, CT
SQL Developer
  • The Judge Group, Inc.
  • Hartford, CT
MSBI with Sql Server
  • Plato Consulting
  • Hartford, CT
Business Intelligence Developer - Tableau
  • Monroe Staffing Services
  • Farmington, CT
SSIS Developer
  • Expedite Technology Solutions
  • Hartford, CT
Data Developer
  • GCR Inc.
  • Windsor, CT
Data Analyst
  • Eliassen Group
  • Hartford, CT
Qlikview + SSRS Lead
  • ReqRoute, Inc
  • Hartford, CT
Data Architect- Mid level
  • Sacrum Technologies LLC
  • Windsor, CT
BI data architect
  • ICONMA
  • Hartford, CT