Senior BI Developer

Summary

Join BETSOL, a leading digital transformation company, as a Business Intelligence Developer. You will design, develop, and deploy data analytic solutions using Tableau, PowerBI, and SSRS. Collaborate with various teams to translate business needs into actionable insights. Leverage your expertise in SQL, data warehousing, and ETL processes to build data marts and ensure data quality. This remote position requires 7+ years of experience in database development and BI reporting, along with advanced knowledge of healthcare data and Epic systems. BETSOL offers comprehensive health insurance, 401K, and other employee-centric benefits.

Requirements

• 7+ years of proven experience in database development, BI reporting
• Strong analytical, technical, and troubleshooting skills
• Ability to assess requirements from multiple sources and find innovative technical solutions
• Solid understanding on creating content to display Epic data from Clarity and Caboodle
• Experience with Microsft BI stack
• Sound knowledge of healthcare and health plan workflows
• Ability to work in a complex environment
• Ability to be organized and proficient at tracking tasks, defining next steps, and following project plans
• Advanced knowledge of SQL, including window functions and common table expressions
• Sound knowledge of data ETL concepts, processes, and tools such as MS SSIS, ADF
• Advanced knowledge of database and data warehousing concepts, including data lakes, relational and dimensional database design concepts, and data modeling practices
• Familiarity with Agile project management methods such as SCRUM, Lean, and/or Kanban
• Expert knowledge of Tableau, PowerBI, and dynamic data visualization tools
• Advanced knowledge of healthcare data structures, workflows, and concepts, from Electronic Health Record systems like Epic
• Bachelor’s degree in a technical, scientific, and/or healthcare discipline; or equivalent work experience

Responsibilities

• Coordinate with various business teams, subject matter experts, or external entities to translate business requirements into coherent Business Intelligence (BI) reports, and dashboards in Tableau, PowerBI, SSRS
• Create data models, ERD and data flow diagrams as needed
• Build functional data marts for in-depth analytics by stakeholders
• Perform data analysis and ad-hoc queries to support business decision-making
• Implement best practices to ensure data quality and data integrity
• Maintain and extend Epic Caboodle platform and develop custom Caboodle data modeling components
• Understand complex logic and solve data issues by coming up with sound technical solutions
• Support implementation of enterprise data standards and master data management standards
• Assist with data governance initiatives in the areas of data quality, data security, metadata management, and MDM
• Actively contribute to all aspects of the data project lifecycle including request intake and acknowledgment, project estimation, time-tracking, and prioritization of tasks
• Assist with identification, development and validation of data sources
• Contribute to the department’s short-term and long-term strategic plan
• Make appropriate recommendations on management of data extraction, and analysis
• Maintain knowledge of the current regulations and technologies related to data management
• Be an exemplary team player with excellent collaboration skills
• Exhibit outstanding customer service skills with stakeholders
• Perform other duties as required or assigned

Preferred Qualifications

• Epic Clarity-Caboodle Development certifications are required within 120 days of hire
• All certifications must be maintained throughout employment

Benefits

• Comprehensive health insurance
• Competitive salaries
• 401K
• Volunteer programs
• Scholarship opportunities
• Fitness center
• Cafe
• Recreational facilities
• Remote