CVS Health

Bringing our heart to every moment of your health.

Senior Application Production Support Engineer

Production EngineerProduction EngineerFull TimeRemoteSeniorTeam 10,001+Since 1963H1B No SponsorCompany Site LinkedIn

Location

Arizona + 4 more

Posted

48 days ago

Salary

$47.0K - $112.2K / year

Seniority

Senior

Bachelor Degree5 yrs expEnglishETLJava ScriptPythonRDBMSSQLSSISTableau.net

Job Description

• Provide on-call support • Monitor batch jobs • Troubleshoot problems • Perform Root Cause Analysis • Troubleshoot and optimize database queries • Maintain SOPs and run books • Complete technical requirements and testing • Act as a liaison with DBA and server teams • Manage code promotion releases • Provide application support • Provide data modeling and design guidelines and best practices • Responsible for database structures/designs to support Reporting Development • Provide direction in data integration standards, frameworks and best practices related to ETL and storage/management technologies

Job Requirements

Demonstrated proficiency in using the MS Office Suite, particularly Excel
5 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 adhoc, recurring standard reports or file builds
5 years of exposure to multiple RDBMS, as well as complex SQL Report Development skills across a variety of DB platforms
3 years developing in modern BI tools like Tableau, PowerBI, MicroStrategy and other development tools like Gitlab or Github
3 years supporting .NET applications including but not limited to technologies like VB, HTML, CSS and Javascript
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
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
Demonstrated ability innovate automated solutions using tools like Python, Batch, or PowerShell scripts
Regular communication with technical, vendor, application and PBM operations staff to ensure reporting database integrity with multiple systems-of-record data extracts