1872 Consulting
Azure Data Engineer – NYC, NY (Midtown) – hybrid WFH
Summary
As a crucial member of our Data and AI team, this role is pivotal in driving our data strategy and achieving our analytical goals. The individual will play an essential part in transforming raw data into actionable insights, thereby empowering the team to make data-driven decisions that enhance our financial services. With a focus on innovation and precision, the role ensures the integrity and availability of data, which is fundamental to our reporting, analytics, and machine learning initiatives. By developing and maintaining robust data pipelines and implementing efficient ETL processes, the role supports the team's mission to deliver unparalleled financial solutions and services to our clients.
What you’ll be doing General
Interact with business stakeholders at all levels to understand data needs.
Collaborate with in-house resources and consultants acting as data scientists, technical analysts, business report writers, and other SMEs to deliver high-quality data solutions.
Coordinate and communicate with members of the IT team regularly to ensure smooth IT operations.
Stay up to date with the latest trends and best practices in data engineering and related technologies.
Data Ingestion
Design, develop, deploy, and maintain scalable data pipelines and ETL processes using Microsoft Fabric.
Ingest data from various sources including, but not limited to, REST APIs, flat files, SQL databases, SharePoint libraries and lists, and Azure storage.
Optimize data ingestion method for each source considering factors such as data availability from vendor, frequency of data updates, resource usage, cost, etc.
Implement data integration solutions to consolidate data from various sources into a unified data platform.
Data Transformation
Perform data transformations at all layers of a medallion architecture to support business reporting, analytics, and machine learning needs.
Create and maintain notebooks, stored procedures, and other data transformation methods, leveraging version control.
Automate data transformations through scheduling and data pipelines
Implement data security using row-level and column-level security, and other available methods.
Platform Maintenance
Optimize and tune data workflows for performance and reliability.
Ensure data quality, integrity, and security across all data processes.
Monitor platform performance and provide utilization analysis and recommendations on required resources.
Develop and maintain documentation for data engineering processes and solutions.
Skills we're seeking
2+ years of experience with Azure Data Engineering
Proficiency in Microsoft Fabric and related technologies (e.g., Azure Data Factory, Azure Synapse Analytics, etc.)
Strong SQL experience
Experience with Python programming
Experience with Spark
Nice to haves (in no particular order)
T‑SQL experience
Experience with Data Modeling
Experience with Python libraries, specifically Pandas and MLlib
Experience with Data Science/Machine Learning
Experience with AzureDevOps
Scala or other Functional Programming experience
Azure certifications
Experience working in financial services
Bachelor's or Master's Degree in Computer Science or another IT/Data related field
#J-18808-Ljbffr
What you’ll be doing General
Interact with business stakeholders at all levels to understand data needs.
Collaborate with in-house resources and consultants acting as data scientists, technical analysts, business report writers, and other SMEs to deliver high-quality data solutions.
Coordinate and communicate with members of the IT team regularly to ensure smooth IT operations.
Stay up to date with the latest trends and best practices in data engineering and related technologies.
Data Ingestion
Design, develop, deploy, and maintain scalable data pipelines and ETL processes using Microsoft Fabric.
Ingest data from various sources including, but not limited to, REST APIs, flat files, SQL databases, SharePoint libraries and lists, and Azure storage.
Optimize data ingestion method for each source considering factors such as data availability from vendor, frequency of data updates, resource usage, cost, etc.
Implement data integration solutions to consolidate data from various sources into a unified data platform.
Data Transformation
Perform data transformations at all layers of a medallion architecture to support business reporting, analytics, and machine learning needs.
Create and maintain notebooks, stored procedures, and other data transformation methods, leveraging version control.
Automate data transformations through scheduling and data pipelines
Implement data security using row-level and column-level security, and other available methods.
Platform Maintenance
Optimize and tune data workflows for performance and reliability.
Ensure data quality, integrity, and security across all data processes.
Monitor platform performance and provide utilization analysis and recommendations on required resources.
Develop and maintain documentation for data engineering processes and solutions.
Skills we're seeking
2+ years of experience with Azure Data Engineering
Proficiency in Microsoft Fabric and related technologies (e.g., Azure Data Factory, Azure Synapse Analytics, etc.)
Strong SQL experience
Experience with Python programming
Experience with Spark
Nice to haves (in no particular order)
T‑SQL experience
Experience with Data Modeling
Experience with Python libraries, specifically Pandas and MLlib
Experience with Data Science/Machine Learning
Experience with AzureDevOps
Scala or other Functional Programming experience
Azure certifications
Experience working in financial services
Bachelor's or Master's Degree in Computer Science or another IT/Data related field
#J-18808-Ljbffr