ETL Systems Analyst

Chicago, IL, US

Job Description / Skills Required

Requisition ID: R13576
The ETL Systems Analyst will work closely with the data product and engineering teams in understanding the requirements and help the ETL Data Engineers in assessing the impact of new project/enhancements on the current/new ETL pipelines. The ETL Systems Analyst will also profile the source data quality, validate and troubleshoot the data output of the ETL pipelines.


Understand the Business requirements, project scope and translate it into technical specifications.

Assess the impact to the current ETL pipelines based on the requirements.

Document the technical specification/impact analysis using text and/or visual models.

Create data flow diagrams, data mapping from Source to Stage and Stage to Target mapping documents indicating the transformations required and business rules to be applied.

Create Test cases and Test scripts for system integration testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.

Validate ETL mappings and design and tune for better performance and reusability, with a view to optimize computing resources.

Perform Data Analysis and Data validation by writing SQL queries.

Be able to roll-up the sleeves, to interpret ETL code and troubleshoot ETL pipelines.

Define data quality checks and profile data.

Review code quality and make recommendations.

Participate in the incidence management, problem management processes, root cause analysis, resolution and reporting.

Write user stories and estimate the time required in tandem with the ETL engineers for ETL development work.


BA/BS degree in Engineering, Computer Science or other Quantitative field (e.g. Physics, Mathematics, Chemistry, Statistics), or equivalent practical experience

Hands-on experience with ETL design, development, testing and implementing ETL solutions.

Good understanding of SDLC, software best practices and Agile development methodologies.

Strong hands-on SQL and relational Database technologies experience like Oracle, Mysql , Teradata.

Experience with data warehousing and star-schema (dimensional) data models a plus.

Working knowledge on Linux/Unix Operating systems

Strong scripting skills – python ( a big plus ), Perl , shell etc.

Solid understanding of SDLC, software best practices and Agile development methodologies

Strong analytical, troubleshooting and diagnostic skills

Ability to develop and organize high-quality documentation

Required Big data systems skills – Hadoop , pig, hive, shark/spark etc..

Excellent verbal and written communication skills

Distinctive problem-solving and analytical skills; demonstrated ability to multi-task and apply initiative and creativity on challenging projects.

Groupon provides a global marketplace where people can buy just about anything, anywhere, anytime. We’re enabling real-time commerce across an expanding range of categories including local businesses, travel destinations, consumer products, and live or lively events. At the same time, we are providing advertising options and tools that merchants can use to grow and manage their businesses. Culturally, we believe that great people make great companies and that starting with the customer and working backward moves us forward. Community matters to us on an internal, local and global scale—it’s fundamental to our company’s growth and to the well-being of the world at large. We also value self-awareness, candor, lunch and WiFi. If we match with you, please apply to join us.