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

Innoactive - Software Engineer (.NET)

Innoactive

(Remote)
1 Month ago
plana technologies - Senior Angular Engineer

plana technologies

(Remote)
21 Hours ago
Epic Games - Data Analyst - CorpTech Analytics

Epic Games

Cary, North Carolina, United States (On-Site)
1 Month ago
Trackman - Senior Android Developer - Mobile Golf

Trackman

Hørsholm, Denmark (On-Site)
1 Month ago
ION - Cloud Engineer Kubernetes

ION

Collecchio, Emilia-Romagna, Italy (Hybrid)
6 Months ago
RoofStack - Data Architect

RoofStack

İstanbul, İstanbul, Türkiye (Remote)
4 Months ago
Voodoo - Senior Data Engineer (Ad networks - Core)

Voodoo

Paris, Île-de-France, France (Hybrid)
2 Months ago
PwC - IN-Senior Associate_Power BI_Data & Analytics_Advisory_Mumbai

PwC

Mumbai, Maharashtra, India (On-Site)
6 Months ago
Google - Senior Data Scientist, Research

Google

New York, New York, United States (On-Site)
2 Days ago
OUTFIT7 - Marketing Data Scientist

OUTFIT7

Ljubljana, Ljubljana, Slovenia (On-Site)
1 Month ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Evolution - CI/CD (DevOps) Engineer

Evolution

Riga, Latvia (On-Site)
4 Months ago
N-iX - Senior DevOps Engineer

N-iX

India (Remote)
2 Months ago
Offworld - DevOps Engineer

Offworld

New Westminster, British Columbia, Canada (On-Site)
1 Month ago
Sumo Logic - Senior Software Engineer II, UI (Data Collection)

Sumo Logic

(Remote)
22 Hours ago
Varaha - Senior Frontend Developer

Varaha

Bengaluru, Karnataka, India (On-Site)
7 Months ago
Playrix - Senior Unity Software Engineer (Gameplay)

Playrix

Ukraine (Remote)
6 Months ago
InnoPhase IoT - Python Build Automation Developer/ DevOps Engineer

InnoPhase IoT

Bengaluru, Karnataka, India (On-Site)
1 Day ago
Hedra - Lead Product Engineer

Hedra

San Francisco, California, United States (On-Site)
1 Month ago
Playrix - Senior QA Automation Engineer (Mobile)

Playrix

Georgia (Remote)
6 Months ago
AppZen - Golang Developer

AppZen

Pune, Maharashtra, India (Hybrid)
4 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Gurugram, Haryana, India

Envestnet,  Inc  - Senior Engineer - QA

Envestnet, Inc

Thiruvananthapuram, Kerala, India (On-Site)
9 Months ago
Unisys - Senior Principal Presales Solution Architect

Unisys

Bengaluru, Karnataka, India (On-Site)
18 Hours ago
Jellyfish - Senior Design Manager

Jellyfish

Mumbai, Maharashtra, India (Hybrid)
6 Days ago
Hashlist - Product Manager

Hashlist

Pune, Maharashtra, India (Hybrid)
6 Months ago
Paytm - Area Sales Manager - Executive Manager - Transit Offline-Railways

Paytm

Ahmedabad, Gujarat, India (On-Site)
4 Months ago
Google - Application Engineering Manager, Workday Platform

Google

Hyderabad, Telangana, India (On-Site)
2 Weeks ago
Maersk Careers - Elixir Software Engineer

Maersk Careers

Bengaluru, Karnataka, India (Remote)
1 Month ago
Google - Staff Software Engineer, Google Cloud Business Platforms

Google

Bengaluru, Karnataka, India (On-Site)
2 Days ago
Saama Technologies,  Inc  - Senior Software Engineer 1

Saama Technologies, Inc

Chennai, Tamil Nadu, India (On-Site)
4 Months ago
Cyara - Senior Salesforce Admin

Cyara

Hyderabad, Telangana, India (Hybrid)
3 Months ago

Get notifed when new similar jobs are uploaded

Data Analyst Jobs

Luxoft - Senior Data Ops Engineer

Luxoft

Bengaluru, Karnataka, India (On-Site)
5 Months ago
Google - Data Scientist III, Product, Consent and Transparency

Google

San Francisco, California, United States (On-Site)
1 Week ago
Tesla - SQL Database Optimization Engineer

Tesla

Athens, Greece (On-Site)
2 Months ago
Next Level Business Services - Senior Data Engineer

Next Level Business Services

Erie, Pennsylvania, United States (On-Site)
6 Months ago
GoTo Group - Senior Manager Data Engineering

GoTo Group

Singapore (On-Site)
6 Months ago
Netflix - Senior Data Scientist (L5), Games

Netflix

United States (Remote)
2 Weeks ago
Google - Technical Program Manager, Analytics, Energy and Location Strategy

Google

Kirkland, Washington, United States (On-Site)
2 Days ago
Universal Music - Manager, Financial & Business Analytics, Bilingual (English/Spanish)

Universal Music

Miami Beach, Florida, United States (On-Site)
1 Month ago
N-iX - Senior Data Engineer

N-iX

Kyiv, Kyiv City, Ukraine (Hybrid)
2 Weeks ago
Playrix - Senior Data Analyst (Game)

Playrix

Almaty, Almaty Region, Kazakhstan (Remote)
6 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