BI Data Analyst (Hybrid)

Rapid Finance; Bethesda (MD); On-site; USD 75,000 - 95,000; Full time

Job summary

Rapid Finance in Bethesda, Maryland, has a dynamic opportunity for a BI Data Analyst to join their Business Intelligence team. The role focuses on building and maintaining business intelligence reporting solutions using Power BI, SQL Server, and Microsoft Fabric.

Ideal candidates are expected to have 3+ years in business intelligence, strong SQL skills, and the ability to collaborate with business stakeholders. This position primarily serves the local community, with limited in-office presence as needed.

Qualifications

• 3+ years of professional experience in business intelligence or related fields.
• Hands-on experience building reports and dashboards in Power BI.
• Strong understanding of dimensional modeling and data warehousing concepts.

Responsibilities

• Design and develop Power BI reports and dashboards.
• Validate SQL queries against Microsoft SQL Server.
• Partner with business teams to define KPIs and reporting solutions.

Skills

Power BI report development

SQL skills (Microsoft SQL Server, T-SQL)

Dimensional modeling

Data validation

Communication skills

Education

Bachelor's degree in Information Systems, Business Analytics, Economics, Computer Science, Statistics, Mathematics, Finance

Tools

Power BI

Microsoft SQL Server

Microsoft Fabric

Job description

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.

Responsibilities

• 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.

About You

• 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.

Technical Skills Required

• 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.

Eligible Candidates

Only U.S. citizens and Green Card holders are eligible for this position.

Rapid Finance is an equal opportunity employer and committed to a diverse workforce.