Senior Data Engineer: AI-Driven Data Platform Lead

Greenkey Resources LLC; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Greenkey Resources LLC in New York, NY is seeking a Senior Data Engineer to lead the design and optimization of data pipelines using Microsoft Fabric and SQL Server. You will collaborate with cross-functional teams to ensure data quality and reliability for critical business processes.

You will migrate legacy systems to modern cloud data platforms, design data warehouses with medallion architecture, and build Power BI semantic models with row-level security.

Qualifications

• 7+ years of data engineering, SQL development, and ETL workflows.
• Proficiency with Microsoft SQL Server, T-SQL, and Azure SQL.
• Experience with Informatica PowerCenter and Microsoft Fabric.
• Strong data warehouse design and medallion architecture knowledge.
• Power BI semantic model development with DAX.
• Python for data engineering tasks.
• DP-700 or DP-600 certifications preferred.

Responsibilities

• Lead development and optimization of data engineering processes using Microsoft Fabric and SQL Server.
• Collaborate with cross-functional teams to ensure data integrity and reliability.
• Migrate legacy systems to cloud-based data platforms.
• Design and implement data warehouse architectures with medallion layering.
• Develop Power BI semantic models with row-level security and entitlement rules.
• Ensure compliance with data governance standards.
• Support production environments, troubleshoot issues, and optimize workflows.
• Drive innovation by integrating AI solutions.

Skills

SQL Server

T-SQL

Azure SQL

Power BI

Data Modeling

Python

AI Integration

Git CI/CD

Medallion Architecture

Data Governance

Microsoft Fabric

DAX

Education

Bachelor's degree

Tools

Informatica PowerCenter

Microsoft Fabric

Power BI

Job description

Greenkey Resources LLC in New York, NY is seeking a Senior Data Engineer to lead the design and optimization of data pipelines using Microsoft Fabric and SQL Server. You will collaborate with cross-functional teams to ensure data quality and reliability for critical business processes.

You will migrate legacy systems to modern cloud data platforms, design data warehouses with medallion architecture, and build Power BI semantic models with row-level security.