JOB DESCRIPTION

Responsible for maintaining scalable, reliable, consistent and repeatable systems that support data operations for Reporting, Analytics, Applications, and Data Science by gathering and processing raw data at scale. Profiles data to measure quality, integrity, accuracy, and completeness and delivers solutions by developing, testing, and implementing code and scripts. Develop data set processes for data modeling, mining, and consumption

Responsibilities

• Actively and consistently supports all efforts to simplify and enhance the customer experience.
• Create and maintain scalable, reliable, consistent and repeatable systems that support data operations for Reporting, Analytics, and Applications for Business Intelligence.
• Gather and process raw data at scale (including writing scripts, web scraping, calling APIs, write SQL queries, etc.).
• Use ETL processes in order to maintain, improve, clean, and manipulate data.
• Profile data to measure quality, integrity, accuracy, and completeness.
• Develop and implement tools, scripts, queries, and applications for ETL/ELT and data operations.
• Design, build, and automate Business Intelligence Data Pipelines.
• Deliver solutions by developing, testing, and implementing code and scripts.
• Produce reports and uphold data delivery schedules.
• Manage life cycle of multiple data sources.
• Work closely with stakeholders on the data demand side (Analysts and BI Developers).
• Increase speed to delivery by implementing workload/workflow automation solutions.
• Perform other duties as assigned.

Experience:

• Ability to use a wide variety of open source technologies and cloud services
• Basic coding/scripting experience using Python, R, shell scripts
• Basic experience with SQL, Tableau, Looker, Alteryx, and ETL techniques
• Basic background in Linux/Unix/CentOS installation and administration; Windows experience preferred
• Basic knowledge in data storage that demonstrates knowledge of when to use a file system, relational database (i.e. Snowflake), or NoSQL variant
• Experience with Spark
• Basic familiarity with JavaScript API, Rest API or Data Extract APIs
• Basic experience receiving, converting, and cleansing big data
• Basic experience with visualization or BI tools, such as Tableau and Looker
• Basic experience with data workflow/data prep platforms, such as Airflow, Infomatica, Pentaho, or Talend
• Ability to identify and resolve end-to-end performance, network, server, and platform issues
• Attention to detail with the ability to effectively prioritize and execute multiple tasks
• Hands-on working experience with RDBMS, SQL, scripting, and coding
• Linux/Unix/CentOS system admin 1
• Basic coding/scripting experience using Python, R, shell scripts
• Basic experience with data workflow/data prep platforms, such as Airflow
• Basic knowledge of best practices and IT operations in an always-up, always-available service
• Basic experience receiving, converting, and cleansing big data
• Basic experience with visualization or BI tools, such as Tableau and Looker
• Basic experience receiving, converting, and cleansing data
• Basic knowledge of best practices and IT operations in an always-up, always-available service

Education

• Degree in an engineering discipline or computer science, or related field, or with equivalent experience."