BI Report Developer (100% Remote)

ClearCaptions, LLC; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

ClearCaptions, LLC is seeking a BI Report Developer to design, develop, and deploy advanced Power BI reports leveraging Microsoft Fabric Data Warehouse, SQL Server, and Synapse Analytics. You will craft DAX measures, implement row-level security, and collaborate with data engineering to optimize data models for performance and user experience.

The role emphasizes data governance, change control, and delivering compelling data-driven narratives to executive stakeholders, with a strong focus on

Qualifications

• Bachelor's degree in computer science, information technology, business, or a related field.
• 3+ years hands-on experience as a Power BI developer with a strong portfolio of reports.
• Experience with structured data from Tabular Models, SQL Server, and Synapse Analytics as data sources.
• Proficiency in writing complex DAX expressions and calculations for advanced reporting.
• Familiarity with Power BI security mechanisms and data governance practices.
• Strong data modeling, transformation, and optimization skills in Power BI.

Responsibilities

• Designs, develops, and deploys advanced Power BI reports and dashboards using Microsoft Fabric Data Warehouse, SQL Server, and Synapse Analytics.
• Uses DAX to create complex calculations, measures, and KPIs for insights.
• Implements row-level security to protect data confidentiality.
• Collaborates with data engineering to optimize data models for performance and UX.
• Manages Fabric capacity and monitors usage for efficient rendering.
• Participates in data governance and change control to maintain data accuracy.
• Performs data analysis, distills insights, and crafts data-driven narratives for storytelling.
• Creates interactive visuals to convey complex information clearly and presents findings to executives.
• Troubleshoots report performance and data quality issues.
• Supports teammates and fosters a collaborative, high-quality work environment.

Skills

Power BI

DAX

Data modeling

Row-level security

Data storytelling

Executive presentation

Problem solving

Team collaboration

Education

Bachelor's degree in CS/IT/Business

Tools

Tabular Models

SQL Server

Synapse Analytics

Microsoft Fabric

OneLake

Job description

Summary:

The BI Report Developer has a strong focus on working within the enterprise. The role is crucial in leveraging Microsoft Fabric, SQL Server, and Synapse Analytics as structured data sources to create insightful and actionable reports. The BI Report Developer contributes to data governance and change control processes and excels in delivering high-quality presentations to internal stakeholders.

What This Role Does:

• Designs, develops, and deploys advanced Power BI reports and dashboards using structured data from Microsoft Fabric Data Warehouse, SQL Server, and Synapse Analytics.
• Utilizes DAX expertise to create complex calculations, measures, and KPIs that provide meaningful insights to business users.
• Implements row-level security measures within Power BI to ensure data confidentiality and compliance with organizational policies.
• Collaborates with data engineering teams to optimize structured data models for enhanced report performance and user experience.
• Manages Fabric capacity resources, monitors usage, and optimizes performance to ensure efficient report rendering.
• Participates in data governance initiatives and adheres to change control processes to maintain data accuracy and consistency.
• Performs thorough data analysis, distills insights, and crafts compelling data-driven narratives for effective storytelling.
• Utilizes advanced visualization techniques to create interactive and visually appealing reports that convey complex information clearly.
• Presents complex findings and reports to executive stakeholders in a clear, professional, and impactful manner.
• Troubleshoots and resolves issues related to report performance, data accuracy, and visualizations.

• Performs other duties as assigned.

What You Will Bring:

• A bachelor’s degree in computer science, information technology, business, or a related field. Equivalent combinations of education and relevant experience may be considered.
• A minimum of three (3) years of hands‑on experience as a Power BI developer, with a strong portfolio showcasing diverse and impactful reports, is required.
• Expertise in working with structured data from Tabular Models, SQL Server, and Synapse Analytics as data sources.
• Proficiency in writing complex DAX expressions and calculations to meet advanced reporting requirements.
• Familiarity with Power BI security mechanisms.
• Strong data modeling skills within Power BI, including structured data transformation and optimization.
• Intermediate skills in Power BI Desktop, including using custom visuals, themes, and advanced interactivity.
• Exceptional data analysis, storytelling, and visualization skills.
• Excellent presentation skills with the ability to confidently present to executive‑level stakeholders.
• Strong problem‑solving and troubleshooting abilities, maintaining professionalism under pressure and demonstrating attention to detail.
• Ability to guide and support others through collaboration, including assisting teammates and contributing to shared processes, to foster a high‑quality, team‑oriented environment that drives results.
• Excellent verbal and written communication and problem‑solving skills.
• Self‑starter with strong organizational and time management skills, self‑directed and able to handle multiple priorities with demanding timeframes.
• Demonstrated ability to use discretion, make sound decisions, and maintain confidentiality.
• Willingness and ability to work flexible hours as needed, including availability for off‑hours support as part of an on‑call rotation.
• Proficiency in Microsoft Office Suite and modern communication tools for virtual teams (e.g., Microsoft Teams, Slack).

Preferred:

• Scrum, Jira, or DevOps experience.
• Familiarity with Microsoft Fabric/OneLake.
• Relevant Power BI certifications, such as Microsoft Certified: Data Analyst Associate or Microsoft Certified: Power BI.

Physical Demands:

In accordance with the Americans with Disabilities Act (ADA) and applicable state and local laws, the Company will provide reasonable accommodations to qualified individuals with documented disabilities to enable them to perform the essential functions of the job, unless such accommodations would impose an undue hardship. Employees seeking accommodation should contact the People Department to initiate the interactive process.

Employees may experience the following physical demands for extended periods of time:

• Sitting, standing, and walking (95-100%)
• Keyboarding (70-90%)
• Viewing computer monitor, tablet, and cell phone requiring close vision (70-90%)

Work Environment:

100% Remote: Work environment is at home.