Company Overview Credit First National Association is a private label credit card bank and the consumer credit division of Bridgestone Americas. The Bridgestone Americas family of enterprises, including CFNA, is comprised of more than 50 production facilities and 55K employees throughout the Americas. We provide the consumer credit solution for the Firestone Complete Auto Care, Tires Plus, and Wheel Works brands, in addition to customized retail credit services for more than 8,000 other tire and automotive retailers nationwide. At our office in Cleveland, OH, more than 300 professionals gather each day to run a successful private label credit card program. We invest in our community and strongly believe that meaningful commitment to a wide variety of philanthropic organizations builds a better world and a brand that makes us proud.
Job Category Information Technology
Position Summary We are seeking an Internal Data Warehouse Development and Administration to join our team.
The SQL Developer/ETL Developer role is to plan, design, install, develop, test and implement SQL based operational and reporting solutions. This position also requires extensive knowledge and experience with supporting third party application integration solutions with CFNA core operational processes. All project and support tasks must be completed consistent with Company goals, industry best practices and regulatory requirements while ensuring data protection and security in highly visible, mission critical environments
We strive to unite individuals with diverse perspectives to create a world-class team where you can thrive.
Responsibilities In this role, your primary responsibilities will include:
SQL Developer Qualifications Experience with SQL Server and SQL Server Management Studio (SSMS)
Experience with Managed File Transfer (MFT) solutions for external data integration solutions
Experience with SQL query performance tuning and optimization
Proficient with SQL database concepts of data modeling and design principles
Experience SQL Server Agent for complex job scheduling and triggering
Proficient and generating Entity Relationship Diagrams (ERD) and documentation of metadata related to new data assets
Experience supporting a Data Warehouse environment/architecture
Proficiency in writing complex queries and scripts
Experience with SQL Server Integration Services (SSIS)
Experience with monitoring SQL Server performance using tools like CloudWatch, Performance Insights, Query Store, and Dynamic Management Views (DMVs).
Ability to collaborate with software engineers and data teams to integrate AWS-hosted SQL Server databases with enterprise applications and analytics platforms.
Acquisition & Deployment Review project requests describing database user needs to estimate time and cost required to successfully accomplish a project.
Participate, with responsibility for some major deliverables, in the transition of support for new IT solutions that have been implemented for customer by the Database Technical Services team or other implementation partners.
Operational Management Collaborate with DBA to create models for new database development and/or changes to existing ones.
Identify and resolve ETL processing performance issues.
Plan and coordinate data migrations between systems.
Develop, implement, and maintain change control and testing processes for modifications to ETL processes.
Assume primary responsibility during problem resolution. Uses troubleshooting techniques to identify root cause and implements permanent corrective action to resolve issues.
Incidental Functions Assist with projects as necessary to contribute to efficiency and effectiveness of the work.
Attend management meetings on behalf of team.
Provide periodic 24/7 on-call support of specific functions.
Minimal travel as required.
Working outside the standard office 8.0 hours workday as required; on-call availability.
Experience Required: 3 - 5+ years IT experience.
Strong understanding of database structures, theories, principles, and practices.
Experience with data processing flowcharting techniques.
Project management experience.
Knowledge of applicable data privacy practices and laws
. Personal Attributes Strong and comprehensive verbal and written communications.
Responsive and alert to new learning opportunities, growth and development of technical, interpersonal and business skills; able to recognize and address areas needing improvement.
Motivated and competent to contribute appropriate time and effort to work needing attention.
Attentive to detail with focus on accurate and timely results.
Organized and able to prioritize tasks, responding effectively to competing needs.
Attentive and reactive to customer (both internal and external vendor) needs and concerns.
Strong analytical and problem-solving abilities.
Strong customer service orientation.
Able to contribute to team effort and individual achievement.
Education Required Bachelor degree or equivalent experience.
Minimum Qualifications Typically requires a bachelor's degree and a minimum of 2 years of related experience; or an advanced degree without experience; or equivalent work experience.
We are building a team as diverse as the world we serve. We believe in championing all perspectives, individuals, and teams. If you find this opportunity compelling, we encourage to apply.
What we offer At Bridgestone, what really matters is to foster co-creation opportunities and empowering you to be creative and curious to make mobility safer, more efficient, and more sustainable for future generations. Whatever role you fill, when you represent Bridgestone, you are a valued teammate, and part of our larger mission to "Serve Society with Superior Quality", for that, we offer you more than just a competitive compensation; we will provide you:
- A supportive and engaging onboarding experience to ensure a smooth transition into our team.
- The opportunity to develop and grow, through training and regular mentorship.
- Corporate Social Responsibility activities.
- A truly global, dynamic and challenging work environment.
- Agility and work/life effectiveness and your long-term well-being.
- A diverse and inclusive team.
Bridgestone is proud to be an Equal Employment Opportunity employer. It is our policy to consider for employment all individuals regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, gender, sex, sexual orientation, gender identity and/or expression, genetic information, veteran status, or any other characteristic protected by federal, state or local law. Employment Eligibility If hired, a Form I-9 Employment Eligibility Verification must be completed at the start of employment. Temporary work authorization or the need for sponsorship may disqualify you from employment.