BI Developer (SSIS and SSAS)

4 Months ago • 5 Years + • Data Analyst

Job Summary

Job Description

This BI Developer role requires 5+ years of experience in SSIS and SSAS. Responsibilities include designing, developing, and maintaining ETL processes using SSIS; creating and managing OLAP cubes and data models using SSAS; collaborating with stakeholders; developing and optimizing SQL queries; ensuring scalability and performance; creating documentation; and working with version control. The ideal candidate will have strong SQL, data modeling, and problem-solving skills, along with excellent communication abilities. The role involves data integration, analysis, reporting, and troubleshooting production BI systems.
Must have:
  • 5+ years SSIS/SSAS experience
  • ETL development expertise
  • Advanced SSAS knowledge
  • Strong T-SQL skills
  • Proficient in data modeling
  • Excellent problem-solving skills
  • Strong communication skills
Good to have:
  • Power BI or Tableau experience
  • Azure Data Factory knowledge
  • Agile/DevOps familiarity
  • MDX/DAX knowledge
  • Job scheduling experience
  • Cloud BI solution experience (Azure Synapse, AWS Redshift)
  • Financial data reporting knowledge

Job Details

Project description

We are looking for experienced BI Developers with strong expertise in SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services) to join our team. You will work on developing, implementing, and optimizing Business Intelligence solutions for our clients, contributing to data integration, analysis, and reporting requirements. The role demands a deep understanding of database management, data warehousing concepts, and hands-on experience with the Microsoft BI Stack.

Responsibilities

Design, develop, and maintain ETL processes using SSIS to support data integration and transformation requirements.

Create and manage OLAP cubes and data models using SSAS for multidimensional and tabular models.

Collaborate with business analysts, stakeholders, and end users to gather requirements and translate them into technical solutions.

Develop and optimize complex SQL queries, stored procedures, and functions for data extraction, transformation, and loading.

Ensure the scalability and performance of BI solutions by monitoring, troubleshooting, and fine-tuning the architecture.

Create and maintain documentation related to BI solutions, including technical specifications, data flows, and user guides.

Work with version control systems to manage and deploy code effectively.

Ensure the integrity and accuracy of data pipelines and solutions by implementing robust testing and validation processes.

Provide support and troubleshooting for production BI systems as needed.

Skills

Must have

5+ years of hands-on experience in BI development with a focus on SSIS and SSAS.

ETL Development: Proven expertise in designing and implementing ETL workflows using SSIS.

SSAS Expertise: Advanced experience in creating and managing OLAP cubes, tabular models, and DAX queries.

SQL Skills: Strong knowledge of T-SQL, query optimization, and performance tuning.

Data Modeling: Proficiency in dimensional modeling, star schema, and snowflake schema design.

Problem-Solving: Strong analytical skills to troubleshoot and resolve issues in BI processes and data pipelines.

Communication: Excellent verbal and written communication skills to collaborate with stakeholders and team members effectively.

Nice to have

Experience with other BI tools such as Power BI or Tableau.

Knowledge of data warehousing concepts and technologies (e.g., Azure Data Factory, Snowflake, or Google BigQuery).

Familiarity with Agile methodologies and DevOps practices for CI/CD in BI development.

Knowledge of MDX (Multidimensional Expressions) and DAX (Data Analysis Expressions).

Experience in automating and scheduling jobs using SQL Server Agent or third-party tools.

Exposure to cloud-based BI solutions like Azure Synapse Analytics or AWS Redshift.

Understanding of financial data and reporting requirements.

Other

Languages

English: B2 Upper Intermediate

Seniority

Senior

Similar Jobs

Inworld AI - Staff Platform Engineer, MLOps

Inworld AI

Mountain View, California, United States (Hybrid)
5 Days ago
Ubisoft - Public Cloud Administrator

Ubisoft

Saint-Mandé, Île-de-France, France (Hybrid)
2 Days ago
PwC - IN-Senior Associate _.Net Developer _Data & Analytics _Advisory _PAN India

PwC

Kolkata, West Bengal, India (On-Site)
6 Months ago
Playtika - PHP Developer

Playtika

Poland (Hybrid)
5 Months ago
SparkCognition - Senior Software Engineer (Frontend)

SparkCognition

Bengaluru, Karnataka, India (On-Site)
7 Months ago
Hawk Eye Innovations - Sports Data Quality Specialist

Hawk Eye Innovations

Sofia, Sofia City Province, Bulgaria (On-Site)
4 Weeks ago
Assystems - Data Owner H/F

Assystems

Courbevoie, Île-de-France, France (On-Site)
5 Months ago
Nielsen Holdings - ETL (AWS Glue)/Informatica-Redshift ,Java ,SQL

Nielsen Holdings

Bengaluru, Karnataka, India (Hybrid)
6 Months ago
The Walt Disney Company - Principal Software Engineer - Ad Platform

The Walt Disney Company

Santa Monica, California, United States (On-Site)
1 Week ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Wargaming - DevOps Engineer

Wargaming

Nicosia, Nicosia, Cyprus (On-Site)
4 Months ago
Info Stretch - Java Developer

Info Stretch

