> Markdown version of [/jobs/ext/3967359-sr-bi-engineer-data-architect](https://www.wearedevelopers.com/jobs/ext/3967359-sr-bi-engineer-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Sr. BI Engineer/Data Architect

- **Company:** Outsource Technical, LLC
- **Location:** Orange, CA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** .NET Framework, Microsoft Excel, Application Programming Interfaces (APIs), Business Analytics Applications, Microsoft Azure, Backup Devices, C Sharp (Programming Language), Profiling, Databases, Data as a Services, Data Architecture, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Mart, Data Warehousing, Dimensional Modeling, Disaster Recovery, Fault Tolerance, Python (Programming Language), Metadata Standards, Microsoft Software, Microsoft SQL Server, SQL Azure, MySQL, Oracle (Applications), Performance Tuning, Windows PowerShell, Power BI, Software Engineering, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Agent, SQL Server Integration Services, SQL Server Analysis Services, Tableau (Software), Transact-SQL, Enterprise Data Management, Data Logging, Diagnostic Tools, Data Processing, Azure Data Factory, Change Data Capture, Indexer, Data Strategy, Git, Powerquery, Microsoft Fabric, Data Management, Cloud Migration, SQL Server Management Studio (SSMS), Software Version Control, Data Pipelines
- **Published:** October 27, 2026
- **Apply:** https://www.careerbuilder.com/job-details/sr-bi-engineer-data-architect-orange-ca--b0d543e0-9ac9-4e62-af97-b3a12926e493

## About the Role

Business Intelligence, DataArchitect Data Modeling Tool, Business Intelligence, Database Administration, Microsoft Product Family, Microsoft SQL Server, Production Support, Data Warehousing, Communication Skills, Enterprise Data Integration, * 8+ years of progressive experience in BI, data engineering, data warehousing, database architecture, or SQL Server administration, including enterprise production support and end-to-end solution delivery.

 * Expert T-SQL and advanced SQL Server development; strong performance tuning using execution plans, Query Store, Dynamic Management Views (DMVs), Extended Events, Profiler, or comparable diagnostic tools.
 * Demonstrated data warehouse architecture and dimensional modeling experience, including conceptual/logical/physical models, Slowly Changing Dimensions, indexing, partitioning, retention, and scalable load design.
 * Hands-on ETL/ELT development with SSIS and/or modern cloud data services, including incremental processing, Change Data Capture (CDC), scheduling, fault-tolerant and recoverable data pipeline, validation, auditing, and heterogeneous source integration.
 * Strong Power BI experience with data modeling, Power Query, DAX, interactive reporting, security, deployment, and refresh administration; working knowledge of SSRS.
 * Production DBA experience with backup/recovery, disaster recovery, security, monitoring, automation, troubleshooting, migrations, upgrades, and high-availability concepts.
 * Ability to communicate technical concepts clearly, work independently, document solutions, prioritize production and project demands, and collaborate with technical and nontechnical stakeholders., Microsoft Fabric, Azure SQL, Azure Data Factory, SSAS/tabular models, MySQL, Oracle, APIs, Git/Azure DevOps, Python, PowerShell, C#/.NET, Tableau, master data management, data governance, cloud migration, and mentoring experience. Bachelor's degree in a relevant field or equivalent professional experience; applicable Microsoft certifications are desirable.

## Description

Seeking a senior technical professional to architect, build, administer, and support enterprise data warehouse, integration, reporting, and analytics solutions. This role owns the full lifecycle from requirements and design through development, deployment, validation, optimization, and production support. The ideal candidate combines advanced SQL Server and Microsoft BI expertise with strong business communication and practical experience supporting reliable, secure, and scalable data platforms., * Design and maintain enterprise data warehouse, data mart, staging, semantic, and reporting architectures using dimensional models, fact and dimension tables, star/snowflake schemas, metadata standards, and historical data strategies.

 * Develop, deploy, and support ETL/ELT pipelines using T-SQL, SSIS, Azure Data Factory, Microsoft Fabric, or equivalent tools; integrate SQL Server, MySQL, Oracle, Azure SQL, files, APIs, and other enterprise sources.
 * Create governed Power BI datasets, semantic models, dashboards, KPIs, and executive/operational reports; develop SSRS and Excel-based reporting where appropriate and administer refreshes, gateways, workspaces, and access.
 * Administer production SQL Server environments, including security, backups, restores, disaster recovery, SQL Agent, monitoring, capacity, migrations, upgrades, availability, and least-privilege access.
 * Develop and optimize complex stored procedures, views, functions, tables, indexes, and data-processing routines; diagnose query, ETL, report, blocking, deadlock, and resource-performance issues.
 * Implement automated reconciliation, auditing, lineage, logging, error handling, alerting, and data-quality controls to verify complete and accurate processing from source systems through final reports.
 * Partner with business leaders, analysts, application teams, and executives to translate requirements into technical designs; manage work through Software Development Life Cycle (SDLC), testing, UAT, change control, version control, deployment, documentation, and support.
 * Provide production incident response, root-cause analysis, architectural guidance, code/design reviews, standards, documentation, knowledge transfer, and mentoring for other team members.