Data Modeler

We are seeking a Data Modeler for a position working remotely from anywhere in Texas with our Austin Texas client supporting their SaaS integration project by designing developing and maintaining conceptual logical and physical data models that align with enterprise architecture standards. This role will focus on defining data relationships across cloud-based and on-premises systems to ensure data consistency accuracy and compliance with State of Texas enterprise data management policies. The Data Modeler will collaborate closely with architects developers and QA teams to support system integration data migration and reporting initiatives.

Responsibilities

* Design document and maintain data models (conceptual logical and physical) that support the integration of SaaS applications with internal and external enterprise systems.

* Collaborate with the Enterprise Architect to ensure data models align with overall architecture frameworks standards and governance requirements.

* Analyze business and system requirements to define data entities relationships and flows across cloud and legacy environments.

* Develop and maintain metadata repositories data dictionaries and data lineage documentation to ensure consistency and traceability.

* Support data mapping and transformation efforts for integration migration and reporting.

* Validate that data structures support performance scalability and data integrity objectives.

* Partner with Quality Assurance to define and verify data validation rules and testing standards.

* Work with security and compliance teams to ensure data models adhere to privacy classification and governance standards.

* Review vendor and third-party data models to ensure alignment with enterprise standards and interoperability requirements.

* Support go-live and post-implementation activities through data validation reconciliation and optimization analysis.

Required Skills and Experience

* 7 years of experience as a Data Modeler Data Architect or Database Designer in enterprise environments.

* Proven experience developing conceptual logical and physical data models for SaaS or cloud-based applications.

* Strong SQL skills and understanding of data integration normalization and modeling best practices.

* Experience working with data modeling tools (e.g. ER/Studio ERwin PowerDesigner or equivalent).

* Understanding of data governance metadata management and data quality frameworks.

* Ability to interpret business requirements and translate them into data design specifications.

* Excellent communication and documentation skills for presenting data models and concepts to technical and non-technical audiences.

Preferred Qualifications

* Experience with state or government data management environments.

* Familiarity with Azure AWS or other cloud data platforms (e.g. Snowflake Redshift or Azure SQL).

* Knowledge of enterprise architecture frameworks (e.g. TOGAF) and data management standards (e.g. DAMA-DMBOK).

* Experience modeling data for financial or ERP systems such as PeopleSoft or CAPPS.

* Understanding of security and compliance requirements related to government data (e.g. data classification encryption retention).