The Role
Build, maintain, and improve Power BI reports, paginated reports, and semantic models. Write and validate T-SQL queries, work with views/stored procedures and Fabric, perform data validation, document logic, and partner with business stakeholders to deliver reliable BI solutions and KPIs.
Summary Generated by Built In
Rapid Finance has a dynamic opportunity for a BI Data Analyst to join our Business Intelligence team. This role will focus on building, maintaining, and improving business intelligence reporting solutions that help stakeholders make data-driven decisions. The position will work primarily with Power BI, paginated reports, Microsoft SQL Server, and Microsoft Fabric.
This is a hands-on, non-senior BI analyst role reporting to the Director of Business Intelligence. The ideal candidate is comfortable working with business stakeholders, translating reporting needs into clear requirements, validating data, and delivering reliable BI solutions using SQL Server and Power BI.
This position is intended for candidates local to the Bethesda, Maryland area, with limited in-office presence as business needs require.
A day in the life of the BI Data Analyst may include:Preferred skills and experience:
Rapid Finance is an equal opportunity employer and committed to a diverse workforce.
This is a hands-on, non-senior BI analyst role reporting to the Director of Business Intelligence. The ideal candidate is comfortable working with business stakeholders, translating reporting needs into clear requirements, validating data, and delivering reliable BI solutions using SQL Server and Power BI.
This position is intended for candidates local to the Bethesda, Maryland area, with limited in-office presence as business needs require.
A day in the life of the BI Data Analyst may include:
- Design, develop, maintain, and enhance Power BI reports, dashboards, semantic models, and paginated reports.
- Write, troubleshoot, and validate SQL queries against Microsoft SQL Server source systems.
- Work with SQL Server views, stored procedures, and existing ETL logic to support reporting and data validation needs.
- Partner with business teams to gather requirements, define KPIs, and translate business questions into reporting solutions.
- Apply dimensional modeling and data warehouse best practices, including facts, dimensions, star schemas, and Kimball-style concepts.
- Support BI solutions in Microsoft Fabric and continue developing hands-on knowledge of Fabric capabilities.
- Perform data validation to confirm the accuracy, completeness, and consistency of reports and dashboards.
- Document report logic, data definitions, business rules, and known data limitations.
- Monitor and improve report usability, data refresh reliability, and performance where appropriate.
- Turn data into actionable insight for business users across Rapid Finance.
- 3+ years of professional experience in business intelligence, data analysis, reporting, or related work; or 5+ years of relevant experience in lieu of a degree.
- Bachelor's degree preferred in Information Systems, Business Analytics, Economics, Computer Science, Statistics, Mathematics, Finance, or a related quantitative/business field; equivalent practical experience will be considered.
- Hands-on experience building reports and dashboards in Power BI.
- Experience creating or supporting Power BI paginated reports, Power BI Report Builder reports, SSRS reports, or similar operational reporting outputs.
- Strong SQL skills, preferably using Microsoft SQL Server and T-SQL.
- Comfortable working with relational data sources, views, stored procedures, and existing SQL-based ETL logic.
- Understanding of dimensional modeling, data warehousing concepts, facts, dimensions, and star schema design.
- Familiarity with Microsoft Fabric and how it supports data integration, analytics, warehousing, and Power BI reporting.
- Strong communication skills with the ability to work with both business users and technical team members.
- Self-motivated, organized, and able to learn new tools, data sources, and business processes quickly.
- Power BI report development, including dashboards, semantic models, DAX basics, and paginated reports.
- Microsoft SQL Server and T-SQL querying.
- Experience reading and troubleshooting SQL Server views and stored procedures.
- Dimensional data modeling and data warehouse best practices, including Kimball-style concepts.
- Familiarity with Microsoft Fabric.
- Data validation, report testing, requirements gathering, and documentation.
- Only U.S. citizens and Green Card holders are eligible for this position.
- Hands-on experience with Microsoft Fabric Data Factory, Data Pipelines, Lakehouse, Warehouse, or related Fabric workloads.
- Experience with Azure Data Factory or similar Microsoft data integration tools.
- Experience with SSRS, Power BI Report Builder, SSIS, or related Microsoft BI tools.
- Experience in fintech, lending, banking, finance, accounting, marketing analytics, or similar data environments.
- Exposure to Agile delivery methods or Kimball SDLC.
- Exposure to Python, R, advanced analytics, forecasting, or predictive modeling is helpful but not required.
Rapid Finance is an equal opportunity employer and committed to a diverse workforce.
Skills Required
- 3+ years of professional experience in business intelligence, data analysis, or reporting (or 5+ years in lieu of a degree).
- Hands-on experience building Power BI reports, dashboards, and semantic models.
- Experience creating or supporting Power BI paginated reports, Power BI Report Builder reports, or SSRS reports.
- Strong SQL skills using Microsoft SQL Server and T-SQL.
- Experience reading, troubleshooting, and validating SQL Server views and stored procedures.
- Understanding of dimensional modeling, star schema, facts and dimensions, and Kimball-style concepts.
- Familiarity with Microsoft Fabric and how it supports data integration, analytics, warehousing, and Power BI reporting.
- Data validation, report testing, requirements gathering, and documentation skills.
- Strong communication skills and ability to work with business users and technical teams.
- Bachelor's degree in a related field (preferred) or equivalent practical experience.
- Hands-on experience with Microsoft Fabric Data Factory, Data Pipelines, Lakehouse, Warehouse, or related Fabric workloads.
- Experience with Azure Data Factory or similar Microsoft data integration tools.
- Experience with SSIS or other Microsoft BI integration tools.
- Experience in fintech, lending, banking, finance, accounting, marketing analytics, or similar environments.
- Exposure to Python, R, advanced analytics, forecasting, or predictive modeling.
- Exposure to Agile delivery methods or Kimball SDLC.
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Rapid Finance is a leading online financial services company that offers flexible funding solutions to small and medium-sized businesses.
