Data Developer II

Why GLS?
Purpose: Access to affordable, reliable transportation is essential to leading productive work and personal lives, caring well for oneself, one’s family, and the needs of others. Through advanced analytics and technology, we can more accurately predict credit risk and provide more people with an affordable auto financing option for their next vehicle. That’s what GLS has done for over 10 years, helping more than half a million families meet and improve their transportation needs. 
People: Join a culture of over 1,000 employees who Care Deeply and Think Boldly, driving innovation in an adaptive and positive culture that celebrates successes. We empower and reward individuals and teams who make direct, positive impacts to the business and each other, who take pride in their work and are ever-raising the bar. 
Growth: Recognized by Inc 5000 as one of the fastest-growing private companies in America. Join GLS to grow with us!
Benefits: GLS offers the below great benefits for your amazing work!o   Competitive base pay and performance bonuses, dependent on roleo   Medical, dental, vision, telemedicine, supplemental insurance benefits, long-term and short-term disabilityo   401K with employer match and 100% immediate vestingo   Paid Time Off (PTO) and paid company holidays to help you balance work and personal lifeo   Paid Volunteer Time Off (VTO) Annuallyo   Tuition Reimbursement o   Parental Leave o   Business casual work environment
What does it mean to be a Data Developer II at GLS?The Data Developer II is responsible for building fast, reliable, transparent, and scalable business-focused information systems. This position designs and builds standardized ETL processes used to populate the data warehouse and feed data to external partners. The position also leverages data query tools to help present data in various data visualization tools. The position consults architects, analysts, and stakeholders toward the efficient and effective use of SQL to perform their analytic and Business Intelligence functions.

How will you drive value within the organization as a Data Developer II?

• Design, build, enhance, and maintain fault tolerant batch based and real-time ETL processes to make new and existing data sources readily available to analysts, applications, and external business partners
• Design and build data warehouses/data lakes/data marts to provide easy access to structured and semi-structured data for analysts/data scientists
• Design, build, enhance, and maintain reliable and performant batch and real-time interactive PowerBI dashboards and SSRS reports working from specification documents and/or direct interaction with business users
• Automate and optimize ad-hoc reports, manual data processes, and user queries, through data research and understanding
• Set-up internal and external secure data exchanges using industry standard encryption techniques
• Implement data security measures to protect PII and other sensitive information
• Integrate processes and tools to monitor and improve data quality and system stability as prescribed by the data governance team
• Review and provide feedback to other developers with an emphasis on efficiency, quality, and maintainability
• Foster a collaborative culture that facilitates the achievement of business plan objectives by working closely with other associates and members of management
• Perform additional assignments and special projects as required by the needs of the company or as directed by management

What should you already know to be successful as a Data Developer II?

• Minimum of bachelor’s degree required
• Minimum of two (2) years’ experience in either ETL, BI (building charts and graphs), or Statistical Analytics fields required
• Must be proficient in SQL including joins, inserts, updates, deletes, conditional logic, subqueries, temp tables, and complex data transformation functions
• Knowledge of relational database management systems and data warehouse system required
• Experience reviewing datasets for data quality required
• Experience with programming languages like Python required
• Experience with unstructured or semi-structured data (ex. XML, JSON) preferred
• Experience with data integration tools like Airflow or Prefect preferred
• Experience with different data security algorithm preferred
• Intrinsically motivated with demonstrated ability to take initiative, identify needs, make recommendations for improvement, see recommendations through implementation, and evaluate improvements for effectiveness 
• Strong verbal and written communication skills
• Team pl