Senior Snowflake Data Engineer - Data Modernization & Analytics

Cornerstonetechtalent; Austin (TX); Remote; USD 150,000 - 190,000; Full time

Job summary

CornerStone Technology Talent Services seeks a Senior Snowflake Data Engineer to modernize legacy data extracts into cloud-based pipelines and analytics. You will transform complex source systems, optimize Snowflake solutions, and enable trusted business reporting via Power BI.

You will work across the data lifecycle—from reverse engineering data to validating Snowflake loads and supporting semantic models. Strong collaboration with data engineers and stakeholders is essential.

Qualifications

• 8+ years of hands-on Snowflake experience with SQL development and performance tuning.
• 4+ years in ETL/ELT concepts, data pipelines, and data integration patterns.
• 5+ years analyzing complex data flows and troubleshooting across systems.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines into Snowflake.
• Reverse engineer data extracts and document source-to-business mappings.
• Develop and optimize Snowflake SQL, loading processes, and transformations.
• Collaborate on data modeling, schema design, and transformation logic.
• Validate mappings, reconcile results, and investigate discrepancies.
• Support Power BI datasets and dashboards using Snowflake as the data source.
• Troubleshoot data flows end-to-end from source to reporting.
• Document data flows, metadata, and procedures for maintainability.

Skills

Data modeling

Documentation

Cross-functional collaboration

Problem solving

Analytical thinking

Education

Bachelor's degree in CS or related field

Tools

Snowflake

SQL

ETL/ELT

Power BI

Informatica

Matillion

Azure Data Factory

Job description

Senior Snowflake Data Engineer – Data Modernization & Analytics

Location: Remote Employment Type: Full-time contract with potential for extension

Build the data foundation that makes modern analytics possible. CornerStone Technology Talent Services (TTS) is seeking a Senior Snowflake Data Engineer to help transform legacy data extracts and reporting processes into reliable cloud-based data pipelines and analytics. This opportunity is ideal for a hands-on engineer who can understand complex source systems, develop efficient Snowflake solutions, and ensure business users can trust the results. You will work across the data lifecycle—from reverse engineering existing extracts and mapping transformation rules to validating Snowflake loads and supporting Power BI semantic models and dashboards. Success requires strong technical execution, careful reconciliation, and the ability to connect business reporting needs with sound data engineering practices.

What You’ll Do

• Design, develop, and maintain ETL/ELT pipelines that ingest and transform data from legacy mainframe and enterprise application environments into Snowflake.
• Reverse engineer existing data extracts, reporting logic, and dependencies to document how source data supports business needs.
• Develop and optimize Snowflake SQL, data-loading processes, and transformations for reliable, efficient processing.
• Collaborate with data engineers and architects on data modeling, schema design, and transformation logic.
• Validate source-to-target mappings, reconcile results across systems, and investigate discrepancies to protect data accuracy and completeness.
• Support Power BI datasets, semantic models, and dashboards using Snowflake as the primary data source.
• Troubleshoot issues across the complete data flow, from source extraction through Snowflake ingestion to Power BI reporting.
• Translate stakeholder requirements into clear functional specifications, technical designs, and documentation.
• Develop data conversion and implementation plans; participate in code reviews, testing, and production support.
• Document data flows, metadata, system dependencies, and operational procedures to support maintainability and self-service analytics.

Required Qualifications

• 8+ years of hands-on Snowflake experience, including SQL development, data loading, transformations, and performance tuning.
• 4+ years of experience with ETL/ELT concepts, data pipelines, and data integration patterns.
• 5+ years of experience analyzing complex data flows and troubleshooting issues across multiple systems.
• 4+ years of experience with enterprise information management processes, relational database management systems, and metadata management.
• 2+ years of experience delivering against project deadlines in fast-paced, changing environments, including analyzing complex information and developing plans to resolve issues.
• 2+ years of experience collaborating across technical and business teams, resolving conflicts, negotiating priorities, and maintaining effective working relationships under pressure.

Preferred Qualifications

• 3+ years of experience with Informatica, Matillion, Azure Data Factory, or comparable data integration tools.
• Experience modernizing legacy mainframe or IMS data extracts for cloud data platforms.
• Experience supporting Power BI datasets, semantic models, and dashboards connected to Snowflake.
• Experience documenting source-to-target mappings, transformation rules, data lineage, and reconciliation procedures.
• Bachelor’s degree in computer science, data processing, business administration, or a related field.

What Makes You a Strong Match

You can explain how data moves, why transformations occur, and how you verify that the final report reflects the source accurately. You are comfortable working through incomplete legacy documentation, investigating data discrepancies, and partnering with stakeholders to clarify reporting requirements. Your experience includes building and supporting production pipelines, with clear examples of the Snowflake work you personally delivered.

Why CornerStone TTS?

CornerStone Technology Talent Services connects technology professionals with opportunities where their expertise can make a measurable difference. Backed by more than 30 years of staffing experience and a network serving over 1,000 clients, we bring technical recruiting knowledge, established client relationships, and personalized support to your search. This engagement offers the opportunity to contribute to a substantial data modernization initiative, work across Snowflake and Power BI, and help shape a dependable foundation for enterprise reporting and analytics.