Data Analyst

Cloudera Data Warehouse Hive team looking for a passionate senior developer to join our growing engineering team. This group is targeting the biggest enterprises wanting to utilize Cloudera’s services in a private and public cloud environment. Our product is built on open source technologies like Hive, Impala, Hadoop, Kudu, Spark and so many more providing unlimited learning opportunities.A Day in the LifeOver the past 10+ years, Cloudera has experienced tremendous growth making us the leading contributor to Big Data platforms and ecosystems and a leading provider for enterprise solutions based on Apache Hadoop. You will work with some of the best engineers in the industry who are tackling challenges that will continue to shape the Big Data revolution.  We foster an engaging, supportive, and productive work environment where you can do your best work. The team culture values engineering excellence, technical depth, grassroots innovation, teamwork, and collaboration.
You will manage product development for our CDP components, develop engineering tools and scalable services to enable efficient development, testing, and release operations.  You will be immersed in many exciting, cutting-edge technologies and projects, including collaboration with developers, testers, product, field engineers, and our external partners, both software and hardware vendors.Opportunity:Cloudera is a leader in the fast-growing big data platforms market. This is a rare chance to make a name for yourself in the industry and in the Open Source world. The candidate will responsible for Apache Hive and CDW projects. We are looking for a candidate who would like to work on these projects upstream and downstream. If you are curious about the project and code quality you can check the project and the code at the following link. You can start the development before you join. This is one of the beauties of the OSS world.Apache Hive

Responsibilities:

•Build robust and scalable data infrastructure software

•Design and create services and system architecture for your projects

•Improve code quality through writing unit tests, automation, and code reviews

•The candidate would write Java code and/or build several services in the Cloudera Data Warehouse.

•Worked with a team of engineers who reviewed each other's code/designs and held each other to an extremely high bar for the quality of code/designs

•The candidate has to understand the basics of Kubernetes.

•Build out the production and test infrastructure.

•Develop automation frameworks to reproduce issues and prevent regressions.

•Work closely with other developers providing services to our system.

•Help to analyze and to understand how customers use the product and improve it where necessary. 

Qualifications:

•Deep familiarity with Java programming language.

•Hands-on experience with distributed systems.

•Knowledge of database concepts, RDBMS internals.

•Knowledge of the Hadoop stack, containers, or Kubernetes is a strong plus. 

•Has experience working in a distributed team.

•Has 3+ years of experience in software development.

• Thoroughly understanding the data processing pipeline and troubleshooting/problem-solving the technical team
• Acting as SPOC for client communications across the portfolio of projects undertaken by the organization
• Contributing to different aspects of organizational growth– team building, process building, strategy and business development

Desired Candidate Profile

• Post-graduate degree in relevant subjects such as Economics/ Engineering/ Quantitative Social Sciences/ Management etc
• At least 5 years of relevant work experience
• Vast experience in managing multiple client projects
• Strong data/quantitative analysis skills are a must
• Prior experience working in data analytics teams
• Credible experience of data platforms & languages in the past    

Responsibilities 

• Identify, analyze, and interpret trends or patterns in complex data sets to develop a thorough understanding of users, and acquisition channels.
• Run exploratory analysis uncover new areas of opportunity, generate hypotheses, and quickly assess the potential upside of a given opportunity.
• Help execute projects to drive insights that lead to growth.
• Work closely with marketing, design, product, support, and engineering to anticipate analytics needs and to quantify the impact of existing features, future product changes, and marketing campaigns.
• Work with data engineering to develop and implement new analytical tools and improve our underlying data infrastructure. Build tracking plans for new and existing products and work with engineering to ensure proper
• Analyze, forecast, and build custom reports to make key performance indicators and insights available to the entire company.
• Monitor, optimize, and report on marketing and growth metrics and split-test results. Make recommendations based on analytics and test findings.
• Drive optimization and data minded culture inside the company.
• Develop frameworks, models, tools, and processes to ensure that analytical insights can be incorporated into all key decision making.
• Effectively present and communicate analysis to the company to drive business decisions.
• Create a management dashboard including all important KPIs to be tracked on a company and department level

• Establish end to end campaign ROI tracking mechanism to attribute sales to specific google and Facebook campaigns

Skills and Experience

• Minimum 1-2 years of proven work experience in a data analyst role.
• Excellent analytical skills and problem-solving ability; the ability to answer unstructured business questions and work independently to drive projects to conclusion.
• Strong analytical skills with the capacity to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Experience extracting insights using advanced SQL or similar tool to work efficiently at scale. Advanced expertise with commonly used analytics tools including Google Analytics, studio and Excel.
• Strong knowledge of statistics, this includes experimental design for optimization, statistical significance, confidence intervals and predictive analytics techniques.
• Must be self-directed, organized and detail oriented as well as have the ability to multitask and work effectively in a fast-paced environment.
• Active team player, excellent communication skills, positive attitude and good work ethic.

Key Responsibilities:

• Understand Business requirements in BI context and design data models to transform raw data into meaningful insights
• Create dashboards and interactive visual reports using Power BI
• Analyze data and present data through reports that aid decision-making
• Design, develop, test, and deploy Power BI scripts and perform detailed analytics
• Communicate with Business units & leadership team and aim at better visualization and transparency of data analytics, driving insightful business strategies and improved business performances
• Partner with other Technology teams to create Data models, Charts & Reports in a scalable and controlled environment

Knowledge/Experience:

• A bachelor’s degree in data science, data analytics, computer science, mathematics, statistics, econometrics, financial engineering, computer or electrical engineering, or other related quantitative fields
• 4-5 years of experience in Data Preparation & Analysis, Business Intelligence using Data visualization tools (e.g.: Power BI) and sound knowledge of JavaScript, SQL
• An understanding of Machine Learning and Artificial Intelligence (AI)
• Experience with analysis in FMCG or Electronic sector is preferred
• Strong knowledge of Microsoft Excel & PowerPoint

Skills/Qualifications:

• Strong analytical skills and ability to work in a fast-paced environment
• Business acumen to understand complex business problems and translate them into analysis that leads to actionable business insights
• Strong communication skills (oral and written) to explain complex data and analytical problems
• Willingness to learn and to explore new ideas, with independent thinking and attention to details
• Strong work ethics, the can-do attitude and excellent interpersonal skills

4-6 years of total experience in data warehousing and business intelligence

3+ years of solid Power BI experience (Power Query, M-Query, DAX, Aggregates)

2 years’ experience building Power BI using cloud data (Snowflake, Azure Synapse, SQL DB, data lake)

Strong experience building visually appealing UI/UX in Power BI

Understand how to design Power BI solutions for performance (composite models, incremental refresh, analysis services)

Experience building Power BI using large data in direct query mode

Expert SQL background (query building, stored procedure, optimizing performance)

• Create, maintain and automate datasets and insightful dashboards to track core metrics and extract business insights
• Analyze large-scale structured and unstructured data to identify business opportunities and optimize features for Analytics.

• 8+ years experience doing Business Intelligence and Analytics work
• B.Tech/M.Tech in a technical field (Computer Science, Math, Statistics)
• Strong knowledge in Data Design, Data Modelling, and Data Validation best practices
• Proficient in data visualization, Preferably SSRS & Power BI
• Fluency with writing advanced SQL code
• Experience with SQL Server Administration and best practices
• Possess BFSI, Fintech Domain Knowledge
• Excellent interpersonal, cross-functional, communication, writing, and presentation skills
• Comfortable working in a fast-paced environment with the ability to be a team player
• Possess excellent Project Management and superior Team Management skills