Data Warehouse Developer (Mid or Senior Level)
Company: Credit Acceptance Corporation
Posted on: January 15, 2019
Credit Acceptance is continuously expanding with a variety of dynamic opportunities in Information Technology. Our culture has landed us on Computerworld's list of the Best Places to Work in IT. In each of the last 5 years, we have held a spot in the top 2 for midsized companies nationwide. Our IT department provides the opportunity to work with progressive tools, and technology including the latest database, development, storage, and computer technologies available. About this Position: Design, develop and implement logic to extract, transform & load data from transactional applications into the DW using Oracle Data Integrator (ODI) and PL/SQL Partner with Database Administrators and DW developers to achieve great performance Help DW end users understand and query data to accomplish their business purposes Demonstrate advanced skills while coaching and mentoring less senior team members(Senior) Outcomes & Activities: Respond promptly and effectively to resolve incidents(Mid-Level) Gather requirements for a change by meeting with customers and listening actively(Mid-Level) Meet your time and cost estimates when implementing a change(Mid-Level) Demonstrate the knowledge, skills and abilities described above(Mid-Level) Fulfill customer requirements using Oracle Data Integrator and PL/SQL(Mid-Level) Responds promptly and effectively to resolve incidents, tasks, and projects(Mid-Level) Shows initiative by working hard(Mid-Level) Solves problems at the source by offering simple, working solutions(Mid-Level) Communicates DW changes clearly, concisely, and objectively verbally & in writing(Mid-Level) Anticipates the impact of a change or project across multiple systems(Mid-Level) Design, code, test and deliver insightful and architecturally sound business solutions(Senior) Document code and projects so others can easily understand(Senior) Fulfill customer requirements as measured in customer survey scores(Senior) Show insight; know your application design & data; offer simple, working solutions(Senior) Apply team coding, documenting and testing standards and recommend process improvements(Senior) Recognize upstream and downstream impacts; communicate effectively verbally & in writing(Senior) Learn the Business Process Your Application Supports so your code will better support the business(Senior) Improve your application and team processes(Senior) Decrease incidents and increase uptime of your application(Senior) Remain compliant with our policies, processes and legal guidelines All other duties as assigned Attendance as required by department Requirements: Bachelor degree or equivalent in Computer Science, Information Systems, or closely related field of study Proficiency in PL/SQL coding, troubleshooting, and performance tuning Experience with Oracle (preferably version 11) Practical knowledge of lifecycle database design, 3NF and dimensional design concepts Knowledge of Unix Scripting and job scheduling. Work onsite at the assigned Credit Acceptance work location. Remain compliant with our policies, processes and legal guidelines. Willingness to participate in an on-call rotation 24x7x365 where you will be responsible for monitoring production failure notifications and resolve issues. Minimum 3 years Data Warehouse design and development experience; 3 years Information Systems experience(Mid-Level) Minimum of 5 years Data Warehouse design and development experience; Minimum of 5 years Information Systems experience(Senior) Knowledge of ETL tools -Oracle Data Integrator Enterprise Edition(Senior) Preferred: Familiarity with Oracle Application Express(Mid-Level) Familiarity with Oracle Business Intelligence Enterprise Edition(Mid-Level) Knowledge of ETL tools -Oracle Data Integrator Enterprise Edition(Mid-Level) Experience in Data Quality and Cleansing, Data Governance, Metadata usage and management, and Master data management(Senior) Knowledge and Skills: Maintain customer focus; keep the customer's and company's best interest in mind. Work well with abstract concepts. Be analytical. Solve problems. Be self-driven, motivated to help, and able to perform with minimal supervision. Effectively prioritize and execute tasks in a high-pressure environment. Ability to gain trust of others and build solid relationships across and vertically throughout the organization and relate well to all business users Communicate effectively (both written and verbal)with all levels Research and resolve a wide range of issues Code expertly in your application while following team coding and testing standards(Senior) Respond promptly and effectively to large-scale problems, projects and tasks(Senior) Demonstrate insight; make recommendations as opportunities arise(Senior) Company Values: To be successful in this role, Team Members need to demonstrate the characteristics of PRIDE (our Company core values) in their work: Positive: Maintain a positive attitude by focusing on solutions and promoting a collaborative and enjoyable environment. Respectful: Value teamwork, share successes, appreciates others and communicates in a way that promotes trust. Insightful: Make timely well considered decisions, create innovative solutions and continuously learn. Direct: Communicate clearly and objectively; don't be afraid of difficult conversations. Raise concerns through the proper channels. Earnest: Be honest, sincere and consistent. Work hard and pursue our goals together relentlessly. Targeted Compensation: $90,000-105,000
Keywords: Credit Acceptance Corporation, Southfield , Data Warehouse Developer (Mid or Senior Level), IT / Software / Systems , Southfield, Michigan
Didn't find what you're looking for? Search again!