Senior Data Engineer

Cleartelligence; United States; On-site; USD 120,000 - 160,000; Full time

Job summary

Cleartelligence in the United States is seeking a Senior Data Management Consultant to design, build, and enable analytics on Snowflake and dbt-based platforms. You will lead discovery, translate business needs into robust data models, and communicate complex concepts to both technical and non-technical stakeholders.

Responsibilities span data integration, ELT pipelines, data modeling, and governance, with a strong emphasis on accuracy, security, and scalable analytics architectures.

Qualifications

• 5+ years hands-on experience in data engineering, analytics engineering, or data management roles.
• Strong Snowflake skills including data modeling, performance optimization, and security.
• Hands-on dbt for analytics engineering: model development, testing, and documentation.
• Advanced SQL with complex transformations, multi-layer queries, and analytics patterns.
• Experience developing ELT pipelines in a modern cloud data platform environment.
• Understanding of modern data warehousing, analytics engineering, and semantic modeling concepts.
• Experience with CI/CD tooling and version control using GitHub and/or GitLab.
• Ability to translate ambiguous business requirements into well-structured data models and analytics solutions.
• Strong consulting and client-facing skills, including stakeholder communication and solution ownership.

Responsibilities

• Analyze data from diverse source systems to understand upstream processes and integration requirements.
• Lead discovery and requirements-gathering with stakeholders to shape analytics solutions.
• Design and implement Snowflake-based data architectures to support analytics and reporting.
• Develop, test, and maintain robust ELT pipelines using Snowflake and dbt best practices.
• Build analytics-ready data models enabling self-service reporting and decision-making.
• Apply analytics engineering best practices, including modular modeling, testing, and version control with dbt.
• Identify and resolve data integration, quality, and performance issues across the analytics stack.
• Lead or support data migrations from on-premises or legacy platforms to Snowflake.
• Provide technical leadership on data modeling standards and analytics architecture.
• Collaborate with cross-functional teams in an agile delivery environment.
• Support release management for data platforms, pipelines, and analytics assets.
• Design and manage workflow orchestration and monitoring for data pipelines.
• Ensure data platform security, including role-based access control and secure data sharing in Snowflake.
• Communicate complex concepts clearly to clients, including tradeoffs and recommendations.

Skills

Snowflake

dbt

SQL

ELT pipelines

Data modeling

Consulting

Tools

GitHub

GitLab

Job description

As a Senior Data Management Consultant , you will play a key role in designing, building, and enabling analytics solutions on modern cloud data platforms. This role focuses on solving complex data integration and modeling challenges using Snowflake and dbt, while partnering closely with clients and stakeholders to deliver trusted, high-impact analytics solutions.

This position requires a strong blend of technical expertise and consulting skills , including the ability to lead discovery, translate business needs into well-designed data models, and communicate effectively with both technical and non-technical audiences.

RESPONSIBILITIES

• Analyze data from diverse source systems to understand upstream business processes, data semantics, and integration requirements
• Lead discovery and requirements-gathering efforts with business and technical stakeholders to shape analytics solutions
• Design and implement scalable Snowflake-based data architectures that support analytics, reporting, and downstream consumption
• Develop, test, and maintain robust, performance-optimized ELT pipelines using Snowflake and dbt best practices
• Build curated, analytics-ready data models that enable self-service reporting and decision-making
• Apply analytics engineering best practices, including modular modeling, testing, documentation, and version control using dbt
• Identify and resolve complex data integration, data quality, and performance issues across the analytics stack
• Implement and maintain CI/CD workflows for data pipelines and analytics models using GitHub or GitLab
• Lead or support data migrations from on-premises or legacy platforms to Snowflake
• Provide technical leadership and guidance on data modeling standards, transformation patterns, and analytics architecture
• Collaborate effectively with cross-functional teams using agile delivery methodologies
• Support release management for data platforms, pipelines, and analytics assets
• Design and manage workflow orchestration and monitoring for data pipelines
• Ensure data platform security, including role-based access control and secure data sharing within Snowflake
• Communicate clearly and confidently with clients, including presenting technical concepts, tradeoffs, and recommendations

QUALIFICATIONS

• 5+ years of hands-on experience in data engineering, analytics engineering, or data management roles
• Strong experience designing and delivering analytics solutions on Snowflake , including data modeling, performance optimization, and security
• Hands-on experience using dbt for analytics engineering, including model development, testing, and documentation
• Advanced SQL skills, including complex transformations, multi-layer queries, and analytical patterns
• Experience developing ELT pipelines in a modern cloud data platform environment
• Strong understanding of modern data warehousing, analytics engineering, and semantic modeling concepts
• Experience with CI/CD tooling and version control using GitHub and or GitLab
• Demonstrated ability to translate ambiguous business requirements into well-structured data models and analytics solutions
• Strong consulting and client-facing skills, including stakeholder communication, expectation management, and solution ownership
• Ability to explain complex technical concepts clearly to non-technical audiences
• Experience working in agile, client-facing, or consulting environments

The anticipated base salary for this role is $120,000 - 160,000. Final pay rate will be determined based on experience, qualifications and geographic location

It is our policy to provide and promote equal employment opportunity to all employees and applicants for employment following all local, state, and federal laws and regulations governing personnel activities. Under federal guidelines we are committed to a program of affirmative action for work sites in the United States