Job description
General information
Ally and Your Career
The Opportunity
The Work Itself
- The Sr. Data Engineer will be a part of team that supports database and PL/SQL development.
- Design, implement, code, test and maintain database technologies.
- Prepare and review system documentation composed by development teams.
- Perform modifications to and maintenance of operational programs and procedures.
- Develops effective and efficient PL/SQL packages, procedures, triggers and functions according to design specifications.
- Applies best practice for tuning for overall system performance.
- Supports software development and test teams throughout the software development lifecycle.
- Includes incremental script execution and defect resolution.
- Provides support for software releases.
- Researches interfaces to identify and code required updates to support integration.
The Skills You Bring
- 3+ years of experience preferred
- Bachelor's degree in computer science, information systems or relevant field of study preferred.
- Extensive experience with database development tools, ETL and integration technologies.
- Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic.
- Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures.
- Ability to setup, maintain and enhance partition table spaces.
- Ability to provide guidance, oversight, and peer review to more junior database developers.
- Experience with managing and resolving problems on a live production system.
- Solid understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports etc.
- Experience with software development lifecycle and software development common practices (code reviews, unit testing etc.).
- Strong written and oral communication skills are essential.
- Solid work ethic, self-driven with the ability to work with minimal supervision.
- Data Engineering
- Data Management
- strong Datawarehousing
- Data Analysis
- Business Analysis/Corrdination
- PYTHON ( medium-expert)
- Cloud (AWS/SNOWFLAKE/QLIK/DBT)
- Reporting/Visulaization (Power BI prefereably)
How We'll Have Your Back
Ally's compensation program offers market-competitive base pay and pay-for-performance incentives (bonuses) based on achieving personal and company goals. Our Total Rewards program includes industry-leading compensation and benefits plus additional incentives that are designed to meet your needs and those of your family so you can get the most out of your career and your life, including:
- Time Away: 11 paid holidays, 20 paid time off days, and 8 hours of volunteer time off, yearly (paid time off is prorated based on start date)
- Planning for the Future: plan for the near and long-term with an industry-leading 401K retirement savings plan with matching and company contributions, student loan pay down and 529 educational save up assistance programs, tuition reimbursement, employee stock purchase plan, and financial learning center and financial coach access.
- Supporting your Health & Well-being: flexible health and insurance options including medical, dental and vision, employee, spouse and child life insurance, short- and long-term disability, pre-tax Health Savings Account with employer contributions, Healthcare FSA, critical illness, accident & hospital indemnity insurance, and a total well-being program that helps you and your family stay on track physically, socially, emotionally, and financially.
- Building a Family: adoption, surrogacy and fertility assistance as well as paid parental and caregiver leave, Dependent Day Care FSA back-up child and adult/elder care days and childcare discounts.
- Work-Life Integration: other benefits including Employee Assistance Program, subsidized and discounted Weight Watchers® program and other employee discount programs.
- Other Compensation: depending on the role for which you are considered, you may be eligible for travel allowances, relocation assistance, a signing bonus and/or equity.
- To view more detailed information about Ally’s Total Rewards, please visit this link: https://www.ally.com/content/dam/pdf/corporate/ally-total-rewards-snapshot.pdf
Who We Are:
Ally Financial is a customer-centric, leading digital financial services company with passionate customer service and innovative financial solutions. We are relentlessly focused on "Doing it Right" and being a trusted financial-services provider to our consumer, commercial, and corporate customers. For more information, visit www.ally.com.
Ally is an equal opportunity employer committed to diversity and inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity or expression, pregnancy status, marital status, military or veteran status, genetic disposition or any other reason protected by law.
We are committed to working with and providing reasonable accommodation to applicants with physical or mental disabilities. For accommodation requests, email us at work@ally.com. Ally will not discriminate against any qualified individual who is capable of performing the essential functions of the job with or without reasonable accommodation.
jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.