Jobs

Scholarships

Courses

Companies

Placements

Community

Home >

Jobs >

BI Developer (SSIS and SSAS)

Haryana, India (On-site)

BI Developer (SSIS and SSAS)

2 Weeks ago • 5 Years + • Data Analyst

About the job

8 skills required for this role

Test your skills to join the top 1% applicants for this job

ci-cd

azure

aws

sql

tableau

power-bi

business-intelligence

scalability

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

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

View Full Job Description

Upload your resume, increase your shortlisting chances by 80%

About The Company

Luxoft

1148 Active Jobs

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.