Michael Page- Data Engineer (Hybrid- NYC)

PageGroup - New York, NY

Full-time - Mid Level

Hybrid - New York, NY

Administrative and Support Services

About the position

The Data Engineer position is a hybrid role based in New York City, focusing on designing, modeling, and developing Enterprise Data Warehouse solutions. The role requires hands-on experience with SQL, programming, and ETL tools, and involves significant contributions to cloud data platform migrations and DevOps initiatives.

Responsibilities

• Design, model, and develop Enterprise Data Warehouse solutions.
• Coordinate and execute SIT and UAT testing for Enterprise Data Warehouse solutions.
• Write SQL queries and programming including stored procedures and reverse engineer existing processes.
• Leverage SQL, programming languages (Python or similar), and/or ETL tools to develop data pipeline solutions.
• Contribute to an enterprise-wide Cloud Data Platform migration.
• Participate in the improvement of DevOps initiatives.
• Provide database design guidance and work with DBAs to troubleshoot problems and optimize performance.
• Support ongoing data management efforts in Development, QA, and Production environments.
• Guide less experienced staff in resolving escalated issues and complex production problems.
• Develop new documentation and ensure quality, security, and compliance requirements are met.

Requirements

• 6+ years of experience in development of high-availability, high volume transactional processing systems.
• Proficiency in working with systems required to effectively process large volumes of both real-time and batch transactions.
• Experience designing, modeling, and developing Enterprise Data Warehouse solutions.
• Proficient in writing SQL queries and programming including stored procedures and reverse engineering existing processes.
• Understanding of physical modeling and metadata analysis efforts.

Nice-to-haves

• Experience with Azure Cloud platform.
• Experience with Azure Data Factory or similar ETL tool.
• Experience with Azure Data Bricks.
• Knowledge of columnar Data Warehouse solutions like Snowflake, RedShift, Vertica, Greenplum.
• Experience in the capital markets industry.
• Snowflake development experience.
• SQL Server development experience.

Benefits

• Competitive compensation hourly rate based on candidate's previous experience.