- 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.
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.
- Working in a close-knit team and a friendly atmosphere
- Development of expert or leader competences
- Bonuses, including those for recommending new employees
- A wide range of training and co-financing of courses
- Additional life insurance
- Attractive package of additional benefits (fitness, gym, cinema, etc.) you chose what you want
- Integration events and joint celebrations
- Possibility to work from home
- Employee volunteering opportunities and interesting CSR projects
- Disability inclusion, assistive technologies, reasonable accommodations
- Private medical care, also for your family
- Bicycle parking and carpooling
Capgemini is one of leading global companies offering consulting, IT technologies.
The Cloud is fashionable - everyone’s talking about it, many use it, but few knows 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.