Business Intelligence Report Developer (Full-time Remote, North Carolina) (Healthcare)
The BI Report Developer will support the Alliance goal to become a data driven organization by developing Business Intelligence products, including reports and dashboards that provide relevant, accurate and clear information. BI Report Developers are responsible for ensuring that data requirements are met and that the developed solution is technically sound. BI Report Developers will also provide end user support on developed data products. The BI Report Developer will employ technologies that adhere to standards established by the organization, contractual requirements, industry standards and best practices and compliance with HIPAA and related security regulations.
This position is fulltime remote. Selected candidate must reside in North Carolina. Some travel for onsite meetings to the Home office at Morrisville may be required.
Responsibilities & Duties
Requirements gathering and data analysis
- Participate in business analysis activities to gather required reporting and business requirements
- Translate requirements into technical specifications that will be used to develop the required reports and/or dashboards
- Perform data analysis of healthcare datasets to get insights into available data and determine its usability for report development
Reports and Dashboards development
- Design and develop MicroStrategy reports and dashboards, including all necessary objects (e.g., metrics and filters) required by them
- Design and develop SQL-based data products (e.g., stored procedures)
- Utilize available visualization tools and skills to develop, detect and promote understanding of data patterns, trends, and correlations to further business insights
- Participate in developing and understanding data models and provide design consultation and testing to support corporate business initiatives
QA / Peer Review
- Test and review MicroStrategy reports and dashboards to ensure that requirements are met and that they are developed in line with our development standards and best practices
- Test and review SQL-based data products to ensure that requirements are met and that they are developed in line with our development standards and best practices
Documentation
- Following our development standards and best practices, document developed data products. This includes both technical and end-user documentation
Data product support
- Provide end user support on developed data products as required
- Provide technical assistance, collaborate with and exercise cross training opportunities with other team members
Minimum Requirements
Associate's degree and five (5) years of experience in data visualization, modeling, and analysis to support process improvement, program effectiveness, and process control including 2 years of experience in the design/prototyping of BI solutions including reports, dashboards, and scorecards.
Or
Bachelor's degree in Computer Science, Business Administration, or other data-intensive field and three (3) years of experience with increasing responsibilities for management and support of healthcare data reporting systems and information technology including direct management of a major IT operation; or an equivalent combination of education and experience.
Preferred:
Experience working in a Business Intelligence role designing, developing, and/or supporting reports and/or dashboards in a healthcare setting.
Knowledge, Skills, & Abilities
- Knowledge of developing BI products in a healthcare environment, preferably the payer side, and working with healthcare datasets
- Knowledge of Data Warehousing concepts including Multidimensional models and star-join schemas, including the ability to develop data cubes
- Knowledge of relational databases and querying languages such as SQL, preferably T-SQL, including development of queries, stored procedures, functions, and views
- Skill in effective communication especially when providing technical assistance
- Skill in analyzing large datasets, problem solving, and organizing
- Skill in choosing optimal visualizations for business insights and requirements
- Ability to develop multidimensional reports in MicroStrategy or similar BI platform
- Ability to work independently and in a team setting
Employment for this position is contingent upon a satisfactory background check and credit check, which will be performed after acceptance of an offer of employment and prior to the employee's start date.
Salary Range
$81,873 - $93,130.13/Annually
Exact compensation will be determined based on the candidate's education, experience, external market data and consideration of internal equity.
An excellent fringe benefit package accompanies the salary, which includes:
- Medical, Dental, Vision, Life, Long and Short Term Disability
- Generous retirement savings plan
- Flexible work schedules including hybrid/remote options
- Paid time off including vacation, sick leave, holiday, management leave
- Dress flexibility
Education
Required- Associates or better in Information Technology
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
