Description
Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand — with heart at its center — our purpose sends a personal message that how we deliver our services is just as important as what we deliver. Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable. *Position Summary* The Member Services team is comprised of multiple technologies with the main technologies being AS400, SQL SERVER, SSRS and SSIS. As a professional level independent contributor, you will be working as a Senior Infrastructure Analyst, and will be responsible for monitoring, troubleshooting, quality testing, and production readiness of numerous internal CVS Health Source Data System extract files as well providing application support for several internal .NET applications. In addition to taking on individual assignments, you will have operational responsibilities to ensure all data files are loaded and available for reporting done by the Member Services Report Development Team and that the supported applications are operating properly. *Responsibilities include:* 1. Provide on-call support, monitor batch jobs in Task Scheduler and RxClaim AS400 / I-Series, troubleshoot problems, and perform Root Cause Analysis 2. Have the technical expertise to provide data modeling and design guidelines and best practices 3. Responsible for database structures/designs to support Reporting Development in a high-performing and highly engaged reporting team within a PBM business operations environment. 4. Provide direction in data integration standards, frameworks and best practices related to ETL and storage/management technologies. 5. Possess the necessary architectural principles and techniques that will span across master data, transaction data and derived/analytic data. 6. Troubleshoot and optimize database queries *Required Qualifications* - 2-3 + years of experience working on RxClaim AS400/SQL Statements and SQL Scripts, Query, Job Queues, Create Macros, File Transfer (PCOMM, FTP), and Job Scheduling. - 3+ years working with SQL Server (T-SQL, SSIS, SSRS, Visual Studio) and Business Intelligence Tools (Tableau, etc.) Proficiency with writing SQL/T-SQL queries, stored procedures, functions, and views for ad-hoc, recurring standard reports or file builds - 3+ years of exposure to multiple RDBMS, as well as complex SQL Report Development skills across a variety of DB platforms - 3+ years supporting .NET applications including but not limited to technologies like VB, HTML, CSS and Javascript - 3+ years of experience in database structure/design to support Reporting Development in a high-performing and highly engaged reporting team within a PBM business operations environment - Strong technical understanding of data integration standards, frameworks and best practices; especially as they relate to ETL development. - Strong technical understanding of data modeling, design and architecture principles and techniques across master data, transaction data and derived/analytic data; strong technical expertise in data storage/management technologies - Experience crafting and optimizing table structures, queries, and views to support data processing and reporting requirements *Preferred Qualifications* - Experience in operationalizing data governance and data quality through metadata. - Regular communication with technical, vendor, application and PBM operations staff to ensure reporting database integrity with multiple systems-of-record data extracts. - Familiarity with the big data solutions and products available in the market - Strong understanding in creating and deploying best big data practices and methodologies - Strong ability to debug SSIS Packages in SQL Server and Visual Studio, identifying problem, isolating the source of the problem, and determining a work around solution. - Familiarity with healthcare analysis and process. Exposure to the Health Care Domain involving the services to policy holders, claims, eligibility, coverage and various healthcare plans - Experience using quantitative skills with the ability to link product design and features to strategic objectives while using hard data and metrics to substantiate assumptions and recommendations - Coordinate with project supervisors and business heads and manages all projects regarding enterprise data - Good interpersonal and leadership skills with demonstrated ability to work in a collaborative environment. - Oversee and monitor all frameworks to manage data across organization. - 3+ years of Data Architecture experience. Bachelor's Degree in Computer Science is preferred *Education* - Bachelor's Degree or 3-5 years equivalent experience required. *Pay Range* The typical pay range for this role is: $43,700.00 - $102,000.00This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above. In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities. The Company offers a full range of medical, dental, and vision benefits. Eligible employees may enroll in the Company's 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees. The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners. As for time off, Company employees enjoy Paid Time Off (“PTO”) or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies. For more detailed information on available benefits, please visit [jobs.CVSHealth.com/benefits](https://jobs.cvshealth.com/benefits) We anticipate the application window for this opening will close on: 06/01/2024
Apply on company website
Find Connections via Linkedin
