Data Analyst

Desired Competencies:

 

Ø  Expertise in Azure Data Factory V2

Ø  Expertise in other Azure components like Data lake Store, SQL Database, Databricks

Ø  Must have working knowledge of spark programming

Ø  Good exposure to Data Projects dealing with Data Design and Source to Target documentation including defining transformation rules

Ø  Strong knowledge of CICD Process

Ø  Experience in building power BI reports

Ø  Understanding of different components like Pipelines, activities, datasets & linked services

Ø  Exposure to dynamic configuration of pipelines using data sets and linked Services

Ø  Experience in designing, developing and deploying pipelines to higher environments

Ø  Good knowledge on File formats for flexible usage, File location Objects (SFTP, FTP, local, HDFS, ADLS, BLOB, Amazon S3 etc.)

Ø  Strong knowledge in SQL queries

Ø  Must have worked in full life-cycle development from functional design to deployment

Ø  Should have working knowledge of GIT, SVN

Ø  Good experience in establishing connection with heterogeneous sources like Hadoop, Hive, Amazon, Azure, Salesforce, SAP, HANA, API’s, various Databases etc.

Ø  Should have working knowledge of different resources available in Azure like Storage Account, Synapse, Azure SQL Server, Azure Data Bricks, Azure Purview

Ø  Any experience related to metadata management, data modelling, and related tools (Erwin or ER Studio or others) would be preferred

 

Preferred Qualifications:

Ø  Bachelor's degree in Computer Science or Technology

Ø  Proven success in contributing to a team-oriented environment

Ø  Proven ability to work creatively and analytically in a problem-solving environment

Ø  Excellent communication (written and oral) and interpersonal skills

Qualifications

BE/BTECH

KEY RESPONSIBILITIES :

You will join a team designing and building a data warehouse covering both relational and dimensional models, developing reports, data marts and other extracts and delivering these via SSIS, SSRS, SSAS, and PowerBI. It is seen as playing a vital role in delivering a single version of the truth on Client’s data and delivering MI & BI that will feature in enabling both operational and strategic decision making. You will be able to take responsibility for projects over the entire software lifecycle and work with minimum supervision. This would include technical analysis, design, development, and test support as well as managing the delivery to production. The initial project being resourced is around the development and implementation of a Data Warehouse and associated MI/BI functions.

 

Principal Activities: 1.       Interpret written business requirements documents 2.       Specify (High Level Design and Tech Spec), code and write automated unit tests for new aspects of MI/BI Service. 3.       Write clear and concise supporting documentation for deliverable items. 4.       Become a member of the skilled development team willing to contribute and share experiences and learn as appropriate. 5.       Review and contribute to requirements documentation. 6.       Provide third line support for internally developed software. 7.       Create and maintain continuous deployment pipelines. 8.       Help maintain Development Team standards and principles. 9.       Contribute and share learning and experiences with the greater Development team. 10.   Work within the company’s approved processes, including design and service transition. 11.   Collaborate with other teams and departments across the firm. 12.   Be willing to travel to other offices when required. 13.You agree to comply with any reasonable instructions or regulations issued by the Company from time to time including those set out in the terms of the dealing and other manuals, including staff handbooks and all other group policies

Location – Bangalore

 

Our client is currently looking for a Data Solutions Associate Director to join the data, technology & analytics division.

• Support agencies on client brief responses, working with the analytics & technology directors to develop tailored solutions using proprietary or partner technologies.
  
• Conduct client data & technology audits for development of audience strategies.
  
• Deliver detailed digital transformation roadmaps to support audience activation, provided in a client-ready format for agency partners to utilize.
  
• Project manage all signed-off SOW’s, from initiation to closure and ensure effective delivery.
  
• Work closely with agency planning teams to identify opportunities for clients within data & tech service scope.
  
• As the SME on data marketplaces, be the POC for buying teams with enquiries on data strategy for media activation (source, validate, build).
  
• Develop agency data ‘champions’ in your respective market, through training and enablement programs covering Identity resolutions, data governance and ethics policies, as defined by our global and legal teams.
  
• Work with the Regional & Marketing teams to create & deliver Learning & Development sessions on our partner solutions to buying and agency teams.
  
• Lead and develop key relationships with relevant data & technology partners, working with investment & agencies to deliver opportunities that support our client and internal requirements.
  
• Any other ad-hoc projects or tasks relevant to the position.
  
• Build a great working relationship with your team, market teams and client team, operating seamlessly together to deliver success for our clients, across the briefing, booking, set up, optimization and reporting processes.
  
  

