Sr Data Engineer

Overview

Client: Wealth Management

Position: Sr Data Engineer

Pay: $120K - $170K + Bonus

Locations: Plano, TX;
Camas, WA. 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.
• 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.
• Coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems.
• 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 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.

• 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.
• Dev Ops experience with Delphix (now part of Perforce) Dev Ops Data Platform and Gen Rocket for testing.
• Experience with Microsoft Purview for 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, Git Hub, Azure Dev Ops, and CI/CD pipelines.
• Advanced knowledge of ETL and/or ELT tools, including batch and real-time data transmission applications such as SSIS, Informatica, Kafka, Spark, Mule Soft, or equivalent software.
• Advanced knowledge of database technologies such as Microsoft SQL Server, Oracle, or No
  
  SQL 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 Dev Ops software.

• 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.