Senior Data Modeler

Pay Range: $60.00hr - $65.00hr Job Overview: The candidate should possess 5+ years of hands-on experience in data modeling, data architecture, or database design roles.

Responsibilities and Requirements: Demonstrate expert proficiency with Erwin Data Modeler (version 9.x or higher preferred), including subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and complete compare functionality. Utilize advanced SQL skills and a deep understanding of Oracle (11g/12c/19c/21c), including SQL, PL/SQL, schema design, and performance tuning fundamentals as they relate to data model design. Build both normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics.

Demonstrate strong command of DDL, including creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views. Apply solid understanding of data modeling theory, including entity-relationship modeling, normalization/denormalization, cardinality, keys, and referential integrity. Apply a solid grasp of database internals, including indexing strategies, partitioning, clustering, and query execution plans. Utilize data modeling best practices, including normalization, denormalization, surrogate keys, and slowly changing dimensions (SCD).

Produce and maintain data dictionaries, metadata, and data lineage documentation. Demonstrate familiarity with version control (e.g., Git) and model comparison/diff tools. Demonstrate excellent communication skills with the ability to clearly explain modeling decisions to both technical and non-technical audiences. Demonstrate self-motivation with an ability to multitask. Work effectively in a team environment.

Preferred Qualifications: Experience in a regulated industry (utilities, financial services, insurance, healthcare) with associated data governance and compliance requirements. Familiarity with additional modeling or metadata tools (e.g., ER/Studio, PowerDesigner, Collibra, Alation). Exposure to cloud data platforms (e.g., Oracle Cloud, AWS, Azure, Snowflake, Databricks) and hybrid on-prem/cloud modeling scenarios. Working knowledge of ETL/ELT tools and data integration patterns. Experience supporting master data management (MDM) or data governance initiatives. Experience working with Microsoft SQL Server. Experience working with PostgreSQL. Data vault experience. Experience with Hadoop/MongoDB.

Benefits: Our Benefits Include: Medical, Dental, and Vision Insurance 401(k) Retirement Plan Health Savings Account (HSA) Disability Insurance (Short-Term and Long-Term) Life and AD&D Insurance Paid Sick Leave (where required by applicable state or local law) Supplemental Insurance Plans Identity Theft Protection Pet Insurance Employee Wellness Programs Employee Assistance Program (EAP) Career Growth and Professional Development Opportunities Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location.

Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws. About Cynet Systems Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada.

We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia. As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers.

Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.