Lead Data Engineer - Snowflake (Remote)

Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.

Job Summary:

CareFirst BlueCross BlueShield is seeking a Lead Data Engineer to architect, deploy, and scale robust data infrastructure. This role involves leading the design and implementation of data integration frameworks, overseeing the development of data lakes and warehouses, and transforming raw data into actionable insights.

Responsibilities:

• Lead engineers are expected to manage Snowflake environments across dev, test, preprod, and prod.

• Advanced proficiency in Snowflake and related tools.

• Familiarity with DevOps practices and CI/CD pipelines

• Creating and managing databases, schemas, and service accounts.

• Refreshing environments, managing security, and ensuring compliance with data retention policies.

• Evaluate and implement best practices for data warehousing and storage.

• Executing DDL/DML operations and coordinating data migrations between environments while optimizing the performance of queries and data pipelines.

• Managing access controls using AD-integrated roles and SailPoint provisioning.

• Designing and implementing ETL/ELT pipelines that move and transform data into Snowflake.

• Supporting integration with tools like Power BI, ensuring secure and performant connectivity.

• Automating repetitive tasks and improving operational efficiency.

• Ensuring PHI and sensitive data are masked or exposed appropriately based on role-based access.

• Collaborating with Cloud and Security teams to align with enterprise policies.

• Supporting FedRAMP compliance and secure data sharing across environments.

• Manage deployment, configuration, and administration of Snowflake environments.

• Leading syncs and working sessions to resolve incidents, share updates, and mentor junior engineers.

• Delegating ownership of subject areas and tasks to team members to foster accountability and growth.

• Acting as a liaison between engineering, analytics, and business teams to define data product requirements.

• Collaborate with cross-functional teams, including data engineering, analytics, and business stakeholders, to deliver high-quality solutions.

• Participating in strategic discussions around Snowflakes role in enterprise data architecture, including AI integration and multimodal data blending.

• Maintaining detailed documentation for processes, configurations, and troubleshooting steps.

Qualifications:

Required:

• Bachelor's Degree in Computer Science, Information Technology or Engineering or related field OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.

• 8 years Experience in leading data engineering and cross functional team to implement scalable and fine tuned ETL/ELT solutions for optimal performance.

• Experience developing and updating ETL/ELT scripts.

• Hands-on experience with application development, relational database layout, development, data modeling.

• Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python).

• Knowledge and understanding of database design and implementation concepts.

• Knowledge and understanding of data exchange formats.

• Knowledge and understanding of data movement concepts.

• Strong technical and analytical and problem solving skills to troubleshoot to solve a variety of problems.

• Requires strong organizational and communication skills, written and verbal, with the ability to handle multiple priorities.

• Able to effectively provide direction to and lead technical teams.

Company:

CareFirst. It’s not just our name. It’s our promise. Founded in 1934, the company is headquartered in Baltimore, Maryland, USA, with a team of 5001-10000 employees. The company is currently Late Stage.