Data Engineer – Lead Analyst
The Cigna Group
CloudETLPySparkPythonSQL
Data Engineer II
Openly
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $108,000 - $121,500 per year
Job Level
JuniorMid-Level
Tech Stack
CloudPythonSQLTerraform
About the role
- Design, create, and maintain data solutions. This includes data pipelines and data structures.
- Work with data users, data science, and business intelligence personnel, to create data solutions to be used in various projects.
- Translating concepts to code to enhance our data management frameworks and services to strive towards providing a high quality data product to our data users.
- Collaborate with our product, operations, and technology teams to develop and deploy new solutions related to data architecture and data pipelines to enable a best-in-class product for our data users.
- Collaborating with teammates to derive design and solution decisions related to architecture, operations, deployment techniques, technologies, policies, processes, etc.
- Participate in domain, stand ups, weekly 1:1's, team collaborations, and biweekly retros
- Assist in educating others on different aspects of data (e.g. data management best practices, data pipelining best practices, SQL tuning)
- Share your knowledge within the data engineer team and with others in the company (e.g. tech all-hands, tech learning hour, domain meetings, code sync meetings, etc.)
Requirements
- 1 to 2 years of data engineering and data management experience.
- Proficiency with SQL optimization and development.
- Python scripting experience.
- Basic understanding and usage of a development and deployment lifecycle, automated code deployments (CI/CD), code repositories, and code management.
- Experience with Google Cloud data store and data orchestration technologies and concepts.
- Hands-on experience and understanding of the entire data pipeline architecture: Data replication tools, staging data, data transformation, data movement, and cloud based data platforms.
- Understanding of a modern next generation data warehouse platform, such as the Lakehouse and multi-data layered warehouse.
- Ability to understand data architecture and modeling as it relates to business goals and objectives.
- Ability to gain an understanding of data requirements, translate them into source to target data mappings, and build a working solution.
- Experience with terraform preferred but not required.
Benefits
- Remote-First Culture - We supported #remotelife long before it was a given. We'll keep promoting it.
- Competitive Salary & Equity
- Comprehensive Medical, Dental, and Vision Plan Offerings
- Life and disability coverage including voluntary options
- Parental Leave - up to 8 weeks (320 hours) of paid parental leave based on meeting eligibility requirements
- 401K Company Contribution - Openly contributes 3% of the employee's gross income, even if the employee does not contribute.
- Work-from-home stipend - We provide a $1,500 allowance to spend on setting up your home workplace
- Annual Professional Development Fund: Each employee has $2,000 in professional development (PD) funds to spend on activities or resources annually. We want each Openly employee to achieve personal and professional success and to feel supported, confident, and informed about improving their efficiency and productivity.
- Be Well Program - Employees receive $50 per month to use towards your overall well-being
- Paid Volunteer Service Hours
- Referral Program and Reward
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data engineeringdata managementSQL optimizationPython scriptingCI/CDdata pipeline architecturedata transformationdata movementdata replication toolsdata orchestration
Soft skills
collaborationcommunicationeducational skillsproblem-solvingteamwork
