Data Engineer

$90,000 - $160,000/Yr

Fisher Investments - Hillsboro, OR

Full-time - Mid Level

Remote - Hillsboro, OR

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

About the position

The Data Engineer will support the Technology Business Services team at Fisher Investments, focusing on building and maintaining the data warehouse for the Private Client Group business. This role involves designing and developing data extraction workloads, establishing data models, and providing operational support for data pipelines and reporting solutions. The position emphasizes collaboration with business intelligence teams and other IT departments to ensure effective data management and reporting capabilities.

Responsibilities

• Build and support the data warehouse used globally by the Private Client Group business.
• Design and develop extract workloads in Azure Data Factory.
• Build dimensional and tabular models to support data and reporting solutions.
• Define and establish data models and support tools for populating data into various repositories.
• Provide operational support and incident/problem management for data pipelines.
• Collaborate with the business to oversee data visualization and report generation.
• Coordinate with IT teams for security, monitoring, and tooling implementations.
• Use Agile practices to elicit and refine requirements for data asset solutions.
• Develop, configure, and manage integration tools and databases.
• Design, build, and deploy data extraction, transformation, and loading processes from various sources.
• Author and maintain documentation for processes and technical designs.

Requirements

• 10 years' experience developing data-related solutions and software.
• Experience with ETL and ELT tools such as SSIS, Azure Data Factory, Informatica, Kafka, Spark, or MuleSoft.
• Proficiency in database technologies like Microsoft SQL Server, Oracle, or NoSQL databases.
• Knowledge of multiple programming languages including C#, Java, Python, SQL, or Scala.
• Familiarity with IT infrastructure standards and tools related to application performance monitoring and DevOps.

Nice-to-haves

• Experience with cloud-based data solutions.
• Familiarity with data vault or dimensional modeling techniques.
• Knowledge of data governance and data quality best practices.

Benefits

• 100% paid medical, dental, and vision premiums for employees and qualifying dependents.
• 50% 401(k) match, up to the IRS maximum.
• 20 days of PTO, plus 10 paid holidays.
• Family Support programs including 8 weeks of Paid Primary Caregiver Leave.
• $10,000 fertility, hormonal health, and family-forming benefit.
• Opportunity to participate in a hybrid work from home program, allowing up to 75 days per year.