Richardson, Texas

Job Description
As the Advisor of Application Development, you will be responsible for Product/Application development for the EDW team. The Advisor, Application Development will be accountable for delivering comprehensive solutions that meet business requirements and incrementally move the data warehouse to the future state. The position requires strong attention to detail, excellent communications skills, and exceptional follow through.

Role and Responsibilities:

• Perform data profiling, analysis and mining activities by writing queries using DB tools like SQL Developer/Sever, IBM Data Studio, Aginity workbench and PostgreSQL.
• Interact with business partners to gather requirements through various elicitation techniques, including JAD (Joint Application Development) sessions.
• Create Business, Functional and Non-Functional Requirement documents, Metadata Specifications, ETL (Extract Transform and Load) Mapping documents, and Reporting Requirements using requirement gathering tools like RTC and RRC.
• Create Data mapping documents based on the standard reports format like 837-Claims and 834-Member Enrollment transactions.
• Analyze existing manual process and create automation algorithms.
• Perform and manage end to end design, development, integration, testing and deployment, supporting the Dev, QA, UAT and Production phases for the projects using technologies like SQL, IBM data analytics products to meet the requirements.
• Review the application design, component design, integration and unit test plans/results of the project. Analyze QA/UAT defects and production issues.
• Lead Business Analysts, development and testing teams in execution of Agile methodologies by applying advanced domain knowledge to deliver business value.
• Mentoring the team and contribute in providing work estimate for the project and effective communication with the project manager regarding the project schedule, progress, risks and impediments. Provide knowledge transition to production support teams and perform project closure activities upon successful completion of the project.
• Experience on creating Business, Functional and Non-Functional Requirements and delivery of solutions for state/federal mandated All Payer Claim Data base (APCD) state compliance and regulatory initiatives for Health Care/PBM business.
• Provides technical oversight for the design, development, testing, implementation, and maintenance of DW solutions along with required artifacts including design documents, process manuals.
• Create new software products, modify existing software to correct errors, to adapt it to new hardware, or to upgrade interfaces and improve performance using datawarehousing technologies.
• Expertise in Data modelling.
• Hands-on experience and knowledge of Data Warehouse best practices, IBM Netezza, Teradata, and ETL Informatica and DataStage.
• Ability to solve issues by coordinating across cross-functional areas by interfacing between hardware and software, develop specifications and performance requirements, or resolve customer problems.

• Provide solutions to enable analytics users by applying mathematical principles or statistical approaches to solve problems in scientific or applied fields.

• Work with business users to understand the current state of information available in the upstream systems in the organization and identify the future needs based on the analysis of business requirements, current state environments, gap analysis and future state warehousing implementations.

• Works closely with architects, project managers, and cross-functional teams for estimation, impact analysis, and coordination between different teams in the warehouse.

• Coordinate with internal/External customers or other departments on project status, proposals, or technical issues, such as software system design or maintenance. Provide support to QA teams during the test execution phase of the project.

• Strong interpersonal, teamwork, organizational and workload planning skills

• Experience in configuration management and software release principles as well as change management concepts

• Strong analytical, evaluative, and problem-solving abilities as well as exceptional customer service orientation

• Experience in managing medium to large sized projects relating to the delivery of applications or application changes

• Excellent written and verbal communication skills as well as excellent interpersonal skills.

• Lead the development team to set clear expectations of milestones and goals.

• Experience in leveraging Managed Services or 3rd party resources to meet application support requirements

• Represent Data Warehouse in meetings for owned projects.

• Performs miscellaneous job-related duties as assigned.

Required Qualifications
• 8+ years’ experience in Data Warehousing.
• 4+ years’ experience in Project/Product owner role.
• 5+ years of Teradata, Netezza, Informatica & DataStage experience or related application.
• 8+ years’ experience working in a cross-functional environment.
• 6+ years of APCD state compliance and regulatory projects experience.
• 10+ years of SQL experience to perform data profiling, analysis, and mining activities on complex and big data sources.
• PBM/Healthcare experience.

COVID Requirements
COVID-19 Vaccination Requirement
CVS Health requires its Colleagues in certain positions to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, pregnancy, or religious belief that prevents them from being vaccinated.
  • If you are vaccinated, you are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status within the first 30 days of your employment. For the two COVID-19 shot regimen, you will be required to provide proof of your second COVID-19 shot within the first 60 days of your employment. Failure to provide timely proof of your COVID-19 vaccination status will result in the termination of your employment with CVS Health.
  • If you are unable to be fully vaccinated due to disability, medical condition, pregnancy, or religious belief, you will be required to apply for a reasonable accommodation within the first 30 days of your employment in order to remain employed with CVS Health. As a part of this process, you will be required to provide information or documentation about the reason you cannot be vaccinated. If your request for an accommodation is not approved, then your employment may be terminated.

Preferred Qualifications
• Excellent oral and written communications skills; ability to interact effectively with all levels within the organization.
• Working experience with Agile/SAFE and SDLC methodology.
• Ability to interact and work effectively with technical & non-technical levels within the organization.
• Ability to drive clarity of purpose and goals during release and planning activities
• Excellent organizational skills including ability to prioritize tasks efficiently with high level of attention to detail.

Bachelor’s degree in computer science, Information Technology or related field or 8+ years of relevant work experience

Business Overview
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.

We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, sex/gender, sexual orientation, gender identity or expression, age, disability or protected veteran status or on any other basis or characteristic prohibited by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities. See Job Description

Richardson, Texas

Continue serving and work with a purpose

As a CVS Health colleague, you'll find career opportunities across the organization and at every stage of your career. More important, your work will have an impactful purpose on someone's life, including your own. Learn more about how you can continue serving on your next mission at CVS Health.

Careers for Veterans and Military Spouses


"The military has an ethos that is grounded in purpose-driven service that’s bigger than the individual. The same holds true for us at CVS Health. You can talk to colleagues in any part of our business and they will be able to articulate our company’s purpose. Working here provides an opportunity for service members and military spouses to continue to serve, just in a civvies."

Similar jobs