Azure Data Engineer

Azure Data EngineerAs 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 GeneralInteract 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 IngestionDesign, 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 TransformationPerform 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 pipelinesImplement data security using row-level and column-level security, and other available methods.Platform MaintenanceOptimize 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 Seeking2+ years of experience with Azure Data EngineeringProficiency in Microsoft Fabric and related technologies (e.g., Azure Data Factory, Azure Synapse Analytics, etc.)Strong SQL experienceExperience with Python programmingExperience with SparkNice To Haves (In No Particular Order)T-SQL experienceExperience with Data ModelingExperience with Python libraries, specifically Pandas and MLlibExperience with Data Science/Machine LearningExperience with AzureDevOpsScala or other Functional Programming experienceAzure certificationsExperience working in financial servicesBachelor's or Master's Degree in Computer Science or another IT/Data related field