Design, document, and maintain logical, conceptual, and physical data models that support scalable, secure, and reliable business and technology solutions.
Key responsibilities:
Translate business requirements into data structures, entities, relationships, and definitions. Develop and maintain conceptual, logical, and physical data models. Establish data standards, naming conventions, metadata, and ownership. Partner with business stakeholders, data engineers, architects, analysts, and governance teams. Assess data quality, integration impacts, performance, security, and regulatory requirements. Support database design, ETL/ELT development, reporting, analytics, and modernization initiatives. Maintain model documentation and communicate design decisions to technical and nontechnical audiences. Experience with relational, dimensional, and potentially NoSQL data modeling with experience in benefits administration preferred Proficiency with SQL and data-modeling tools such as ER/Studio, ERwin, or Lucidchart. Understanding of data warehouses, data lakes, APIs, master data, metadata, and data governance. Strong analytical, communication, documentation, and stakeholder-management skills.
Mandatory Skills
Allfusion Erwin Data Modeler: Advanced
Data Modeling: Advanced
Embarcadero ER/Studio 2016: Intermediate
Lucidworks: Advanced
NoSQL: Advanced
Preferred Skills
Benefits Administration Consultancy: Intermediate
Data Governance: Intermediate
Data lake design and development: Intermediate
Enterprise Data Warehouses: Intermediate