Shift4 (NYSE: FOUR) is boldly redefining commerce by simplifying complex payments ecosystems across the world. As the leader in commerce-enabling technology, Shift4 powers billions of transactions annually for hundreds of thousands of businesses in virtually every industry. For more information, visit www.shift4.com.
Job Summary
We are looking for passionate database engineers to join the team responsible for the data architecture that empowers our customers to run their businesses. The engineer will work closely with cross functional teams to model the data needs as well as support the development of complex database features.
Lighthouse
Lighthouse is Shift4's multi-tenant, built for cloud platform used by tens of thousands of merchants across the US. The Lighthouse platform provides centralized capabilities including:
- A vast array of features for hospitality back office management capabilities across multiple point-of-sales and hospitality products.
- Internet payments administration and management capabilities.
- Integration with multiple third party services providers.
- Centralized management of multiple product platforms.
- Be a key team member within a high velocity engineering team.
- Technology
- Work closely with the development teams to support design, modeling and usage of the databases
- Review and analyze current and future data needs, design and expand the database schemas and data models
- Review application developer code, provide inputs and guidance on improvements and performance impacts
- Create, maintain and optimize SQL driven reports and application logic
- Work with the application teams on complex reporting and analytics needs
- Translate business requirements into new logical and physical models
- Analyze existing models and design new optimized physical models
- Maintain documentation for application models
- People
- Work very closely with the product team, product owners and stakeholders to understand needs and ensure alignment.
- Interface across multiple engineering teams and engineering groups working on various parts of the platform.
- Process
- Work closely with the engineering leadership to contribute towards process improvements.
Requirements:
- Must have:
- 3+ years of experience working as a Data Modeler or data engineer or similar role
- 3+ years of SQL development experience, Postgres SQL a plus
- 5+ years in the software engineering industry
- Hands on experience with relational, dimensional and logical modeling. Experience with normalization up to 3NF
- 3+ years working with Agile teams. Experience with Scaled Agile (such as SAFe) would be very advantageous.
- Experience with cloud based OLTP and OLAP systems
- Nice to Have:
- Experience with ETL tools and reporting / BI tools (Tableau) is a plus
- Additional technical expertise which will be an advantage:
- Javascript, Python
- Multi-tenant Architecture / Modeling
- AWS Glue / Spark / Redshift / RDS
- Confluence, JIRA and Gitlab
- Familiarity with ORMs and Active Record / Data Mapper patterns
Other:
- Work location in Allentown PA, Butler PA, Silver Spring MD
- Las Vegas NV is OK but less preferable.
- Must be open to a hybrid work model with 4 days in the office.
- We will consider fully remote work for exceptionally qualified candidates.
- 10% travel (post pandemic).
Education:
- Computer Science or engineering degree or commensurate experience.
We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class.
Employment Type: FULL_TIME