Senior Data Modeler / Architect - Need 15+

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 24 Month(s)
Able to Provide Sponsorship

Skills

Agile
Amazon RDS
Amazon S3
Amazon Web Services
Apache Hadoop
Apache Hive
Cloud Computing
Collaboration
Communication
Computer Science
Data Architecture
Data Governance
Data Migration
Data Modeling
Data Quality
Data Retention
Data Warehouse
ER/Studio
ERwin
Finance
Google Cloud
Google Cloud Platform
GxP
IBM DB2
Informatica
Insurance
Management
Master Data Management
Mathematics
Meta-data Management
Microsoft Azure
Mobile Device Management
Normalization
OLAP
OLTP
PL/SQL
Pharmaceutics
Process Modeling
Regulatory Compliance
Remote Desktop Services
Research and Development
SEC
SQL
Snow Flake Schema
Software Development Methodology
Stakeholder Management
Star Schema
Testing
Virtualization
Toad

Job Details

We are seeking a seasoned Data Architect with over 18 years of experience designing and implementing data solutions across diverse, regulated industries. The ideal candidate will have a strong foundation in data modeling, data governance, enterprise data architecture, and data warehousing in cloud and on-premises environments. The role involves working closely with business and technical stakeholders to evolve scalable and compliant data solutions using modern tools and platforms like Snowflake, AWS, ERWin, Hadoop, and others.

Key Responsibilities:

  • Lead the design, development, and evolution of enterprise data warehouses, data lakes, and data modeling standards.

  • Develop and manage logical and physical data models using tools like ERWin, ERStudio, and Model Mart.

  • Architect data platforms leveraging AWS (S3, Aurora, RDS), Snowflake, Hive/Hadoop, and Denodo.

  • Define and enforce metadata management, master data management (MDM), data lineage, and data quality standards.

  • Collaborate with cross-functional teams to support data-driven initiatives across R&D, finance, compliance, HR, and IT.

  • Implement best practices for data retention, indexing, normalization/denormalization, and partitioning strategies.

  • Ensure compliance with industry standards and regulations (e.g., SEC, FDA, FCC, GxP, 21 CFR Part 11).

  • Support Agile SDLC processes from requirements through testing and deployment.

Required Qualifications:

  • Bachelor s and Master s degrees in Computer Science, Engineering, or Mathematics.

  • 15+ years in Data Architecture or Data Modeling roles across enterprise environments.

  • Hands-on experience with Snowflake, Oracle, SQL Server, DB2/UDB, and SQL/PLSQL.

  • Proficiency with ERWin, ERStudio, Toad, and Informatica.

  • Experience in data governance, data lineage tools (e.g., Collibra), and business process modeling.

  • Familiarity with Agile methodologies and tools.

  • Strong knowledge of data warehouse concepts (e.g., Star Schema, Snowflake, OLTP/OLAP).

  • Demonstrated experience working with large-scale data migration and consolidation projects.

  • Strong communication and stakeholder management skills.

Preferred Qualifications:

  • Experience with cloud data architecture (AWS, Azure, or Google Cloud Platform).

  • Knowledge of data virtualization tools (e.g., Denodo).

  • DAMA membership or similar professional certification.

  • Experience in the financial, insurance, or pharmaceutical sectors.

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.