Position Status:Full TIme
The BI Developer will be working with the latest Microsoft SQL Server technologies and involved in most aspects of HealthStream BI platform development. Under the guidance and supervision of the Technology Services manager, this person will part of the team responsible for the data warehouse including ETL development, data modeling, analysis, and reporting. Experience in data warehousing concepts/architecture and all area of the SQL Server BI Stack will be needed for this position.
ESSENTIAL DUTIES OR RESPONSIBILITIES:
Design and development of enterprise ready BI solutions
Data warehouse design, development, support and performance tuning
Development, support and performance tuning of ETL processes related to data warehouse loads
Report development using Tableau and/or SSRS
Participate in the on-call rotation to troubleshoot and resolve database issues
Investigate and resolve data issues as needed.
Must be methodical and able to establish priorities
Must be able to recognize confidential data issues and maintain this confidentiality.
A. KNOWLEDGE/ EDUCATION AND EXPERIENCE REQUIRED:
4 year degree in Computer Science, Information Systems, Engineering or related field (required)
Three or more years designing and developing Microsoft SQL Server OLTP and OLAP solutions
One or more years of experience developing SSAS solutions for reporting and analytics. SQL Server 2012 SSAS Tabular or In-Memory experience would be a plus
Two or more years of experience developing well performing ETL solutions using SSIS or other ETL tools.
Two or more years of experience developing reports using SSRS. Tableau experience a plus.
One or more years of experience with VB.Net/C# .Net development, specifically WEB API’s and MVC development.
Strong T/SQL, MDX/DAX experience
Hadoop and/or Linux experience would be a huge plus
Seasoned in the full product development life cycle including requirements gathering
Experience developing and supporting mission critical applications that function 24 hours a day, 7 days a week
B. SKILLS REQUIRED:
Excellent written and oral communication skills
Works collaboratively with others-teamwork
Helps others accomplish objectives-teamwork
Demonstrates a friendly approach
Accurately and effectively communicates
Responds to customer needs-commitment to service
C. ABILITIES REQUIRED:
Fundamental understanding of standard data warehousing concepts and architecture . Must have extensive knowledge indexed views, and partitioning strategies.
Good understanding of data visualization techniques and previous experience building dashboards is required. Any familiarity with ASP.NET MVC and
API applications would be a plus.
High motivation and commitment to quality and customer service
Strong debugging, performance tuning and troubleshooting skills
Ability to work well within a team-oriented environment
Must be able to work in a strong team-oriented environment
Ability to handle high volumes of work without error
Mentor to, learn from, and backup other team members as necessary
Treats customers with respect-commitment to service
Promotes the mission and vision-performance excellence
Demonstrates acceptance of diverse populations
Functions as the leader of a team
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.