Senior Data Engineer, Gemini

• 5+ years experience in data engineering with data warehouse technologies
• 5+ years experience in custom ETL design, implementation and maintenance
• 5+ years experience with schema design and dimensional data modeling
• Experience building real-time data solutions and processes
• Advanced skills with Python and SQL are a must
• Experience with one or more MPP databases(Redshift, Bigquery, Snowflake, etc)
• Experience with one or more ETL tools(Informatica, Pentaho, SSIS, Alooma, etc)
• Strong computer science fundamentals including data structures and algorithms
• Strong software engineering skills in any server side language, preferable Python
• Experienced in working collaboratively across different teams and departments
• Strong technical and business communication

Desirable

• As a member of our data engineering team, you'll deliver high quality work while solving challenges that impact the whole or part of the team's data architecture
• You'll update yourself with recent advances in Big data space and provide solutions for large-scale applications aligning with team's long term goals
• Your work will help resolve complex problems with identifying root causes, documenting the solutions, and implementing Operations excellence (Data auditing, validation, automation, maintainability) in mind
• Communicating your insights with leaders across the organization is paramount to success
• Design, architect and implement best-in-class Data Warehousing and reporting solutions
• Lead and participate in design discussions and meetings
• Mentor data engineers and analysts
• Design, automate, build, and launch scalable, efficient and reliable data pipelines into production using Python
• Build real-time data and reporting solutions
• Design, build and enhance dimensional models for Data Warehouse and BI solutions
• Research new tools and technologies to improve existing processes
• Develop new systems and tools to enable the teams to consume and understand data more intuitively
• Partner with engineers, project managers, and analysts to deliver insights to the business
• Perform root cause analysis and resolve production and data issues
• Create test plans, test scripts and perform data validation
• Tune SQL queries, reports and ETL pipelines
• Build and maintain data dictionary and process documentation