Knowledge of Microsoft SQL Server, Microsoft Excel, and other analytics and reporting tools.Strong understanding of database design concepts (both OLTP and OLAP).Ability to effectively collaborate with customers and analysts to translate business needs/requests into functional and/or technical requirements.
Ability to analyze and optimize SQL Queries.Create SSRS reports and maintain/enhance existing reports.Create SSIS packages and maintain/enhance existing packages.
Ability to adhere to development/deployment best practices and procedures, including: Utilizing Visual Studio for development, utilizing source control for code/script management, and following change control and code review processes.
Ability to work independently as well as in a cross-functional team environment.Ability to document and maintain solutions to common/recurring problems.
Strong attention to detail.Excellent interpersonal, analytical, business and technical judgment, problem solving, verbal and written communication skills.
Ability to build strong relationships with internal team, demonstrate excellent customer service skills, including the ability to work with customers on the phone and web meetings.
Experience in developing test plans and specification to ensure bug fixes and code updates resolve the issue identified and do not introduce other errors.
Deliver assignments on-time and on-budget with high level of quality; must be well organized.Positive attitude and ability to maintain balance under stress, and ability to work effectively with all types of people at all levels.
Provide accurate status reports, track billable time, and enter timecard information for projects on a timely basis.Other duties, as assigned.Maintains confidentiality of information.
Displays a neat, clean, professional appearance at all times.Exhibits behavior that promotes harmony and goodwill among clients and co-workers.Promotes PHC / LCS culture by providing quality, comprehensive services to all customers through a team approach.
Position Summary:Candidates applying for the Junior BI/Database Developer position must be able to develop, test, and maintain Microsoft SQL Server database objects, SSIS packages, and SSRS reports.
This role will be a member of our new Application Support team. The goal of this team is to spearhead all maintenance activities for our application suite.
This includes, but is not limited to: Break fixes, troubleshooting, monitoring, and basic enhancements.Additional responsibilities include ETL programming, basic data modeling,
design, development, and documentation based on industry best practices.Education/Experience:A Bachelor\'s Degree in Computer Science, Information Systems, or other related field (or has equivalent work experience).
1-3 years of experience in a BI/database developer or analyst role.1-3 years of experience of hands-on knowledge of SQL.