Power BI Developer (Healthcare Claims)

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 AutomateMaintain, 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 neededSupport 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 dataDevelop and maintain upstream data quality assurance process to check data accuracy and completeness before loading to any applications leveraging support from Data Quality as neededIndependently 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 reportingo the overall effects of changes to database design, table structures, and calculated metricsMaintain documentation of all development activity and review code developmentThis 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 developmentAdvanced development skills with a variety of tools and platforms, including MS SQL, MS PRB, SSIS, DAX Studio, and Power AutomateHealthcare claims experienceKnowledge of claims processing and the various fields submitted with a claim, such as Universal Medical BillingWorking 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 procedures5+ years of experience in data analyticsKnowledgeable of best practices for relational databases and schemas Excellent communication skillsPREFERRED SKILLS:Bachelor’s degree in Healthcare, Informatics, Computer Science, Economics, or a related fieldMaster's degreeMust be authorized to work in the US. Sponsorships are not available.