Data Engineer - Business Intelligence

Be a part of the Subway Group - the world's largest quick service restaurant franchisor and recognized leader in the Quick Service Restaurant industry. With more than 44,000 restaurants in over 100 countries, we continue to add talent to our team at our global headquarters in Milford, Connecticut. Subway seeks to hire an experienced Business Intelligence (BI) Data Engineer to work closely with our BI Team and Business Users to continue to evolve our cloud enabled data ecosystem.

The BI Engineer will be responsible for the design and development of datasets and Reports that support our BI Platforms.  The BI Engineer will work as part of a cross functional team to deliver Reporting solutions for enterprise initiatives.

A successful candidate will deliver scalable and flexible solutions that conform to Subway's data design and governance strategies utilizing our AWS environment and Amazon Redshift data warehouse and other cloud-based technologies. Responsibilities include, but are not limited to:

• Design and develop Datasets (Tableau or other tools) that are performant, scalable and flexible.
• Design and develop Reports that are performant and flexible.
• Design and develop data pipelines and integrations that are performant, scalable and flexible.
• Work with project teams to deliver Datasets and reports, ensuring a high degree of reliability and resiliency.
• Work with business users and project teams to provide SME guidance, finalize requirements and develop level of effort estimates.
• Conduct Unit testing and UAT with the business counterparts.
• Provide database support by coding utilities, responding to user questions, and resolving problems.
• Create and maintains documentation of the datasets and reports including data flow and data lineage documentation.
• Responsible for tier 3 support and assisting our Operations Team as required to provide a great customer experience for our users.
• Responsible for overall data quality in the aggregate layer in Data warehouse.  Provide data analysis as required to troubleshoot data issues.
• Assist with Dataset and reporting related code reviews and mentorship of junior and offshore developers.

The successful candidate will have:

• 5 years' experience in creating Tableau Datasets and Tableau workbooks.
• 5 years' experience in creating SSRS reports.
• Bachelor's degree in Computer or Information Science or related field or equivalent combination of education and experience.
• Knowledge of Matillion and/or other ELT systems preferred.
• Experience with creating SQL DDL's and DML's in Redshift.
• Expert level data analysis and data management skills with highly effective problem-solving skills that can transform problems into solutions.
• Knowledge of integration methodologies and best practices.
• Expert level SQL programming experience.
• Python programming experience.
• Data Modeling skills and familiarity with BI Reporting Tools.

• Understanding of DevOps, Continuous Integration and Continuous Delivery technologies.

Experience which would set the candidate apart:

• Tableau certification is a plus (Architect or Developer track).
• Practical understanding of public cloud architecture.