Data Modeler
3B Staffing LLC, Austin, TX, United States
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-PMBOK).
* 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).
* 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-PMBOK).
* 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).