Senior BI & SQL Data Architect | Enterprise Data Leader

Jobot; Orange (CA); Presencial; USD 160 000 - 185 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Bonus potential

Direct exposure to leadership

Modern Microsoft data environment

End-to-end ownership

Resumo da oferta

Jobot is seeking a Senior Data Architect to own and advance our enterprise data environment. This hands-on role spans data architecture, data engineering, and DBA responsibilities, with a focus on BI, data warehousing, and SQL Server administration.

You will design, build, deploy, and production-support scalable data solutions, partnering with executives and stakeholders to translate business requirements into robust data architectures.

Qualificações

• 8+ years in BI, data warehousing, and/or SQL Server administration.
• Expert-level SQL Server and T-SQL proficiency.
• Strong data warehouse architecture and dimensional modeling experience.
• Experience designing conceptual, logical, and physical data models.
• ETL/ELT development with SSIS and/or cloud data services.
• Advanced Power BI data modeling, security, deployment, and refresh administration.
• Production DBA experience: backup/recovery, monitoring, migrations, upgrades, high availability.

Responsabilidades

• Design and maintain enterprise data warehouses, data marts, staging environments, semantic layers, and reporting architectures.
• Develop dimensional data models (fact/dimension, star/snowflake, historical data).
• Build and support production ETL/ELT pipelines (SSIS, Azure Data Factory, Microsoft Fabric, T-SQL).
• Integrate data across SQL Server, MySQL, Oracle, Azure SQL, APIs, and files.
• Build governed Power BI datasets, semantic models, dashboards, KPIs, and executive reporting.
• Own SQL Server performance tuning and resolve queries, ETL issues, and blocking/deadlocks.
• Administer production SQL Server environments (security, backup/recovery, DR, migrations, upgrades, availability).
• Implement data quality, reconciliation, auditing, lineage, logging, and alerting processes.
• Ensure accuracy from source systems to final reporting; collaborate with business leaders and analysts.
• Support SDLC, testing, UAT, deployments, change control, and incident response.

Conhecimentos

BI & Data Warehousing

SQL Server

T-SQL

Data Modeling

ETL/ELT

Power BI

Performance Tuning

Ferramentas

SSIS

Azure Data Factory

Microsoft Fabric

SQL Server

Descrição da oferta de emprego

Jobot is seeking a Senior Data Architect to own and advance our enterprise data environment. This hands-on role spans data architecture, data engineering, and DBA responsibilities, with a focus on BI, data warehousing, and SQL Server administration.

You will design, build, deploy, and production-support scalable data solutions, partnering with executives and stakeholders to translate business requirements into robust data architectures.