Data Architect/Modeler-Dallas TX( Richardson TX office) (Remote)- Need Local

Client -Freeman,


C2C - Get me good profiles with competitive rates.

• 15+ years of experience in Data Architecture and Data Modeling and should have excellent communication and leadership skills
• Should have in depth understanding or executed new concepts like Data Lakehouse and should have worked on data sources such as SAP and Salesforce
• Should have done Data Modeling for Fortune 100 organizations and databases atleast 10 TB in size
• Should have done complex (100+ entities/tables) Data Modeling programs in both on-prem and cloud environments (any cloud is ok)
• Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin R1, Sybase Power Designer, DBSchema, ER/Studio, Toad Data Modeler, etc)
• Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive, Athena, Redshift, Snowflake, Synapse Analytics, Azure SQL and on prem databases such as Oracle, SQL Server and DB2
• Should have led Data Model workshops with business and technology stakeholders
• Should have written complex SQL queries for data analysis, generated, deployed and altered DDL
• Should have implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
• Should have worked atleast 4 projects using Agile/SAFe methodology
• Should have in depth understanding on Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy and Data Governance
• Should have cross global location experience and been part of a team of atleast 20+ members in a global delivery model
• Should have knowledge on Microservices & Service Oriented Architecture
• Should have experience in gathering business requirements by collaborating with business users, stakeholders and SMEs
• Should have experience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team on a daily basis to analyze requirements, design, development and deployment technical solutions

• Participate in JAD, workshops and/or business requirements sessions to understand, capture and detail data modeling requirements
• Analyze client landscape and architectures to find the best data sources needed for the business requirements
• Determine appropriate data architecture suitable for the business requirements
• Perform detailed data analysis on source data, profile data, identify data cardinality, granularity and data quality issues
• Define enterprise abbreviation and data modeling naming standards
• Design data quality and cleansing rules based on profiling results to increase quality of data
• Create data flow architecture across multiple zones (raw, refined, curated, BI zones)
• Design conceptual, logical and physical data models across all data zones based on business needs
• Create Data Dictionary & DDLs for the created Data Model
• Create normalized and/or denormalized structures to manage usability and performance
• Design source to target mapping documents with transformation rules to ingest data from source tables to target environment across all the data zones
• Create security document to assign database access to users accordingly
• Design partitioning and CDC strategy across various subject areas and data zones based on business needs
• Work with business, ETL and BI teams to identify and design data models for KPIs
• Design test cases for data modeling requirements
• Create and deliver Data Model (Conceptual, logical & physical), DDL, Data Architecture document, Data Dictionary and Design document with Security Rules, CDC Strategy, Data Quality/Cleansing Rules & S2T Mapping document with transformation rules
• Support stakeholders, ETL & BI teams during data pipeline development
• Participate in onshore/nearshore/offshore calls as required to support the data pipeline development