Data Warehouse Analyst IV (649-702)
Santander Consumer USA Inc - Dallas, TX

This job posting is no longer available on Monster. Find similar jobs:Data Warehouse Analyst jobs - Santander Consumer USA jobs

Santander Consumer USA Inc. (“SCUSA”) is a leading consumer finance company, whose core business is indirect, direct and third-party originations and servicing of auto loans. With its Drive®, Santander Auto Finance and® brands, SCUSA’s finance programs help consumers with less-than-perfect credit purchase vehicles. The company began originating loans in 1997, and is headquartered in Dallas with satellite offices throughout the U.S. We are owned by global banking leader Banco Santander (NYSE: SAN), which was named “Best Bank in the World” by EuroMoney Magazine, and one of the “Top 10 Safest Banks” by Global Finance Magazine. Associates who work for SCUSA are provided with comprehensive benefits, including a Medical PPO, Dental and Vision plans, 401(k) with 100% matching up to 6%. Employees also receive Paid Time Off, paid holidays, Life/LTD/STD Insurance as well as numerous voluntary products such as Medical and Dependent Care FSA, and more. SCUSA is an equal opportunity employer.

The Data Warehouse Analyst IV shall have these general responsibilities to be performed under minimal supervision:
Designing and documenting logical and physical analytical enterprise databases, particularly the Enterprise Data Warehouse (EDW) Analyzing source systems for loading into EDW and communicating findings and make recommendations back to the EDW team. Specifying and documenting ETL requirements to maintain the EDW environment. Coordinating with ETL and DBA teams to meet objectives and deadlines. Analyzing and recommending reactions to source system changes as they impact the EDW. Addressing user questions about the EDW. - Assisting in publication and availability of enterprise meta-data pertaining to the EDW. Planning, documenting and coordinating the exchange of data with third party vendors and lenders as needed. Assist, guide and train other members of the EDW team. Source System Analysis / Impact Analysis Analyze source systems in response to new functionality requests to EDW and summarize findings and make recommendations. Perform impact analysis to assess impact of source changes to the EDW. Maintain Enterprise Data Models Coordinate with business analysts (EDW users) to understand data requirements. Use ERwin Model Manager to create and maintain logical and physical analytical data models for simple projects. Maintain and administer the corporate meta-data repository. Adhere to enterprise modeling standards. Document Solutions Work closely with Business Analysts and users as required to understand and help design technical solutions to requirements. Document data migration mappings and transformations for data warehouse loading. Assist ETL as requested in the interpretation and execution of loading specifications. Work with Business Intelligence developers and users Assure that metrics are understood and efficiently utilized. Help review Cognos models to assure that they are exposing data properly. Investigate and report on data anomalies.

Required Skills

Eight (8) years experience with data modeling and data warehouse environment. Must be able to write and troubleshoot complex SQL queries. Experience with auto finance or banking is a plus. Bachelor""s degree in I.T. or Business preferred. Equivalent combination of education and experience may be substituted in lieu of college degree. Overtime work may be required as needed to adapt to business change.

Submitting a resume online at a job site could cause valuable screening information to be missed.

Please apply directly at:

We are an Equal Opportunity Employer