Sign upLog in

Senior Business Intelligence (BI) Specialist

Apollo Technology Solutions LLC

North Chesterfield, VA

Apply
JOB DETAILS
SKILLS
Analysis Skills, Best Practices, Business Intelligence, Business Solutions, Communication Skills, Computer Science, Data Analysis, Data Modeling, Data Quality, Data Recovery, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Ecosystems, Git, HIPAA (Health Insurance Portability and Accountability Act), Information Technology & Information Systems, Information/Data Security (InfoSec), Maintain Compliance, Medical Record System, Metrics, Microsoft ADO (ActiveX Data Object), Microsoft Product Family, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Query Optimization, Regulations, Regulatory Compliance, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Stored Procedures
LOCATION
North Chesterfield, VA
POSTED
30+ days ago
Job Title: Senior Business Intelligence (BI) Specialist
Duration: 6 Months
Location: North Chesterfield, VA
Interview Type: In Person Only
Work Arrangement: Onsite
Note:
  • 100% ONSITE - NO REMOTE WORK and in-person interview only.
Job Description:
We are seeking a highly skilled Senior BI Specialist to design, develop, and maintain advanced business intelligence solutions that empower data-driven decision-making across the organization.
  • The ideal candidate will have deep expertise in Power BI, T-SQL, SSIS, dimensional modeling, and other Microsoft data tools, with a strong ability to translate complex data into actionable insights.
  • Experience working with medical data and ensuring compliance with HIPAA regulations is a significant plus.
  • This contractor will primarily support Electronic Health Records (HER) requests and duties.
Key Responsibilities:
  • Extensive work with medical data including HIPAA compliance requirements.
  • Design and implement Power BI dashboards and reports to visualize key business metrics and trends.
  • Develop and optimize SQL queries, stored procedures, and views for efficient data retrieval and transformation.
  • Build and maintain ETL processes using SSIS to integrate data from multiple sources into data warehouses.
  • Apply dimensional modeling techniques to design and maintain scalable data models for analytics.
  • Collaborate with stakeholders to gather requirements and deliver BI solutions aligned with business objectives.
  • Ensure data integrity, security, and compliance with HIPAA and other regulatory standards when handling sensitive medical data.
  • Maintain clean code bases and releases using GIT and ADO Pipelines.
Qualifications:
  • Bachelor's degree in computer science, Information Systems, or related field (or equivalent experience).
  • 5+ years of experience in BI development and data analytics.
  • Proficiency in: Power BI (DAX, Power Query, data modeling) SQL Server (T-SQL, performance tuning) SSIS (ETL design and implementation) Dimensional modeling and data warehousing concepts Understanding of Microsoft ecosystem (Azure, Excel, etc.).
  • Excellent problem-solving, analytical, and communication skills.
Additional "would likes”
  • Knowledge of Azure Data Services (Data Factory, Synapse Analytics).
  • Exposure to data governance and security best practices.
Required/Desired Skills:
  • Work with medical data including HIPAA compliance requirements
  • Design and implement Power BI dashboards and reports to visualize key business metrics and trends.
  • Develop and optimize SQL queries, stored procedures, and views for efficient data retrieval and transformation.
  • Build and maintain ETL processes using SSIS to integrate data from multiple sources into data warehouses.
  • Apply dimensional modeling techniques to design and maintain scalable data models for analytics
  • Gather requirements and deliver BI solutions aligned with business objectives
  • Maintain clean code bases and releases using GIT and ADO Pipelines

About the Company

A

Apollo Technology Solutions LLC