Work Experience Requirements :
8+ years of Information Technology experience with a proven track record working as a Business Data Analyst for multiple large Business Intelligence (BI), Data Warehouse (DW) or Big Data Analytics projects preferably in the B2B domain.
Knowledge with a variety of ETL, data quality, data cleansing, data blending & BI tools. ((Tableau, PowerBI, Alteryx, Talend, Pentaho etc.)
Experience with data profiling, metadata management, address cleansing, high availability, server tuning concepts (parameters, resources, contention) and parallelism into ETL flows is preferred.
Strong knowledge of and experience with reporting packages (Tableau, Power BI etc.), RDBMS (MYSQL) &Full understanding of AWS Redshift or Columnar DB architecture, perhaps including use of Data Pipeline.
Knowledge of one or more OLAP (e.g. Mondrian), reporting visualization tools (e.g. Tableau, Power BI).
Familiarity with Entity-Relationship (ER) / UML modeling and diagramming tools (like ERwin or ER/Studio).
Designing & developing dimensions, hierarchies & cubes.
Technical expertise regarding data models, database design development, data mining and segmentation techniques
Knowledge of statistics and experience using statistical packages for analyzing large datasets (Excel, SPSS etc.)
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
Adept at queries, report writing and presenting findings
Deep analytical experience and understanding of typical information technology processes.
Experience with requirements gathering and documentation processes
Experience in working in a multicultural team environment and having managed a team of data specialists
Behavioral Attributes& Preferred Skills
Passionate about technology and applying it to business solutions.
Enthusiastic and possessing a - can do- attitude, startup experience preferred.
Thrive on and have a track record of getting things done, within a fast-paced and changing environment.
Comfortable dealing with ambiguity and a changing &fast paced 24x7 environment.
Self-starter - able to work on his own initiative with minimal supervision.
Excellent analytical and communication skills, including ability to work effectively with business users and cross-functional technical teams. Attention to details.
Working knowledge of a programming or statistical language like Java or R.
Familiarity with Natural Language Processing (NLP), Named Entity Recognition (NER), part of speech (POS) tagging; Statistics, Machine Learning (Mahout, R, Weka, RapidMiner, KNIME); NoSQL and MPP databases (MongoDB); and/or Search (IR - Lucene, Solr, ElasticSearch, CloudSearch).
Role & Responsibilities
Demonstrated experience in effectively managing multiple projects and activities in a timely, organized manner.
Demonstrated experience in organizing and prioritizing work, meeting deadlines and working independently as well as collaboratively with others.
Acquire data from primary or secondary data sources and maintain databases/data systems
Data analysis (profiling) experience with large dataset's, including unstructured / semi-structured data.
Interpret data, analyze results using statistical techniques and provide ongoing reports
Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality
Identify, analyze, and interpret trends or patterns in complex data sets
Manage BI solutions (portals, dashboards, standard and ad-hoc reporting) with a specific focus on data management, and data warehouse architecture.
Filter and ?clean? data, and review reports and performance indicators to locate and correct problems
Work closely with management to prioritize business and information needs
Locate and define new process improvement opportunities
Maintains resource forecast and resolves resource conflict and risk.
Ensures utilization of investment allocated to team through balance of projects, goals, and training.
Excellent communication, creative problem solver, flexible, proactive and have demonstrated experience in effectively working within a fast paced, ever changing environment.
Provide technical direction and mentoring to a team of developers who develop and build solutions using our Enterprise Data tools (Alteryx, MySQL, Tableau, Power BI and Power View).
Work with multi-disciplinary teams based in three countries and with external consultants, both onshore and offshore, in an agile environment.
Be responsible for data quality and performance management; Design and develop the partition strategy and automate the maintenance
Provide production support on a regular basis during normal working hours, with 24x7 on-call support as needed.
Create performance monitor framework; Create framework for Data validation