Senior Data Modeler: Enterprise Data Architect & Analytics

Fractal; California (MO); On-site; USD 120,000 - 145,000; Full time

Benefits offered by this job

Health, dental, vision, life insurance

Disability plans

401(k) plan

Paid holidays

Parental Leave

PTO

Job summary

Fractal Analytics is seeking a Sr Data Modeler to design, implement, and govern data models across OLTP/OLAP environments. The role partners with analysts, engineers, architects, and governance teams to ensure models meet business needs and compliance requirements.

The ideal candidate will develop conceptual, logical, and physical models, document data dictionaries, and collaborate to optimize data structures while ensuring security and efficiency in a fast-paced, data-driven landscape.

Qualifications

• Bachelor's degree in MIS, Business or equivalent work or educational experience required.
• Minimum of 5 years of experience with physical/logical data modeling and database design for both relational and non-relational databases required.
• Experience modeling for transaction processing and analytics preferred.
• Experience in the banking or financial services industry preferred.
• Experience with cloud data platforms such as Azure, AWS, or GCP preferred.
• Experience with Agile or other project management methodologies preferred.
• Expert knowledge of data modeling and metadata management tools such as Erwin or ER/Studio preferred.
• Knowledge of the Banking Industry Architecture Network (BIAN) information architecture preferred.
• Strong analytical and problem-solving skills with the ability to analyze complex business requirements and translate them into effective data models required.
• Excellent organizational skills with the ability to document and present data models effectively required.

Responsibilities

• Develop, maintain, and optimize conceptual, logical, and physical data models in support of initiatives and new data offerings.
• Create and document logical and physical data models including data dictionaries, metadata, and entity-relationship diagrams. Modeling scope includes OLTP and OLAP
• Drive internal customer needs into meaningful effective data models in collaboration with Data Architects, Developers, and Analysts.
• Enforce data modeling standards, guidelines, and best practices. Partner with Data Governance when new standards and guidelines are to be developed.
• Ensure data security and compliance with relevant regulations and standards.
• Prepare documentation for data models and definitions.
• Communicate complex data and data modeling concepts to non-technical stakeholders effectively.
• Support the design and implementation of database schemas/structures, and database performance tuning/optimization.
• Perform additional duties as assigned.

Skills

Data modeling

Database design

Cloud platforms

Agile methodologies

Analytical skills

Communication to non-technical

Education

Bachelor's degree in MIS/Business

Advanced degree preferred

Tools

Erwin

ER/Studio

Job description

Fractal Analytics is seeking a Sr Data Modeler to design, implement, and govern data models across OLTP/OLAP environments. The role partners with analysts, engineers, architects, and governance teams to ensure models meet business needs and compliance requirements.

The ideal candidate will develop conceptual, logical, and physical models, document data dictionaries, and collaborate to optimize data structures while ensuring security and efficiency in a fast-paced, data-driven landscape.