The Senior BI Consultant provides expertise in the design, development and operation of subject matter areas and associated reports contained within the enterprise data warehouse as well as other data sources. Engages with operations teams to understand and translate business requirements into operational designs for business intelligence projects. Support the development of productive relationships with non-IT staff performing BI-related activities and management, operational and other reporting activities. Continually align BI and reporting project requirements to broader IT strategies and architectures. Maintain technical competency, participate in vendor and customer meetings and assist in advancing the Business Intelligence services. Drive continuous improvements to keep BI architecture and solutions aligned with current and future business needs.
Main accountabilities:
- Must have an extensive knowledge of data warehouse and data mart concepts or/and “In memory” analytics and other data storage technologies (i.e. Qlik View Data Files QVD)
- Develops conceptual and logical data models for building effective decision support systems.
- Translate conceptual design specifications in close collaboration with business owners, and design and develop BI solutions.
- Capture business, technical and operational requirements and create / communicate business intelligence options (ETLs, cubes, analytics).
- Data Modelling and Enterprise Data Warehouse Design and Operation. Developing and testing programs to extract, cleanse, transform and load from source systems into Data Warehouse or/and other data technologies (i.e. “In Memory”, QVD etc.)
- Serving as application administrator for ETL/BI tools.
- Building Management, Operational, and ad hoc reports.
- Develop quality control measures, testing measures, and the accuracy of data standards to support deployment of solutions for the business.
- Responsible for gathering and assessing business information needs and preparing data and reporting requirements. Performs analysis, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation.
- Reviews and validates data loaded into the data warehouse for accuracy.
- Provides technical consulting to users and advises them on conflicts and inappropriate data usage
- Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modelling for data warehouses.
You will be working in the Business Intelligence (BI) Consulting Team in Krakow and Katowice. We are a team of experienced BI experts who are passionate about integrating, analyzing and visualizing data to provide valuable insights to the customers.
So far, we delivered number of solutions based on various technologies such as: QlikView/Qlik Sense, Microsoft BI (SSRS, SSIS), Power BI, SAP Business Objects and Service Now – Performance Analytics.
Candidate’s profile:
- Ability to think objectively and make sound business and technical decisions
- Ability to motivate and inspire an BI/Analytics other team members
- Effective business communication and presentation skills
- Flexibility, strong interpersonal, analytical, technical and problem solving attributes
- Understands the IT environment well and specializations within IT and relationship building with customers to meet their needs
- Expertise in data modelling, data integration (i.e. SSIS) and Reporting tools
- Candidates with ITIL processes experience would be preferred
- Candidates with ServiceNow Performance Analytics experience would be preferred
Requirements:
Required Experience: 4-5 years
Four years of Data Warehousing and BI Analysis experience including Data Analysis, Report Writing and Data Warehouse Development experience.
- Work history of successful software/BI Solution design and utilization of latest technologies in Microsoft Visual Studio and SQL Server Business Intelligence Studio; Microsoft’s SQL server and Windows Server environment; SSRS; SSIS
- Experience in above MS BI technologies or/and other BI Tools (SAS, Cognos, Oracle BI, Qlik View/Sense, PowerBI etc.) is also welcome
- ServiceNow Performance Analytics would be an asset.
Atmosphere
- Working with great people and in legendary atmosphere
- No formal dress code
- Annual family picnics
- Unforgettable integrational events
- Employee volunteering opportunities and interesting CSR projects
- We value and respect diversity in terms of gender, nationality, roles, age, interests
- Internal celebration initiatives: Children\'s Day, St. Nicholas Day and many more
- Supporting employees\' hobbies: Business Run, e-sport games, basketball, volleyball
Development
- Development in expert or leader competencies
- Broad training offer with possible co-funding
- Access to Harvard Business Review knowledge base
- Introduction plan for new employees and Buddy Initiative
- A wide range of instructor-led and e-learning trainings
- Co-financing for post-graduate studies and courses
- Many companies under one roof / internal headhunters
- Internal development events: conferences, meetings, communities
Capgemini is one of leading global companies offering consulting and IT technologies.
The Cloud is fashionable – everyone’s talking about it, many use it, but only few know what it consists of, how it works, how to access it, and how to take care of it. It is us, Cloud Infrastructure Services, who understand the subject thoroughly. From high level services, through managing equipment and operating systems, internal or access networks to managing applications, IT operations, availability, configurations, and changes. By working in an international environment, we use a number of foreign languages.