Description

You will build and maintain the data infrastructure to power data analytics and operational insights.

Responsibilities

  • Design and implement data pipeline architecture to assemble complex data sets meeting business requirements.
  • Automate manual processes and re-design infrastructure to improve data delivery and scalability.
  • Build ETL infrastructure to extract, transform, and load data from various sources using SQL and AWS big data technologies.
  • Develop analytics tools that leverage data pipelines for key business performance metrics.
  • Troubleshoot data workflows, identify bottlenecks, and provide solutions for defect-free, scalable applications.
  • Required Skills

    • 2+ years of experience in data warehousing, ETL development, and ETL architecture.
    • 2+ years combined experience with database technologies including RDBMS (MSSQL, MySQL, Oracle) or NoSQL (MarkLogic, Snowflake, DynamoDB, Redis).
    • 2 years of experience working on large data initiatives (5+ terabytes).
    • Advanced SQL knowledge and experience with relational database query authoring.
    • Experience building and optimizing big data pipelines and data sets.
    • Experience performing root cause analysis on data and processes to identify improvements.
    • Working knowledge of version control systems (e.g., SVN, Git).
    • Good knowledge of OO Javascript, XHTML, CSS, XML, and Ajax.

Education

Bachelor's degree