Data Architect Job at OtB Tech LLC, Agoura Hills, CA

WmxwdXpQQUc4RVhRMUJGM2d0RTVhREFIVGc9PQ==
  • OtB Tech LLC
  • Agoura Hills, CA

Job Description

Job Description - Data Architect

Location :Agoura Hills CA

Job Type :Contract

We are seeking an experienced Data Architect with strong expertise in Azure Data Factory (ADF) and SQL Server to design, build, and optimize scalable data solutions. The ideal candidate will be responsible for defining data architecture standards, designing end-to-end data integration pipelines, and ensuring high performance, security, and reliability of enterprise data platforms.

Key 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.

Required Skills & Qualifications

  • 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.
  • Experience with CI/CD for data pipelines is a plus.

Strong analytical, problem-solving, and communication skills.

Job Tags

Contract work,

Similar Jobs

Henderson Inc.

Preconstruction Manager Job at Henderson Inc.

 ...We are seeking a detail-oriented and experienced Preconstruction Manager / Senior Estimator with 10+ years in estimating and preconstruction across a range of commercial, institutional, and industrial project types. This role leads all preconstruction activities from... 

Darsan Technologies, Inc

Jira Administrator - Contract-to-Hire Providence RI Job at Darsan Technologies, Inc

 ...considered for this position. This is a hands-on admin role that works directly with stakeholders across the organization. Job...  ...benefits: ~401(k)~401(k) matching ~ Dental insurance ~ Flexible schedule ~ Flexible spending account ~ Health insurance ~... 

Farm Job Search

Farm Feedlot Assistant Job at Farm Job Search

 ...Farm Feedlot Assistant (5927) Location: Nebraska JobNumber: 5927 Farm Feedlot Assistant job available on a well established family farm with 2000 head of beef cattle and 1,000 acres of soybeans and corn under center pivot irrigation in East Central Nebraska.... 

SERVPRO Team Wilson

Operations Manager Job at SERVPRO Team Wilson

 ...? SERVPRO Team Wilson is seeking an experienced and dynamic Operations Manager to lead our Mitigation and Emergency Response team in Houston...  ...of 12-15 operations staff members, galvanizing them to meet production expectations. Drive budget and profit initiatives... 

Dave Wright Nissan Subaru

Parts Delivery Driver Job at Dave Wright Nissan Subaru

 ...TIMES!Want to help people grow and do something with a purpose?Do you want to be part of an organization that will help you reach your full potential?Parts Delivery Driver Responsibilities* Create, maintain and build relationships with other businesses*...