The Business Intelligence Developer / Analyst will be responsible for the building of reports, dashboards and KPI's. Will lead projects to improve the usability, scalability, efficiency, and security of BI tools. Will lead the analysis of data discrepancies and validation.
Job duties & responsibilities
Design and develop BI reports and dashboards. This involves understanding the business requirements, designing the data model, and developing visualizations that provide actionable insights.
Manage data sets, ensuring they are clean, accurate, and ensure data security.
Collaborate with stakeholders.
Train end-users
Troubleshooting and maintenance:
Need to stay updated with the latest features, updates, and best practices to leverage them effectively.
Qualifications & Experience requirements
Requires a BS or MS in computer science or information system.
Over five years of experience in data preparation, data gateway, and data warehousing projects
Over five years of experience working with the Microsoft Business Intelligence Stack
Expertise of SQL queries, SSRS, and SQL Server Integration Services (SSIS) including DAX
Three to four years of experience with a self-service tool such as Power BI or Tableau
Three to Five years healthcare data experience (claims, quality, encounters)
Must be highly proficient with MS Excel (VLOOKUP function, pivot tables, charts, etc.).
Knowledge/Skills/Abilities
Excellent customer service skills
High level of curiosity
Strong knowledge of industry standards and guidelines.
Attention to detail.
Outstanding written and verbal communication abilities
Familiarity with computer and necessary software
Strong proficiency with SQL and its variation among popular databases
Experience with some of the modern relational databases.
Skilled at optimizing large, complicated SQL statements.
Knowledge of best practices when dealing with relational databases
Capable of configuring popular database engines and orchestrating clusters as necessary
Ability to plan resource requirements from high level specifications.
Capable of troubleshooting common database issues
Familiar with tools that can aid with profiling server resource usage and optimizing it.
Proficient understanding of code versioning tools
Must have high ethical standards and treat prospective enrollees with respect and dignity.
Work environment
May work beyond normal working hours, on weekends and holidays, when necessary.
Is subject to frequent interruptions.
Time sensitive tasks and responses
May require field-based work. May require occasional overnight travel will be required as times with field-based assignments.
Physical effort/demands (With or Without the Aid of Mechanical Devices)
Ability to move (sit, stand, bend, lift) intermittently throughout the workday.
Ability to lift, push, pull, and move a minimum of 50 pounds.
Mental effort/demands (With or Without the Aid of Mechanical Devices)
Ability to function independently and have flexibility, personal integrity, and ability to work effectively with staff and support agencies.
In good health and demonstrating emotional stability.
Ability to cope with the mental and emotional stresses of the position.
Communication (With or Without the Aid of Mechanical Devices)
Must be able to read, write and speak the English language in an understandable manner.
Bilingual language skills a plus
Sensory requirements (With or Without the Aid of Mechanical Devices)
Ability to see and hear or use prosthetics that will enable these senses to function adequately to assure that the requirements of this position can be fully met