Audit Data Analyst II
Audit Data Analyst II
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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
Employer: United Services Automobile Association
Tasks: Leverages expert business/analytical knowledge to participate or lead discussions with cross functional teams to understand and collaborate highly complex business objectives and influence solution strategies. The business problems analyzed are typically medium to large scale with significant impact to current and/or future business strategy. Applies innovative and scientific/quantitative analytical approaches to draw conclusions and make insight to action recommendations to answer the business objective and drive the appropriate change. Translates recommendation into communication materials to effectively present to various levels of management. Incorporates visualization techniques to support the relevant points of the analysis and ease the understanding for less technical audiences. Identifies and gathers the relevant and quality data sources required to fully answer and address the problem for the recommended strategy through testing or exploratory data analysis (EDA). Integrates/transforms disparate data sources and determines the appropriate data hygiene techniques to apply. Thoroughly documents assumptions methodology validation and testing to facilitate peer reviews. Subsequent analysts should be able to rely on documentation to replicate and continue work. Understands and adopts emerging technology that can affect the application of scientific methodologies and/or quantitative analytical approaches to problem resolutions. Succinctly delivers analysis/findings in a manner that conveys understanding influences various levels of management garners support for recommendations drives business decisions and influences business strategy. Recommendations typically have a major impact on business results. Provides subject matter expertise in operationalizing recommendations. May telecommute.
Requirements: Bachelors degree in Economics Finance Statistics Mathematics Actuarial Sciences Engineering Management Telecommunications Engineering or related field and 1 year of experience in the job offered or in an Audit Data Analystrelated occupation. Position requires experience in the following:
- Validating large banking transaction datasets for reporting supporting business requests and remediation using tools such as SAS;
- Performing data testing for completeness and accuracy in various audits;
- Creating complex SQL/SAS scripts which includes complex joins sub queries analytical functions and DML operations to process;
- Extracting data from Snowflake Oracle and Teradata DB;
- Hadoop Netezza Oracle SQL Server and Snowflake;
- Tableau reports and dashboards;
- Performing data cleansing and manipulation by using Excel VLOOKUPs pivot and other advanced excel functions;
- Experience finding cleaning and manipulating data to build data sets;
- Real time/Streaming data onprem and in cloud environments including AWS or Snowflake;
- Developing analysis queries and procedures in SQL SAS BI tools or other analysis software;
- Experience with new and emerging data sets and incorporation (data wrangling data mining) into new insights;
- Leveraging analytic tools to provide adhoc support while also developing automation;
- Continuous Monitoring development and implementation;
- Experience with regulatory impacts such as consent orders and MRAs;
- Experience with creating Strategy and Methodology for next generation Audit ;
- Identifying and gathering relevant quality data sources through testing or exploratory data analysis (EDA); and
- Integrating and transforming disparate data sources
Worksite: 5601 Legacy Drive Plano TX 75024
Relocation assistance is Not Available for this position.
This position is eligible for the Employee Referral Program.
#DNP
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.
Employees may be eligible for pay incentives based on overall corporate and individual performance and at the discretion of the USAA Board of Directors.
The 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.
Benefits: At USAA our employees enjoy bestinclass 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 visit our benefits page on .
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.
Required Experience:
IC
Employment Type
Full-Time
