Senior Data Engineer for the MDM Data Product Team at Avenga. Responsible for provisioning data from master data customer and product systems.
About the role
- Senior Data Engineer designing and delivering modern data solutions using cloud-based platforms for Wealth Management. Collaborating with teams to enable scalable and secure data platforms.
Responsibilities
- Use Agile practices to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing and delivering enterprise data asset solutions in collaboration with business intelligence teams or other IT teams
- Develop, configure, customize and manage integration tools, databases, warehouses and analytical systems with the use of data related software
- Design, build, and deploy data extraction, transformation, and loading processes and pipelines from various sources including databases, APIs, and data files
- Develop and deploy structured, semi-structured, and unstructured data storage models such as data vault or dimensional modeling on a various platforms to meet business requirements
- Coordinate security, application monitoring, development tooling, and related capabilities with responsible teams
- Provide operational support and incident management for data pipelines and data flows, including proactively updating internal clients and relevant parties on status changes and issues encountered
- Author and maintain accurate and up-to-date documentation for processes, procedures, and technical designs
- Coach junior data and business intelligence personnel across the company, including developing material and guiding junior personnel on their technical skill growth
Requirements
- 12+ years' experience developing data-related solutions and software
- 10+ years of experience working with relational databases and applying it in various applications, including within the Microsoft Azure platform
- For DevOps experience Delphix (now part of Perforce) provides a DevOps Data Platform and GenRocket for testing
- Experience with Microsoft Purview is a comprehensive portfolio of products spanning data governance, data security, and data compliance solutions.
- 4+ years of experience with multiple cloud technologies in the Microsoft Stack (Azure IaaS and PaaS) designing and development on-premises and cloud-based (Azure) infrastructure and platform components
- 4+ years of hands-on development and deployment experience with Azure cloud using T-SQL, Azure SQL, Azure Storage, Azure Data Factory, Azure Synapse, Cosmos DB, GitHub, Azure DevOps, and CI/CD pipelines
- Advanced knowledge of Extract/Transform/Load (ETL) and/or Extract/Load/Transform (ELT) tools, including both batch and real-time data transmission applications such as SSIS, Informatica, Kafka, Spark, MuleSoft, or equivalent software
- Advanced knowledge of database technologies such as Microsoft SQL Server, Oracle, or NoSQL databases
- Advanced knowledge of multiple programming languages, such as Python, SQL, Scala, or similar.
- Advanced knowledge of IT infrastructure standards and tools, such as application performance monitoring, IT service management, or DevOps software
Benefits
- 100% paid medical, dental and vision premiums for you and your qualifying dependents
- A 50% 401(k) match, up to the IRS maximum
- 20 days of PTO, plus 10 paid holidays
- Family Support programs including 8 week Paid Primary Caregiver Leave, $10,000 fertility, family forming, and hormonal health assistance, and back-up child, adult, and elder care
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Data Warehouse Modelling Engineer designing and maintaining data models using Data Vault 2.0 for iGaming industry. Collaborating with stakeholders and optimizing data models in a hybrid work environment.
Senior Data Engineer driving impactful data solutions for the climate logistics startup HIVED's core data platform. Collaborating with cross - functional squads to enhance analytics and delivery.
Data Engineer developing and maintaining CRE forecasting infrastructure for Cushman & Wakefield. Collaborates with senior economists and technical teams to ensure high - quality data solutions.
Data Engineer at PwC, engaging with Azure cloud services to enhance data handling and integrity. Responsibilities include pipeline optimizations, documentation, and collaboration with stakeholders.
Data Engineer Manager at PwC focusing on building data infrastructure and solutions. Leading data engineering projects to transform raw data into actionable insights and drive business growth.
Junior Data Engineer at OneMarketData focusing on data quality and integrity in financial datasets. Collaborating with senior analysts and assisting in data management and analysis tasks.
Data Engineer Manager leading robust data solutions for PwC's clients. Transforming raw data into actionable insights and coaching team members.
Senior Data Engineering Analyst developing and implementing data solutions. Collaborating in a diverse environment focused on data processing and analysis for clients' digital transformation.
Principal Software Engineer in Threat Data Platform developing AI - driven tools for threat intelligence automation. Collaborating on robust data pipelines for PANW’s product ecosystem.