Senior Data Analyst
Senior Data Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
About The Company:
What makes iLinks offerings unique is the fact that we use precreated frameworks designed to accelerate software development and implementation of business processes for our clients. iLink has over 60 frameworks (solution accelerators) both industryspecific and horizontal that can be easily customized and enhanced to meet your current business challenges.
Requirements
We are seeking a skilled Ecommerce Analyst to design develop and maintain robust data pipelines and analytical reports for our ecommerce platform. The ideal candidate will leverage data from multiple sources including GA4 Google Ads Meta Ads Tiktok and others to deliver actionable insights and drive business growth with a strong emphasis on using Power BI for reporting and Snowflake.
Bachelor s degree in computer science Data Science Statistics or a related field.
3 years of experience in data engineering data analysis or a similar role preferably in ecommerce.
Technical Skills:
Proficient in SQL and Python (or R) for data extraction transformation and analysis.
Strong experience with Snowflake DBT data modelling Dagster and ETL/ELT processes.
Advanced proficiency in Power BI for creating interactive dashboards and reports.
Familiarity with GA4 Google Ads Meta Ads Meta S2S and Braze Marketing APIs.
Handson experience with BI tools (Power BI Looker...) for reporting and visualization.
Experience with cloud platforms and data integration tools; familiarity with Google BigQuery or AWS is a plus.
Experience with ecommerce analytics including funnel analysis cohort analysis and attribution modelling.
Soft Skills:
Strong analytical and problemsolving skills with a keen attention to detail.
Excellent communication skills to translate technical insights into business recommendations.
Ability to work independently and collaboratively in a fastpaced environment.
Roles and responsibilities:
Data Pipeline Development:
Build optimize and maintain scalable ETL/ELT pipelines using Snowflake to integrate data from diverse sources (GA4 Google Ads Meta Ads Meta S2S Braze etc.) into a centralized data warehouse.
Ensure data quality consistency and reliability across all data sources.
Data Analysis & Reporting:
Develop and automate interactive dashboards and reports using Power BI to monitor ecommerce KPIs (e.g. conversion rates ROAS customer acquisition costs).
Conduct indepth analyses to uncover trends customer behaviour and campaign performance.
Provide actionable recommendations to optimize marketing strategies and improve ROI.
Data Integration & Transformation:
Work with APIs and servertoserver (S2S) integrations to collect and process data from platforms like Meta Google and Braze.
Transform raw data into structured formats for analysis using SQL Python or similar tools leveraging Snowflake for efficient data processing.
Benefits
- Competitive salaries
- Medical Insurance
- Employee Referral Bonuses
- Performance Based Bonuses
- Flexible Work Options & Fun Culture
- Robust Learning & Development Programs
- InHouse Technology Training
Minimum 5+ years of hands-on experience with Snowflake and a total of 9+ years of industry experience. Strong understanding of database concepts and data warehouse architectures. Expertise in SQL querying, ensuring efficient data manipulation and retrieval. Skilled in designing and implementing Snowflake cloud data warehouse architectures and data modeling. Experience in migration projects, transitioning on-premise systems to Snowflake. Comprehensive knowledge of Snowflake features, including Snowpipe, Stages, SnowSQL, Streams, and Tasks. Proficiency in advanced Snowflake concepts, such as resource monitoring, RBAC controls, virtual warehouse sizing, and Zero Copy Clone. In-depth understanding of data migration from RDBMS to Snowflake cloud environments. Ability to deploy Snowflake capabilities, such as data sharing, event-driven architectures, and lakehouse patterns. Well-versed in incremental extraction loads, handling both batch processing and real-time streaming.
Employment Type
Full Time
