Description

Onbe, a fast-growing FinTech, bringing innovation to a rapidly growing global marketplace, stands for “on behalf.” Because that’s exactly how we work: on behalf of our clients, as their comprehensive payments partner. We transform the way payments are imagined — as an opportunity for innovation, a source of insight to customers, and a way to connect with partners around the globe! Summary: Associate Data Engineer Intern will be part of the Data Engineering/Technology organization building ETL pipelines for reporting and other analytics needs. The position requires strong SQL skills, knowledge of data warehouse concepts, exposure to data engineering tools and technologies, willingness to learn and burning desire to grow. This role is a hybrid role that will work onsite 1-2 days per week at our Buffalo Grove, IL location. Occasional travel may be required as part of this position. #LI-

Role and Responsibilities

• Responsibilities: Collaborate with business stakeholders and Senior Data Engineers to understand data requirements and translate into technical solutions. Perform data studies and data discovery around new or existing data sources. Review existing stored procedures for troubleshooting or optimization. Develop and maintain data pipelines from SQL Server and other data sources, Transform and load to Snowflake DB. Implement ETL process using Prophecy DBT tool to create facts and dimension tables. Collaborate with cross-functional teams including reporting for scalable and reliable solutions. Document source to target mappings, data pipelines, and transformations as part of knowledge sharing. Participate in daily status calls, design sessions, and code reviews. Qualifications: Bachelor’s degree in computer science, Information Systems, or a related field. I have working knowledge of building data transformation and processing solutions using SQL, Python, or similar programming languages. Knowledge of ETL tools such as Azure Data Factory, Notebook, SQL, Python, and SSIS. Ability to troubleshoot and resolve complex data-related issues. Excellent communication and interpersonal skills, willingness to collaborate, and the desire to learn.