ETL Developer

Your Day-to-Day

1. Derive Insights and drive major strategic projects to improve Business Metrics and take responsibility for cost efficiency and Revenue management across the country
2. Perform Market research, Post Mortem analyses on competitor expansion and Market Penetration patterns. 
3. Provide in-depth business analysis and data insights for internal stakeholders to help improve business. Derive and launch projects in order to reduce the gaps between targeted and projected business metrics
4. Responsible for optimizing Carsome’s C2B and B2C customer acquisition and Dealer retention funnel. Work closely with Marketing and Tech teams to create, produce and implement creative digital marketing campaigns and drive CRM initiatives and strategies 
5. Analyse the Revenue flows and processes large datasets to gather process insights and propose process improvement ideas for Carsome across SE-Asia
6. Lead commercial projects & process mapping, from conceptualization to completion, to build or re-engineer business models, tools and processes.
7. Having experience in analyses and insights in dealing on Unit Economics, COGs and P&L will be preferred ,but not mandatory
8. Use Business Intelligence and Data Science tools to answer the appropriate business problems using SQL, Tableau or Python.
9. Coordinate with HQ Data Insights Team and manage internal stakeholders across departments to ensure the smooth delivery of strategic projects
10. Work across different departments/functions (BI,DE, tech, pricing, finance, operations, marketing, CS,CX) and also on high impact projects and support business expansion initiatives

Your Know-Know

• At least a Bachelor's Degree in Accounting/Finance/Business or the equivalent. 
• 3-5  years of experience in strategy / consulting / analytical / project management roles; experience in e-commerce, Start-ups or Unicorns(CARS24,OLA,SWIGGY,FLIPKART,OYO) or entrepreneur experience preferred + At Least 2 years of experience leading a team
• Top-notch academics from a Tier 1 college (IIM / IIT/ NIT)
• Must have SQL/PostgreSQL/Tableau Experience. 
• Excellent Market Research, reporting and analytical skills, including carrying out weekly and monthly reporting
• Holds experience in working with Data/Business Intelligence Team
• Analytical mindset with ability to present data in a structured and informative way
• Enjoy a fast-paced environment and can align business objectives with product priorities
• Good to have : Financial modelling, Developing financial forecasts , development of Financial - strategic plan/framework

Who we are:

Stanza Living is India’s largest and fastest growing tech-enabled, managed accommodation company that delivers a hospitality-led living experience to migrant students and young working professionals across India.

We have a full-stack business model that focuses on design, development and delivery of daily living solutions tailored to the young consumers’ lifestyle. From smartly-planned

residences, host of amenities and services for hassle-free living to exclusive community engagement programmes – everything is seamlessly integrated through technology to ensure the highest consumer delight.

Today, we are:

• India’s largest managed accommodation company with over 50,000 beds under management across 24+ cities

• Most capitalized player in the managed accommodation space, backed by global marquee investors – Falcon Edge, Equity International, Sequoia Capital, Matrix Partners, Accel Partners

• Recognized as the Best Real Estate Tech company across the Globe in 2020 by leading analysis agency, Tracxn

• LinkedIn Top Startup to Work for - 2022

The opportunity: Job Responsibilities:

• Perform data analysis on large volumes of data to identify trends and/or data processing rules

• Team player of core analytics team.

• Responsible for weekly and monthly Sales/Marketing Reports on Gross and Net basis and other adhoc reports.

• Generating reports on daily basis at all stages ·

• Analyze the data to come out with insights on what leads to better conversions, student preferences, role on various

investments and channels, optimizing the spend etc.

• Prepare reports and dashboard for various business functions to keep track of important business metrics.

• Elicit and document requirements at various levels including Business, Logical and Physical/Technical

Skill Sets

• Good hands-on Advanced Excel & SQL.

• Has extensively worked on live Dashboards, reporting, data manipulation and making flat tables in SQL

• Knowledge in Python/R

• Strong analytical skills and ability to interpret data

• Natural curiosity and self-drive to understand the broader business in order to provide the appropriate reporting support

• Extremely high ownership, self-starter and work in a constantly-changing and fast-growing environment

• Establish collaborative and trusting relationships with the business’s key internal leaders and stakeholders in order to ensure that there is a free flow of ideas and information across the business

• First principle thinking and strong problem solving

What Can You Expect:

• A phenomenal work environment, with extremely high ownership and growth opportunities

• Opportunity to shape a potential unicorn

• Quick iterations and deployments - fail-fast attitude

• Opportunity to work on cutting-edge technologies

• Access to a world-class mentorship network

Kindly note that candidates who have graduated in 2022 and 2023 only will be considered for the role who are based in Mumbai, immediate joiners

JD - Data Operations Analyst

What is the job and team like

• As a Data Operations Analyst we manage business reporting of numerous teams, constantly monitor performance
• Checking the integrity of the revenue reporting done by the different systems for the correct profitability to be
• reported to the CXOs
• Send reports periodically and alert stakeholders for changes in the key performance metrics
• Allocate efforts to different Business Implementations that help build Profit/Loss statement for the Financials.
• Track crucial data points which affect the core of the business and escalate it to senior stakeholders

Roles and Responsibilities

• Graduate in IT Background(BE/BSc IT/ BCA) 2022 and 2023 graduates only
• Executing a set of business processes daily/weekly/monthly as per Business requirement.
• Provide ad-hoc data support on any urgent reports and material in an expedited manner
• Maintain a list of open tasks and escalations, and send updates to the relevant stakeholders
• Have an eye for detail, should have the ability to look at numbers, spot trends and identify gaps
• Identify efficient and meaningful ways to communicate data and analysis through ongoing reports and dashboards
• Proficiency in SQL, Excel and any statistical and analytical tools such as SAS, SPSS is a big plus
• Managing master data, including creation, updates, and deletion.
• Ability to work in a fast paced, technical, cross functional environment
• Familiarity with Internet Industry and Online Advertising Business is a plus

Ideal candidate

• Import and export large volume of data to database tables as required
• Should be able to write Data Definition Language or Data Manipulation Language SQL commands
• Develop programs, methodologies to get analyzable data on a regular basis
• Good team player and multi-tasker
• Should have the ability to learn and adapt to change
• Self-starter Must be productive with minimal direction
• High-level written and verbal communication sk

Job Details

Work mode- In office

Must have skills - SQL, MS Excel, Communications

About the role:

 Hopscotch is looking for a passionate Data Engineer to join our team. You will work closely with other teams like data analytics, marketing, data science and individual product teams to specify, validate, prototype, scale, and deploy data pipelines features and data architecture.

Here’s what will be expected out of you:

➢ Ability to work in a fast-paced startup mindset. Should be able to manage all aspects of data extraction transfer and load activities.

➢ Develop data pipelines that make data available across platforms.

➢ Should be comfortable in executing ETL (Extract, Transform and Load) processes which include data ingestion, data cleaning and curation into a data warehouse, database, or data platform.

➢ Work on various aspects of the AI/ML ecosystem – data modeling, data and ML pipelines.

➢ Work closely with Devops and senior Architect to come up with scalable system and model architectures for enabling real-time and batch services.

What we want:

➢ 5+ years of experience as a data engineer or data scientist with a focus on data engineering and ETL jobs.

➢ Well versed with the concept of Data warehousing, Data Modelling and/or Data Analysis.

➢ Experience using & building pipelines and performing ETL with industry-standard best practices on Redshift (more than 2+ years).

➢ Ability to troubleshoot and solve performance issues with data ingestion, data processing & query execution on Redshift.

➢ Good understanding of orchestration tools like Airflow.

 ➢ Strong Python and SQL coding skills.

➢ Strong Experience in distributed systems like spark.

➢ Experience with AWS Data and ML Technologies (AWS Glue,MWAA, Data Pipeline,EMR,Athena, Redshift,Lambda etc).

➢ Solid hands on with various data extraction techniques like CDC or Time/batch based and the related tools (Debezium, AWS DMS, Kafka Connect, etc) for near real time and batch data extraction.

Note :

Product based companies, Ecommerce companies is added advantage

We are #hiring for AWS Data Engineer expert to join our team

Job Title: AWS Data Engineer

Experience: 5 Yrs to 10Yrs

Location: Remote

Notice: Immediate or Max 20 Days

Role: Permanent Role

Skillset: AWS, ETL, SQL, Python, Pyspark, Postgres DB, Dremio.

Job Description:

 Able to develop ETL jobs.

Able to help with data curation/cleanup, data transformation, and building ETL pipelines.