Milestone Technologies is a global IT managed services firm that partners with organizations to scale their technology, infrastructure and services to drive specific business outcomes such as digital transformation, innovation, and operational agility. Milestone is focused on building an employee-first, performance based culture and for over 25 years, we have a demonstrated history of supporting category-defining enterprise clients that are growing ahead of the market. The company specializes in providing solutions across Application Services and Consulting, Digital Product Engineering, Digital Workplace Services, Private Cloud Services, AI/Automation, and ServiceNow. Milestone culture is built to provide a collaborative, inclusive environment that supports employees and empowers them to reach their full potential.

 

Our seasoned professionals deliver services based on Milestone’s best practices and service delivery framework. By leveraging our vast knowledge base to execute initiatives, we deliver both short-term and long-term value to our clients and apply continuous service improvement to deliver transformational benefits to IT. With Intelligent Automation, Milestone helps businesses further accelerate their IT transformation. The result is a sharper focus on business objectives and a dramatic improvement in employee productivity. Through our key technology partnerships and our people-first approach, Milestone continues to deliver industry-leading innovation to our clients. With more than 2,000 employees serving over 200 companies worldwide, we are following our mission of revolutionizing the way IT is deployed around the globe. 

We are looking for someone who is creative , analytical and a thinker to join our Business Intelligence team as a Senior Tableau Developer in Hyderabad, India 

Responsibilities

• Proficient in all Tableau platforms including desktop, server and web-based including Tableau Prep
• Design, build, maintain & deploy complex reports in Tableau.
• Identify, analyze, and interpret trends or patterns in complex data sets using standard statistical tools and techniques.
• Consult with and advise senior management and multiple clients on strategies to improve reporting techniques through automation and the creation of dashboards.
• Generate monthly reporting and ad-hoc analysis to support leadership decision-making.

• Gather and document requirements from cross-functional teams and projects, and align on visualization expectations.
• Build best practices of integrating financial and operational data for a variety of data sources; including: MS Excel, SQL, internal forecasting and planning tools.
• Create dynamic dashboards using parameters, filters, calculated fields and applying level of details functionality.

Minimum Qualifications

• 5+ years’ experience in data analytics.
• Systems: Proficient with Tableau, MS Excel, Anaplan, SQL (Oracle, Hive, MySQL) and other analytical applications.
• Bachelor’s degree in Computer Science, Statistics, Math, Engineering, Business and/or equivalent specialized education and experience in Data Science, Statistics, Data Analysis or related field

Knowledge, Skills and Abilities

• Expertise in designing and presenting data using best practices in data visualization.
• Ability to present to variety of internal and external stakeholders.
• Strong written and verbal communication skills.
• Knowledge of best practices and experience optimizing Tableau for performance by optimizing queries, extracts and logic.
• Experience performing administration tasks in Tableau Server in a production environment.
• Experience with connecting and blending multiple data sources.
• Strong analytical and critical thinking skills.

BitClass, a VC funded startup (backed by the investors or Unacademy, Doubtnut, ShareChat, Meesho among others) in the domain of edtech, is looking for a data analyst to help in making better business decisions using information from the available data. The responsibility is to gather and prepare data from multiple sources, run statistical analyses, and communicate your findings in a clear and objective way.

Responsibilities

- Understanding the business requirements so as to formulate the problems to solve and restrict the slice of data to be explored.
- Collecting data from various sources.
- Performing cleansing, processing, and validation on the data subject to analyze, in order to ensure its quality.
- Exploring and visualizing data.
- Performing statistical analysis and experiments to derive business insights.
- Clearly communicating the findings from the analysis to turn information into something actionable through reports, dashboards, and/or presentations.

Skills

- Experience solving problems in the project’s business domain.
- Experience with data integration from multiple sources 
- Proficiency in at least one query language, especially SQL.
- Working experience with NoSQL databases, such as MongoDB and Elasticsearch.
- Working experience with popular statistical and machine learning techniques, such as clustering, linear regression, KNN, decision trees, etc.
- Good scripting skills using Python, R or any other relevant language
- Proficiency in at least one data visualization tool, such as Matplotlib, Plotly, D3.js, ggplot, etc.
- Great communication skills.

• Ensure and own Data integrity across distributed systems.
• Extract, Transform and Load data from multiple systems for reporting into BI platform.
• Create Data Sets and Data models to build intelligence upon.
• Develop and own various integration tools and data points.
• Hands-on development and/or design within the project in order to maintain timelines.
• Work closely with the Project manager to deliver on business requirements OTIF (on time in full)
• Understand the cross-functional business data points thoroughly and be SPOC for all data-related queries.
• Work with both Web Analytics and Backend Data analytics.
• Support the rest of the BI team in generating reports and analysis
• Quickly learn and use Bespoke & third party SaaS reporting tools with little documentation.
• Assist in presenting demos and preparing materials for Leadership.

• Strong experience in Datawarehouse modeling techniques and SQL queries

