BI Architect

Post Date

Jul 25, 2025

Location

Plano,
Texas

ZIP/Postal Code

75093
US
Oct 01, 2025 Insight Global

Job Type

Perm

Category

Architect

Req #

TPA-797933

Pay Rate

$170k - $180k (estimate)

Job Description

Insight Global is seeking 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.
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

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form. The EEOC "Know Your Rights" Poster is available here.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

- 10+ years of hands on T-SQL Experience, nothing less than 10 years! (Writing queries, building stored procedures, performance optimization, etc.)
- 4+ years of 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 of Experience as a BI Architect
o Azure SQL Data Warehouse (Synapse)
o ADF building pipelines

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.