Jobs via Dice
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 Associate Vice President of Corporate Services Technology. This is a full-time, in-office role with the potential for a hybrid work-from-home program based on role, tenure, and performance. Location: Camas, WA. Responsibilities
Be a trusted advisor for 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 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. Understand usage cost drivers in Azure cloud-based solutions. Manage end-to-end delivery by investigating problem areas, working with product managers 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 partners can access and manipulate data for routine and ad hoc analysis to improve results using advanced analytics. Qualifications
10+ years with T-SQL (hands-on experience with writing queries, building stored procedures, performance optimization). 4 years of experience with Azure Synapse Serverless pool. 3+ years of experience in designing, implementing, and operating 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. Semantic data modeling for reporting with Tableau or Power BI and Microsoft Fabric. Azure SQL Data Warehouse (Synapse) experience; ADF and building pipelines. Bachelor’s degree in math, computer science, engineering, finance, statistics, or a relevant field. Required Information
Workplace Type: This is a hybrid position in Camas, WA. Application Deadline: This position is anticipated to close on Oct 3, 2025. Salary and Benefits
The pay range for this position is $160,000.00 - $170,000.00/yr.
#J-18808-Ljbffr
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. This is a full-time, in-office role with the potential for a hybrid work-from-home program based on role, tenure, and performance. Location: Camas, WA. Responsibilities
Be a trusted advisor for 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 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. Understand usage cost drivers in Azure cloud-based solutions. Manage end-to-end delivery by investigating problem areas, working with product managers 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 partners can access and manipulate data for routine and ad hoc analysis to improve results using advanced analytics. Qualifications
10+ years with T-SQL (hands-on experience with writing queries, building stored procedures, performance optimization). 4 years of experience with Azure Synapse Serverless pool. 3+ years of experience in designing, implementing, and operating 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. Semantic data modeling for reporting with Tableau or Power BI and Microsoft Fabric. Azure SQL Data Warehouse (Synapse) experience; ADF and building pipelines. Bachelor’s degree in math, computer science, engineering, finance, statistics, or a relevant field. Required Information
Workplace Type: This is a hybrid position in Camas, WA. Application Deadline: This position is anticipated to close on Oct 3, 2025. Salary and Benefits
The pay range for this position is $160,000.00 - $170,000.00/yr.
#J-18808-Ljbffr