Data Analyst/Report Developer
The Intersect Group
Addison, United States of America
7 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Addison, United States of America
Tech stack
Microsoft Excel
Microsoft Windows
Data analysis
Health Informatics
Data Integration
Data Retrieval
Database Queries
Excel Macros
Microsoft SQL Server
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
Powerquery
Microsoft Fabric
Information Technology
Vba Programming Language
Job description
This role will focus on Healthcare Revenue Cycle Management data analysis and reporting. It requires working closely with various business leaders to understand their requests, analyze data in coordination with onshore/offshore data team, build dashboards and reports, and present these findings to business leaders., * Gather and document reporting requirements, securing stakeholder approval.
- Analyze data and design, build, and maintain Power BI reports and dashboards aligned with business needs.
- Identify data quality issues, gaps, and inconsistencies, and recommend or implement corrective actions.
- Automate and streamline reporting processes to ensure timely and efficient delivery.
- Troubleshoot issues, determine root causes, and resolve system or data gaps.
- Monitor and support data integration workflows and reporting jobs.
- Document metrics, definitions, and processes while adhering to change control procedures.
- Support user acceptance testing and provide stakeholder training for new reports or data models.
- Follow established best practices while proactively suggesting enhancements.
- Collaborate with both offshore and onshore development and data teams.
- Coordinate cross?functional data analysis initiatives and uphold high-quality standards across all deliverables.
Requirements
- 5+ years analyzing data and writing SQL queries/stored procedures on SQL Server
- 3+ years building dashboards/visualizations, with minimum 1+ year using Power BI, including full lifecycle of BI dev--configuring data sources and acquiring data from multiple sources (SQL, .CSV, flat files, etc.), setting up semantic models for Power BI (not just creating dashboards from prepared data/Excel provided by Developers/Data Modelers)
- 2+ years coding in DAX and Power Query for calculations and data retrieval/transformation
- 2+ years analyzing data and writing queries in SQL Server (proficiency in writing complex JOINs from scratch using some Windows functions required; not just SELECT statements since data will be pulled from multiple tables)
- 2+ years experience analyzing financial data, with strong preference towards healthcare revenue cycle data data experience strongly preferred
- Will be querying data and creating views
- Proven ability to think critically about data and take full ownership of deliverables.
- Strong verbal and written communication skills.
- Ability to manage multiple projects simultaneously and work effectively with minimal supervision.
- Highly analytical with exceptional attention to detail.
- Ability to manage multiple concurrent projects and deliver with minimal supervision
- Analytical thinker with strong attention to detail
Preferred:
- Bachelor's degree in Computer Science, Health Informatics, or a related field-or equivalent professional experience.
- Experience working with healthcare data, including clinical or revenue cycle datasets.
- Proficiency with Microsoft Fabric, Microsoft Lakehouse, Excel Macros/VBA, SSRS, or Power BI Report Builder.
- Experience collaborating with offshore teams in a distributed development environment.