(Mid/ Senior) Data Engineer

<p><strong>About the Tech Team<br/></strong></p><p>Technology powers everything we do at Dialectica – from communicating with clients and finding the most relevant expert profiles in just a few minutes to indexing and categorizing thousands of pieces of information every day. To do so, we are building our own proprietary web application that automates and optimizes the delivery of our market leading services.</p><p>Technologies we use:</p><p></p><p><strong>About the role</strong><br/></p> <p>We are looking for a Data Engineer to expand and optimize our data and data pipeline architecture, as well as optimize data flow and collection for cross functional teams.</p> <p>The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. You will support our software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing products. </p> <p>As a <strong>Data </strong><strong>Engineer </strong>in Dialectica you will:<br/></p> <ul> <li>Create and maintain optimal data pipeline architecture</li> <li>Assemble large, complex data sets that meet functional / non-functional business requirements</li> <li>Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.</li> <li>Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies</li> <li>Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics</li> <li>Work with stakeholders including the Product, Engineering and Design teams to assist with data-related technical issues and support their data infrastructure needs</li> <li>Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.</li> <li>Work with data and analytics experts to strive for greater functionality in our data systems.</li> </ul><p><strong>Requirements</strong></p><p>We have seen that people who successfully fit in this position have:</p><ul> <li>4+ years of experience in a Data Engineer role</li> <li>Strong Knowledge of Data Management, Data Warehousing concepts (Dimensional Modeling, Data Marts) and Database Technologies.</li> <li>Strong understanding of modern approaches to data engineering and the best approach to solve data problems.</li> <li>Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases</li> <li>ETL/ELT processes (Knowledge of DBT is a plus)</li> <li>Working experience in Python.</li> <li>Hands-on experience in Production Data Lake architecture in cloud and Big Data implementations in general (designing, constructing, cataloging and optimizing data lake)</li> <li>Experience with Cloud Technologies and Serverless Computing (we use AWS).</li> </ul><p>Based on values we are looking for someone with the following traits:<br/></p><ul> <li>Aiming to deliver unprecedented value</li> <li>Strong sense of caring for their teams, to provide guidance and support</li> <li>Act as culture and brand ambassadors for Dialectica</li> <li>Seeking support and guidance to achieve mastery and great quality results</li> <li>Having ownership of their responsibilities and not being afraid of getting things done</li> <li>Turning problems into opportunities</li> <li>Being open and honest with their team and themselves</li> <li>Constantly improving through self-learning and knowledge sharing</li> </ul><p>Fluency in English is a must</p><p><strong>Benefits</strong></p><ul> <li>Competitive base salary with additional performance incentives</li> <li>Coverage under the company’s collective health insurance plan</li> <li>Learning and development opportunities (e.g. onboarding, Mini-MBA, on-the-job training, Udemy courses and many others!)</li> <li>Hybrid work model &amp; extra personal/flex days and paid volunteer days a year for your favorite cause</li> <li>Company sponsored team-bonding events</li> <li>Weekly health &amp; wellness activities (e.g. basketball, football, yoga, running), gym discounts, healthy breakfast, snacks and beverages</li> <li>Entrepreneurial culture and amazing coworkers!</li> </ul> <p><strong>About Dialectica</strong></p><p>Dialectica is an information services company that shapes better decision-making worldwide. We partner with the world’s leading investment and consulting companies, enabling them to collect real-time information and market insights from industry experts across markets, industries,