BI Developer (SSIS and SSAS)

7 Months ago • 5 Years +

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

Games For Love - Esports Streamer

Games For Love

Lynnwood, Washington, United States (Remote)
11 Months ago
Zeeco, Inc. - Senior Designer (Mechanical Draftsman)

Zeeco, Inc.

Mumbai, Maharashtra, India (On-Site)
7 Months ago
caliogo - JIRA Administrator

caliogo

Hyderabad, Telangana, India (On-Site)
3 Months ago
Crowd Strick - Director, Alliances Partnership Southern Europe

Crowd Strick

(Remote)
1 Month ago
Evolution  - Regulatory Compliance Specialist

Evolution

St. Julian's, Malta (On-Site)
7 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Penumbrainc - Benefits Program Manager

Penumbrainc

Alameda, California, United States (On-Site)
8 Months ago
Sailpoint - Staff Angular Engineer

Sailpoint

Austin, Texas, United States (On-Site)
1 Month ago
Evolution  - In Studio Game Presenter

Evolution

Atlantic City, New Jersey, United States (On-Site)
5 Months ago
TransUnion - Senior Workday Consultant, HRIS Advisor

TransUnion

Chicago, Illinois, United States (Hybrid)
1 Month ago
NinjaVan - B2B Account Manager

NinjaVan

Makati City, Metro Manila, Philippines (Hybrid)
8 Months ago
Capgemini - Remote Desktop Support

Capgemini

Bengaluru, Karnataka, India (Remote)
1 Month ago
Qualcomm - Building Maintenance Services Engineer

Qualcomm

Bengaluru, Karnataka, India (On-Site)
1 Month ago
PhonePe - Area Sales Manager

PhonePe

Shivpuri, Madhya Pradesh, India (On-Site)
1 Month ago
frames store - Animator - Short Term - Mid & Snr

frames store

Melbourne, Victoria, Australia (Hybrid)
1 Month ago
Zinnia - Executive Business Partner (Sales and Revenue)

Zinnia

Greenwich, Connecticut, United States (Hybrid)
2 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Gurugram, Haryana, India

Roblox - Data Scientist

Roblox

Gurugram, India (On-Site)
2 Weeks ago
Insight Software - Senior Software Engineer (C#.net, SQL)

Insight Software

Hyderabad, Telangana, India (On-Site)
1 Month ago
clevertap - Animator

clevertap

Mumbai, Maharashtra, India (Hybrid)
3 Weeks ago
Demandbase - Software Engineer 2 (Data Platform)

Demandbase

Hyderabad, Telangana, India (On-Site)
1 Month ago
Capgemini - ORACLE DBA

Capgemini

Bengaluru, Karnataka, India (On-Site)
2 Months ago
AiDash - Software Development Engineer III - iOS

AiDash

Bengaluru, Karnataka, India (Hybrid)
2 Weeks ago
Green gold animation - VFX Modeling Artist

Green gold animation

Hyderabad, Telangana, India (On-Site)
2 Months ago
Nagarro - Senior Staff Engineer, Delivery

Nagarro

Gurugram, Haryana, India (On-Site)
8 Months ago
Cubic corporation - Senior Security Operations Engineer

Cubic corporation

Hyderabad, Telangana, India (On-Site)
2 Weeks ago
Capgemini - FW with NAND development

Capgemini

Bengaluru, Karnataka, India (On-Site)
1 Month ago

Get notifed when new similar jobs are uploaded

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

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