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.