Senior Data Engineer

Cognizant•Charlotte, NC

3d•$70,000 - $117,000•Onsite

About The Position

We are seeking an experienced Senior Data Engineer / Architect with 14+ years of expertise in designing and implementing scalable data solutions. The ideal candidate will have strong proficiency in Snowflake, ETL/ELT pipelines, dbt, Airflow, and Salesforce integration, along with hands-on experience in cloud platforms and data orchestration tools. This role involves leading data architecture initiatives, optimizing data workflows, and ensuring high-performance data systems to support business intelligence and analytics.

Requirements

10+ years of experience in Data Engineering, with strong expertise in Snowflake, ETL/ELT, and data modeling.
Hands-on experience with dbt, Airflow, and Python scripting for data orchestration and automation.
Proficiency in Salesforce integration and data management.
Strong knowledge of RDBMS (Oracle, Teradata, Postgres) and SQL performance tuning.
Experience with AWS services (S3, Redshift) and cloud-based data warehousing.
Familiarity with Informatica IICS, Matillion, and other ETL tools.
Excellent problem-solving, communication, and collaboration skills.

Nice To Haves

Experience with Kafka, MongoDB, and Cassandra Graph.
Knowledge of data governance frameworks and compliance standards.
Exposure to BI tools like Tableau, Power BI, and Business Objects.

Responsibilities

Design and implement data architecture and data models for enterprise-scale solutions on Snowflake and AWS Cloud.
Lead database migration, deployment, and production releases across environments (Dev, QA, Prod).
Develop and optimize ELT pipelines using Airflow, Python, and dbt, improving efficiency and reducing manual processes.
Implement dbt for modular data transformation, testing, and documentation; create custom macros for automation.
Build and maintain ETL processes using Matillion, integrating data from Salesforce, Oracle, and Teradata into Snowflake.
Configure and manage Snowflake features such as Snowpipe, Time Travel, and Zero-Copy Cloning for continuous data loading and recovery.
Optimize SQL queries and database performance across Snowflake, Postgres, Redshift, and Oracle.
Manage Salesforce data integration, including standard/custom objects, roles, security profiles, and workflow rules.
Ensure data governance, security, and compliance across all data platforms.
Create data visualizations using Tableau, Power BI, and Einstein Analytics to support business insights.
Collaborate with cross-functional teams to gather requirements and deliver scalable data solutions.
Provide technical leadership and mentor junior engineers on best practices in data engineering and analytics.