Remote Business Intelligence Developer

About Our Client

Our client is an established organization supporting complex healthcare-focused analytics, reporting, and data quality initiatives. They are adding a hands-on business intelligence professional to support projects involving large, sensitive, and highly detailed data sets.

This is a fully remote role with a stable organization that offers strong benefits, long-term growth potential, and the opportunity to contribute to work that supports better healthcare outcomes.

You will work across both the data layer and the reporting layer, helping transform complex healthcare and operational data into trusted reporting assets, dashboards, and analytical outputs.

Culture & Benefits

The company is invested in its employees and offers a competitive benefits package including medical, dental, vision, tuition reimbursement, 401k, and employee stock program. Along with being fully remote, 15 paid company holidays, 3 weeks of vacation, benefit package that includes medical, dental, vision, tuition reimbursement,4% match 401(k) and an employee stock ownership plan. Over the years we have placed nearly 100 people at this company who have enjoyed long tenure, career growth, and upward mobility.

Position Overview

You will work closely with analytics teams, stakeholders, and external partners to clarify reporting needs, prepare and validate data, develop SQL-based workflows, and deliver business intelligence solutions that support decision-making.

This role combines business intelligence development, SQL-based data engineering, data validation, and healthcare analytics in a collaborative environment where accuracy, communication, and problem-solving matter.

Key Responsibilities

• Partner with analysts, technical teams, and stakeholders to translate reporting requirements into usable BI solutions.
• Build and maintain dashboards, reports, and visual analytics using Tableau, Amazon QuickSight, Power BI, or similar platforms.
• Design reporting solutions that help stakeholders understand trends, performance, and operational outcomes.
• Develop SQL-based data preparation and transformation processes to support reporting and analytics delivery.
• Work with Microsoft SQL Server environments to ingest, stage, transform, validate, and organize structured and semi-structured data into reporting-ready datasets.
• Support normalization and standardization of datasets that vary significantly in structure, naming conventions, layouts, and quality.
• Develop repeatable SQL-based processes for deduplication, reconciliation, validation, and transformation of large datasets.
• Use T-SQL, stored procedures, reusable SQL logic, and parameter-driven processes to support repeatable reporting workflows.
• Create data quality checks to identify missing values, duplicates, invalid records, inconsistent formats, unexpected trends, and source-to-target mismatches.
• Support movement of data from raw or staged formats into structured reporting tables, warehouse models, or analytics-ready datasets.
• Translate business rules and reporting definitions into accurate SQL transformation logic.
• Troubleshoot data discrepancies, failed loads, report issues, and dashboard performance problems.
• Support testing and validation before reports, dashboards, or data outputs are delivered.
• Maintain documentation describing data lineage, transformations, validation checks, key joins, workflow steps, and reporting definitions.
• Communicate technical findings clearly to both technical and nontechnical audiences.
• Manage multiple reporting and data projects simultaneously while maintaining quality and accuracy.

Data Environment

The work may involve healthcare and operational data sources such as:

• Medical claims
• Pharmacy claims
• Enrollment and eligibility data
• Provider, member, or patient-related records
• Clinical or laboratory data
• EHR/EMR-derived data
• Survey or review data
• Registry data
• Operational or financial data
• Quality and compliance-related reporting data

Required Background

• Bachelor’s degree in a technical, quantitative, analytics, healthcare informatics, computer science, information systems, or related field.
• 3+ years of experience building BI reports, dashboards, or visual analytics solutions.
• 3+ years of experience working with ETL or data transformation processes.
• 3+ years of experience working with data warehouses, reporting databases, or structured analytics data models.
• Strong hands-on SQL experience, preferably in a Microsoft SQL Server environment.
• Experience gathering and documenting business and technical reporting requirements.
• Strong attention to detail and ability to validate data before it is used in reporting.
• Ability to explain technical logic and data issues clearly.

Technical Skills

Strong candidates should have experience with several of the following:

• Microsoft SQL Server
• T-SQL
• Stored procedures
• SQL-based data transformation
• ETL workflows
• Data warehouse or reporting table design
• Staging tables and production reporting tables
• Source-to-target validation
• Data quality checks
• Data reconciliation
• Tableau
• Amazon QuickSight
• Power BI
• SSIS
• SSAS
• Business Objects / Web Intelligence
• Excel for analysis and validation support
• UAT support and technical documentation

Python is a plus if used for data profiling, cleansing, validation automation, QA scripting, reconciliation, or anomaly detection.

Preferred Experience

• Healthcare analytics, claims, eligibility, clinical data, quality reporting, Medicaid, Medicare, or payer/provider reporting environments.
• Experience working with large structured datasets.
• Experience building repeatable validation processes or data quality checks.
• Experience documenting source-to-target mappings, business rules, and transformation logic.
• Experience working in regulated, compliance-driven, healthcare, insurance, government, or research-focused environments.

Ideal Background

You have experience preparing, validating, transforming, documenting, and visualizing complex data for reporting or analytics purposes.

You are comfortable working through messy or inconsistent data, identifying gaps in requirements, validating results before delivery, and creating reporting solutions stakeholders can trust.

You combine strong SQL and data transformation skills with practical dashboard development experience, analytical curiosity, attention to detail, and strong communication skills.

Not the Right Fit

• You only build dashboards from data someone else already prepared.
• You have limited SQL experience.
• You have not worked with ETL, data loads, or reporting databases.
• You are heavily focused on Python but lack strong SQL, ETL, and BI delivery experience.
• You struggle communicating technical concepts or gathering requirements from stakeholders.
• You prefer narrowly defined tasks and are uncomfortable working through ambiguous data or reporting requests.