Senior Data Engineer

Description

Job Summary: We are looking for a professional to develop and maintain data pipelines, build dimensional models, and assist in data governance, aiming to simplify people's financial lives and drive business growth. Key Highlights: 1. A career that yields higher returns at PagBank 2. A team that plays together and values diversity 3. A disruptive and innovative spirit When you think about your career, what comes to mind? Purpose? Collaboration? Being the protagonist who makes a difference? At PagBank, we offer all this—and much more. We’re seeking people who proudly wear the jersey—individuals eager to simplify people's financial lives and drive business growth! Interested in a career that yields higher returns? **Check out this opportunity and \#JoinPagBank!** **Responsibilities and Duties** * Develop and maintain *pipelines* to transform raw data into valuable business insights. * Actively participate in building dimensional models to deliver accessible, consistent, and high-performance data for complex queries. * Develop data integration processes into and out of the analytical environment using Apache Kafka. * Assist in data governance by actively contributing to the development of data monitors and documentation of tables. * Critically analyze business requirements to design dimensional models reflecting metrics truly important to the company. **Requirements and Qualifications** * Bachelor’s degree (completed or in progress) in Information Technology or related fields. * Advanced SQL knowledge (Procedures and Functions; Window Functions). * Knowledge of relational and NoSQL databases (Redshift, Oracle, PostgreSQL, DynamoDB, MongoDB). * Knowledge of data distribution. * Experience with Relational Modeling and Dimensional Modeling (facts, dimensions, SCD). * Experience with ETL orchestration using Airflow. * Knowledge of code versioning with Git and GitHub. * Familiarity with Apache Kafka. * Knowledge of OGG and CDC (Change Data Capture). * Knowledge of AWS architecture (Redshift, S3, Lambda, IAM). * Familiarity with Data Observability. **Additional Information** **To stand out in this role, it would be great if you also had:** * Experience with AWS architecture. * Experience with Python or Java for ETL. * Experience with Power BI or Looker. You might know us from our card machines or memorable commercials—but we’re so much more! Every day, we develop products and solutions inspired by our purpose: simplifying people’s and businesses’ financial lives. We work to transform how people manage money—opening new possibilities to help them achieve their dreams. **How do we do it?** **With People** We’re a team that plays together! Here, we value all forms of diversity—race/ethnicity, gender, age, origin, persons with disabilities, sexual orientation, family composition, and aesthetics. **With Technology** Our disruptive and innovative spirit is in our DNA: we’re part of Grupo UOL, a 100% Brazilian company, an internet pioneer since 1996, transforming people’s lives for over 25 years. **With One Culture** We have a strong, unique culture that drives us beyond limits—enabling continued growth and long-term business sustainability. **We are one of the largest digital banks in the country and one of the most profitable fintechs in the segment.** **To experience all this, you’ll enjoy a comprehensive benefits package that truly makes a difference:** * Meal allowance and/or food voucher. * Health and dental insurance. * Life insurance. * Partnerships with TotalPass and ZenKlub. * Extended maternity and paternity leave. * Childcare assistance. * Up to 50% discount on postgraduate programs and MBAs from top institutions such as FIA, FAAP, and PUCRS. **And more:** * No dress code: wear whatever makes you feel comfortable. * \#HappyBirthday: Birthday day off. * Baby Gift: gift for newborns. **Interested in a career that yields higher returns?** Join our unbeatable team! **\#JoinPagBank.**