Senior Data Modeler

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

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

401(k) plan after 30 days

11 paid holidays

Parental leave 12 weeks

PTO (free time)

Job summary

Fractal Analytics Inc in the United States is seeking a Sr Data Modeler to design, implement, and manage enterprise data models across OLTP/OLAP environments. You will partner with analysts, engineers, and governance teams to ensure models meet business needs and governance requirements.

The role emphasizes data modeling standards, documentation, security, and collaboration with Data Governance. You will drive data dictionaries, ER diagrams, and metadata, while ensuring scalability and

Qualifications

• Bachelor's degree in MIS, Business or equivalent work or educational experience required.
• Advanced degree preferred.
• Minimum of 5 years of experience with physical/logical data modeling and database design for both relational and non-relational databases.
• 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

Analytical skills

Problem solving

Translation to non-technical

Communication with stakeholders

Cloud data platforms

Education

Bachelor's degree in MIS/Business or equivalent

Advanced degree preferred

Tools

Erwin

ER/Studio

Job description

Company Culture

It's fun to work in a company where people truly BELIEVE in what they are doing! We're committed to bringing passion and customer focus to the business. Fractal Analytics is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets. An ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite is one who empowers imagination with intelligence. And that it will be such Fractalites that will continue to build the company for the next 100 years.

SUMMARY

The Sr Data Modeler is pivotal in ensuring the consistency, accuracy, and reliability of data systems. This role is responsible for designing, implementing, and managing data models for the organization. The Sr Data Modeler will partner with business analysts, engineers, architects, and data governance to ensure our data models meet the needs of our business and align with governance requirements.

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.

QUALIFICATIONS

• Bachelor's degree in MIS, Business or equivalent work or educational experience required.
• Advanced degree preferred.
• 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.

Pay

Pay: The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Fractal, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is: $120,000 to $145,000. In addition, for the current performance period, you may be eligible for a discretionary bonus.

Benefits

• As a full-time employee of the company or as an hourly employee working more than 30 hours per week, you will be eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time.
• You will be eligible for benefits on the first day of employment with the Company.
• In addition, you are eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms.
• The Company provides for 11 paid holidays and 12 weeks of Parental Leave.
• We also follow a "free time" PTO policy, allowing you the flexibility to take time needed for either sick time or vacation.

Equal Opportunity

Fractal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Mission

At Fractal, towards our goal of "powering every human decision in the enterprise", our partnerships and alliances help in creating and delivering a compelling suite of solutions to unlock value. We partner with companies from around the globe, leaders in their respective fields. With Fractal's expertise in artificial intelligence, design, engineering, and digital transformation, combined with the data, technology, and software platforms from our partners, we create cutting-edge solutions to problems in the business world. We understand how critical and timely decision triggers, and information, empower our clients to create, unlock, deliver, and realize value. Together with our partners, our goal is to serve each client in their end-to-end data-to-decision journey.