Senior Data Engineer

in Information Technology
  • New York City, New York View on Map
  • Salary: $160,000.00 - $180,000.00
Permanent

Job Detail

  • Experience Level Sr Level
  • Degree Type Bachelor of Science (BS)
  • Employment Full Time
  • Working Type Hybrid
  • Job Reference 0000021410
  • Salary Type Annually
  • Industry Broker Dealer;Financial Services
  • Selling Points

    Lead impactful data engineering projects at a leading organization. Drive innovation with modern cloud-based data platforms and tools. Enhance your expertise in SQL, ETL, and Power BI technologies.

Job Description

Senior Data Engineer Overview

  • The Senior Data Engineer will lead the development and optimization of data engineering processes using Microsoft Fabric and SQL Server technologies.
  • Collaborate with cross-functional teams to ensure data integrity and reliability for critical business processes.
  • Contribute to the migration of legacy systems to modern cloud-based data platforms.
  • Design and implement data warehouse architectures using medallion layering for enhanced data accessibility.
  • Develop Power BI semantic models with robust data entitlement rules for secure reporting.
  • Ensure compliance with regulatory requirements and maintain high standards of data governance.
  • Support production environments, troubleshoot issues, and optimize workflows for efficiency.
  • Drive innovation by integrating AI solutions and modern data engineering practices.

Senior Data Engineer Key Responsibilities & Duties

  • Design and optimize SQL Server objects, including schemas, stored procedures, and queries.
  • Develop and maintain ETL workflows using Informatica PowerCenter and Microsoft Fabric tools.
  • Implement data warehouse solutions with dimensional modeling and medallion architecture.
  • Create and certify Power BI semantic models with row-level security and entitlement rules.
  • Monitor production processes, troubleshoot failures, and ensure uninterrupted data operations.
  • Apply Git version control and CI/CD pipelines to data engineering workflows.
  • Document technical processes, data lineage, and operational runbooks for team collaboration.
  • Collaborate with stakeholders to align data solutions with business requirements.

Senior Data Engineer Job Requirements

  • Bachelor’s degree in Computer Science, Information Systems, or related field.
  • 7+ years of experience in data engineering, SQL development, and ETL workflows.
  • Proficiency in Microsoft SQL Server, T-SQL, and Azure SQL.
  • Experience with Informatica PowerCenter and Microsoft Fabric tools.
  • Strong knowledge of data warehouse design and medallion architecture.
  • Hands-on experience with Power BI semantic model development and DAX.
  • Familiarity with Python for data engineering tasks.
  • Microsoft certifications such as DP-700 or DP-600 are preferred.
  • ShareAustin:

Related Jobs

  • Lead impactful IT operations, mentoring technicians and ensuring service excellence. Drive continuous improvement initiatives in a dynamic, client-focused environment. Elevate customer satisfaction through white-glove technical support.