Data Modeler

Job title: Senior Data Modeler / Database Architect (Remote – Texas Residents Only) Job type: Contract Contract Length: Until August 31, 2026 (with strong likelihood of extension) Rate: Competitive, DOE Role Location: Remote – Must currently reside in the state of Texas The company: A large, well-established Texas state government agency undergoing a multi-year mainframe-to-cloud modernization program. Role and Responsibilities: • Perform advanced data modeling and architecture work to migrate legacy hierarchical mainframe data into modern relational and cloud data warehouse environments • Design and build normalized 3NF models for transactional systems and dimensional star/snowflake schemas (Facts & Dimensions) for analytics • Analyze existing IMS hierarchical databases and COBOL programs to create accurate source-to-target mappings • Produce high-quality data architecture deliverables: ERDs, data dictionaries, pipeline topologies, process flows, and technical documentation • Collaborate with ETL developers (Informatica/SSIS), cloud engineers, and application teams to deliver production-ready database solutions using Oracle, SQL Server, and Snowflake • Ensure all models adhere to security, governance, and PII classification standards • Support change data capture (CDC), bulk data movement, code promotion via Git, and production deployments • Provide clear status reporting and present modeling solutions to both technical and business stakeholders Job Requirements: Minimum (Required): • 5+ years hands-on experience as a Senior Data Modeler / Database Architect delivering production data models • 5+ years creating data architecture artifacts (ERDs, data dictionaries, source-to-target mappings, etc.) • Expert-level relational (3NF) and dimensional (star/snowflake, facts & dimensions) modeling • Strong proficiency with data modeling tools (DBSchema, ER/Studio, SqlDBM, ERwin, etc.) • Real-world experience with at least three of: Oracle, SQL Server, Snowflake, and legacy mainframe IMS hierarchical databases • Solid understanding of ETL tools/concepts (Informatica and/or SSIS) • Comfortable promoting database objects through environments using Git or similar version control • Excellent documentation and communication skills Highly Preferred: • Oil & Gas or regulatory/compliance domain experience • Snowflake experience or SnowPro certification • Exposure to Power BI, MuleSoft, Salesforce, or GoAnywhere • Experience with data governance and PII handling in regulated environments • Relevant certifications (Snowflake, Microsoft Data/Analytics, DAMA, etc.) Accessibility Statement: Read and apply for this role in the way that works for you by using our Recite Me assistive technology tool. Click the circle at the bottom right side of the screen and select your preferences. We make an active choice to be inclusive towards everyone every day. Please let us know if you require any accessibility adjustments through the application or interview process. Our Commitment to Diversity, Equity, and Inclusion: Signify’s mission is to empower every person, regardless of their background or circumstances, with an equitable chance to achieve the careers they deserve. Building a diverse future, one placement at a time. Check out our DE&I page here