> Markdown version of [/jobs/ext/172142-data-engineer-warehouse-bi-sql-dba](https://www.wearedevelopers.com/jobs/ext/172142-data-engineer-warehouse-bi-sql-dba). 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). --- # Data Engineer (Warehouse, BI & SQL DBA) - **Company:** Barrett-Jackson Auction Co, LLC - **Location:** Scottsdale, AZ, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Agile Methodology, Artificial Intelligence, Microsoft Azure, Backup Devices, Code Review, Information Systems, Databases, Continuous Integration, Information Engineering, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Warehousing, Relational Databases, Database Design, Database Development, DevOps, Dimensional Modeling, Github, Microsoft Data Access Components, Microsoft SQL Server, SQL Azure, Performance Tuning, Query Optimization, Role-Based Access Control, Power BI, Azure Active Directory, Software Deployment, SQL Databases, Transact-SQL, Data Logging, Azure Data Factory, Snowflake, Database Optimization, Apache Spark, Indexer, Git, Microsoft Fabric, Git Flow, Information Technology, Deployment Automation, Azure Synapse Analytics, Data Pipelines, Key Vault - **Published:** May 20, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=a2a5363a406f3ade ## About the Role Do you have experience in Software deployment?, * Experience using AI-assisted tools to support database administration, SQL development, reporting, troubleshooting, and workflow optimization is preferred. * 6+ years of hands-on experience in data engineering and/or data warehouse engineering, including building production-grade pipelines and curated datasets. * 4+ years administering and tuning SQL Server and/or Azure SQL (query optimization, indexing, security, backup/restore, and maintenance). * Strong proficiency with T-SQL, relational data modeling, and performance tuning (execution plans, statistics, partitioning, and concurrency patterns). * Experience building ELT/ETL with Azure Data Factory/Synapse Pipelines and/or Fabric Data Factory; familiarity with event/file-based ingestion patterns. * Experience designing and operating a modern warehouse/lakehouse using Azure Synapse and/or Microsoft Fabric (Lakehouse/Warehouse, notebooks/Spark, and orchestration). * Strong understanding of data warehouse concepts and modeling techniques (Kimball dimensional modeling, SCD, data marts, and semantic layer alignment). * Power BI experience supporting enterprise reporting (datasets/semantic models, refresh strategies, performance optimization, and workspace governance). * Experience with Azure security and identity patterns (Azure AD, managed identities, Key Vault, RBAC) and protecting sensitive data (PII) end-to-end. * Hands-on experience with DevOps practices: Git branching, code reviews, CI/CD, and automated deployments (Azure DevOps and/or GitHub). * Strong troubleshooting skills across data pipelines, databases, and BI; ability to communicate clearly with technical and non-technical stakeholders. * Experience using AI-assisted tools to support database administration, SQL development, reporting, troubleshooting, and workflow optimization is preferred. * Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent experience. ## Description We are seeking a Data Engineer (Warehouse, BISQL DBA) to join our Scottsdale-based team and own our end-to-end Microsoft data platform-from database design and administration, through reliable data pipelines, into a governed enterprise Data Warehouse/Lakehouse (Azure Synapse and/or Microsoft Fabric), and ultimately enabling analytics and reporting in Power BI. This role blends hands-on SQL Server/Azure SQL engineering and DBA responsibilities with modern ELT/ETL development, dimensional modeling, performance tuning, security, and data governance. You will partner closely with application teams, business stakeholders, and analytics users to deliver trusted, well-documented datasets and scalable solutions that support operational and strategic decision-making., * Design, implement, and administer SQL Server and Azure SQL databases, including schema design, indexing strategies, constraints, and data integrity controls. * Own core DBA functions: backup/restore, HA/DR, patching and upgrades, capacity planning, monitoring/alerting, and routine maintenance. * Build and optimize ELT/ETL pipelines using Microsoft tooling (e.g., Azure Data Factory/Synapse Pipelines and/or Fabric Data Factory), integrating data from on-prem and cloud sources. * Develop scalable transformation patterns using T-SQL and Spark (where applicable), implementing repeatable, testable data-processing frameworks. * Design and manage the enterprise Data Warehouse/Lakehouse, including dimensional modeling (star/snowflake), incremental loads, historization (SCD), and semantic layer alignment for BI. * Administer and optimize Azure Synapse and/or Microsoft Fabric (Lakehouse/Warehouse), including workspace organization, resource governance, and performance/cost tuning. * Enable Power BI reporting by delivering curated datasets, developing and supporting semantic models, and partnering with analysts on performance, refresh strategies, and best practices. * Implement data quality, reconciliation, and observability (logging, lineage, SLAs), and drive root-cause analysis for data issues across pipelines and reporting. * Establish and enforce security and governance controls (RBAC, least privilege, encryption, PII handling, auditability) across databases, lakehouse/warehouse, and BI. * Automate deployments and operations using Git-based workflows and CI/CD (Azure DevOps/GitHub), including infrastructure-as-code where appropriate. * Create technical documentation for data models, source-to-target mappings, operational runbooks, and support procedures. * Collaborate with application engineering, product, and business stakeholders to translate requirements into reliable data products and deliver iteratively in an Agile environment. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)