Data Engineer

About the Company: Our client, NYSTEC, is a respected, mission-driven organization focused on leveraging data, technology, and innovation to support strategic decision-making and operational excellence. As the organization continues to invest in its enterprise data capabilities, it is seeking a skilled Data Engineer to help advance its modern data platform and support future analytics, reporting, and AI initiatives.

About the Role

The Data Engineer will serve as a key member of the Business Intelligence team, responsible for designing, developing, and maintaining the organization's enterprise data platform. This individual will play a critical role in building scalable data solutions, supporting the continued adoption of Microsoft Fabric, and ensuring data is secure, reliable, and accessible across the organization.

This is a highly visible position with significant ownership and influence over data architecture, integration strategies, and platform performance. The ideal candidate is a true data engineering professional who can independently develop and support enterprise data solutions while partnering effectively with both technical and business stakeholders.

Responsibilities

Design, develop, and maintain scalable enterprise data pipelines and integration solutions. Build and support data warehouses, lakehouses, and analytical data repositories. Develop and maintain ETL/ELT processes to ingest, transform, validate, and deliver data from multiple internal and external sources. Create and optimize data models that support reporting, analytics, and business intelligence initiatives.

Develop solutions using SQL, Python, and Py. Spark to support data processing, automation, and analytics. Integrate data from enterprise applications, APIs, relational databases, cloud environments, and third-party systems. Implement and maintain data governance, security, metadata management, and data quality standards.

Monitor and optimize the performance, scalability, and reliability of the organization's data platform. Collaborate with business stakeholders and technical teams to translate business needs into scalable data solutions. Support ongoing modernization efforts and future initiatives related to analytics, artificial intelligence, and self-service reporting.

Qualifications

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Information Technology, or a related field, or an equivalent combination of education and experience. Minimum of 5 years of experience designing, developing, and supporting enterprise data platforms. Proven experience working in a Data Engineer role rather than a primarily Data Analyst-focused position.

Ability to work independently while managing multiple priorities in a collaborative environment. Strong communication and stakeholder engagement skills. Authorization to work in the United States without sponsorship.

Required Skills

Hands-on experience with Microsoft Fabric and modern Microsoft data technologies. Advanced SQL development skills, including query optimization, database design, and performance tuning. Strong proficiency with Python and/or Py. Spark. Experience designing and supporting ETL/ELT processes and data integration solutions.

Experience building and supporting data warehouses, lakehouses, and enterprise data models. Strong understanding of enterprise data architecture, governance, security, and data quality best practices. Experience integrating data from multiple source systems, APIs, databases, and cloud platforms. Strong analytical, troubleshooting, and problem-solving abilities.

Certifications (Preferred): Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) Microsoft Certified: Azure Data Engineer Associate (DP-203) Other Microsoft data platform certifications