BI Business Analyst

BI Business Analyst

Are you seeking impactful and meaningful work? Do you enjoy collaborating with other teams and problem-solving? Are you interested in working in an empathetic and collaborative environment?

This opportunity might be for you!

GreenPath Financial Wellness is amidst a digital transformation journey that will transform how we do business with technology. You will be key to this transformation by collaborating with business leaders to understand and document data needs. You’ll collaborate with the data platform team to gather requirements for the data warehouse and business intelligence solutions. Accurately and efficiently document data requirements for the the Power-BI Dashboards and SSRS Reports. Your analysis of the information will optimize the data and facilitate data driven decisions.

GreenPath Financial Wellness wholeheartedly believes a strong organization is based on the foundation of diverse groups of team members. We believe deeply in employees not only bringing their whole selves to work each day, but also feeling comfortable being their authentic self. We encourage people from each and every background and walk of life to apply for opportunities which they are passionate about and meet the qualifications.

At the heart of this role is a deep passion and commitment to GreenPath’s mission to empower people to lead financially healthy lives. Through our core values of integrity, teamwork and quality, GreenPath serves individuals directly, empowering strong financial decisions with high quality tools, resources and information.

Financial wellness is a key factor in people’s freedom to pursue their dreams. We envision a world where people are ready for life’s ups and downs, and we all have the tools we need to accomplish our financial goals.

Need to Know Logistics:

• The opportunity to work hybrid environment is available if local to Farmington Hills, MI
  • If out of state, remote work is available
• Full-time, direct hire opportunity. Eligible for full benefits package (listed at bottom of post)
• Eastern Time Zone business hours

We Have:

• The opportunity to make a difference in all areas of the business through collaboration with various leaders and team members
• Experienced IT and Data teams for you to join
• A guiding principle to put people at the center of everything we do. Empathy coaching, human-centered design and behavioral economics practices anchor our work in meeting people’s needs.
• Caring, compassionate and creative humans that show up every day with integrity and a drive to provide a quality experience through each and every interaction. This is more than a job for most of us. We are on a mission to make it easier for people to be financially well.
• Partnerships with others enable us to impact financial health on a large scale. We collaborate to design and deliver financial health services that are a win for people, for our partners, and for GreenPath.
• Products and services designed specifically with our clients in mind.

You Have:

• Bachelor’s degree in Information Technology or related field. In lieu of a Bachelor’s Degree, you may have equivalent experience.
• 3 - 5 years of hands-on experience in data analysis and requirements gathering for operational reporting, business intelligence and data warehouse projects.
• Experience working with Word, Excel, T-SQL queries using SQL Server management studio and PowerBI.
• Data discovery and exploration using SQL queries, PowerBI or Excel.
• Understanding of relational and dimensional data modeling including OLAP cubes.
• Experience in Business and Data analysis.
• Experience in Agile methodology and Azure DevOps
• Experience in the financial services industry or call center is preferred.
• Experience creating Product Backlog items with appropriate acceptance criteria.
• Strong integrity, accuracy, positivity and dependability
• Motivation to be a self-starter and work independently on multiple projects
• Excellent analytical and problem-solving skills
• An ability to work collaboratively with others
• Ability to interface and collaborate well with business and technical stakeholders

The Day to Day:

• Collaborate with business leaders to understand requirements, formulate use cases, and then translate that into report or dashboard requirements document.
• Requirements gathering for Power BI dashboards and SSRS reports.
• Analysis and documentation of source data and data structures and source to Data warehouse mappings.
• Understand data transformation rules required to fulfill business requirements
• Perform data validation for reports and dashboards once ready for UAT.
• Facilitate UAT and obtain business stakeholder’s signoff for production release.
• Ensure the work delivered is of quality and meets the business criteria.
• Effectively communicate and interact with business and technical personnel to solve complex data related business problems.
• Create and maintain enterprise data catalogs, data dictionary and data flow diagrams.
• Participate in brainstorming sessions and contribute ideas to our data trends, data patterns, data quality monitoring, data cleansing, data stewardship etc.
• Contribute to Enterprise data strategy while working with data architects and product owner.
• Understand and document Ad-hoc report requests within the stipulated turnaround times.
• Maintain an enthusiastic, positive attitude and be a dependable team member.
• Other duties as assigned.

The Perks:

• We all need some “me time” every once in a while. All full-time employees receive 19 paid days off during their first year of employment, in addition to 10 company-paid holidays per year. Use it for a fabulous vacation, to play nurse (or patient) at home, or sit on your couch watching DIY marathons on HGTV all day. We don’t care – it’s your time. Enjoy.
• Need some additional time to focus on preventative care? GreenPath provides all employees with additional Preventative Care Time Off to encourage all employees to be proactive about their physical wellness.
• Saving for Retirement? GreenPath employees can start contributing to a 403b right away! After one year of employment we make a monthly contribution to eligible employee’s Retirement Account equivalent to 5% of their gross compensation.
• Need to reduce your student loan debt? GreenPath is a qualified employer under the federal Public Service Loan Forgiveness (PSLF) program, which means that you may be able to have a portion of your federal student loans forgiven after meeting certain eligibility requirements of the PSLF program.
• Planning on growing your family? GreenPath offers paid Maternity and Paternity benefits.
• Continuous learners can get their classroom fix in a couple of different ways. GP team members are eligible for up to $2,500 in tuition reimbursement per year. In addition, GP team members can attend courses through Invest in Yourself, an in-house educational program offering training classes on a variety of topics ranging from Cash Flow Planning to Microsoft Excel to Stress Management.
• Want to take additional college courses? We have an agreement with Cleary College where all GreenPath employees are eligible for a 25% discount on college tuition.