Staff Data Engineer
About The Position
Caremark LLC, a CVS Health company, is hiring for the following role in Wellesley, MA: Staff Data Engineer to design, build and manage large scale data structures, pipelines and efficient Extract/Load/Transform (ETL) workflows to support business applications. Duties include: develop large scale data structures and pipelines to organize, collect and standardize data to generate insights and addresses reporting needs; write ETL (Extract/Transform/Load) processes, design database systems, and develop tools for real-time and offline analytic processing; collaborate with Data Science team to transform data and integrate algorithms and models into automated processes; leverage knowledge of Hadoop architecture, HDFS commands, and designing and optimizing queries to build data pipelines; utilize programming skills in Python, Java, or similar languages to build robust data pipelines and dynamic systems; build data marts and data models to support Data Science and other internal customers; integrate data from a variety of sources and ensure adherence to data quality and accessibility standards; analyze current information technology environments to identify and assess critical capabilities and recommend solutions; and experiment with available tools and advise on new tools to provide optimal solutions that meet the requirements dictated by the model/use case. Mentor junior team members. Independently lead development of solutions with high complexity and risk. Telecommuting available.
Requirements
- Bachelor’s degree (or foreign equivalent) in Computer Science, Computer Engineering, Information Technology, Engineering, or a related field
- Five (5) years of experience in Development of large data warehouses
- Five (5) years of experience in Oracle or similar databases, including advanced partitioning, indexing, SQL tuning and security
- Five (5) years of experience in ETL tools including PL/SQL, Data stage, Informatica, or Oracle warehouse builder
- Five (5) years of experience in Programming with Unix, Korn Shell Scripting, SQL, and/or PL/SQL
Responsibilities
- Develop large scale data structures and pipelines to organize, collect and standardize data to generate insights and addresses reporting needs
- Write ETL (Extract/Transform/Load) processes, design database systems, and develop tools for real-time and offline analytic processing
- Collaborate with Data Science team to transform data and integrate algorithms and models into automated processes
- Leverage knowledge of Hadoop architecture, HDFS commands, and designing and optimizing queries to build data pipelines
- Utilize programming skills in Python, Java, or similar languages to build robust data pipelines and dynamic systems
- Build data marts and data models to support Data Science and other internal customers
- Integrate data from a variety of sources and ensure adherence to data quality and accessibility standards
- Analyze current information technology environments to identify and assess critical capabilities and recommend solutions
- Experiment with available tools and advise on new tools to provide optimal solutions that meet the requirements dictated by the model/use case
- Mentor junior team members
- Independently lead development of solutions with high complexity and risk
Benefits
- Medical coverage
- Dental coverage
- Vision coverage
- 401(k) retirement savings plan
- Employee Stock Purchase Plan
- Paid Time Off (PTO)
- Paid holidays
- Wellness programs
- Education assistance
- Free development courses
- CVS store discount
- Discount programs with participating partners
- Paid time off
- Retirement savings options
- Wellness programs
- Fully-paid term life insurance plan
- Short-term disability benefits
- Long-term disability benefits
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