Sunderland, England, United Kingdom (On-Site)
6 Months ago
ION - Cloud Engineer/Architect (DevOps)

ION

Italy (On-Site)
6 Months ago
Sony Interactive Entertainment - Senior Cloud Security Engineer

Sony Interactive Entertainment

Tokyo, Japan (On-Site)
4 Months ago
The Walt Disney Company - Software Engineer II

The Walt Disney Company

Seattle, Washington, United States (On-Site)
1 Week ago
NCR Atleos - PS Engineer III

NCR Atleos

Hyderabad, Telangana, India (On-Site)
7 Months ago
Sony Interactive Entertainment - Developer Experience Engineer (PlayStation™Network Server Platform Development)

Sony Interactive Entertainment

Tokyo, Japan (On-Site)
2 Weeks ago
CI Games  - Automation Engineer

CI Games

England, United Kingdom (Remote)
3 Weeks ago
Ajmera Infotech - Site Reliability Engineer (SRE) - Kubernetes

Ajmera Infotech

Austin, Texas, United States (On-Site)
2 Months ago
Evolution - QA Automation Engineer

Evolution

Tallinn, Harju County, Estonia (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Gurugram, Haryana, India

STAGE - CS Intern

STAGE

Noida, Uttar Pradesh, India (On-Site)
3 Months ago
Cyara - Product Owner

Cyara

Hyderabad, Telangana, India (Hybrid)
4 Months ago
Assystems - Mechnanical Engineer

Assystems

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Google - Web Solutions Engineer

Google

Bengaluru, Karnataka, India (On-Site)
1 Week ago
Google - Service Delivery Manager, Ads Content Operations

Google

Bengaluru, Karnataka, India (On-Site)
6 Days ago
Kwalee - DevOps Engineer

Kwalee

Bengaluru, Karnataka, India (On-Site)
2 Months ago
Wind River Systems - Field Application Engineer (Automotive)

Wind River Systems

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Google - ASIC Design for Testability Engineer, Silicon

Google

Bengaluru, Karnataka, India (On-Site)
1 Week ago
Microsoft - Principal Software Engineer - Android/iOS

Microsoft

Bengaluru, Karnataka, India (On-Site)
1 Week ago
Blue Yonder - Expert Support Engineer - Cloud

Blue Yonder

Bengaluru, Karnataka, India (On-Site)
7 Months ago

Get notifed when new similar jobs are uploaded

Data Analyst Jobs

Homa games - Senior Data Scientist

Homa games

Île-de-France, France (On-Site)
1 Week ago
Google - Analytical Lead, Large Customer Sales

Google

Buenos Aires, Buenos Aires, Argentina (On-Site)
1 Week ago
Google - Senior Product Data Scientist, Google Education

Google

Mexico City, Mexico City, Mexico (On-Site)
6 Days ago
Microsoft - Senior Data Scientist

Microsoft

(On-Site)
1 Week ago
Google - Analytical Lead, Apps and Fintech, Large Customer Sales

Google

Guangdong Province, China (On-Site)
1 Week ago
PwC - IN_Senior Associate _GCP Developer _Data &Analytics _Advisory  _Ahmedabad

PwC

Ahmedabad, Gujarat, India (On-Site)
6 Months ago
PwC - Senior Associate_Hadoop Developer_Advisory Corporate_Advisory_Bangalore Millenia

PwC

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Kwalee - Ad Monetization Analyst

Kwalee

Royal Leamington Spa, England, United Kingdom (On-Site)
1 Month ago
Canva - Lead Data Scientist - ANZ Remote

Canva

Melbourne, Victoria, Australia (Remote)
2 Weeks ago
PwC - IN_Manager_Data Migration Lead_Data & Analytics_Advisory_PAN India

PwC

Kolkata, West Bengal, India (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded

About The Company

Luxoft, a DXC Technology Company (NYSE: DXC), is a digital strategy and software engineering firm providing bespoke technology solutions that drive business change for customers the world over. Acquired by U.S. company DXC Technology in 2019, Luxoft is a global operation in 44 cities and 21 countries with an international, agile workforce of nearly 18,000 people. It combines a unique blend of engineering excellence and deep industry expertise, helping over 425 global clients innovate in the areas of automotive, financial services, travel and hospitality, healthcare, life sciences, media and telecommunications.

DXC Technology is a leading Fortune 500 IT services company which helps global companies run their mission critical systems. Together, DXC and Luxoft offer a differentiated customer-value proposition for digital transformation by combining Luxoft’s front-end digital capabilities with DXC’s expertise in IT modernization and integration. Follow our profile for regular updates and insights into technology and business needs.

Poland, Ohio, United States (Remote)

Kraków, Lesser Poland Voivodeship, Poland (On-Site)

Wrocław, Lower Silesian Voivodeship, Poland (On-Site)

Ukrainka, Kyiv Oblast, Ukraine (Remote)

Bengaluru, Karnataka, India (On-Site)

Mississauga, Ontario, Canada (On-Site)

Toronto, Ontario, Canada (On-Site)

Poland, Ohio, United States (Remote)

Pune, Maharashtra, India (On-Site)

View All Jobs

Get notified when new jobs are added by Luxoft

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug