Join the next generation of thinkers helping restaurants to grow.

For over 30 years, Rewards Network has helped restaurants increase their revenue, traffic, and customer engagement through our innovative financial and marketing services and premier dining rewards programs.

When you join our team, you have an opportunity to make a direct impact on the success of our restaurant clients through our culture of close collaboration, data-driven ideas, agile thinking, and iterative experimentation. Whether on the ground developing relationships or behind the scenes making improvements, your work will be visible and integral to the future of the industry we support.

As part of the Data team, the Data Integration Engineer is the glue that will bring RN’s data, analytics and systems together to accomplish major initiatives such as integrating with a real-time data platform, integrating with the data science platform and implementing large-scale data initiatives. You will act as a deep technology expert in the Informatica on-premise and Informatica Cloud platforms and collaborate with the larger data team (dba, ETL developers, data science/analytics) to architect, design and implement scalable and flexible data integration solutions. There are three primary areas of focus for this role: 1) Architecture, design and development of Informatica/ETL based processes, 2) operational support of ETL processes and platform, 3) administration and maintenance of the Informatica/ETL cloud platform.

We don’t rest on our successes. We build on them. You should too.

What you’ll do with us:

• Architect, design, develop, and maintain data integration solutions using the Informatica PowerCenter and Informatica cloud platforms
• Apply industry and tool specific design practices to Informatica design, such as using reusable or shared objects, restart-ability, caching and other design and architecture standards
• Communicate integration solution progress and updates with business users and stakeholders
• Collaborate with the data team to monitor and tune Informatica processes and mappings for performance
• Collaborate with business analysts, data analysts, data scientists and development team members to understand the technical and data design requirements and develop the optimal integration solution

ETL Development using Informatica software:

• Primary resource in designing and developing the necessary code for complex applications including databases, business applications, web interfaces to multiple data repositories, data transfer between heterogeneous systems and other software systems for all internal and external business processes delivering a solid robust application, utilizing coding standards and source code development
• Design, develop, code and test ETL code.
• Develop integrated data sets to internal and external systems from an integrated data source
• Document technical and architectural designs for integration processes
• Design and define test cases based on user stories and acceptance criteria
• Conduct analysis of data sources and targets and appropriate data models
• Maintain detailed and accurate documentation per code standards
• Coordinate the migration of all code to the various environments (QA, Production)

Operational support, platform administration and maintenance responsibilities:

• Provide 1st Level Support[AM1] for the Informatica platform and operational support requests (on-call rotation)
• Proactively identify and implement technical and operational improvements to the Informatica platform and processes
• Coordinate Informatica support processes with infrastructure maintenance processes to minimize impacts to ETL jobs
• Provide development, administration and support for the Informatica Cloud-based services, including data synchronization, replication and task scheduling
• Administer Informatica software upgrades and patches
• Monitor and manage the Informatica platform (monitor operations, jobs and processes)
• Proactively identify and implement improvements to the overall Informatica platform and processes

Your Background:

• Bachelor’s or advanced degree in Information Technology, Math, or science discipline or equivalent work experience
• 3-4 years previous data integration experience using the Informatica toolset
• 3+ years Informatica PowerCenter (v9+) experience architecting, designing and developing integration solutions
• 2+ years Informatica Cloud Data integration experience
• 3+ years programming in a SQL based database environment (e.g. SQL Server, Amazon Redshift)
• Expertise with Microsoft SQL Server/Amazon Redshift or similar RDBMS (Advanced SQL writing ability) is required
• Expertise designing scalable data architectures for high-volume analytics and warehousing solutions is required
• Experience with data warehousing, data profiling, data quality validation and testing is required
• Expertise with data modeling methodologies (STAR,SnowFlake, Data lakes) is a plus
• Experience with data science tools such as Python is a plus
• Exposure to BI/analytics tools, such as DOMO is a plus
• Exposure to Salesforce CRM or other cloud based ERP/CRM tools is a plus
• Knowledge of restaurant industry, marketing or loyalty programs is a plus

We connect diners to fantastic restaurant experiences by offering unique card-linked offers thanks to our ability to leverage advanced technology and powerful data analytics, while simultaneously providing value to our strategic partners' overall loyalty programs.

We work alongside our restaurant partners every day, sharing in the ebbs and flows of their business while helping them achieve their dreams. We provide marketing and financing that work with their business and are truly pay-for-performance. We help them increase revenue, traffic, and customer engagement. Importantly, our services do not require the merchant to discount or give away their products.

Even more, we enhance our partners' loyalty programs by offering a turn-key, scalable dining rewards program that is right for their business model and leverages their unique brand to help increase the value proposition for their customers.

Finally, we connect our millions of members to our participating restaurants, allowing them to earn the rewards they desire when dining out.

Rewards Network is an Equal Opportunity Employer (EOE). We encourage and strongly support workplace diversity.