BI Consultant Job Description
BI Consultant Duties & Responsibilities
To write an effective BI consultant job description, begin by listing detailed duties, responsibilities and expectations. We have included BI consultant job description templates that you can modify and use.
Sample responsibilities for this position include:
BI Consultant Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for BI Consultant
List any licenses or certifications required by the position: SAP, BI, ITIL, SQL, BOE, MS, HANA, AI, BW, PL200
Education for BI Consultant
Typically a job would require a certain level of education.
Employers hiring for the BI consultant job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Business, Technical, Education, Information Technology, Statistics, Engineering, Economics, Mathematics, Finance
Skills for BI Consultant
Desired skills for BI consultant include:
Desired experience for BI consultant includes:
BI Consultant Examples
BI Consultant Job Description
- Data Integration between the SuccessFactors Modules
- Implementation and testing of change requests to the BI solution
- Development of premium reports of varying complexity
- Preparation and updating of technical requirements and specifications
- Use of MDX for multidimensional queries and measures
- Use of APIs and (SOAP) web services – including the SuccessFactors API
- Design and implementation of data integrations using our cloud-based middleware platform
- Conduct on-site employee meetings in a manner that is interesting and informative to the audience
- Meet individually with employees on-site to assist them in enrolling in the retirement plan, completing retirement account transactions answer questions related to the participant website
- Coordinate own travel arrangements and meeting logistics with clients
- Business Intelligence development experience and programming experience
- University graduate (Bachelor degree), secondary school when relevant experience
- Comfortable with information technology, systems and data
- Basic understanding of relevant area principles is advantage
- Sense of responsibility and willingness to learn new systems and processes
- Actively leverage relevant sources of information (websites, analyst reports, webinars, win/loss reports, ) for useful market intelligence
BI Consultant Job Description
- Serve as a trainer / coach junior resources on SFDC functionality, Integration and migration tools and error handling
- Capable of understanding task requirements clearly and implement independently
- Design and implement data migration and conversion processes for medium and large scale Enterprise Transformation Projects
- Assess ETL processes performance, recommend improvements and fine tuning
- Create data visualizations (analytic overviews, dashboards )
- Design solutions and validate the development of integration processes using Informatica PowerCenter, Teradata, SAS
- Participate in presales activities in the projects delivery
- Gather requirements for business analysis from end users and document the same
- Understand business objectives for the use of multi-source data sets, conduct analyses and document the same
- Work with a team of developers (front-end and back-end software engineers), business or digital strategist(s), business analyst(s), user experience designer(s), testers and project manager(s)
- 3 or more years of experience working with SAS business analytic software
- 1 or more years of experience working with Tableau software, developing dashboards, stories and data visualizations
- Demonstrated experience with development of data models, including predictive models
- Familiarity with First Data Bank or Medispan drug classification systems
- Familiarity with CMS Star Ratings
- ETL Certified
BI Consultant Job Description
- Participate in the design, development, and implementation of end to end Business Intelligence and Analytics solutions (ETL, DW, Cubes, KPIs, Dashboards, Presentation, Self-service reports etc)
- Supporting business with timely Data warehouse solutions using SSIS, SQL, Azure, Master Data Services
- Rationalize and identify use cases for developing data visualization solutions, including identifying different personas and the data sets relevant for each use case
- Develop data models, data shaping logic and data visualizations using Excel, PowerPivot, Power BI and other data software and tools
- Publish and support roll out of Power BI, Tableau and Excel solutions as part of project deliverables
- BI/ Analytics - Consulting with business stakeholders
- Work with Data Architect to design data structures for stakeholders
- Data research and analytics
- Daily support and maintenance of our existing systems to ensure business continuity
- Interact with users to ensure optimal usage of SAP BI functionality seen in relation to needs
- BI solution design and implementation experience using technologies like Microstrategy, QlikView, Cognos, Oracle, Informatica, SSIS
- Possibilities of professional growth and education/trainings
- Motivating salary including excellent employee benefits package
- Perspective job in the international company and projects
- Must have 4+ overall years experience on various Integration/ Migration Projects
- Expertise in multiple Integration & Migration tool like Informatica Powercenter ,Informatica Cloud, Boomi, Cast iron, Mulesoft, Jitterbit Should expose himself as SME in Integration & Migration tools
BI Consultant Job Description
- Becoming a subject matter expert for data management within the SunGard Services team
- Partner with Product Management to build out further capabilities to support BI such as data platforms, process automation capabilities and standardized reporting templates
- Gather requirements from stakeholders and advise on appropriate technical solutions
- Plan out the work required to deliver a project in Alteryx
- Develop and maintain workflows in Alteryx Designer and Alteryx Server, plus other data preparation and visualisation tools
- Deliver knowledge transfer and training to the client
- Work on R&D side projects individually or as part of a team
- Definition of strategy, business case, roadmap to implement Business Intelligence and analytics solutions
- Defining KPIs, analysis trails, reports and dashboards relating to different business functions
- User requirements gathering, design, modelling & implementation of leading Business Intelligence solutions in an agile environment
- Solid knowledge of of the leading RDBMS platforms
- Knowledge of of column oriented RDBMS platform
- Extensive knowledge of leading ETL platforms
- Ability to navigate and work productivity in a large corporate IT environment
- Collaboration with colleagues located around the globe
- Ability to work collaboratively and across distant timezones
BI Consultant Job Description
- Conducting workshops to gain consensus and alignment of senior stakeholders in client business and IS organizations
- Translating business needs to BI functionality and communicating and collaborating with technical and services delivery teams to design and implement technical and operational architectures
- Helping design and implement technical and operational architectures with appropriate reviews
- Facilitating user acceptance testing and solution implementation sign off
- Conducting user change management and end user training
- Overall program management, issue resolution and leading teams with multiple skills
- You will work in an international team together with BI Architects to deliver the High Value BI/Analytics solutions, based on the best practices
- Function as a technical SME
- Creates, develops and reviews the logical data model ensuring the logical designs comply with standards, guidelines, and procedures
- Data extracts, queries, and automating processes/tasks, creating reports, scorecards and dashboards
- Availability to serve weekend days on rotation
- Minimum of 2+ years experience in IT Consulting
- Technical background in data science/ analytics
- Formulate and track work plans and delivery milestones in line with client expectations
- Apply extensive and deep knowledge to provide guidance and insight during project solution definition activities, from ideation through explore, to ensure strategic alignment and best practice adherence
- Assess Business Unit/Function needs clearly eliciting, translating, and documenting requirements in the form of user stories