In person interview required.
Primary Skills: SQL, EDW, BI development
Top 3 responsibilities that the hiring team will be looking for this individual to do:
•Possess strong understanding of database design concepts and deliver stable and scalable programmatic solutions.
•Maximize hands-on knowledge of SQL programming development, SQL tuning, data profiling, and query optimization.
•Utilize excellent interpersonal, analytical, problem solving, and technical skills.
This individual must have 5 years EDW and BI development experience. They must also have excellent data analyst and architectural skills. SQL Server is a must! Agile experience is another must for this role.
When it comes to soft skills the hiring team is looking for someone who has a good team based approach, strong collaboration skills, open communicator, and works well with others. This position is in a matrixed environment so individuals need to be okay with that and know how to manage it.
This position is responsible to design, develop, implement, test, and analyze programs interacting with data store and data warehouse data. This includes researching, designing, documenting, and modifying existing data throughout the production lifecycle. The software engineer will also analyze and amend data errors in a timely and accurate fashion and provide status reports where required.
An active and self-motivated Scrum team member, you contribute to successful delivery of a member health care encounters systems solution. Contribute to performance, integration, and unit testing; coordinate user acceptance testing, facilitate meetings, and perform research and analysis.
·Possess strong understanding of database design concepts and deliver stable and scalable programmatic solutions.
·Maximize hands-on knowledge of SQL programming development, SQL tuning, data profiling, and query optimization.
·Utilize excellent interpersonal, analytical, problem solving, and technical skills.
·Collaborate with appropriate project subject matter experts to gather, document, and confirm business and technical requirements.
·Assist the technical resources in understanding and translating business requirements for the purpose of developing functional requirements.
·Provide effective written and oral communication to key EDW stakeholders to report progress and to identify risks and constraints.
·Assist product owner with product backlog management, user story development, and prioritization
·Participate in Sprint planning, review, retrospective, and daily scrum stand ups. Provide transparent and continual feedback to Scrum team members and post-sprint updates to product owner for backlog refinement.
·Other projects and duties as assigned.
Bachelor’s degree in Computer Science, Software Engineering or Information Technology preferred; demonstrated experience may be considered in lieu of degree.
Five years of Enterprise Data Warehouse and Business Intelligence development experience.
Excellent data analyst and architecture skills.
Experience with data modeling and schema design techniques.
Three years of working experience in general database development using MS-SQL Server and XML.
Focus will be on writing optimal T-SQL queries, stored procedures, view creation, reading query plans, tuning, and troubleshooting issues.
Must have good problem solving, analytical and communication abilities.
Basic understanding of BizTalk.
Experience with specific phases of data warehouse and the software development life cycle, especially related to agile processes, code management, and code review.
Two years working in Agile teams with experience in developing/updating user stories, acceptance criteria and project documentation.
Experience in Test Driven Development and automated unit testing.
Familiarity with Electronic Data Exchange (EDI), specifically health insurance-related X12 specifications, including 834, 835, and 837.
Knowledge and/or experience with Encounters.
Familiarity with the health care industry.