OtB Tech LLC ยท 21 hours ago
Data Architect
Agoura Hills, CA
Contract
Onsite
Senior LevelOtB Tech LLC is seeking an experienced Data Architect with strong expertise in Azure Data Factory and SQL Server. The ideal candidate will be responsible for designing, building, and optimizing scalable data solutions while ensuring high performance, security, and reliability of enterprise data platforms.
Information Technology & Services
Hiring Manager
Varun Reddy
Responsibilities
Design and implement enterprise-level data architectures using Azure and SQL Server technologies
Develop, manage, and optimize data integration pipelines using Azure Data Factory
Architect ETL/ELT workflows to ingest data from multiple sources (on-premises and cloud)
Design and maintain SQL Server databases, including schemas, tables, indexes, and stored procedures
Ensure data quality, data governance, and data security best practices are followed
Optimize SQL queries and data pipelines for performance, scalability, and cost efficiency
Collaborate with business stakeholders, data engineers, and analytics teams to translate business requirements into technical solutions
Define data modeling standards (logical, physical, and dimensional models)
Implement error handling, monitoring, and logging in Azure Data Factory pipelines
Support data migration initiatives from on-prem systems to Azure
Provide technical leadership, architecture reviews, and mentoring to development teams
Document architecture designs, data flows, and technical standards
Qualification
Required
Strong experience as a Data Architect or Senior Data Engineer
Hands-on expertise with Azure Data Factory (pipelines, triggers, linked services, datasets)
Deep knowledge of SQL Server (T-SQL, performance tuning, indexing, partitioning)
Experience with data modeling (OLTP and OLAP, star/snowflake schemas)
Solid understanding of ETL/ELT concepts and data warehousing principles
Experience integrating data from REST APIs, flat files, relational databases, and cloud sources
Familiarity with Azure SQL Database / SQL Managed Instance
Knowledge of security concepts such as encryption, RBAC, and data access controls
Strong analytical, problem-solving, and communication skills
Preferred
Experience with CI/CD for data pipelines is a plus
Company
OtB Tech LLC
OtB Tech LLC is a leading staffing firm that provides customized workforce solutions to businesses of all sizes.
Founded in 2021
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase