Data Engineer - Transformation Processes

Launchpad, a people-first technology company, is a leader in North America´s rapidly growing tech sector. Through two solutions, Launchpad supports its clients with digital transformation: • PaasportTM, our iPaaS solution, streamlines software integration and automates workflows. • Nearshore Staff Augmentation, our managed IT staffing service, connects top IT talent across various geographical regions, bringing industry expertise to leading clients. Based in Vancouver, Canada, our operational footprint spans across North and South America, with a second headquarters in Santiago, Chile. In 2023, our unwavering dedication to innovation garnered recognition as a Deloitte Technology Fast 50™ Program Company. Our clientele boasts industry leaders such as Walmart, GM, TIME Magazine, Salesforce, Tableau, Splunk, Bolt.com, Freedom House, and more. At Launchpad, we genuinely care about our people as individuals. If you are looking for a team that values growth, drive, and passion for your... craft, if you’re seeking a place to achieve your goals and dreams with fairness and integrity, then we’d love to hear from you. Overview As part of our data migration project, we are seeking a talented Data Engineer to focus on the transformation layer of our data pipeline. Job Summary We are looking for a Data Engineer with exceptional SQL skills and experience with DBT (Data Build Tool) to handle the transformation processes within our data pipeline. The ideal candidate will play a critical role in ensuring data is accurately and efficiently transformed for visualization and analysis. Please note that this is a 6 to 8 months project, and it requires availability from Monday to Friday, 7.30 am to 3.30 pm PST. Key Responsibilities • Develop and maintain robust data transformation processes using SQL and DBT. • Collaborate with the extract and load team to ensure data is properly ingested and prepared for transformation. • Design and implement data models and transformations that support business requirements and enable data visualization. • Optimize SQL queries and dbt models for performance and scalability. • Ensure data integrity and consistency throughout the transformation process. • Document data transformation processes and maintain comprehensive documentation for data workflows. Qualifications • Bachelor's degree in Computer Science, Information Technology, or a related field. • 3+ years of experience as a Data Engineer, with a focus on data transformation. • Strong SQL skills, with a proven track record of writing efficient and complex queries. • At least 2 years of experience with DBT (Data Build Tool). • Familiarity with ELT (Extract, Load, Transform) processes and principles. • Excellent problem-solving skills and attention to detail. • Strong communication and collaboration skills. • Ability to work independently and as part of a team. Why work for Launchpad? • 100% remote • People first culture • Excellent compensation in US Dollars • Hardware setup for working from home • Work with global teams and prominent brands based in North America, Europe, and Asia • Training allowances • Personal time off (PTO) for vacations, study leave, personal time, etc. • ...and more! At Launchpad, we genuinely care about our people as individuals. If you are looking for a team that values growth, drive, and passion for your craft, if you’re seeking a place to achieve your goals and dreams with fairness and integrity, then you are the future of Launchpad. Launchpad is committed to fostering a diverse and representative workforce and an inclusive work environment where all employees are respected and treated equally. Are you ready to elevate your career at Launchpad? We want to hear your story! Contact us todayShow full descriptionCollapse