Business Intelligence Architect

Overview

On Site
USD 150,000.00 - 175,000.00 per year
Full Time

Skills

Software Design
Data Marts
Business Process
IaaS
SaaS
PaaS
Streaming
Dashboard
Collaboration
Unstructured Data
Cloud Computing
Management
Schematics
Relational Databases
DevOps
Continuous Integration
Continuous Delivery
Supply Chain Management
Advanced Analytics
Transact-SQL
Writing
Performance Tuning
OLTP
OLAP
NoSQL
Data Storage
Microsoft SQL Server
PostgreSQL
Cosmos-Db
Redis
Caching
Data Lake
Microsoft Azure
Analytics
Databricks
Python
Scala
Business Intelligence
Semantics
Data Modeling
Reporting
Tableau
Microsoft Power BI
Microsoft
SQL Azure
Data Warehouse
ADF
Mathematics
Computer Science
Finance
Statistics
Expect
Universe
Training And Development
Investments

Job Details

Overview

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 a Business Intelligence Architect to support our Corporate Services Technology 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:

We are looking for a Business Intelligence Architect to plan the architecture and solution design of enterprise data warehouses/data marts and reporting as part of a collection of systems in a large technology ecosystem. You will be the guide for architectural principles and standards. You will report to the Associate Vice President of Corporate Services Technology

The Day-to-Day:
  • Be a trusted advisor for our internal clients by designing and building analytics cloud solutions to promote better outcomes
  • Deliver architectures for transformation and modernization of enterprise data solutions using Azure cloud data technologies
  • Analyze current business processes and identify relevant Microsoft Azure Data & Analytics IaaS, SaaS and PaaS services
  • Help use data-driven insights to help our clients achieve outcomes and goals while respecting security requirements
  • Design and build data pipelines, data streams, reports, information dashboards, data services APIs, data generators and other data-relevant services
  • Work across client partners to gather solution requirements and propose architecture decisions
  • During implementation collect, aggregate, transform, load and analyze structured/unstructured data from multiple internal and external sources
  • Have a sound understanding of usage cost drivers in Azure cloud-based solutions
  • Manage end-to-end delivery by Investigating problem areas, working with product manager and other partners
  • Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics
  • Define effective metrics for data monitoring processes. Knowledge of DevOps processes (including CI/CD) and Infrastructure as Code fundamentals
  • Be a critical part of the data supply chain, ensuring that partners can access and manipulate data for routine and ad hoc analysis to improve results using Advanced Analytics

Your Qualifications:
  • 10+ years with T-SQL ( Hands on experience , writing queries , building stored procs, performance optimization)
  • 4 years of experience Azure Synapse Serverless pool
  • 3+ years of experience building large-scale design, implementation, and operations of OLTP, OLAP, DW and NoSQL data storage technologies such as SQL Server, Azure SQL, Azure SQL DW, PostgreSQL, Cosmos DB, Redis Cache, Azure Data Lake, Azure Stream Analytics, Event Hubs, Databricks, Python, Scala, or Power BI
  • 2+ years experience
    • As a Business Intelligence architect
    • Semantic data modeling for reporting with Tableau, or Power BI and Microsoft Fabric
    • Azure SQL Data Warehouse (Synapse)
    • ADF and building pipelines
  • Bachelor's degree in math, computer science, engineering, finance, statistics, or relevant field

Compensation:
  • $150,000 - $175,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, $10,000 fertility, family forming, and hormonal health assistance, and back-up child, adult, and elder care
  • This is an in-office role. Based on your role, tenure, and performance eligibility you may have the opportunity to participate in our hybrid work from home program. This program is subject to change.

FISHER INVESTMENTS IS AN EQUAL OPPORTUNITY EMPLOYER
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Fisher Investments