Should have Business Intelligence Experience in a data warehouse environment
Should have good experience in writing Power Query, DAX, MDX for complex data projects
Good on Rest Services including the API documentation.
Should have Experience authoring, diagnosing, and altering SQL Server objects and T-SQL
queries
Should have worked on Tabular models in Azure Analysis Services or SSAS
Should have Experience in Microsoft Azure Platform
Similar jobs
- Lead pre-sales activities, including requirements gathering, solution design, and presentation to prospective clients.
- Understand and decipher customer requirements, including hidden and unhidden needs.
- Conduct requirements gathering meetings, workshops, and discussions with clients.
- Develop and present data solutions using cloud platforms such as GCP Big Query, Azure Synapse / ADF / Azure Cloud, Snowflake, Databricks, and Cloudera Big Data CDP platform.
- Create and deliver compelling presentations and demonstrations to clients using PowerPoint and other similar tools.
- Collaborate with sales, engineering, and product teams to develop tailored solutions for clients.
- Maintain strong client relationships and ensure customer satisfaction through effective communication and engagement.
- Stay updated with the latest trends and advancements in big data and cloud technologies.
- Provide technical expertise and guidance to clients and internal teams.
- Participate in industry events, conferences, and seminars to showcase the company’s capabilities and solutions.
Immediate Joiners Preferred
NOTE: Working Shift: 11 am - 8 pm IST (+/- one hour on need basis) Monday to Friday
Responsibilities :
1. Leverage Alteryx to build, maintain, execute and deliver data assets. This entails using data analytics tools (combination of proprietary tools, Excel, and scripting), validating raw data quality, and working with Tableau/ Power BI and other geospatial data visualization applications
2. Analyze large data sets in Alteryx, finding patterns and providing a concise summary
3. Implement, maintain, and troubleshoot analytics solution and derive key insights based on Tableau/ Power BI visualization and data analysis
4. Improve ETL setup and develop components so they can be rapidly deployed and configured
5. Conduct data assessment, perform data quality checks and transform data using SQL and ETL tools
Qualification :
1. 3+ years of relevant and professional work experience with a reputed analytics firm
2. Bachelor's degree in Engineering / Information Technology from a reputed college
3. Must have the knowledge to handle/design/optimize complex ETL using Alteryx
4. Expertise with visualization tools such as Tableau /Power BI to solve a business problem related to data exploration and visualization
5. Good knowledge in handling large amounts of data through SQL, T-SQL or PL-SQL
6. Basic knowledge in Python for data processing will be good to have
7. Very good understanding of data warehousing and data lake concepts
Role - Senior Executive Analytics (BI)
Overview of job -
Our Client is the world’s largest media investment company and are a part of WPP. In fact, we are responsible for one in every three ads you see globally. We are currently looking for a Senior Executive Analytics to join us. In this role, you will be responsible for a massive opportunity to build and be a part of largest performance marketing setup APAC is committed to fostering a culture of diversity and inclusion. Our people are our strength, so we respect and nurture their individual talent and potential.
Reporting of the role - This role reports to the Director - Analytics.
3 best things about the job:
1. Responsible for data & analytics projects and developing data strategies by diving into data and extrapolating insights and providing guidance to clients
2. Build and be a part of a dynamic team
3. Being part of a global organisations with rapid growth opportunities
Responsibilities of the role:
• Design and build Visualization, Dashboard and reports for both Internal and external clients using Tableau, Power BI, Datorama or R Shiny/Python, SQL, Alteryx.
• Work with large data sets via hands-on data processing to produce structured data sets for analysis.
• Good to Have - Build Marketing-Mix and Multi-Touch attribution models using a range of tools, including free and paid.
What you will need:
• Degree in Mathematics, Statistics, Economics, Engineering, Data Science, Computer Science, or quantitative field.
• Proficiency in one or more coding languages – preferred languages: Python, R
• Proficiency in one or more Visualization Tools – Tableau, Datorama, Power BI
• Proficiency in using SQL.
• Minimum 3 years of experience in Marketing/Data Analytics or related field with hands-on experience in building Marketing-Mix and Attribution models is a plus.
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
Exp-Min 10 Years
Location Mumbai
Sal-Nego
Powerbi, Tableau, QlikView,
Solution Architect/Technology Lead – Data Analytics
Role
Looking for Business Intelligence lead (BI Lead) having hands on experience BI tools (Tableau, SAP Business Objects, Financial and Accounting modules, Power BI), SAP integration, and database knowledge including one or more of Azure Synapse/Datafactory, SQL Server, Oracle, cloud-based DB Snowflake. Good knowledge of AI-ML, Python is also expected.
- You will be expected to work closely with our business users. The development will be performed using an Agile methodology which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc.) and XP (continuous integration, refactoring, unit testing, etc) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership, leadership and be able to work well in teams.
- Responsibilities :
- Design, development and support of multiple/hybrid Data sources, data visualization Framework using Power BI, Tableau, SAP Business Objects etc. and using ETL tools, Scripting, Python Scripting etc.
- Implementing DevOps techniques and practices like Continuous Integration, Continuous Deployment, Test Automation, Build Automation and Test-Driven Development to enable the rapid delivery of working code-utilizing tools like Git. Primary Skills
Requirements
- 10+ years working as a hands-on developer in Information Technology across Database, ETL and BI (SAP Business Objects, integration with SAP Financial and Accounting modules, Tableau, Power BI) & prior team management experience
- Tableau/PowerBI integration with SAP and knowledge of SAP modules related to finance is a must
- 3+ years of hands-on development experience in Data Warehousing and Data Processing
- 3+ years of Database development experience with a solid understanding of core database concepts and relational database design, SQL, Performance tuning
- 3+ years of hands-on development experience with Tableau
- 3+ years of Power BI experience including parameterized reports and publishing it on PowerBI Service
- Excellent understanding and practical experience delivering under an Agile methodology
- Ability to work with business users to provide technical support
- Ability to get involved in all the stages of project lifecycle, including analysis, design, development, testing, Good To have Skills
- Experience with other Visualization tools and reporting tools like SAP Business Objects.
Minimum of 8 years of experience of which, 4 years should be of applied data mining
experience in disciplines such as Call Centre Metrics.
Strong experience in advanced statistics and analytics including segmentation, modelling, regression, forecasting etc.
Experience with leading and managing large teams.
Demonstrated pattern of success in using advanced quantitative analytic methods to solve business problems.
Demonstrated experience with Business Intelligence/Data Mining tools to work with
data, investigate anomalies, construct data sets, and build models.
Critical to share details on projects undertaken (preferably on telecom industry)
specifically through analysis from CRM.
We are looking for a savvy Data Engineer to join our growing team of analytics experts.
The hire will be responsible for:
- Expanding and optimizing our data and data pipeline architecture
- Optimizing data flow and collection for cross functional teams.
- Will support our software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.
- Must be self-directed and comfortable supporting the data needs of multiple teams, systems and products.
- Experience with Azure : ADLS, Databricks, Stream Analytics, SQL DW, COSMOS DB, Analysis Services, Azure Functions, Serverless Architecture, ARM Templates
- Experience with relational SQL and NoSQL databases, including Postgres and Cassandra.
- Experience with object-oriented/object function scripting languages: Python, SQL, Scala, Spark-SQL etc.
Nice to have experience with :
- Big data tools: Hadoop, Spark and Kafka
- Data pipeline and workflow management tools: Azkaban, Luigi, Airflow
- Stream-processing systems: Storm
Database : SQL DB
Programming languages : PL/SQL, Spark SQL
Looking for candidates with Data Warehousing experience, strong domain knowledge & experience working as a Technical lead.
The right candidate will be excited by the prospect of optimizing or even re-designing our company's data architecture to support our next generation of products and data initiatives.
- Data Steward :
Data Steward will collaborate and work closely within the group software engineering and business division. Data Steward has overall accountability for the group's / Divisions overall data and reporting posture by responsibly managing data assets, data lineage, and data access, supporting sound data analysis. This role requires focus on data strategy, execution, and support for projects, programs, application enhancements, and production data fixes. Makes well-thought-out decisions on complex or ambiguous data issues and establishes the data stewardship and information management strategy and direction for the group. Effectively communicates to individuals at various levels of the technical and business communities. This individual will become part of the corporate Data Quality and Data management/entity resolution team supporting various systems across the board.
Primary Responsibilities:
- Responsible for data quality and data accuracy across all group/division delivery initiatives.
- Responsible for data analysis, data profiling, data modeling, and data mapping capabilities.
- Responsible for reviewing and governing data queries and DML.
- Accountable for the assessment, delivery, quality, accuracy, and tracking of any production data fixes.
- Accountable for the performance, quality, and alignment to requirements for all data query design and development.
- Responsible for defining standards and best practices for data analysis, modeling, and queries.
- Responsible for understanding end-to-end data flows and identifying data dependencies in support of delivery, release, and change management.
- Responsible for the development and maintenance of an enterprise data dictionary that is aligned to data assets and the business glossary for the group responsible for the definition and maintenance of the group's data landscape including overlays with the technology landscape, end-to-end data flow/transformations, and data lineage.
- Responsible for rationalizing the group's reporting posture through the definition and maintenance of a reporting strategy and roadmap.
- Partners with the data governance team to ensure data solutions adhere to the organization’s data principles and guidelines.
- Owns group's data assets including reports, data warehouse, etc.
- Understand customer business use cases and be able to translate them to technical specifications and vision on how to implement a solution.
- Accountable for defining the performance tuning needs for all group data assets and managing the implementation of those requirements within the context of group initiatives as well as steady-state production.
- Partners with others in test data management and masking strategies and the creation of a reusable test data repository.
- Responsible for solving data-related issues and communicating resolutions with other solution domains.
- Actively and consistently support all efforts to simplify and enhance the Clinical Trial Predication use cases.
- Apply knowledge in analytic and statistical algorithms to help customers explore methods to improve their business.
- Contribute toward analytical research projects through all stages including concept formulation, determination of appropriate statistical methodology, data manipulation, research evaluation, and final research report.
- Visualize and report data findings creatively in a variety of visual formats that appropriately provide insight to the stakeholders.
- Achieve defined project goals within customer deadlines; proactively communicate status and escalate issues as needed.
Additional Responsibilities:
- Strong understanding of the Software Development Life Cycle (SDLC) with Agile Methodologies
- Knowledge and understanding of industry-standard/best practices requirements gathering methodologies.
- Knowledge and understanding of Information Technology systems and software development.
- Experience with data modeling and test data management tools.
- Experience in the data integration project • Good problem solving & decision-making skills.
- Good communication skills within the team, site, and with the customer
Knowledge, Skills and Abilities
- Technical expertise in data architecture principles and design aspects of various DBMS and reporting concepts.
- Solid understanding of key DBMS platforms like SQL Server, Azure SQL
- Results-oriented, diligent, and works with a sense of urgency. Assertive, responsible for his/her own work (self-directed), have a strong affinity for defining work in deliverables, and be willing to commit to deadlines.
- Experience in MDM tools like MS DQ, SAS DM Studio, Tamr, Profisee, Reltio etc.
- Experience in Report and Dashboard development
- Statistical and Machine Learning models
- Python (sklearn, numpy, pandas, genism)
- Nice to Have:
- 1yr of ETL experience
- Natural Language Processing
- Neural networks and Deep learning
- xperience in keras,tensorflow,spacy, nltk, LightGBM python library
Interaction : Frequently interacts with subordinate supervisors.
Education : Bachelor’s degree, preferably in Computer Science, B.E or other quantitative field related to the area of assignment. Professional certification related to the area of assignment may be required
Experience : 7 years of Pharmaceutical /Biotech/life sciences experience, 5 years of Clinical Trials experience and knowledge, Excellent Documentation, Communication, and Presentation Skills including PowerPoint
Certification required-
DP-100/DP-200/AZ-900 Cetification Mandatory
Requirements:
- 3+ years of hands-on experience in Azure Databricks platform .Delta lake, Time travel design patterns. Lambda Data Architecture
- Experience in Azure Cloud Platform. (ADLS, Blob , ADF ).
- Understanding of big data file formats like JSON, Avro, Parquet and other prevalent big data file formats
- Experience with Python, PySpark, Scala, Spark to write data pipelines and data processing layers
- Demonstrate expertise in writing complex, highly-optimized SQL queries across large data sets
- Experience with Data Governance ( Data Quality, Metadata Management, Security, etc.)
- Strong SQL skills and proven experience in working with large datasets and relational databases.
- Understanding Data Warehouse design principles (Tabular, MD).
- Experience in working with big data tools/environment to automate production pipelines
- Familiarity with Azure Synapse and Snowflake
- Experience with data visual analysis and BI tools (matplotlib and Power BI)