GLS is looking to improve access to affordable, reliable transportation by leveraging advanced analytics and technology to predict credit risk and provide auto financing options.
Requirements
- 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
Responsibilities
- 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
Other
- 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 able to work at a desk/in a seated position up to 100% of the workday
- Must be able to constantly operate a computer and other standard office equipment
- Strong verbal and written communication skills
