BI Developer (SSIS and SSAS)

Luxoft India

7 years

0 Lacs

Gurugram Haryana India

Posted:2 weeks ago| Platform:

Apply

Skills Required

developer sql server integration analysis data reporting database management stack development support planning risk drive design technology architecture prioritization estimation documentation powerbi mdx git jenkins power tableau azure agile devops dax scheduling analytics aws redshift compensation diversity

Work Mode

On-site

Job Type

Full Time

Job Description

About the Company: 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: Provide technical expertise to the team. Delivery results based on requirements set by the team lead. Provide oversight for the quality of the application and artifacts related to the application analysis and development. Collaborate with the production support team to implement sound change planning and change management. Be proactive in uncovering risk, manage and drive risks and issues understanding business impact. Strive for Best Practice in design and development. Contribute to the technology strategic agenda by driving application architecture simplicity and by minimizing production incidents through high quality development and processes. Be an active participant in regular task elaboration, prioritization and estimation workshops. Ensure Documentation is up-to-date and relevant. Build effective relationships with key Business Stakeholders. Qualifications: 7+ years of hands-on experience in BI development with a focus on SSIS and SSAS. Required Skills: Familiarity with all aspects of SDLC. Detailed experience with SQL Server, Analysis Services, Integration Services, Reporting Services (SSRS and PowerBI), and MDX queries for Cubes. Experience in SSAS multi-cube. Excellent system design skills in a SQL Server Business Intelligence. Experienced with Source control - GIT, Jenkins. Preferred Skills: 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. Pay range and compensation package: Not specified. Equal Opportunity Statement: Include a statement on commitment to diversity and inclusivity. Show more Show less