Senior Data Engineer - Portfolio Management Group

$150,000 - $175,000/Yr

Fisher Investments - Portland, OR

Full-time - Mid Level

Remote - Portland, OR

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

It's an exciting time to join Fisher Investments; we're investing in the future of our firm's technology and information security. Our business is growing internationally, which emphasizes the need to build an unparalleled team that promotes future global growth through strategic solutions and progress. The Senior Data Engineer will report to the VP of Portfolio Management Technology. You will be intimately familiar with Wealth Management concepts and data domains and have expertise in modeling data and data frameworks and repositories. You will oversee the design and development of all data and reporting solutions for the Portfolio Management Group (PMG) following the broader data strategy. The scope of responsibilities will include defining and establishing PMG data models and supporting the tools and methods of populating PMG data into transactional databases, data warehouses, data marts, or other data repositories and establishing and supporting reporting toolsets and frameworks. You will collaborate with the PMG business to oversee the visualization of data and report generation to meet various needs. You will oversee coordination with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems.

Responsibilities

• Establish data models to support the distribution of Portfolio Management Data
• Build processes and tools for storing and populating data
• Develop, configure, customize and manage integration tools, databases, warehouses and analytical systems with the use of data related software
• Implement & administer visualization tools such as Power BI and Tableau
• 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, users, or other IT teams
• 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 variety of platforms to meet 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, including developing material, mentoring, and guiding junior personnel on their technical skill growth

Requirements

• 7+ years' experience in developing data-related solutions and software
• Strong knowledge of Wealth Management concepts and Portfolio Management data domains
• Experience with visualization tools such as Power BI, Tableau etc.
• Experience with MS Azure tools such as ADF, Azure Synapse etc.
• Experience with database technologies such as Microsoft SQL Server, and NoSQL databases
• Experience with multiple programming languages, such as C#, .Net, Python, SQL, or similar
• Experience with Extract/Transform/Load (ETL) 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
• Experience with IT infrastructure standards and tools, such as application performance monitoring, IT service management, or DevOps software
• Bachelor's degree or equivalent combination of education/experience required

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 weeks Paid Primary Caregiver leave, adoption assistance and back-up child care
• $10,000 fertility, hormonal health and family-forming benefit
• Opportunity to participate in our hybrid work from home program, with the opportunity to work from home up to 75 days per year based on tenure and performance eligibility