Data Modeler (Senior)

Why USAA?

At USAA, our mission is to empower our members to achieve financial security through highly competitive products, exceptional service and trusted advice. We seek to be the #1 choice for the military community and their families.

Embrace a fulfilling career at USAA, where our core values – honesty, integrity, loyalty and service – define how we treat each other and our members. Be part of what truly makes us special and impactful.

The Opportunity

As a dedicated Data Modeler (Senior), you will get to work with P&C Data & Analytics and help define the strategy and vision of our data modeling practice. This position holds the responsibility to design, enhance, and maintain quality logical and physical database designs that meet business requirements and ensure maximum application data quality and performance.  Facilitate and participate in all phases of the data development lifecycle; review and analyze requirements, maintain both logical and physical data model objects.  Facilitates and participate in cross functional teams to clarify and conform data requirements and business rules around data with their data stewards, business teams, and Information technology partner teams.  Ensure data models are meeting the USAA guidelines for data modeling, metadata requirements, attribute name and type creation.  Viewed as senior resource in given field for department and or unit.  Provides technical advice to lower-level associates and other functional areas.

This position can work remotely in the continental U.S. with occasional business travel. Relocation assistance is not available for this position.

What you'll do:

• Leads and/or engineers the full cycle of data solutions from analysis, solution design, data pipeline engineering, testing, deployment, scheduling, and production support.
• Designs and implements highly-complex technical solutions for data engineering and analytic systems using new methodologies and emerging technologies.
• Designs, builds, manages and optimizes data pipelines for data structures encompassing data transformation, data models, schemas, metadata, data quality, and workload management.
• Leads design reviews for the team and provides recommendations using innovative architectural concepts and principals.
• Breakdowns business features into technical stories and approaches.  Presents to leadership and influences on technical solutions.
• Creates proof of concepts and prototypes on highly complex solutions and presents to leadership to deliver on vision for solution.
• Collaborates with cross-functional partners and stakeholders to lead technical solutions.
• Implements efficient defect management, root cause analysis, and resolution processes.
• Helps develop, maintain, and enforce the company’s data development tools and standards. Conduct code reviews on a regular basis to improve quality and ensure compliance
• Creates the development of data pipelines, extracting data from our various applications (internal & external sources) into the Data Platform.
• Assists in setting technical direction for the team and serves a mentor to team members.
• Ensures risks associated with business activities are effectively identified, measured, monitored, and controlled in accordance with risk and compliance policies and procedures.

What you have:

• Bachelor’s degree; OR 4 years of related experience (in addition to the minimum years of experience required) may be substituted in lieu of degree.
• 6 years of data engineering, data analysis or software development experience implementing data solutions with at least 2 years of data engineering or data management experience.
• Proven experience with end to end delivering of data solutions that includes building, managing, and optimizing data pipelines across cloud environments; curating and modeling the data for various types of consumers/products and their pattern of usage to include data marts, data lake, and operational analytic applications.
• Strong understanding of the agile principles and ability to apply them.
• Extensive knowledge and experience in SQL and Relational Databases.
• Proficient in  working with Cloud technologies and tools.

What sets you apart:

• 6 or more years hands-on experience with physical and relational data modeling within Erwin or comparable data modeling tool
• 6 or more years of developing models and or reverse engineering relationships from database platforms (snowflake, oracle, sql server,  etc…)
• 4 or more years of experience working with P&C Data (Financial,Claims,Policy, etc..) Guidewire expertise a plus
• Knowledge of data modeli