Data Modeler (Senior) at USAA - United Services Automobile Association
San Antonio, TX 78201
About the Job
Why USAA?Let’s do something that really matters.At USAA, we have an important mission: facilitating the financial security of millions of U.S. military members and their families. Not all of our employees served in our nation’s military, but we all share in the mission to give back to those who did. We’re working as one to build a great experience and make a real impact for our members.We believe in our core values of honesty, integrity, loyalty and service. They’re what guides everything we do – from how we treat our members to how we treat each other. Come be a part of what makes us so special!The OpportunityAs 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 complianceCreates 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 tool6 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 plusKnowledge of data modeling principles including conceptual, logical data models, physical data modelsExperience working with relational data modelsKnowledge of metadata management and related toolsStrong communication skillsThe above description reflects the details considered necessary to describe the principal functions of the job and should not be construed as a detailed description of all the work requirements that may be performed in the job.What we offer:Compensation: USAA has an effective process for assessing market data and establishing ranges to ensure we remain competitive. You are paid within the salary range based on your experience and market data of the position. The actual salary for this role may vary by location. The salary range for this position is: $109,130-208,580.Employees may be eligible for pay incentives based on overall corporate and individual performance and at the discretion of the USAA Board of Directors.Benefits: At USAA our employees enjoy best-in-class benefits to support their physical, financial, and emotional wellness. These benefits include comprehensive medical, dental and vision plans, 401(k), pension, life insurance, parental benefits, adoption assistance, paid time off program with paid holidays plus 16 paid volunteer hours, and various wellness programs. Additionally, our career path planning and continuing education assists employees with their professional goals.For more details on our outstanding benefits, please visit our benefits page on USAAjobs.com.Applications for this position are accepted on an ongoing basis, this posting will remain open until the position is filled. Thus, interested candidates are encouraged to apply the same day they view this posting. USAA is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.SummaryLocation: Plano Legacy; Phoenix Campus (Main); Chesapeake; Tampa Campus; Charlotte, NC - CENTS; San Antonio Home Office I; Colorado Springs CampusType: Full time