BI Consultant

Strong Power Bi, Power App and SQL skills,

• Design and build compelling analyses, trending and/or forecasting reports using Microsoft Power BI.

• Design and build apps using power apps and power automate.

• Assist in the publishing of metrics dashboards by identifying, analyzing and interpreting trends or patterns in complex data sets.

• Define BI development objectives by analyzing user requirements while envisioning system features and functionality.

• Translate business needs into technical requirements, clearly communicate probable designs and create prototypes.

• Follow data and reporting performance optimization and tuning best practices.

• Conduct analytical activities of system data.

• Conducts complex data analysis and evaluates intangibles providing management with fact-based information.

• Knowledge of the supply chain domain.

• Proven, effective analytical skills

• Ability to work effectively under time constraints and multitask.

• Ability to work collaboratively across multiple functions and departments within the organization.

Brief:

As a BI Developer at GradRight, you’ll be working with Tableau and supporting data sources to build reports for the requirements of various business teams.

Responsibilities:

1. Translate business needs to technical specifications for reports and dashboards
2. Design, build and deploy BI solutions
3. Maintain and support data analytics platforms (e.g. Tableau, Mixpanel, Google Analytics, etc)
4. Evaluate and improve existing BI systems
5. Collaborate with teams to integrate systems
6. Develop and execute database queries, conduct analysis and prepare data to be shared with respective stakeholders
7. Create visualizations and reports for requested projects
8. Develop and update technical documentation around reports

Requirements:

1. At least 3 years of proven experience as a BI Developer
2. Experience at a startup
3. Background in data warehouse design (e.g. dimensional modeling) and data mining
4. In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
5. Working knowledge of Tableau
6. Knowledge of SQL queries and MongoDB
7. Proven abilities to take initiative and be innovative
8. Analytical mind with a problem-solving aptitude

JOB SUMMARY:  The Senior Associate supports the Data Analytics Manager by proposing relevant analytics procedures/tools, executing the analytics and also developing visualization outputs for audits, continuous monitoring/auditing and IA initiatives. The individual’s responsibilities include -

Understanding audit and/or project objectives and assisting the manager in preparing the plan and timelines.

Working with the Process/BU/IA teams for gathering requirements for continuous monitoring/auditing projects.

Working with Internal audit project teams to understand the analytics requirements for audit engagements.

Independently build pilot/prototype, determine appropriate visual tool and design the views to meet project objectives.

Proficient in data management and data mining.

Highly skilled on visualization tools like Qlik View, Qlik Sense, Power BI, Tableau, Alteryx etc.

Working with Data Analytics Manager to develop analytics program aligned to the overall audit plan.

Showcasing analytics capability to Process management teams to increase adoption of continuous monitoring.

Establishing and maintaining relationships with all key stakeholders of internal audit.

Coaching other data analysts on analytics procedures, coding and tools.

Taking a significant and active role in developing and driving Internal Audit Data Analytics quality and knowledge sharing to enhance the value provided to Internal Audit stakeholders.

Ensuring timely and accurate time tracking.

Continuously focusing on self-development by attending trainings, seminars and acquiring relevant certifications.

Specific Responsibilities

• Minimum of 2 years Experience in Google Big Query and Google Cloud Platform.
• Design and develop the ETL framework using BigQuery
• Expertise in Big Query concepts like Nested Queries, Clustering, Partitioning, etc.
• Working Experience of Clickstream database, Google Analytics/ Adobe Analytics.
• Should be able to automate the data load from Big Query using APIs or scripting language.
• Good experience in Advanced SQL concepts.
• Good experience with Adobe launch Web, Mobile & e-commerce tag implementation.
• Identify complex fuzzy problems, break them down in smaller parts, and implement creative, data-driven solutions
• Responsible for defining, analyzing, and communicating key metrics and business trends to the management teams
• Identify opportunities to improve conversion & user experience through data. Influence product & feature roadmaps.
• Must have a passion for data quality and be constantly looking to improve the system. Drive data-driven decision making through the stakeholders & drive Change Management
• Understand requirements to translate business problems & technical problems into analytics problems.
• Effective storyboarding and presentation of the solution to the client and leadership.
• Client engagement & management
• Ability to interface effectively with multiple levels of management and functional disciplines.
• Assist in developing/coaching individuals technically as well as on soft skills during the project and as part of Client Project’s training program.

• 2 to 3 years of working experience in Google Big Query & Google Cloud Platform
• Relevant experience in Consumer Tech/CPG/Retail industries
• Bachelor’s in engineering, Computer Science, Math, Statistics or related discipline
• Strong problem solving and web analytical skills. Acute attention to detail.
• Experience in analyzing large, complex, multi-dimensional data sets.
• Experience in one or more roles in an online eCommerce or online support environment.

• Expertise in Google Big Query & Google Cloud Platform
• Experience in Advanced SQL, Scripting language (Python/R)
• Hands-on experience in BI tools (Tableau, Power BI)
• Working Experience & understanding of Adobe Analytics or Google Analytics
• Experience in creating and debugging website & app tracking (Omnibus, Dataslayer, GA debugger, etc.)
• Excellent analytical thinking, analysis, and problem-solving skills.
• Knowledge of other GCP services is a plus

• Key Responsibilities : Use cases to support use case analysis E2E, define capabilities, understand the data and model Machine Learning Operations MLOps Azure Machine Learning, Azure Cognitive Services, Azure DevOps, Overall Azure Cloud Experience, Powershell, DSVM, AML Compute / Training Clusters Azure Infrastructure Experience, Python, Big Data Python Scripting 8 Automate ML models deployments,  Manage, monitor, troubleshoot machine learning infrastructure and Setup ML Pipe lines
• Technical Experience : Proven skills experience in Azure AI ML solution design and architecture based solution using Azure Cloud capabilities AML / AKS Proven record of embedding advanced analytical models into business processes Collaborate in multi-functional teams to evaluate business activities, and then develop innovative and effective approaches to tackle teams analytics problems and communicate results bitbucket, Nodejs, PowerBI SQL, Python
• Experience in setting up MLOps framework for AI ML team