Details
Posted: 24-Jun-22
Location: Frisco, Texas
Salary: Open
Categories:
General Nursing
Internal Number: 2205015525
JOB SUMMARY
The Data Warehouse Developer III will be a critical team member for the delivery of key customer commitments surrounding Conifer�s Revenue Cycle Management and Value Based Care data sets and support the build out of enterprise information management capabilities across the business.
This position requires the individual to be very logical and have strong coding skills. The developer III will work individually and as a member of a development team to design, develop and maintain customized business application software. He/She is expected to lead small to medium development projects. Developer will be involved in all aspects of the development process, including: design, development, system testing and all other aspects of the software development process. Individual will be expected to further their technical knowledge and knowledge of Conifer products during the work day and in off business hours. Self-motivated, fast learner with a desire to learn new technologies.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Include the following. Others may be assigned.
If in Data Management group:
- BI and Reporting Metadata Development / Data Warehouse Development and Integration
- Data Modeling, ETL/BI design
If in Product Development group:
- Make enhancements and build applications of any size.
- Design and build small to large size applications with little or no direction or oversight.
i. Document application flow.
ii. Lay out sql tables, stored procedures, and queries.
iii. Application code
iv. Present/Review status and completion with Sr developers, managers, and business entities.
- Able to translate business requirements/specs into technical requirements and documentation.
- Interface with all business entities including upper level management.
- Debug, read and support code written by other developers.
- Mentor/advise lower level developers.
- Contribute by writing applications that drive RCM and Value Based Care products forward.
Qualifications:KNOWLEDGE, SKILLS, ABILITIES
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
BI and Reporting Metadata Development
-
- Develop a scalable, consistent and robust metadata model within the BI and Reporting tool (IBI-Webfocus) to serve our Reporting needs
- Engage business owners/stakeholders to define the reporting and BI functional needs such as KPIs, metrics, drill up/drill down hierarchies, slice/dice capabilities, user-security requirements as well as non-functional requirements such as performance SLAs etc.
- Translate these requirements into technical specifications for the development of metadata model within IBI
- Collaborate with the Data Architect/modeler to develop the data model (Dimensional/Star schema) to ensure functional and non-functional requirements are met
- Build metadata model (synonyms, procedures etc.) with IBI such that the model is scalable and meets current and future requirements leveraging IBI best practices
- Test the metadata model for functionality, performance and collaborate with the report development to test the end-to-end solution
- Support ongoing changes and maintenance of the IBI solution including bug fixes, change requests, performance tuning and administration activities
- Must have demonstrated experience developing business intelligence reporting tools metadata and reports (at least 4-6 years) preferably using IBI Webfocus, at least 2 projects implementations experience. Also demonstrated experience in IBI tool administration, performance tuning techniques at server and metadata level
Data Warehouse Development and Integration
- Define and implement clear guiding principles and an integration reference model to enable agile, secure and timely integration of data.
- Develop programs that integrate data sources into the ecosystem. This person uses ETL (extract, transform, load) and ELT (extract, load, transform) techniques to move data from various sources systems. They should have expertise in one or more of the data integration tools in use at Conifer (T-SQL, Stored procedures, SSIS). They should have hands-on experience in loading data to different structures including Hadoop, relational and star-schema.
- Must have deep expertise (3-5 years) in data warehouse and data mart development, data integration techniques, star/dimensional schemas. Hands-on expertise in developing ETL/ELT based programs across heterogeneous sources and targets
- Must have at least (4-5) project implementations building data warehouses/data marts where he/she will show demonstrated expertise in engaging with business/technical stakeholders to understand business stakeholders, translate to technical requirements, build Source to target mapping documents, develop and test the ETL/ELT routines and support user acceptance testing
Additional Skills
- Must have excellent written and spoken communication skills and ability to engage with teams who may be remote
- Nice to have experience in data modeling (normalized, dimensional), data architecture, reference and master data management
- Nice to have Healthcare experience
- Technology Must haves - IBI Webfocus or any leading BI reporting tool, Microsoft SQL server, T-SQL, Stored procedures
- Technology Nice to have - Microsoft APS, Hadoop
Product Development
- Visual Basic
- ASP
- ASP.NET
- C#
- COM Objects
- Stored Procedures
- SQL Server/T-SQL
- HTML
Conifer requires its candidates, as applicable and as permitted by law, to obtain and provide confirmation of all required vaccinations and screenings prior to the start of employment. This may include, but is not limited to, the COVID-19 vaccination, influenza vaccination, and/or any future required vaccines and screenings.
EDUCATION / EXPERIENCE
- Bachelor�s degree in computer science, engineering or management information systems
- 6+ years of experience as a Report/BI Metadata developer
- 6+ years of experience as a ETL/ELT developer
- 5+ years of experience developing Data Marts/Data warehouses
- 3+ years of experience as Report/BI Tool Administrator
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Must be able to work in sitting position, use computer and answer telephone
- Ability to travel
- Includes ability to walk through hospital-based departments across broad campus settings, including Emergency Department environments
WORK ENVIRONMENT
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Office Work Environment
- Hospital Work Environment
TRAVEL
- Approximately 25% travel may be required
Job:
Conifer Health Solutions
Primary Location:
Frisco, Texas
Job Type:
Full-time
Shift Type:
Days
Employment practices will not be influenced or affected by an applicant�s or employee�s race, color, religion, sex (including pregnancy), national origin, age, disability, genetic information, sexual orientation, gender identity or expression, veteran status or any other legally protected status. Tenet will make reasonable accommodations for qualified individuals with disabilities unless doing so would result in an undue hardship.
