Demo

Technical Data Architect

RELQ TECHNOLOGIES LLC
Cincinnati, OH Full Time
POSTED ON 3/15/2025
AVAILABLE BEFORE 4/1/2025

Key Responsibilities :

ETL / ELT Architecture Design :

Architect and design scalable robust ETL / ELT frameworks using Informatica / IDMC and Snowflake to support complex data integration and transformation needs.

Define best practices for data integration data quality error handling logging and performance optimization.

Solution Development :

Develop and maintain complex data pipelines to extract transform and load data from various sources into Snowflake using Informatica IDMC.

Collaborate with data engineers and developers to implement highperformance faulttolerant data integration solutions.

Data Modeling & Warehousing :

Design and implement data models within Snowflake to support analytics reporting and business intelligence.

Optimize database designs for performance scalability and costefficiency in cloudbased environments.

Cloud Integration :

Architect solutions that leverage Informatica Cloud for data integration across hybrid multicloud environments.

Implement data migration strategies to move data from onpremise systems to Snowflake in the cloud.

Collaboration & Leadership :

Provide technical leadership and mentoring to junior developers and data engineers.

Collaborate with crossfunctional teams including business analysts data scientists and other stakeholders to translate business requirements into technical solutions.

Performance Optimization :

Monitor analyze and optimize ETL / ELT job performance.

Implement efficient query strategies within IDMC and Snowflake to ensure high performance and low latency for data operations.

Compliance & Security :

Ensure data governance compliance and security standards are adhered to in all ETL processes.

Implement data encryption masking and access control in Snowflake and Informatica IDMC environments wherever applicable.

Experience :

10 years of experience in ETL architecture and data engineering.

Strong experience with Informatica Intelligent Data Management Cloud (IDMC) and Snowflake

Expertise in Snowflake architecture data warehousing and performance optimization.

Handson experience with cloud platforms such as AWS Azure or GCP.

Technical Skills :

Proficiency in designing ETL / ELT pipelines using Informatica IDMC.

Deep understanding of Snowflakes data sharing time travel and multicluster architectures.

Strong SQL skills for database querying and optimization.

Experience with data modeling techniques for both OLAP and OLTP environments.

Knowledge of data integration best practices data governance and cloudbased data migration.

Preferred Qualifications :

Certifications in Informatica IDMC and Snowflake.

Experience with SQL Python Scala or other programming languages for data manipulation and integration.

Experience with realtime data integration and streaming architectures.

Familiarity with DataOps principles and methodologies

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Technical Data Architect?

Sign up to receive alerts about other jobs on the Technical Data Architect career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$170,841 - $219,163
Income Estimation: 
$159,552 - $206,899
Income Estimation: 
$116,726 - $151,072
Income Estimation: 
$147,901 - $186,323
Income Estimation: 
$89,551 - $118,439
Income Estimation: 
$116,726 - $151,072
Income Estimation: 
$124,724 - $161,246
Income Estimation: 
$89,966 - $112,616
Income Estimation: 
$118,163 - $145,996
Income Estimation: 
$120,777 - $151,022
Income Estimation: 
$129,363 - $167,316
Income Estimation: 
$86,891 - $130,303
Income Estimation: 
$145,845 - $177,256
Income Estimation: 
$172,688 - $210,712
Income Estimation: 
$170,589 - $211,671
Income Estimation: 
$178,619 - $225,190
Income Estimation: 
$86,891 - $130,303
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at RELQ TECHNOLOGIES LLC

RELQ TECHNOLOGIES LLC
Hired Organization Address AK Full Time
Job Description Seven (8) years of broad, extensive, and increasingly responsible experience applying Project Management...
RELQ TECHNOLOGIES LLC
Hired Organization Address Florida, FL Full Time
Analyse and ability to troubleshoot the existing oracle data sets related to MA CAR TICO and ISO standards. Develop Anal...
RELQ TECHNOLOGIES LLC
Hired Organization Address New York, NY Full Time
Project Description : Cloud-based solution designed to integrate modules and transform a legacy Medicaid Management Info...
RELQ TECHNOLOGIES LLC
Hired Organization Address New York, NY Temporary
Position Summary : The Data Engineer is responsible for building and maintaining data pipelines, ensuring the smooth ope...

Not the job you're looking for? Here are some other Technical Data Architect jobs in the Cincinnati, OH area that may be a better fit.

Technical Data Architect

Derex Technologies Inc, Cincinnati, OH

Technical Data Architect

Derex Technologies, Union, KY

AI Assistant is available now!

Feel free to start your new journey!