Participates in resolving service requests by collecting business, data, and system reporting requirements by interviewing stakeholders, identifying project scope, and acting as the liaison between cross functional teams.
Documents data warehouse business rules for collection, aggregation, standardization and validation of data.
Develops and thoroughly tests ETL packages per documented service request or data warehouse requirements/specifications
Develops and prepares reports that efficiently and effectively fulfill the agreed upon requirements.
Makes recommendations for or identifies appropriate data sourcing, relative to the system of record in order to ensure data integrity and accuracy.
Conducts data profiling to understand data relationships, and recommends conforming logic.
Conducts data modeling and maintains data models.Maintains templates for capturing metadata.
RequiredKnowledge Skills and Abilities
Leading software products and technologies pertaining to data warehousing and reporting.
Knowledge of a variety of IT disciplines/technologies including: Databases, data modeling.
Knowledge of database and data warehouse design concepts.
Strong knowledge of relational databases, with the ability to perform normalization and denormalization.
Knowledge of ETL development in particular to MS SSIS platform.
Knowledge of SQL Server Query development.
Experience with a report development application, such as SSRS.
Strong interpersonal skills, including the ability to establish and maintain effective working relationships with individuals at all levels.
Strong oral and written communication skills, with the ability to effectively communicate complex technical issues to technical and non-technical audiences, make presentations and write technical specifications.
Strong organizational skills, including the ability to effectively manage multiple priorities.
Strong customer service skills, with the ability to meet with and document customer requests and deliver on negotiated timeline.
Strong collaboration skills with the ability to meet service request deadlines.
Ability to work independently and as part of a team.
Strong mathematics skills with the ability to perform data analysis.
Ability to speak and be understood in English.
Ability to handle confidential information with appropriate discretion.
PreferredKnowledge of healthcare specific computer hardware and software.
Knowledge of QNXT claims payment system.
Knowledge of managed careKnowledge of the Agile Scrum software development framework.
Intermediate Microsoft Visio skills, with ability to create flow diagrams from business requirements.
Intermediate Excel skills, with ability to write complex formulas.