• A good understanding of designing, developing, deploying, and maintaining Power BI report solutions
• Ability to create KPIs, visualizations, reports, and dashboards based on business requirement
• Knowledge and experience in prototyping, designing, and requirement analysis
• Be able to implement row-level security on data and understand application security layer models in Power BI
• Proficiency in making DAX queries in Power BI desktop.
• Expertise in using advanced level calculations on data sets
• Experience in the Fintech domain and stakeholder management.

• Create & Manage dashboards on various Mobile & web tools like Clevertap, Branch, Google Analytics, Zoho Page Sense, Firebase, and other data tools that marketing and product teams use on a daily basis.
• Create richer & holistic (collating multiple data sources/platforms) dashboards and reports on Tableau & Metabase for Product, Marketing & Business teams.
• Improve dashboards & set up alert systems on Sentry, Firebase, GA for product & technology teams to timely catch fatal crashes, errors.

Deliver data-backed insights & periodic analysis reports

• Perform deep data analysis to identify issues, trends, opportunities, and improvements possible in Acquisition, Activation, Transactions, Conversion Ratios & other driving product metrics. Present findings to product, marketing, and business stakeholders.
• Perform analysis to assess the success of ongoing product initiatives, provide insights to product managers & designers to iterate product features and flows.
• Create & Track product and marketing funnels to identify growth opportunities and problem areas. Collaborate with PMs and Designers to discover underlying reasons for drop points. Analyze Funnel, Cohort, Trends, LTV, DAU, MAU, Retention & user behavior using data & help teams make data-driven decisions.

Define measurement & success criteria for experiments, new features, and A/B tests.

• Collaborate with Product Manager to design, execute and analyze A/B tests, define target KPIs & control segments.
• Help Product Managers define success criteria and measurement standards for new features and product offerings.
• Ensure technical setup is there to MONITOR important KPIs and collect custom events data. Define custom events & properties to be tracked on Clevertap, GA, Zoho Page Sense.

 

Drive increased engagement & retention using Clevertap

• Define AARRR KPIs and Optimize them with CT multi-channel journeys by continuously performing A/B tests.
• Create detailed and diverse user segments to identify high, medium & low activity cohorts. Create strategies to increase the size of high-activity cohorts.
• Analyze website & mobile traffic, create user journeys & campaigns to enable cross-channel product experience and marketing.

Manage, Mentor & lead Product Analytics

• Act as an Analytics Subject Matter Expert in the team. Train, hire, and manage a team of analysts. Setup collaborative processes & management practices to help teams achieve important analytics goals.
• Assist the Product stakeholders to make data-driven decisions to achieve short and long-term goals relating to product growth.
• Collaborate & hire analysts to improve the overall product analysis capabilities.
• Research and be updated with upcoming technologies and trends in digital product analytics.
  
  

Experience

• Bachelor’s Degree in Computer Science, Engineering or any other related field.
• 4+ years of experience in mobile/web application analytics, business analytics, must have led or managed a team before.

Technical Skills

• In-depth knowledge & hands-on experience of digital analytics software like Zoho Page Sense, Google Analytics, CleverTap, Branch, Firebase, Facebook Analytics.
• Expertise in dash-boarding tools like Tableau, Metabase, and Excel.
• Experience with data warehousing concepts and ETL development and tools
• Fetching and manipulating large data sets using SQL / Hive.
• Analyzing and visualizing large data sets: R / python.

Soft Skills

• Ability to prioritize and manage multiple milestones and projects efficiently.
• Team spirit, good time-management skills, strong communication skills to collaborate with various stakeholders.
• Detail-oriented, advanced problem-solving skills with customer-centric approach.

 

Good knowledge of SQL , Microsoft Excel One Programming language in SAA/Python or R

Power BI Experience: 2-3 years Skills: Power BI Start date : Looking out for Immediate Joiners Contract position for 3 months Location Bangalore Job Designation Power BI Developer : 1. To Develop Power BI reports & effective dashboards after gathering and translating end user requirements. 2. To have Ability to turn large amounts of raw data into actionable information. 3. Be responsible for the performance and usability of the system 4. To Perform optimization of MS SQL Queries and SSIS packages 5. To Provide solutions using SSAS cubes (Tabular/Multidimensional Models) 6. Must have excellent experience in MS SQL Server - writing queries, joints, stored procedures, functions etc Candidate should have the knowledge of: Power BI with DAX query, Multiple Data Sources and Relationships of data Power BI Architecture Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power BI Desktop Hands-on professional with thorough knowledge of scripting, data source integration and advanced GUI development in Power BI. Familiar with Power BI custom add-on development & deployment. Connecting Power BI with on-premise and cloud computing platforms. To provide optimized SQL Scripts for complex scenarios Business Intelligence Systems & Tools (Microsoft Power BI, SQL Server Reporting Services) Good understanding of the processes of data quality, data cleansing and data transformation