Senior Data Engineer

Role: Senior Data Engineer
Location: ONSITE- Raleigh/Pheonix/Dallas
Job type: Contract
Rate:$55/hr


Descriptions:

• Design and implement scalable, resilient data pipelines using Snowflake features including Snowpipe, Tasks, Streams, Dynamic Tables, and advanced SQL.
• Build and maintain DBT models with strong testing, documentation, and lineage.
• Develop Python ingestion frameworks for files and APIs, including schema validation, retries, and metadata capture.
• Engineer ingestion for CSV, fixed width multi record layouts, JSON, XML, Excel,and semi structured formats.
• Design Mainframe VSAM data ingestion pattern for complex EBCDIC data formats.

Schema Drift & Schema Evolution

• Detect, analyze, and manage schema drift across file, API, and replicated database sources.
• Implement metadata driven schema evolution strategies to ensure downstream stability.
• Coordinate schema changes through controlled CI/CD workflows.

Database Replication & CDC

• Configure and manage Qlik Replicate tasks for CDC and full load replication from Oracle, SQL Server, and DB2.
• Ensure idempotent, auditable, and recoverable replication pipelines with strong monitoring and reconciliation.

Data Governance, Security & Tokenization

• Implement and maintain Snowflake Data Masking policies, including dynamicmasking, conditional masking, and role based masking rules.
• Apply Protegrity tokenization for sensitive data fields across ingestion and transformation layers.
• Enforce RBAC, data access controls, and governance standards across Snowflake and supporting systems.

Orchestration & Automation

• Build and schedule workflows using Astronomer Airflow, ensuring dependencymanagement, retries, SLAs, and observability.
• Integrate pipelines with enterprise DevOps processes using GitLab and Azure DevOps for CI/CD automation.

Version Control & Code Quality

• Manage code repositories using GitLab, including branching strategies, merge requests, code reviews, and approvals.

Monitoring, Alerting & Performance Optimization

• Implement monitoring and alerting for ingestion pipelines, schema drift, replication, and transformation workloads.
• Optimize Snowflake compute, storage, and query performance; scale ingestion pipelines to meet evolving data volume and latency requirements.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.