Job Description
Job Description
Client : Wealth Management
Position : Sr Data Engineer
Pay : $120K - $170K + Bonus
Locations : - First 90 days on site with 1 day a week WFH afterwards
Scope : This role will design and deliver modern data solutions using cloud-based platforms and AI-driven innovations. They will partner with business, technology, and governance teams to enable scalable, secure and compliant data platforms that power advanced analytics and AI. They will act as the enterprise expert for designing, developing, and optimizing data processing systems and pipelines used to populate data into transactional databases, data warehouses, data marts, or other data repositories. They will also coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems.
Education : Computer Science, Information Technology, or other relevant field
Experience :
12+ years' experience developing data-related solutions and software10+ years of experience working with relational databases and applying it in various applications, including within the Microsoft Azure platformFor DevOps experience Delphix (now part of Perforce) provides a DevOps Data Platform and GenRocket for testingExperience 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 components4+ 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 pipelinesAdvanced 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 softwareAdvanced knowledge of database technologies such as Microsoft SQL Server, Oracle, or NoSQL databasesAdvanced 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 softwareResponsibilities :
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 teamsDevelop, configure, customize and manage integration tools, databases, warehouses and analytical systems with the use of data related softwareDesign, build, and deploy data extraction, transformation, and loading processes and pipelines from various sources including databases, APIs, and data filesDevelop and deploy structured, semi-structured, and unstructured data storage models such as data vault or dimensional modeling on a various platforms to meet business requirementsCoordinate security, application monitoring, development tooling, and related capabilities with responsible teamsProvide operational support and incident management for data pipelines and data flows, including proactively updating internal clients and relevant parties on status changes and issues encounteredAuthor and maintain accurate and up-to-date documentation for processes, procedures, and technical designsCoach junior data and business intelligence personnel across the company, including developing material and guiding junior personnel on their technical skill growthBenefits :
100% paid medical, dental and vision premiums for you and your qualifying dependentsA 50% 401(k) match, up to the IRS maximum20 days of PTO, plus 10 paid holidaysFamily 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