Cygnus Professionals Inc.
Data Engineer Snowflake (W2 Contract) (Indianapolis)
Cygnus Professionals Inc., Indianapolis, Indiana, United States, 46262
Snowflake Data Engineer
Location : Indianapolis, IN onsite
Contract W2
About Cygnus Professionals, Inc. Cygnus is a Princeton, NJ-headquartered global Business IT consulting and software Services firm with offices in the USA and Asia. Cygnus offers and enables innovation and helps our clients accelerate time to market & grow their business. Over 15 years, we have taken great pride in continuing our deep relationships with our clients.
For further information about CYGNUS, please visit our website
www.cygnuspro.com
We are seeking a
Snowflake Data Engineer
to design, build, and optimize scalable data solutions on the Snowflake Data Cloud. This role will support analytics, reporting, and AI/ML initiatives across commercial, manufacturing, R&D, and quality systems. The ideal candidate has strong expertise in cloud data engineering, ELT pipelines, and enterprise-grade data platforms within regulated environments. Required Qualifications Bachelors degree in Computer Science, Engineering, Data Science, or related field 8+ years of hands-on experience in data engineering with strong focus on Snowflake Data Warehouse design and management Extensive experience designing, building, and managing
enterprise-scale Snowflake data warehouses Strong hands-on experience with
Snowflake
(SQL, Virtual Warehouses, Snowpipe, Streams, Tasks, Time Travel, Zero Copy Cloning) Proven expertise in
Snowflake warehouse management , including sizing, multi-cluster warehouses, workload isolation, concurrency scaling, and cost optimization Proficiency in
SQL
and
Python
for data transformations and orchestration Experience with cloud platforms:
AWS, Azure, or GCP Experience building robust ELT pipelines and working with structured and semi-structured data (JSON, Parquet, Avro) Strong knowledge of
data modeling for data warehouses
(star/snowflake schemas, dimensional modeling) Experience implementing
data governance, security, and access controls
in Snowflake (RBAC, masking policies, row access policies) Experience with Git-based version control and CI/CD pipelines Key Responsibilities Design, develop, and maintain scalable data pipelines using
Snowflake
as the core data platform Build and optimize ELT workflows using tools such as
dbt, Airflow, Matillion, or Fivetran Implement data models (star/snowflake schemas) to support analytics, BI, and advanced analytics use cases Optimize Snowflake performance and cost (warehouses, clustering, caching, resource monitors) Integrate data from diverse sources: ERP (SAP), CRM (Salesforce), manufacturing systems, LIMS, IoT, and external data feeds Ensure data quality, governance, lineage, and metadata management in compliance with regulatory standards (GxP, FDA, ISO) Collaborate with data analysts, data scientists, product teams, and business stakeholders Implement CI/CD, version control, and automated testing for data pipelines Support data security, access controls, and compliance requirements Participate in architecture reviews and contribute to enterprise data strategy
Cygnus Belief We believe in our commitment to diversity & inclusion.
Equal Employment Opportunity Statement Cygnus is an Equal Opportunity Employer. We ensure that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.
All our employment decisions are taken without looking into age, race, creed, color, religion, sex, nationality, disability status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other aspects of employment protected by federal, state, or local law. Applicants for employment in the US must have work authorization.
About Cygnus Professionals, Inc. Cygnus is a Princeton, NJ-headquartered global Business IT consulting and software Services firm with offices in the USA and Asia. Cygnus offers and enables innovation and helps our clients accelerate time to market & grow their business. Over 15 years, we have taken great pride in continuing our deep relationships with our clients.
For further information about CYGNUS, please visit our website
www.cygnuspro.com
We are seeking a
Snowflake Data Engineer
to design, build, and optimize scalable data solutions on the Snowflake Data Cloud. This role will support analytics, reporting, and AI/ML initiatives across commercial, manufacturing, R&D, and quality systems. The ideal candidate has strong expertise in cloud data engineering, ELT pipelines, and enterprise-grade data platforms within regulated environments. Required Qualifications Bachelors degree in Computer Science, Engineering, Data Science, or related field 8+ years of hands-on experience in data engineering with strong focus on Snowflake Data Warehouse design and management Extensive experience designing, building, and managing
enterprise-scale Snowflake data warehouses Strong hands-on experience with
Snowflake
(SQL, Virtual Warehouses, Snowpipe, Streams, Tasks, Time Travel, Zero Copy Cloning) Proven expertise in
Snowflake warehouse management , including sizing, multi-cluster warehouses, workload isolation, concurrency scaling, and cost optimization Proficiency in
SQL
and
Python
for data transformations and orchestration Experience with cloud platforms:
AWS, Azure, or GCP Experience building robust ELT pipelines and working with structured and semi-structured data (JSON, Parquet, Avro) Strong knowledge of
data modeling for data warehouses
(star/snowflake schemas, dimensional modeling) Experience implementing
data governance, security, and access controls
in Snowflake (RBAC, masking policies, row access policies) Experience with Git-based version control and CI/CD pipelines Key Responsibilities Design, develop, and maintain scalable data pipelines using
Snowflake
as the core data platform Build and optimize ELT workflows using tools such as
dbt, Airflow, Matillion, or Fivetran Implement data models (star/snowflake schemas) to support analytics, BI, and advanced analytics use cases Optimize Snowflake performance and cost (warehouses, clustering, caching, resource monitors) Integrate data from diverse sources: ERP (SAP), CRM (Salesforce), manufacturing systems, LIMS, IoT, and external data feeds Ensure data quality, governance, lineage, and metadata management in compliance with regulatory standards (GxP, FDA, ISO) Collaborate with data analysts, data scientists, product teams, and business stakeholders Implement CI/CD, version control, and automated testing for data pipelines Support data security, access controls, and compliance requirements Participate in architecture reviews and contribute to enterprise data strategy
Cygnus Belief We believe in our commitment to diversity & inclusion.
Equal Employment Opportunity Statement Cygnus is an Equal Opportunity Employer. We ensure that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.
All our employment decisions are taken without looking into age, race, creed, color, religion, sex, nationality, disability status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other aspects of employment protected by federal, state, or local law. Applicants for employment in the US must have work authorization.