Business Intelligence Architect

Overview

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 Application Development Team Leader.

 

The Day To Day:

• Be a trusted advisor for our internal clients by designing and building analytics cloud solutions to enable 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 stakeholders 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 consumption cost drivers in Azure cloud-based solutions
• Manage end-to-end delivery by Investigating problem areas, working cross-functionally with product manager & other stakeholders
• 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 stakeholders can access and manipulate data for routine and ad hoc analysis to improve results using Advanced Analytics

Your Qualifications:

• Bachelor's degree in math, computer science, engineering, finance, statistics, or relevant field
• 7+ years with T-SQL ( Hands on experience , writing queries , building stored procs, performance optimization)
• 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 using Azure SQL Data Warehouse (Synapse) and Azure Synapse Serverless pool - 4 years
• 2+ years hands on experience with ADF and building pipelines

Why Fisher Investments:

 

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 (*17 days of PTO and 3 days of sick time for California employees)
• Family Support programs including 8 weeks Paid Primary Caregiver leave, adoption assistance and back-up child care
• Opportunity to participate in our hybrid work from home test. This program is a pilot test and subject to change. Based on tenure and performance eligibility, you will have the opportunity to work from home up to 100 days per year

FISHER INVESTMENTS IS AN EQUAL OPPORTUNITY EMPLOYER