The Senior Consultant designs and develops ETL processes, manages data models, and collaborates with teams to deliver BI solutions and dashboards.
The Senior Consultant designs, models, maintains and develops ETL/Integration processes leveraging different technologies and techniques, analysis and dashboards. The Senior Consultant interacts with technical administration as expert-level problem solver and develop job skills and knowledge to introduce new techniques and technologies within the company and to perform assignments of increasing complexity. Senior Consultant is also responsible for coordinating all efforts needed to successfully implement the requirements/projects. The senior consultant will be able to develop an end to end solution from gather and transform the data to model and create the front end solution to deliver to end users.
Responsibilities
Understand the values and vision of the organization and align the activities accordingly
Protect the Intellectual Property
Adhere to all the policies and procedures
Work with other line functions to collect or provide relevant data
Establishing the needs of users and monitoring user access and security
Maintains both back-end organization of data and front-end accessibility for end-users
Maintaining data standards, including adherence to the Data Protection Act
Writing documentation, including standards, procedures and definitions for the data dictionary (metadata)
Controlling access permissions and privileges, developing, managing and testing security models
Working closely with IT project managers, functional users and other BI and Functional developers
Communicating regularly with technical, applications and operational staff
Design and implement data model to support reporting needs
Develop ETL processes |flows
Develop analysis and dashboards
Essential Skills
Job
Excellent written and verbal communication, coding skills are essential
Must be proficient in customer relationship management
Must be familiar with the main data manipulation languages and the principles of DWH design
Must understand be updated with latest developments in IT
Must have knowledge of database theory, database design, excellent SQL knowledge is a must
Must have expert level knowledge on BI/Integration tools such as ODI 11g/12c and OBIEE 12c
Must be dynamic, flexible and possess perseverance skills
Exhibit reactiveness and constructiveness at work such as suggesting innovative and pragmatic solutions
Utilize secondary research sources and techniques
Personal
Should have understanding of business objectives and organization structure
The candidate must have strong work ethics and trustworthiness
The candidate should possess attention to detail and also maintain confidentiality and integrity
Must be highly collaborative and be a team player with commitment to excellence
Ability to work under pressure to achieve the multiple daily deadlines for client deliverables with a mature approach
Preferred Skills
Job
Must be proficient in Microsoft Office
Experience with Oracle Cloud BI and ETL tools is a plus: Oracle Integration Cloud, Oracle Analytics Cloud, Business Intelligence Cloud Service, DataSync,BI Cloud Connector Console
Experience with BI Apps and Cloud sources is preferred
Self-motivated, fast learner with the ability to operate independently
The candidate must be a highly versatile thinker who can assimilate knowledge and has understanding across different industries, products, technologies, disciplines etc.
Personal
Demonstrate proactive thinking
Should have strong interpersonal relations and business acumen
Negotiation and persuasion skills are required to work with partners and implement changes
Have the ability to work under stringent deadlines and demanding client conditions
A very inquisitive mind that can factor in several variables acting on the situation
About Us
The Hackett Group (NASDAQ: HCKT) is an intellectual property-based strategic consultancy and leading enterprise benchmarking firm to global companies, offering digital transformation including implementation of leading enterprise cloud applications, workflow automation and analytics that enable digital world class performance.
Top Skills
Bi Cloud Connector Console
Business Intelligence Cloud Service
Datasync
ETL
Obiee 12C
Odi 11G
Odi 12C
Oracle Analytics Cloud
Oracle Cloud Bi
Oracle Integration Cloud
SQL
Similar Jobs
Consulting
The Senior Consultant will design and implement scalable data warehouse and BI solutions on Azure, drive Power BI development, oversee ETL pipelines, ensure data quality, and act as a trusted advisor for BI strategy while collaborating with stakeholders.
Top Skills:
Azure Data WarehouseAzure Synapse AnalyticsBig Data TechnologiesEltETLPower BIPowershellPythonShellSQL
Cloud • Information Technology • Productivity • Software • Automation
The Revenue Analytics Engineer will design and maintain analytics solutions for revenue reporting, focusing on subscription metrics and ensuring data quality and technical implementation.
Top Skills:
DbtPower BISalesforceSnowflakeSQL
Cloud • Information Technology • Productivity • Software • Automation
As a Senior ServiceNow CRM Developer/Administrator, you will lead the design and implementation of CRM solutions, manage platform governance, and mentor junior developers while ensuring optimal service delivery.
Top Skills:
CSSFlow DesignerGlide ApiHTMLIntegration HubJavaScriptRestServicenowSoapXML
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