Strong Postgres DB exp and knowledge of Dremio data visualization/semantic layer between DB and the application is a plus.

Sql, Python, and Pyspark is a must.

Communication should be good

• Graduate+ in Mathematics, Statistics, Computer Science, Economics, Business, Engineering or equivalent work experience.
• Total experience of 5+ years with at least 2 years in managing data quality for high scale data platforms.
• Good knowledge of SQL querying.
• Strong skill in analysing data and uncovering patterns using SQL or Python.
• Excellent understanding of data warehouse/big data concepts such data extraction, data transformation, data loading (ETL process).
• Strong background in automation and building automated testing frameworks for data ingestion and transformation jobs.
• Experience in big data technologies a big plus.
• Experience in machine learning, especially in data quality applications a big plus.
• Experience in building data quality automation frameworks a big plus.
• Strong experience working with an Agile development team with rapid iterations. 
• Very strong verbal and written communication, and presentation skills.
• Ability to quickly understand business rules.
• Ability to work well with others in a geographically distributed team.
• Keen observation skills to analyse data, highly detail oriented.
• Excellent judgment, critical-thinking, and decision-making skills; can balance attention to detail with swift execution.
• Able to identify stakeholders, build relationships, and influence others to get work done.
• Self-directed and self-motivated individual who takes complete ownership of the product and its outcome.

Required Experience

· 3+ years of relevant technical experience as a data analyst role

· Intermediate / expert skills with SQL and basic statistics

· Experience in Advance SQL

· Python programming- Added advantage

· Strong problem solving and structuring skills

· Automation in connecting various sources to the data and representing it through various dashboards

· Excellent with Numbers and communicate data points through various reports/templates

· Ability to communicate effectively internally and outside Data Analytics team

· Proactively take up work responsibilities and take adhocs as and when needed

· Ability and desire to take ownership of and initiative for analysis; from requirements clarification to deliverable

· Strong technical communication skills; both written and verbal

· Ability to understand and articulate the "big picture" and simplify complex ideas

· Ability to identify and learn applicable new techniques independently as needed

· Must have worked with various Databases (Relational and Non-Relational) and ETL processes

· Must have experience in handling large volume and data and adhere to optimization and performance standards

· Should have the ability to analyse and provide relationship views of the data from different angles

· Must have excellent Communication skills (written and oral).

· Knowing Data Science is an added advantage

Required Skills

MYSQL, Advanced Excel, Tableau, Reporting and dashboards, MS office, VBA, Analytical skills

Preferred Experience

· Strong understanding of relational database MY SQL etc.

· Prior experience working remotely full-time

· Prior Experience working in Advance SQL

· Experience with one or more BI tools, such as Superset, Tableau etc.

· High level of logical and mathematical ability in Problem Solving

Responsibilities

• Design and implement Azure BI infrastructure, ensure overall quality of delivered solution 
• Develop analytical & reporting tools, promote and drive adoption of developed BI solutions 
• Actively participate in BI community 
• Establish and enforce technical standards and documentation 
• Participate in daily scrums  
• Record progress daily in assigned Devops items 

Ideal Candidates should have

• 5 + years of experience in a similar senior business intelligence development position 
• To be successful in the role you will require a high level of expertise across all facets of the Microsoft BI stack and prior experience in designing and developing well-performing data warehouse solutions 
• Demonstrated experience using development tools such as Azure SQL database, Azure Data Factory, Azure Data Lake, Azure Synapse, and Azure DevOps. 
• Experience with development methodologies including Agile, DevOps, and CICD patterns 
• Strong oral and written communication skills in English 
• Ability and willingness to learn quickly and continuously 
• Bachelor's Degree in computer science 

• Experience implementing large-scale ETL processes using Informatica PowerCenter.
• Design high-level ETL process and data flow from the source system to target databases.
• Strong experience with Oracle databases and strong SQL.
• Develop & unit test Informatica ETL processes for optimal performance utilizing best practices.
• Performance tune Informatica ETL mappings and report queries.
• Develop database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Hands-on Experience in Unix.
• Experience in Informatica Cloud (IICS).
• Work with appropriate leads and review high-level ETL design, source to target data mapping document, and be the point of contact for any ETL-related questions.
• Good understanding of project life cycle, especially tasks within the ETL phase.
• Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment.
• Excellent communication and presentation skills.
• Effectively worked on the Onsite and Offshore work model.