Walnut Creek / Engineering
Developing innovative technologies to revolutionize the payments industry while helping customers transact in global marketplaces is not for the faint of heart. We have big goals and are looking for people to join our team who want to leave a legacy. Just as you are committing to do your best work, we are committed to making this the best place you’ve ever worked. It’s a partnership from the very beginning. If you are looking to step outside your comfort zone, learn new things, apply your skills, collaborate with brilliant people and have fun along the way, then you might be our next Yapster! We promise to provide you with an amazing journey along your career. At Yapstone, we don’t just accept difference — we celebrate it, we support it, and we thrive on it for the benefit of our employees. Yapstone is proud to be an equal opportunity workplace.
Yapstone is looking for a Data Engineer to be part of the Data Services Team. The Data Services team works very closely with all aspects of data, both internal and external. We are looking for a Data Engineer with the Software Engineering skills to build data pipelines for efficient and reliable data movement across systems, and also to build the next generation of data tools in public cloud to enable us to take full advantage of this data. In this role, your work will broadly influence the company's data consumers, executives and analysts.
Design, build and launch extremely efficient & reliable data pipelines to move data to our Data Warehouse/Data Mart.
Own end-to-end data quality for the data pipelines you build
Develop ETL routines to populate databases from multiple disparate data sources and create aggregates
Create and run data migrations across different servers and different databases including Enterprise CRM and ERP applications.
Perform complex data transformations, create/update stored procedures/functions, and optimize existing stored procedures/functions using indexing, temp tables, views, logic changes, etc.
Design/develop new systems and tools to enable stakeholders to consume and understand data faster
Data cleansing and manipulation using your expert SQL & programming skills
Troubleshoot data issues and present solutions to the issues
Prepare activity and progress reports regarding database & data health and status
Design and improve agile development processes as it applies to data and data structure design
Design, code and automate data quality checks, metrics, standards and guidelines
Work across multiple teams in high visibility roles and own the solution end-to-end
BS or MS in Computer Science, Information Management, or related field
5+ years of experience as a Data Engineer.
Candidate must have a deep understanding of logical and physical data modeling for OLTP and OLAP systems.
Ability to translate a logical data model into a relational or non-relational solution as appropriate
Familiar with multiple relational platforms, recent MSSQL Server experience is required.
Hands-on expertise in database development using views, T-SQL, MSSQL and/or SQL scripts and SSIS packages and transformations. Experience building and troubleshooting SSAS cubes.
Fluent in using tools like SQL Server Management Studio or similar.
Recent experience in SQL tuning, indexing, partitioning, data access patterns and scaling strategies
Programming/Scripting experience in Windows (C#, PowerShell) as well as Unix/Linux environments (Python, Bash)
Experience in NoSQL/Big Data technologies (Couchbase or MongoDB)
Excellent analytical problem solving and decision-making skills
Experience working with large complex sets of data in a high-availability environment
Experience with agile methodology process and development practices
Plus to have:
Payment or e-commerce industry experience
Experience working with Informatica Intelligent Cloud Services (IICS)
Experience in Business Intelligence tools and technologies
Experience with Snowflake – Snowpipe, SnowSQL, Snowflake Procedures
Experience in building out BI solutions in Looker
- We offer comprehensive health, dental, and vision wellness plans for you and your family with low employee premiums.
- You work hard every day to build the future of our company, so we’ll help you build your future with a 401(k) plan that features employer match.
- We encourage and support our teams to take time off to recharge and reboot because changing how the world pays is no easy task.
- We care about the community where we work. Through YapCares, you get 8 hours of paid volunteer time off each year to make a difference.
- Enjoy food, fun and camaraderie with breakfasts, dinners, snacks, social hours and events.
- A great location in the East Bay that is a reverse commute for many Yapsters, and we’re right across the street from BART.