Senior Data Architect – Databricks Lakehouse
CVS Health
AWSCloudPySparkPythonSQLUnity
Lead Data Engineer
American Red Cross
full-time
Posted on:
Location Type: Remote
Location: Remote • North Carolina, South Carolina, Virginia • 🇺🇸 United States
Visit company websiteSalary
💰 $140,000 - $150,000 per year
Job Level
Senior
Tech Stack
Amazon RedshiftAWSCloudEC2ETLPythonSQL
About the role
- Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
- Build and implement scalable solutions that align to our data governance standards and architectural roadmap for data integrations, data storage, reporting, and analytic solutions.
- Design, develop and test data integration solutions. Write, automate and document unit/integration/functional tests.
- Manage automated deployments using Git pipelines, ensuring code changes are efficiently version-controlled and deployed.
- Collaborate with multiple teams to streamline deployment workflows, monitor and troubleshoot pipelines for reliability and performance.
- Perform data analysis required to troubleshoot data-related issues by building a data quality framework and assist in the resolution of data issues.
- Serve as tech lead by mentoring less experienced members of the team through code reviews, pair programming and similar hands-on interactions.
Requirements
- Education*: 4-year college degree or equivalent combination of education and experience. Prefer academic backgrounds in Computer Science, Engineering, Mathematics, or related technical field.
- 10 years of relevant work experience in data engineering, business intelligence or related field.
- Experience with a variety of database technologies and data warehouse schema design patterns (snowflake and star in particular).
- Experience with cloud-based databases, specifically AWS technologies (e.g., Redshift (preferred), RDS, S3, EC2, EKS, Zero ETL)
- Advanced experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets.
- Proficient in object-oriented programming ( Coding experience in Python is a required).
- Experience with DBT is preferred.
- Experience creating ETL and/or ELT jobs.
- Experience with Agile software development methodologies.
- Excellent problem solving and troubleshooting skills.
- Process oriented with great documentation skills.
- Experience with DevOps methodologies and tools (e.g., Git, Artifactory, etc.).
- Experience developing integrations across multiple systems and APIs is a plus.
Benefits
- Medical, Dental Vision plans
- Health Spending Accounts & Flexible Spending Accounts
- PTO: Starting at 19 days a year; based on type of job and tenure
- Holidays: 11 paid holidays comprised of six core holidays and five floating holidays
- 401K with up to 6% match
- Paid Family Leave
- Employee Assistance
- Disability and Insurance: Short + Long Term
- Service Awards and recognition
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data engineeringbusiness intelligencedata integration solutionsSQLPythonETLELTdata warehouse schema designDBTdata quality framework
Soft skills
problem solvingtroubleshootingmentoringcollaborationdocumentationprocess oriented
