Senior Associate - Data Engineer / Data Analyst

Job Overview

We are looking for a savvy Data Engineer to manage in-progress and upcoming data infrastructure projects. The candidate will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder using Python and data wrangler who enjoys optimizing data systems and building them from the ground up. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products.

Responsibilities for Data Engineer

• Create and maintain optimal data pipeline architecture, assemble large, complex data sets that meet functional / non-functional business requirements using Python and SQL / AWS / Snowflakes.• Identify, design, and implement internal process improvements through: automating manual processes using Python, optimizing data delivery, re-designing infrastructure for greater scalability, etc.• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL / AWS / Snowflakes technologies.• Build analytics tools that utilize the data pipeline to provide actionable insights intocustomer acquisition, operational efficiency and other key business performancemetrics.• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.• Keep our data separated and secure across national boundaries through multiple data centers and AWS regions.• Work with data and analytics experts to strive for greater functionality in our data systems.

Qualifications for Data Engineer

• Advanced working SQL knowledge and experience working with relationaldatabases, query authoring (SQL) as well as working familiarity with a variety ofdatabases.• Experience performing root cause analysis on internal and external data andprocesses to answer specific business questions and identify opportunities forimprovement.• Strong analytic skills related to working with unstructured datasets.• Build processes supporting data transformation, data structures, metadata, dependency and workload management.• A successful history of manipulating, processing and extracting value from largedisconnected datasets.

Desired Skillset:-

• 3+ years of experience in a Python Scripting and Data specific role, with Bachelor degree.• Experience with data processing and cleaning libraries e.g. Pandas, numpy, etc., web scraping/web crawling for automation of processes, APIs and how they work.• Debugging code if it fails and find the solution. Should have basic knowledge of SQL server job activity monitoring and of Snowflake.• Experience with relational SQL and NoSQL databases, including PostgreSQL andCassandra.• Experience with most or all the following cloud services: AWS, Azure, Snowflake,Google Strong project management and organizational skills.• Experience supporting and working with cross-functional teams in a dynamic environment

Summary:

In this role, you will be a part of the centralised global office based in India and work closely with each of our markets globally to understand the clients communication objectives, access multiple data sources and visualise it using Tableau / Datorama, support on of ETL process using MSSQL / Alteryx Flow and has sound knowledge of Excel VBA.

Key responsibilities

• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards on the key drivers of our business.
• Partner with operations/business teams to consult, develop and implement KPIs, automated reporting/process solutions and data infrastructure improvements to meet business needs
• Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format
• Manage on-time delivery of regular client reports including:

o Building reports from data warehouse

o Review of completed reports for anomalies & discrepancies

o Troubleshooting data issues/discrepancies

o Ensure formatting & delivery parameters are met.

• Updating Tableau dashboards and Excel Dashboard as required for daily/weekly client reporting. Investigate and understand the opportunities of new data sources in the context of integration into Tableau.
• Updating Tableau/Excel/ or any similar dashboards for daily/weekly client reporting.
• Support data cleansings & manipulation process including but not limited to:

o Taxonomy classification

o Conversion re-naming, grouping

o Removal of test/ghost impressions.

Desired Skills:-

• Minimum 2+ years of experience in Analytics
• Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams.
• Hands on experience in creating complex Excel reports, SQL Queries joining multiple datasets
• Data Visualization tools such as Quick Sight / Tableau / Power BI / Datorama
• An ability and interest in working in a fast-paced, ambiguous and rapidly-changing environment.
• Experience in developing requirements and formulating business metrics for reporting, familiarity with data visualization tools, e.g. Tableau, Power BI.