Data Engineer
Fisher Investments 160000.00 US Dollar . USD Per annum
2024-11-05 03:41:35
Gresham, Oregon, United States
Job type: fulltime
Job industry: I.T. & Communications
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. If you are looking for an opportunity to make a difference as we develop scalable and strategic solutions to support our global growth, we want to hear from you!
The Opportunity:
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. You will report to the Team Leader of Technology Business Services.
The Day-to-Day:
- 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
- Author and maintain accurate and up-to-date documentation for processes, procedures, and technical designs
- 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
- $90,000 - $160,000 base salary per year in the state of WA. New hires should expect to start at the lower end of the range depending on experience
- Eligible for a discretionary bonus based on firm and individual performance
We work for a bigger purpose: bettering the investment universe. We take great pride in our inclusive culture, our learning and development framework customized for every employee, and our Great Place to Work Certification. 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
- 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, fertility, family forming, and hormonal health assistance and back-up child, adult, and elder care
- $10,000 fertility, hormonal health and family-forming benefit
- Opportunity to participate in our hybrid work from home program. This program is subject to change. Based on tenure and performance eligibility, you will have the opportunity to work from home up to 75 days per year