Be an early applicantLess than 25 applicants

Company

GreenPath Financial Wellness · 1 day ago

BI Business Analyst

Farmington Hills, MI

Full-time

Remote

Mid Level

3+ years exp

Maximize your interview chances

Financial ServicesNon Profit

Growth Opportunities

Insider Connection @GreenPath Financial Wellness

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data analysisRequirements gatheringPower BISQL Server Management StudioT-SQL queriesExcelRelational data modelingDimensional data modelingAgile methodologyAzure DevOpsBusiness analysisFinancial services experienceCall center experienceProduct Backlog creationData validationData transformation rulesData quality monitoringData cleansingData stewardship

Required

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.

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.