Database Developer II
Company
DriveTime
Location
Phoenix – Mesa – Scottsdale, AZ
Type
Full Time
Job Description
What's Under the Hood
DriveTime Family of Brands is the largest privately owned used car sales finance & servicing company in the nation. Headquartered in Tempe, Arizona and Dallas, Texas, we create opportunities and improve the lives of our customers and our employees by placing a focus on putting the right customer, in the right vehicle, on the right terms and on their path to ownership.
The DriveTime Family of Brands spans across DriveTime, Bridgecrest and SilverRock. You can find us at the intersection of technology and innovation as we use our proprietary tools and over two decades of industry knowledge to redefine the process of purchasing, financing, and protecting your vehicle.
That's Nice, But What's the Job?
We are seeking a skilled Database Developer II with a strong analytical mindset to join our team
and contribute to our data infrastructure and analytics initiatives. As a Database Developer II
you will be responsible for designing, developing, and maintaining robust data pipelines
and ETL processes.
In Short.
- Analyze operational business workflows to understand data requirements,
- process dependencies, and key performance indicators (KPIs).
- Design, develop, and optimize data pipelines and ETL processes using SQL
- Server and SSIS to extract, transform, and load data from various sources into
- data warehouses and data lakes.
- Develop data processes that support online transactional processing workflows, ensuring data integrity and reliability for real-time operations.
- Apply critical thinking skills to identify and address data quality issues,
- anomalies, and inconsistencies in the data pipeline.
- Write efficient and scalable SQL queries, stored procedures, and database scripts to manipulate and transform large volumes of data.
- Utilize Python programming to develop data processing scripts, automate data workflows, and enhance data integration capabilities.
- Utilize Argo, a container-native workflow engine (if applicable), to orchestrate and schedule complex data workflows and job dependencies.
- Implement data modeling techniques and best practices to optimize data storage, retrieval, and analysis.
- Leverage your analytical skills to identify patterns, trends, and insights from data to support business decision-making processes.
- Utilize Snowflake, an innovative cloud-based data platform, to design and manage data warehousing solutions.
- Collaborate with product team leaders, software engineers, data scientists and analysts to provide them with the necessary data infrastructure and tools for software application data functionality, analysis, and reporting.
- Monitor and troubleshoot data pipelines, addressing any performance issues, data quality concerns, or system failures.
- Stay updated with industry trends and emerging technologies in the field of data engineering and suggest improvements to enhance data processing and analytics capabilities.
The Specifics.
- Bachelor's degree in Computer Science, Engineering, or a related field.
- Strong experience in SQL Server, SSIS, and Stored Procedures for data integration and ETL processes.
- Proficiency in Python programming language for data processing and automation tasks.
- Experience with Argo (a plus), a container-native workflow engine, for orchestrating data workflows.
- Experience with Snowflake (a plus), a cloud-based data platform, for data warehousing and management.
- Working knowledge of Azure data products such as Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and Azure Data Lake Storage.
- Solid understanding of data modeling principles, data warehousing concepts, and database design.
- Strong analytical skills to analyze operational business workflows and identify data requirements and KPIs.
- Critical thinking abilities to evaluate data quality, identify anomalies, and provide data-driven insights.
- Experience in developing data processes that support online transactional processing workflows.
- Strong problem-solving and troubleshooting skills to address issues in data pipelines and ETL processes.
- Excellent communication and collaboration skills to work effectively with diverse, cross-functional teams.
- Ability to adapt to new technologies, learn quickly, and stay updated with industry advancements
So What About the Perks? Perks matter
- Medical, dental, and vision, oh my! DriveTime Family of Brands covers a sizable amount of insurance premiums to ensure our employees receive top-tier healthcare coverage.
- But Wait, There's More. 401(K), Company paid life insurance policy, short and long-term disability coverage to name a few.
- Growth Opportunities. You grow, I grow, we all grow! But seriously, DriveTime Family of Brands is committed to providing its employees with every opportunity to grow professionally with roughly over 1,000 employees promoted year over year.
- Tuition Reimbursement. We're as passionate about your professional development as you are. With that, we'll put our money where our mouth is.
- Wellness Program. Health is wealth! This program includes self-guided coaching and journeys, cash incentives and discounts on your medical premiums through engaging in fun activities!
- Gratitude is Green. We offer competitive pay across the organization, because, wellmoney matters!
- In-House Gym. We want our employees to be the best versions of themselves. So come early, take a break in your day or finish strong with a workout!
- Give Us a Reason (or not), and We'll Celebrate. Regardless of whether there is a holiday or not, we are finding ways to kick back and enjoy each other's company outside of day-to-day work.
- Smart-Casual Dress. Come dressed in jeans (you'll fit right in with the rest of us).
- Paid Time Off & Paid Holidays. Not just lip service: we work hard, to play hard.
Anything Else? Absolutely.
DriveTime Family of Brands is Great Place to Work Certified! And get this: 90% of our rockstar employees say they feel right at home here. We could spend a lot of time having you read about ALL our awards, but we'll save time (and practice some humility) just naming a few others; Comparably Awards: Best Company for Diversity, Best Company Culture and Best Company Leadership, oh and don't forget Phoenix Business Journal Healthiest Employers (okay, we'll stop there)!
Hiring is contingent upon successful completion of our background and drug screening process. DriveTime is a drug-free, tobacco-free workplace and an Equal Opportunity Employer.
And when it comes to hiring, we don't just look for the right person for the job, we seek out the right person for DriveTime. Buckle up for plenty of opportunities to grow in a professional, fun, and high-energy environment!
Date Posted
04/15/2024
Views
12
Similar Jobs
Front End Engineer - Swarmbotics AI
Views in the last 30 days - 0
Swarmbotics AI a company specializing in lowcost swarm robotics for defense and industry is seeking a FrontEnd Engineer The role involves designing an...
View DetailsAndroid Developer - Swarmbotics AI
Views in the last 30 days - 0
Swarmbotics AI a lowcost swarm robotics company is seeking an experienced Android Developer to build missioncritical command and control interfaces fo...
View DetailsSoftware Developer in Test Manager - Vālenz Health
Views in the last 30 days - 0
Valenz Health is seeking a Software Developer in Test Manager with 6 years of experience in software development or QA automation The role involves le...
View DetailsBusiness Consultant - Arizona - FrankCrum
Views in the last 30 days - 0
FrankCrum a familyowned business since 1981 is seeking a fulltime Business Consultant in Arizona The role involves prospecting and obtaining direct sa...
View DetailsSIU Team Lead, Cash App - Cash App
Views in the last 30 days - 0
Cash App a dynamic financial ecosystem developed by Block is seeking a Team Lead for its Financial Crimes Special Investigations Unit SIU The role inv...
View DetailsSales and Retention Rep - Cox Enterprises
Views in the last 30 days - 0
Cox Communications is hiring a Sales and Retention Representative for a fulltime position in Phoenix AZ The role involves taking calls from customers ...
View Details