Senior Executive - Analytics (Business Intelligence)

The Client is the world’s largest media investment company. Our team of experts support clients in programmatic, social, paid search, analytics, technology, organic search, affiliate marketing, e-commerce and across traditional channel We are currently looking for a Manager Analyst – Analytics to join us. In this role, you will work on

various projects for the in-house team across data management, reporting, and analytics.

Responsibility:

•       Serve as a Subject Matter Expert on data usage – extraction, manipulation, and inputs for analytics

•       Develop data extraction and manipulation code based on business rules

•       Design and construct data store and procedures for their maintenance  Develop and maintain strong relationships with stakeholders  Write high-quality code as per prescribed standards.

•       Participate in internal projects as required

Requirements:

•       2-5 years for strong experience in working with SQL, Python, ETL development.

•       Strong Experience in writing complex SQLs

•       Good Communication skills

•       Good experience of working with any BI tool like Tableau, Power BI.

•       Familiar with various cloud technologies and their offerings within the data specialization and Data Warehousing.

•       Snowflake, AWS are good to have.

Minimum qualifications:

•       B. Tech./MCA or equivalent preferred

Excellent 2 years Hand on experience on Big data, ETL Development, Data Processing.  

1. Bridging the gap between IT and the business using data analytics to assess processes, determine requirements and deliver data-driven recommendations and reports to executives and stakeholders.

2. Ability to search, extract, transform and load data from various databases, cleanse and refine data until it is fit-for-purpose

3. Work within various time constraints to meet critical business needs, while measuring and identifying activities performed and ensuring service requirements are met

4. Prioritization of issues to meet deadlines while ensuring high-quality delivery

5. Ability to pull data and to perform ad hoc reporting and analysis as needed

6. Ability to adapt quickly to new and changing technical environments as well as strong analytical and problem-solving abilities

7. Strong interpersonal and presentation skills

SKILLS:

1. Advanced skills in designing reporting interfaces and interactive dashboards in Google Sheets and Excel

2. Experience working with senior decision-makers

3. Strong advanced SQL/MySQL and Python skills with the ability to fetch data from the Data Warehouse as per the stakeholder's requirement

4. Good Knowledge and experience in Excel VBA and advanced excel

5. Good Experience in building Tableau analytical Dashboards as per the stake holder's reporting requirements

6. Strong communication/interpersonal skills

PERSONA:

1. Experience in working on adhoc requirements

2. Ability to toggle around with shifting priorities

3. Experience in working for Fintech or E-commerce industry is preferable

4. Engineering 2+ years of experience as a Business Analyst for the finance processes

Job Description

Responsibilities:

- Collaborate with stakeholders to understand business objectives and requirements for AI/ML projects.

- Conduct research and stay up-to-date with the latest AI/ML algorithms, techniques, and frameworks.

- Design and develop machine learning models, algorithms, and data pipelines.

- Collect, preprocess, and clean large datasets to ensure data quality and reliability.

- Train, evaluate, and optimize machine learning models using appropriate evaluation metrics.

- Implement and deploy AI/ML models into production environments.

- Monitor model performance and propose enhancements or updates as needed.

- Collaborate with software engineers to integrate AI/ML capabilities into existing software systems.

- Perform data analysis and visualization to derive actionable insights.

- Stay informed about emerging trends and advancements in the field of AI/ML and apply them to improve existing solutions.

Strong experience in Apache pyspark is must

Requirements:

- Bachelor's or Master's degree in Computer Science, Engineering, or a related field.

- Proven experience of 3-5 years as an AI/ML Engineer or a similar role.

- Strong knowledge of machine learning algorithms, deep learning frameworks, and data science concepts.

- Proficiency in programming languages such as Python, Java, or C++.

- Experience with popular AI/ML libraries and frameworks, such as TensorFlow, Keras, PyTorch, or scikit-learn.

- Familiarity with cloud platforms, such as AWS, Azure, or GCP, and their AI/ML services.

- Solid understanding of data preprocessing, feature engineering, and model evaluation techniques.

- Experience in deploying and scaling machine learning models in production environments.

- Strong problem-solving skills and ability to work on multiple projects simultaneously.

- Excellent communication and teamwork skills.

Preferred Skills:

- Experience with natural language processing (NLP) techniques and tools.

- Familiarity with big data technologies, such as Hadoop, Spark, or Hive.

- Knowledge of containerization technologies like Docker and orchestration tools like Kubernetes.

- Understanding of DevOps practices for AI/ML model deployment

-Apache ,Pyspark

Responsibilities:

• Designing Hive/HCatalog data model includes creating table definitions, file formats, compression techniques for Structured & Semi-structured data processing

