Azure Data Engineer (Financial Exp Mandatory and Locals to NY/ NJ Only)

Sans - Woodbridge Township, NJ

Full-time - Mid Level

Woodbridge Township, NJ

Educational Services

About the position

The Azure Data Engineer role focuses on designing, modeling, and developing Enterprise Data Warehouse solutions, with a strong emphasis on financial experience. The position requires hands-on involvement in testing, data pipeline development, and contributing to cloud data platform migrations, while fostering relationships with stakeholders and ensuring compliance and quality standards are met.

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 (Azure Data Factory, Data Bricks, Talend, SSIS) to develop data pipeline solutions.
• Conduct data analysis and resolve complex problems.
• Contribute to enterprise-wide Cloud Data Platform migration.
• Participate in the improvement of DevOps initiatives.

Requirements

• 6+ years of experience in development of high-availability, high volume transactional processing systems.
• Proficient in writing SQL queries and programming including stored procedures.
• Experience designing, modeling, and developing Enterprise Data Warehouse solutions.
• Ability to work independently in a fast-paced environment with minimal direction.
• Experience with physical modeling and metadata analysis efforts.
• 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.

Nice-to-haves

• Experience with Azure Cloud platform.
• Familiarity with Azure Data Factory or similar ETL tools.
• 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.