Develop database designs and architecture in Azure, secure data migrations, and conduct data profiling while collaborating with teams on technical designs.
- Work in an Azure data warehouse environment, which includes developing database designs and architecture, data modeling and metadata repository creation
- Work with Architects, Technical Leads and Business Teams and contributes to the development of technical designs
- Secure data migrations & transformations to/from clients, customers, and vendors
- Provides technical database consultation on application development, global infrastructure, and other database administration efforts related to specific DBMS
- Conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows
- Migrate current ETL and SSIS packages to Synapse
Requirements
- 2-3+ Years of proven experience performing large data migration and transformation efforts
- Strong hands-on experience with Microsoft Azure Data & Analytics including Azure Synapse, Azure Data Factory, & Azure Data Lake Storage
- Experience in writing complex SQL queries and creating data models
- Experience or exposure to TSQL, SQL server, PL/SQL
- Experience or exposure to Informatica PowerCenter, Star Schema, Snowflake Schema
- Database performance tuning
- Data warehouse and data mart experience
- Strong knowledge of various data structures and the ability to extract data from various data sources (such as Cognos, Informatica, Hyperion, etc.)
Benefits
- Education Assistance/Student Loan Repayment - up to $2400 annually
- Remote work allowance
- Internet reimbursement
- Bench pay
- Profit share
- Healthcare reimbursement
- 401k - 4% match
- Short-Term disability
- Long-Term disability
- Life Insurance
Top Skills
Azure Data Factory
Azure Data Lake Storage
Azure Data Warehouse
Azure Synapse
Informatica Powercenter
Pl/Sql
SQL
SQL Server
Tsql
Similar Jobs
.jpg)
Big Data • Healthtech • Software
Design, build, and maintain scalable ETL/ELT pipelines using Python, Spark, Databricks, Airflow and SSIS. Integrate and cleanse diverse healthcare datasets, implement Unity Catalog for metadata and governance, optimize Spark performance and JVM tuning, support Medallion architecture, and collaborate with cross-functional teams to automate CI/CD, observability, and data quality processes.
Top Skills:
Apache AirflowSparkAWSCsvDatabricksDeltaGitlab CiJenkinsJvmMedallion ArchitectureNoSQLParquetPythonScalaSQLSsisUnity CatalogXML
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
The Lead Data Engineer designs and builds data pipelines, manages Snowflake as core data platform, and ensures data observability for AI systems at enterprise scale.
Top Skills:
AWSDbtGlueGreat ExpectationsLambdaMonte CarloPower BIPythonRedshiftS3SagemakerSnowflakeSnowparkSQL
Professional Services • Software
Lead the buildout of a new enterprise data platform, designing infrastructure, pipelines, and storage while ensuring data governance and quality.
Top Skills:
AWSAzureDatabricksGCPJavaSnowflakeSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
