Dice is the leading career destination for tech experts at every stage of their careers. Our client, Raas Infotek LLC, is seeking the following. Apply via Dice today!
Job Title: Data Architect
Location: Cincinnati, OH (Hybrid)
Employment Type: W2 Only
Duration: 12+ Months
About The Role
We are seeking an experienced Data Architect with deep expertise in enterprise data warehouse (EDW) design and modern data platforms. You will lead the development of our next-generation data architecture, ensuring scalable, secure, and high-performance solutions that power analytics and business intelligence.
Key Responsibilities
Design and implement scalable data warehouse solutions (cloud, hybrid, or on-premise)
Develop star/snowflake schemas, dimensional models, and data marts
Optimize ETL/ELT pipelines for performance and reliability
Define data partitioning, indexing, and storage strategies
Architect solutions using Snowflake, Redshift, BigQuery, or Synapse
Implement data governance frameworks (metadata management, lineage, quality)
Evaluate and select data integration tools (Informatica, Talend, Matillion)
Design for real-time and batch processing
Partner with BI teams to enable reporting (Power BI, Tableau)
Work with security teams on RBAC, encryption, and compliance (GDPR, CCPA)
Mentor data engineers and review technical designs
Drive cloud migration of legacy data warehouses
Implement cost optimization strategies for cloud platforms
Research emerging tech (data mesh, lakehouse architectures)
Required Skills & Experience
14+ years in data architecture, with focused on data warehousing
Expertise in:
EDW platforms: Snowflake, Redshift, BigQuery, Teradata, or Synapse
Data modeling: Kimball/Inmon methodologies
ETL/ELT: Informatica, SSIS, Talend, or custom Spark pipelines