Power Bi Developer

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

Our client is the world’s largest media investment company and are a part of WPP. In fact, they are responsible for one in every three ads you see globally. We are currently looking for a Senior Software Engineer to join us. In this role, you will be responsible for coding/implementing of custom marketing applications that Tech COE builds for its customer and managing a small team of developers.

What your day job looks like:

• 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
• Develop automated and manual test cases for the code written
• Design and construct data store and procedures for their maintenance
• Perform data extract, transform, and load activities from several data sources.
• Develop and maintain strong relationships with stakeholders
• Write high quality code as per prescribed standards.
• Participate in internal projects as required

 
Minimum qualifications:

• B. Tech./MCA or equivalent preferred
• Excellent 3 years Hand on experience on Big data, ETL Development, Data Processing.

    What you’ll bring:

• Strong experience in working with Snowflake, SQL, PHP/Python.
• Strong Experience in writing complex SQLs
• Good Communication skills
• Good experience of working with any BI tool like Tableau, Power BI.
• Sqoop, Spark, EMR, Hadoop/Hive are good to have.

We are looking for a Business Intelligence (BI)/Data Analyst to create and manage Power Bl and analytics solutions that turn data into knowledge.  In this role, you should have a background in data and business analysis. If you are self-directed, passionate about data,

and have business acumen and problem-solving aptitude, we'd like to meet you. Ultimately, you will enhance our business intelligence system to help us make better decisions.

Requirements and Qualifications

• BSc/BA in Computer Science, Engineering, or relevant field.
• Financial experience and Marketing background is a plus
• Strong Power BI development   skills including Migration of existing deliverables to PowerBl.
• Ability to work autonomously
• Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power-BI.
• Proven experience as a Power BI Developer is a must.
• Industry experience is preferred.  Familiarity with other BI tools (Tableau, QlikView).
• Analytical mind with a problem-solving aptitude.

Responsibilities

• Design, develop and maintain business intelligence solutions
• Craft and execute queries upon request for data
• Present information through reports and visualization based on requirements gathered from stakeholders
• Interact with the team to gain an understanding of the business environment, technical context, and organizational strategic direction
• Design, build and deploy new, and extend existing dashboards and reports that synthesize distributed data sources
• Ensure data accuracy, performance, usability, and functionality requirements of BI platform
• Manage data through MS Excel, Google sheets, and SQL applications, as required and support other analytics platforms
• Develop and execute database queries and conduct analyses
• Develop and update technical documentation requirements
• Communicate   insights   to both   technical   and non-technical audiences.

Exp-10 Years

Location Mumbai

Ready to work from Office

Permanent role

Role

Business Analytics/Data Analytics Lead

• Enable Business Transformation with Data Analytics by working with our big clients in major sectors such as Oil & Gas, Manufacturing, Retail, BFSI
• Partner business teams to understand the business area, work with the team to evolve and define the business problems, use-cases, translate the same into an analytical problem, design solution approach, define ROI, help execute to deliver relevant insights that lead to actions and business value.
• Connect business requirements with Technology solutions and be able to determine feasibility, technical gaps, size etc.
• Be able to define a project plan for the identified solutions, help hire and train technical resources, be the glue between Business team and the technical/implementation team
• Be proficient at solving ad hoc business problems, innovating on potential future solutions, and working with technology partners to build solutions and/or creative approaches to solve ‘one of a kind’ problems.
• Embed tested solutions to make them business as usual and help quantify value benefits from analytics.
• Be creative and a committed problem-solver using Data and Advanced analytics skill alongside leadership and direct engagement of business leaders.
• Be a trusted advisor to the client CxOs/leadership team in evangelising the use of Data & Data Science in business decisions. Help accelerate the organisation journey to become data driven.
• Provide input during development and implementation phases, including formulation and definition of systems scope, objectives and necessary system enhancements for complex, high-impact projects
• Work with development and testing teams to deliver solutions and support UAT
• Identify and communicate risks and impacts and propose risk mitigation options, considering business implications of the application of technology to the current business environment.

Qualifications

• 10+ years experience in technology/project management/product management/solution delivery
• 4+ years of relevant work experience in roles partnering in Data Analytics related use-cases and solutions resulting in significant cost, productivity and/or quality gains for the business
• Bachelors degree in a relevant technical field (Computer Science, IT, Statistics, Business Analytics or similar). MBA preferred

·       Experience of specifying and writing business requirements and suggesting appropriate solutions in the field of Data Analytics/AI

• Prior industry experience in defining/creating Data Analytics solutions  in one or more of Oil & Gas, BFSI, Manufacturing, Retail sectors.
• Strong preference for experience in setting up & managing analytics / data products / platforms & leading change management.
• Be able to articulate and have a keen eye on the value that Data Analytics, AI, Machine Learning, Data Lake/Catalogue can bring to organizations
• Ability to communicate complex quantitative insights in a precise, and actionable manner
• Strong communication skills and ability to work with peers & senior stakeholders demonstrating strong vertical and lateral influence.
• Working knowledge of Analytics tools such as PowerBI, Tableau, AI modelling such as Regression, Classification, and Time Series Problems.
• Experience building insights from analytics & telling data stories
• Passion for empirical research and for answering hard questions with data

Power BI Engineer 

Company Overview: 

At Codvo, software and people transformations go hand-in-hand. We are a global empathy-led technology services company. Product innovation and mature software engineering are part of our core DNA. Respect, Fairness, Growth, Agility, and Inclusiveness are the core values that we aspire to live by each day. 

We continue to expand our digital strategy, design, architecture, and product management capabilities to offer expertise, outside-the-box thinking, and measurable results. 

What we're looking for :

• You should have strong technical and analytical skill with more in SQL Server, reporting tools like Tableau, Power BI, SSRS and .Net. 
• You have experience in OLAP, UI/UX and Dashboard building.
• You should have experience for proper understanding of the project deliverables. 
• You should possess excellent communication skills. 

• You will be responsible for the respective tasks assigned in the project. 
• You will be responsible for the deliverable with proper quality, in planned time and cost adhering to the industry standards that will be defined for the project. 
• You will be involved in client interaction. 

• Power BI Report and Dashboard development.
• Building Analysis Services reporting models.
• Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
• Connecting data sources, importing data, and transforming data for Business intelligence.
• Analytical thinking for translating data into informative reports and visuals.
• Should have an edge over making DAX queries in Power BI desktop.
• Expert in using advanced-level calculations on the data set.
• SQL Server with SSAS is must.
• Very good communication skills must be able to discuss the requirements effectively with the client teams, and with internal teams.

• 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.