Data & Analytics Architect

Company: Fisher Investments
Location: Camas
Posted on: November 13, 2024

Job Description:

It's an exciting time to be a member of the Fisher Investments Technology Department. We're investing in the future of our firm's technology and are building our team to achieve global growth. We are looking for a Data Engineer to support our Technology Business Services team. The Data Engineer will join the Business Intelligence team building and supporting the data warehouse used globally by our Private Client Group business. The team designs and develops extract workloads in Azure Data Factory, builds dimensional and tabular models to support data and reporting solutions. You will define and establish data models and supporting the tools and methods of populating data into transactional databases, data warehouses, data marts, or other data repositories and establishing and supporting reporting toolsets and frameworks. You will provide operational support and incident/problem management including logging, instrumentation, analysis, and implementation of process improvements. You will collaborate with the business to oversee the visualization of data and report generation to meet various needs. You will coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities. 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, our users, or other IT teams
Develop, configure, customize and manage integration tools, databases, warehouses 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 variety platforms to meet the 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
10 years' experience developing data-related solutions and software
- Experience of Extract/Transform/Load (ETL) and Extract/Load/Transform (ELT) tools, including both batch and real-time data transmission applications such as SSIS, Azure Data Factory, Informatica, Kafka, Spark, MuleSoft, or equivalent software
- Experience of database technologies such as Microsoft SQL Server, Oracle, or NoSQL databases
- Experience of multiple programming languages, such as C#, Java, Python, SQL, Scala, or similar
- Knowledge of IT infrastructure standards and tools, such as application performance monitoring, IT service management, and DevOps software
- Bachelor's or foreign equivalent degree in MIS, computer science or a related field required

Eligible for a discretionary bonus based on firm and individual performance

It's the people that make the Fisher purpose possible, and we invest in them by offering exceptional benefits like:
-100% paid medical, dental and vision premiums for you and your qualifying dependents
- 20 days of PTO, plus 10 paid holidays
- Family Support programs including 8 week Paid Primary Caregiver Leave, fertility, family forming, and hormonal health assistance and back-up child, adult, and elder care
-$Opportunity to participate in our hybrid work from home program. Based on tenure and performance eligibility, you will have the opportunity to work from home up to 75 days per year

Keywords: Fisher Investments, Salem , Data & Analytics Architect, Other , Camas, Oregon