Job Information
Santander US Sr. Associate, Business Intelligence & Reporting in Dallas, Texas
Sr. Associate, Business Intelligence & Reporting
Dallas, United States of America
Oversees, develops and analyzes practices related to dealer management performance. Analyze internal records to understand a dealer’s history with us to build out a profile and ultimately a recommendation aligned with our dealer strategy. Run periodic analysis to identify outlier dealer behavior to bring in dealers for review. Develops and deploys standardized dealer management tools and templates to ensure reviews are completed consistently and with comprehensive information.
Works as a strategic partner with business leaders, Sales, 2nd line of defense partners and others to help facilitate data driven solutions. Through analysis and collaboration with business partners, creates standardized templates of dealer management performance. Partners closely with the BI team to create data visualization dealer views and summaries.
Summary of Responsibilities:
The Sr. Associate is primarily responsible for working with the DCS team to aggregate dealer information across a number of dimensions. The incumbent manages/assists with pulling together an aggregate profile of dealer performance, dealer quality and fraud experience. S/he works with colleagues in 2nd line of defense, BI, Ops Strategy and Sales to complete and aggregate a full dealer profile and provides input and best practice information.
Essential Functions:
Aggregates data across a number of repositories including fraud, collections, dealer quality, performance, and complaints.
Develops and maintains key metrics through data extraction and manipulation.
Maintains detailed tracking of dealer files for updates.
Develops, optimizes, and maintains queries in MS SQL Server Management Studio 2008/2012.
Creates advanced reporting and analysis through Microsoft SQL Server Report Builder.
Gathers pertinent data and performs regression and other statistical analyses to help identify meaningful data relationships, Key Performance Indicators, and Key Risk Indicators.
Performs quality checks and provides in-depth data analysis reports to analyze key business issues, and system defects.
Analyzes current processes to determine gaps and areas for possible enhancements.
Analyzes anomalies and create an action plan for dealer data remediation.
Creates ad-hoc analysis in order to analyze key business issues.
Troubleshoots and escalates issues and/or process gaps.
Ensures that documentation meets internal policy and guidelines on dealer data.
Documents procedures as well as offer and implement suggestions to enhance accuracy and efficiency of the processes.
Other Functions:
- Other duties as assigned.
Requirements:
Education:
Bachelor's Degree in Business, Economics, Accounting, Statistics or equivalent field.
or equivalent work experience
Experience:
3-10 years experience in mathematics / statistics / computer science / accounting or related.
3-10 years experience modeling complex datasets in order to resolve an outstanding problem.
3-10 years experience researching complex problems and arriving at a viable solution.
3-10 years exposure to basic Financial Services and Dealer Management concepts.
Skills & Abilities:
Advanced technical skills
Capacity for advanced problem solving and critical thinking
SQL, data manipulation, data mining, data modeling, BI experience
Experience creating Tableau dashboards
Demonstrated strong knowledge in Microsoft Excel, including but not limited to data transformation, functions/expressions, Macros
Proficient in MS Office applications
Familiarity with business cycles, both fiscal and calendar
Strong logical thinking, problem solving and decision making skills
Highly analytical with strong attention to detail
Self-directed and able to flourish in a fast-paced environment
Excellent written and oral communications.
Diversity & EEO Statements:
At Santander, we value and respect differences in our workforce and strive to increase the diversity of our teams. We actively encourage everyone to apply.
Santander 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, genetics, disability, age, veteran status or any other characteristic protected by law.
Working Conditions:
Frequent Minimal physical effort such as sitting, standing and walking. Occassional moving and lifting equipment and furniture is required to support onsite and offsite meeting setup and teardown. Physically capable of lifting up to fifty pounds, able to bend, kneel, climb ladders.
Employer Rights:
This job description does not list all of the job duties of the job. You may be asked by your supervisors or managers to perform other duties. You may be evaluated in part based upon your performance of the tasks listed in this job description. The employer has the right to revise this job description at any time. This job description is not a contract for employment and either you or the employer may terminate at any time for any reason.
Masters of Science (MS) English Business Intelligence
Primary Location: Dallas, TX, Dallas
Other Locations: Texas-Dallas
Organization: Santander Bank N.A.
The base pay range for this position is posted below and represents the annualized salary range. For hourly positions (non-exempt), the annual range is based on a 40-hour work week. The exact compensation may vary based on skills, experience, training, licensure and certifications and location.
Salary: $108,000 - $160,000/year
AN EQUAL OPPORTUNITY EMPLOYER M/F/Vet/Disabled/SO