Principal Data Engineer

Cornerstone OnDemand
Jackson, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Jackson, United States of America

Tech stack

Airflow
Amazon Web Services (AWS)
Big Data
Information Engineering
Data Infrastructure
ETL
Data Mart
Data Transformation
Data Presentation
Data Security
Data Structures
Data Systems
Data Warehousing
Digital Assets
Dimensional Modeling
Salesforce
SQL Databases
Tableau
Enterprise Data Management
Data Processing
Scripting (Bash/Python/Go/Ruby)
Sql Optimization
Informatica Powercenter
Snowflake
Multi-Cloud
Data Lake
Marketo
Data Pipelines

Job description

You will partner closely with Sales, Marketing, Customer Success, and Product teams to design, build, and optimize data models and pipelines that support reporting, analytics, and self-service data access., * Lead data initiatives across business functions (Sales, Marketing, Revenue Operations, Customer Success & Support) by delivering clear, actionable insights and strong data storytelling.

  • Design, build, and maintain scalable data pipelines and transformations using Snowflake and dbt .
  • Develop and manage dimensional data models and curated data marts to support analytics and reporting.
  • Write efficient, scalable SQL to transform and analyze large datasets.
  • Partner with business stakeholders to translate requirements into data models and solutions that drive decision-making.
  • Explain enterprise data lake and data warehouse concepts clearly to non-technical audiences.
  • Ensure high standards for data quality, governance, and reliability .
  • Support and enable self-service analytics through well-structured, documented data assets.
  • Mentor team members and promote best practices in data engineering and modeling.

Requirements

  • 10+ years of experience in data engineering, analytics, or BI in an enterprise environment.
  • Strong expertise in Snowflake , including building data pipelines and optimized data structures.
  • Hands-on experience with dbt for data transformation and modeling.
  • Deep understanding of data warehousing principles , including dimensional modeling (star/snowflake schemas).
  • Advanced SQL skills for large-scale data transformation and analysis.
  • Experience working with data lakes and modern data platforms .
  • Familiarity with Python for data tasks (scripting, automation, light data processing)-no data science experience required.
  • Excellent communication skills, with the ability to explain technical concepts to business stakeholders.
  • Proven ability to partner cross-functionally and deliver business-impacting data solutions.

An extra dose of awesome if...

  • Experience working in AWS or multi-cloud environments .
  • Familiarity with orchestration and ETL tools (e.g., Airflow, Informatica, Matillion).
  • Experience supporting Tableau or similar BI tools .
  • Background supporting CRM / GTM systems (e.g., Salesforce, Marketo, Gainsight).

Apply for this position