Salary: $124,800 - 135,200 per year
Requirements:
- 5+ years of hands-on experience in data modeling, data architecture, or database design.
- Expert proficiency with Erwin Data Modeler, preferably version 9.x or higher, including subject areas, model templates, DDL generation, forward and reverse engineering, model versioning, and compare functionality.
- Advanced SQL skills and deep knowledge of Oracle 11g, 12c, 19c, or 21c, including SQL, PL/SQL, schema design, and performance-tuning fundamentals relevant to data modeling.
- Experience building normalized (3NF) transactional models and dimensional (star or snowflake) models for reporting and analytics.
- Strong command of DDL, including creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
- Solid understanding of data modeling theory, including entity-relationship modeling, normalization and denormalization, cardinality, keys, and referential integrity.
- Understanding of database internals, including indexing strategies, partitioning, clustering, and query execution plans.
- Knowledge of data modeling best practices, including surrogate keys and slowly changing dimensions (SCD).
- Ability to produce and maintain data dictionaries, metadata, and data lineage documentation.
- Familiarity with version control tools such as Git and model comparison or diff tools.
- Excellent communication skills, including the ability to explain modeling decisions to technical and non-technical audiences.
- Self-motivated, able to multitask, and effective in a team environment.
- Preferred: Experience in a regulated industry, such as utilities, financial services, insurance, or healthcare, and familiarity with related data governance and compliance requirements.
- Preferred: Familiarity with other modeling or metadata tools, such as ER/Studio, PowerDesigner, Collibra, or Alation.
- Preferred: Exposure to cloud data platforms such as Oracle Cloud, AWS, Azure, Snowflake, or Databricks, including hybrid on-premises and cloud modeling.
- Preferred: Working knowledge of ETL/ELT tools and data integration patterns.
- Preferred: Experience supporting master data management (MDM) or data governance initiatives.
- Preferred: Experience with Microsoft SQL Server, PostgreSQL, Data Vault, Hadoop, or MongoDB.
Responsibilities:
- Design transactional and dimensional data models for reporting and analytics.
- Use Erwin Data Modeler to manage subject areas, templates, DDL generation, engineering, versioning, and model comparisons.
- Apply SQL, PL/SQL, Oracle, and DDL knowledge to support schema design and data model development.
- Create and modify database objects, including tables, indexes, constraints, sequences, synonyms, and materialized views.
- Document and maintain data dictionaries, metadata, and data lineage.
Technologies:
- AWS
- Azure
- Cloud
- Data Vault
- Databricks
- ETL
- Git
- Hadoop
- Support
- MongoDB
- Oracle
- PostgreSQL
- SQL
- Snowflake
- Security
More:
We are recruiting for a data modeling role with an hourly pay range of $60–$65. Our benefits include medical, dental, and vision insurance; a 401(k) retirement plan; a health savings account; short- and long-term disability insurance; life and AD&D insurance; paid sick leave where required by law; supplemental insurance plans; identity theft protection; pet insurance; wellness programs; an employee assistance program; and career development opportunities. Eligibility, accrual, and usage may vary by employment status, tenure, and work location; paid sick leave follows applicable state and local requirements, and benefit plans may be changed in accordance with law. Cynet Systems Inc. was founded in 2010 and is headquartered in the Washington, DC metro area. We provide technology staffing and workforce solutions to Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada, serving IT, engineering, life sciences, clinical, and professional staffing needs. We are a certified Minority Business Enterprise and hold ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II certifications.
last updated 46 week of 2026
You apply on DevITjobs, where this job was posted. Peter Nowak isn’t the employer and doesn’t check listings.
