Overview
Remote
$90,000 - $115,000
Full Time
Skills
SQL
Job Details
Power BI Developer
Exciting opportunity to join 1st class organization that has excellent benefits including a pension plan. Most of our associates retire from here, which is why this position is open.
RESPONSIBILITIES:
- Design, develop, and thoroughly test applications and reports using tools such as Power BI, MS SQL, MS PRB, SSIS, DAX Studio, and Power Automate
- Maintain, update, and ensure the accuracy of the data operations within the CDW and reporting/analytic layer used by Analytics leveraging support from Data Quality as needed
- Support all inbound and outbound data loads that are aligned with the Analytics team (e.g., Medical Claims ingestion, Lab Data ingestion, Milliman input/output, IINT input/output, IPro input/portal, Mt Sinai outbound data, ad hoc claims extracts, etc.)
- Perform at a high level of programming skills with a strong aptitude for reviewing, auditing, and analyzing data
- Develop and maintain upstream data quality assurance process to check data accuracy and completeness before loading to any applications leveraging support from Data Quality as needed
- Independently able to retrieve and interpret product or regulation specifications such as grouper input requirements, data requests, or federal transparency regulations
- Develop and maintain an in-depth understanding of:
o common healthcare utilization and cost metrics, including HEDIS
o Available fund data and how it is standardized and used in production reporting
o the overall effects of changes to database design, table structures, and calculated metrics - Maintain documentation of all development activity and review code development
This is a direct hire position. You can live anywhere and work 100% remotely. Incredible company culture and benefits including 401(k), Pension, Tuition Assistance, Employee Assistance Program (EAP), and work 37.5 hour work week.
REQUIRED SKILLS:
- 3+ years of Power BI, including dataset building, data flows, and metric development
- Advanced development skills with a variety of tools and platforms, including MS SQL, MS PRB, SSIS, DAX Studio, and Power Automate
- Healthcare claims experience
- Knowledge of claims processing and the various fields submitted with a claim, such as Universal Medical Billing
- Working knowledge and experience in industry coding (revenue codes, ICD 9 & 10 classifications, CPT codes, etc.)
- 5+ years of experience with hands-on development and SQL Server stored procedures
- 5+ years of experience in data analytics
- Knowledgeable of best practices for relational databases and schemas
- Excellent communication skills
PREFERRED SKILLS:
- Bachelor s degree in Healthcare, Informatics, Computer Science, Economics, or a related field
- Master's degree
Must be authorized to work in the US. Sponsorships are not available.