Staff Data Engineer

 Role Summary 

The Staff Data Engineer works together with the team and is responsible for the creation and maintenance of ETL processes into and out of the data warehouse, and data management and modeling. 

This role also requires the ability to think logically and critically to solve complex problems or build business rules using data.  

Knowledge of programming concepts i.e. OOP, design patterns, data structures, and SQL is essential for the role. This role will require the candidate to mainly work with Python as a programming language, would be good to have an interest in cloud computing (AWS in particular) and data warehousing concepts. A substantial portion of the role includes interacting with APIs to fetch data using Python and developing a scalable and stable solution to achieve that. 

Responsibilities 

• Manage, lead, mentor, remove impediments, coach & grow our engineering team.  

• Work alongside data engineers in developing data extractors to fetch data from various sources (Python, Apache Airflow), data sources may include SFTP, API, and other data-acquiring technologies depending on the various systems interacted with. 

• Data cleansing - troubleshooting, fixing errors, and identifying discrepancies in data when onboarding new sources. 

• Design and implement extendable software component to automate onboarding new data source at scales. 

• Implement and maintain ELT stack to bring in data from multiple data sources into Snowflake. 

• Provide input to project planning, status, and review meetings. 

• Manage expectations from business owners to define and prioritize requirements, and architecting software & hardware solutions to their most critical needs incrementally. 

• Perform other duties as assigned. 

Requirements

• 8+ years’ experience in developing web applications. 

• 2+ years of experience in leading a team size of 4 technical professionals. 

• Solid experience in Object Oriented Design Concept 

• Experience interacting with third-party interfaces, for example, APIs. Familiarity with writing your own APIs and optimal data fetching logic. 

• Solid development, logical thinking, troubleshooting, bug tracking, and quality assurance methodologies 

• Able to stay ahead of the curve with new and emerging technologies. 

• Python skills or a proven record of adapting to new technologies and languages. 

• Understanding of data warehouses and ETL principals and having command over SQL 

• Knowledge of or interest in cloud data warehousing 

• Proactive and eager to learn new things. 

• Ability to work within a collaborative team environment is essential. 

Personal Attributes 

• Excellent command of English– both verbal & written 

• The ability to consistently deliver solid, successful solutions in short development cycles. 

• A strong spirit of innovation, self-starter, independence, and with the ability to come up with solutions to meet business problems. 

• Strong desire to learn new things and pass knowledge acquired onto others. 

• Have a results-driven personality, high enthusiasm, and can work well with others. 

• Able to manage own hours and work in a remote team environment. 

About Kinesso 

Kinesso, the Marketing Engine of IPG (a Fortune 500 company), is focused on creating data-driven solutions through enhanced or newly created products and services, maximizing the impact of traditional and addressable media. Kinesso’ core principle is to drive smarter business decisions and better outcomes for clients using our suite of data and technology services. Powered by Acxiom, IPG’s foundational data and technology layer, the company will provide comprehensive data-driven marketing capabilities to clients, as well as act as a trusted data management partner to brands. Designed for flexibility and speed, Kinesso’s offerings are structured to improve media and marketing performance with an emphasis on accuracy, agility, and effectiveness. Our open architecture approach is powered with the right combination of creativity and data, activated with flexibility and measured with precision.