• Implementing Spark processing based ETL frameworks

• Implementing Big data pipeline for Data Ingestion, Storage, Processing & Consumption

• Modifying the Informatica-Teradata & Unix based data pipeline

• Enhancing the Talend-Hive/Spark & Unix based data pipelines

• Develop and Deploy Scala/Python based Spark Jobs for ETL processing

• Strong SQL & DWH concepts.

Preferred Background:

• Function as integrator between business needs and technology solutions, helping to create technology solutions to meet clients’ business needs

• Lead project efforts in defining scope, planning, executing, and reporting to stakeholders on strategic initiatives

• Understanding of EDW system of business and creating High level design document and low level implementation document

• Understanding of Big Data Lake system of business and creating High level design document and low level implementation document

• Designing Big data pipeline for Data Ingestion, Storage, Processing & Consumption

Work Location - Bangalore

The Data Analytics Senior Analyst is a seasoned professional role. Applies in-depth disciplinary knowledge, contributing to the development of new techniques and the improvement of processes and work-flow for the area or function. Integrates subject matter and industry expertise within a defined area. Requires in-depth understanding of how areas collectively integrate within the sub-function as well as coordinate and contribute to the objectives of the function and overall business. Evaluates moderately complex and variable issues with substantial potential impact, where development of an approach/taking of an action involves weighing various alternatives and balancing potentially conflicting situations using multiple sources of information. Requires good analytical skills in order to filter, prioritize and validate potentially complex and dynamic material from multiple sources. Strong communication and diplomacy skills are required. Regularly assumes informal/formal leadership role within teams. Involved in coaching and training of new recruits. Significant impact in terms of project size, geography, etc. by influencing decisions through advice, counsel and/or facilitating services to others in area of specialization. Work and performance of all teams in the area are directly affected by the performance of the individual.

Responsibilities:

• Build and enhance the software stack for modelling and data analytics
• Incorporate relevant data related algorithms in the products to solve business problems and improve them over time
• Automate repetitive data modelling and analytics tasks
• Keep up to date with available relevant technologies, to solve business problems
• Become a subject matter expert and closely work with analytics users to understand their need & provide recommendations/solutions
• Help define/share best practices for the business users and  enforce/monitor that best practices are being incorporated for better efficiency (speed to market & system performance)
• Share daily/weekly  progress made by the team
• Work with senior stakeholders & drive the discussions independently
• Mentor and lead a team of software developers on analytics related product development practices

Qualifications:

• 10-13 years of data engineering experience.
• Experience in working on machine-learning model deployment/scoring, model lifecycle management and model performance measurement.
• In-depth understanding of statistics and probability distributions, with experience of applying it in big-data software products for solving business problems
• Hands-on programming experience with big-data and analytics related product development using Python, Spark and Kafka to provide solutions for business needs.
• Intuitive with good interpersonal-skills, time-management and task-prioritization
• Ability to lead a technical team of software developers and mentor them on good software development practices.
• Ability to quickly grasp the business problem and nuances when put forth.
• Ability to quickly put together an execution plan and see it through till closure.
• Strong communication, presentation and influencing skills.

Education:

• Bachelor’s/University degree or equivalent experience
• Data Science or Analytics specialization preferred

Role Summary

We Are looking for an analytically inclined, Insights Driven Product Analyst to make our organisation more data driven. In this role you will be responsible for creating dashboards to drive insights for product and business teams. Be it Day to Day decisions as well as long term impact assessment, Measuring the Efficacy of different products or certain teams, You'll be Empowering each of them. The growing nature of the team will require you to be in touch with all of the teams at upgrad. Are you the "Go-To" person everyone looks at for getting Data, Then this role is for you.

Roles & Responsibilities

• Lead and own the analysis of highly complex data sources, identifying trends and patterns in data and provide insights/recommendations based on analysis results
• Build, maintain, own and communicate detailed reports to assist Marketing, Growth/Learning Experience and Other Business/Executive Teams
• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions.
• Analyze data and generate insights in the form of user analysis, user segmentation, performance reports, etc.
• Facilitate review sessions with management, business users and other team members
• Design and create visualizations to present actionable insights related to data sets and business questions at hand
• Develop intelligent models around channel performance, user profiling, and personalization

Skills Required

• Having 4-6 yrs hands-on experience with Product related analytics and reporting
• Experience with building dashboards in Tableau or other data visualization tools such as D3
• Strong data, statistics, and analytical skills with a good grasp of SQL.
• Programming experience in Python is must
• Comfortable managing large data sets
• Good Excel/data management skills