Sr. BI Developer

Company Description

BETSOL is a cloud-first digital transformation and data management company offering products and IT services to enterprises in over 40 countries. BETSOL team holds several engineering patents, is recognized with industry awards, and BETSOL maintains a net promoter score that is 2x the industry average.

BETSOL’s open source backup and recovery product line, Zmanda (Zmanda.com), delivers up to 50% savings in total cost of ownership (TCO) and best-in-class performance.

BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for its customers.

BETSOL offices are set against the vibrant backdrops of Broomfield, Colorado and Bangalore, India.

We take pride in being an employee-centric organization, offering comprehensive health insurance, competitive salaries, 401K, volunteer programs, and scholarship opportunities. Office amenities include a fitness center, cafe, and recreational facilities.

Job Description

Individuals in this position will design, develop, and deploy data analytic solutions to a diverse array of stakeholders across the enterprise. As a Business Intelligence Developer, you will collaborate with our team of skilled developers to implement BI reports, dashboards, and other forms of analytics solutions designed to gain new insights, while upholding best practices and standards. You will play a key role in our mission of converting data into actionable insights.

Note: This is a senior position that requires candidates with extensive healthcare and Epic experience who can hit the ground running.

Role Context:

• This role is embedded within Epic systems
• Work involves moving data from Epic to Kaboodle and building metrics from Epic for analytical reports
• Fast-track hiring process for exceptional candidates with the right experience
• Remote position with expedited interview process for qualified candidates

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 the 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 the identification, development, and validation of data sources
• Contribute to the department's short-term and long-term strategic plan
• Make appropriate recommendations on the 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

Qualifications

Required Experience

• 10+ years of proven experience in database development, BI reporting
• 8-10 years of experience working with Epic backend systems (not just application team experience)
• 8-10 years of experience working with Clarity and Caboodle databases
• Healthcare experience required with a thorough understanding of healthcare workflows
• Very strong SQL skills (this is a fundamental requirement for success in this role)
• Deep understanding of Epic database architecture

Important Clarification

Candidates who have only briefly moved from application teams to BI teams (e.g., 2 years BI experience after 8 years on application team) will not be considered as having sufficient back-end experience.

Additional Qualifications

• Strong analytical, technical, and troubleshooting skills
• Ability to assess requirements from multiple sources and find innovative technical solutions
• Solid understanding of creating content to display Epic data from Clarity and Caboodle
• Experience with Microsoft BI stack
• Ability to work in a complex environment
• Ability to be organized and proficient at tracking tasks, defining next steps, and following project plans
• 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

Education

• Bachelor's degree in a technical, scientific, and/or healthcare discipline; or equivalent work experience

Additional Information

Licensure/Certifications

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

Additional Information

• Hours: Must be able to accommodate Pacific time zone hours
• Location: Remote
• Important: The position does not offer visa transfer or sponsorship options