Data Architect

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Data Architect -Irving TX-Remote

Job Details

Please share your resumes to Fasi at synapsetechservice dot com

 

Data Architect

Irving, TX -Remote

Long term

C2C

 

We are seeking an experienced Data Architect to lead the design and development of a scalable.

 

 

Key Responsibilities:

Designed OLTP systems with 3NF normalization; established DB standards for contract data.

Migrated legacy Datastage jobs to Azure Databricks; integrated with Data Lake, Data Factory, and Azure SQL.

Designed and tuned data models (relational, non-relational, hybrid); optimized performance and cost.

Built ETL pipelines using Datastage, Databricks, and Snowflake with complex business logic.

Implemented Snowflake best practices: data migration, role-based access control, query tagging.

Enabled data quality audits via stored procedures and control frameworks.

Supported ERA master data models across Sales, Customer, and Product dimensions.

Delivered predictive analytics and forecasting models using historical market data.

Authored PL/SQL procedures, packages, views, and performance-tuned reports.

Developed enterprise naming standards, data dictionaries, source-to-target mappings, and documentation.

Led data migration from SQL Server/Oracle to Snowflake Cloud.

 

Skills Required:

Snowflake, Azure Databricks, Data Factory, Azure SQL

Data Modeling (OLTP, OLAP, Normalization/Denormalization)

ETL Tools: Datastage, Azure Pipelines

PL/SQL, Performance Tuning, Data Governance

Strong knowledge of enterprise data architecture and metadata management

 

 

 

Regards,

Mohd Fasi | Synapse Tech Service Inc |

800 Cross Pointe Rd, Suite L, Columbus, OH 43230

Email: |

ll ||

LinkedIn URL:

We are an E-Verified Employer

 

 

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.