Lead Data Engineer
AirOps
AirflowAmazon RedshiftAWSBigQueryCloudETLGoogle Cloud PlatformPythonSQL
Data Engineer
Booker DiMaio
full-time
Posted on:
Location Type: Hybrid
Location: New York City • New York • 🇺🇸 United States
Visit company websiteJob Level
SeniorLead
Tech Stack
AzureCloudETL.NETSDLCSQL
About the role
- Responsible for all standard SDLC processes: planning, designing, coding, configuring, installing, testing, troubleshooting, integrating, performance monitoring, maintenance, enhancements, security management, and support of computer applications programs in a Microsoft .NET environment.
- Designs database tables and develops stored procedures and triggers to extract/import/export data from SQL Server into other data sources on a daily basis.
- Perform ETL/ELT data integration using Azure Data Factory or Azure Synapse Pipeline and Azure PaaS/DevOps tools.
- Attend meetings onsite in New York City a few times each month and collaborate with team members and stakeholders as required.
Requirements
- 7+ years of experience in all stages of system development life cycle, including conceptual design, software development, testing, deployment, and post-implementation enhancements of applications utilizing Visual Studio.
- 7+ years of experience with .Net with SQL Server for data management and Active Directory for identity management.
- Designs database tables, extract (import or export) data from SQL Servers into other data sources on a daily basis through the development and coding of stored procedures and triggers, as needed.
- Experience with ETL and ELT data integration.
- Experience in Azure Data Factory or Azure Synapse Pipeline.
- Knowledge of Azure cloud and associated PaaS and DevOps tools.
- Candidates must live close enough to attend meetings onsite in NYC a few times each month.
Benefits
- great environment for exceptional growth opportunities.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SDLCMicrosoft .NETSQL ServerETLELTstored procedurestriggersdata integrationVisual StudioAzure
Soft skills
collaborationcommunication
