Infotech - Senior Technical Specialist - Data Warehousing

4 weeks ago

Mumbai, Maharashtra, India Datavail Full time

About Us :

Datavail is a leading provider of data management, application development, analytics, and cloud services, with over 1,000 professionals enabling clients to design, build, and manage applications and data through a world-class tech-enabled delivery platform. With 17+ years of industry expertise, Datavail partners with AWS, Microsoft, Oracle, and MySQL to deliver enterprise-grade solutions across industries.

Role Overview :

We are seeking a Senior Technical Specialist with deep expertise in the Microsoft Business Intelligence (MSBI) stack, including SSIS, SSRS, and SSAS. The ideal candidate will have a proven track record in designing, developing, tuning, and maintaining enterprise BI solutions, with strong SQL/T-SQL skills and the ability to lead technical initiatives in a client-facing role.

Key Responsibilities :


BI Solution Development & Implementation :

- Design, develop, and deploy SSIS ETL packages for efficient, accurate, and secure data movement between source systems, staging areas, and data warehouses.

- Build and enhance SSRS reports and SSAS cubes (MOLAP/ROLAP) to support analytical and reporting needs.

- Create and optimize complex SQL and T-SQL queries, stored procedures, and functions for performance, scalability, and maintainability.

- Implement data integration strategies aligned with business requirements and technical best practices.

Performance Optimization & Troubleshooting :


- Perform SQL/T-SQL performance tuning and optimization for large datasets and high-volume transactions.

- Debug, tune, and refactor SSIS/ETL processes for optimal performance.

- Triage production issues, perform root cause analysis, and deploy code fixes with minimal downtime.

Data Architecture & Warehousing :

- Collaborate with Data Architecture teams to define and enhance data mart and data warehouse structures supporting BI applications.

- Assist in extending existing warehouse systems to accommodate new analytical requirements.

- Apply data warehousing best practices for data modeling, metadata management, and data governance.

Stakeholder Collaboration & Leadership :

- Engage with business users to translate functional requirements into technical specifications for BI solutions.

- Provide technical guidance, mentorship, and training to development teams and end users.

- Document solution architectures, coding standards, and best practices to ensure maintainability and scalability.

Required Skills & Qualifications :


Core Expertise :

- 812 years of experience with MSBI tools SSIS, SSRS, and SSAS (mandatory).

- Advanced SQL/T-SQL development and performance tuning skills.

- Proven experience in data warehouse design and ETL processes.

- Strong knowledge of MDX and multidimensional modeling.

Development & Delivery :

- Hands-on experience in building complex BI applications from scratch.

- Expertise in implementing data integration pipelines and dashboard/reporting solutions.

- Agile/Scrum development experience preferred.

Additional Skills (Good to Have) :

- Experience with Power BI or other visualization tools.

- Knowledge of Python/PySpark for advanced data processing.

- Familiarity with Azure Data Services (Azure SQL, Data Factory, Synapse).

Soft Skills :

- Strong analytical and problem-solving skills.

- Excellent verbal and written communication.

- Client-facing experience with the ability to manage stakeholder expectations.

- Self-motivated, independent, and proactive. (ref:hirist.tech)

  • Senior Data Migration Specialist

    5 days ago

    Mumbai, Maharashtra, India beBeeDataMigration Full time ₹ 25,00,000 - ₹ 35,00,000

    Job TitleThe primary role of the Senior Data Migration Specialist is to oversee the technical aspects of implementing data pipeline migration requirements.Main ResponsibilitiesEngage directly with stakeholders to gather key performance indicators and business needs.Possess comprehensive knowledge of functional and technical impact analysis, as well as...

  • Senior Data Specialist

    2 days ago

    Mumbai, Maharashtra, India beBeeData Full time US$ 90,000 - US$ 1,20,000

    Job Title: Senior Data SpecialistWe are seeking a highly skilled Data Specialist to join our team.Job Description:The successful candidate will be responsible for designing and implementing scalable data pipelines using various tools such as Fabric, Pyspark notebooks, Spark SQL, and Python. They will work closely with the data engineering team to ensure that...

  • Data Warehousing Lead Position

    4 days ago

    Navi Mumbai, Maharashtra, India beBeeDataWarehousing Full time ₹ 9,00,000 - ₹ 12,00,000

    Job DescriptionWe are seeking an experienced Data Warehousing Professional to lead our team. As a DWH Tech Lead, you will be responsible for designing and implementing data warehousing solutions.Responsibilities:Design and implement ETL processes using ODI/Informatica/Data Stage/Pentaho and other real-time replication tools like Golden Gate.Develop and...

  • Part-Time Data Warehousing Technology Lead

    4 days ago

    Navi Mumbai, Maharashtra, India beBeeDataWarehousing Full time ₹ 25,00,000 - ₹ 30,00,000

    Job OpportunityA part-time Data Warehousing Technology Lead position requires a strong background in data warehousing, ETL tools, and big data technologies. As a Technology Lead, you will oversee the development and implementation of data warehousing solutions.Key Responsibilities:Design and implement data warehousing architecturesLead cross-functional teams...

  • Senior Technical Specialist

    2 days ago

    Mumbai, Maharashtra, India beBeeTechnical Full time ₹ 15,00,000 - ₹ 25,00,000

    Job Title: Senior Technical SpecialistAbout the Role:We are seeking a highly skilled and experienced technical professional to join our team as a Senior Technical Specialist. The ideal candidate will have a strong background in software maintenance, support, and deployment, with expertise in Empower and other CDS systems.Key Responsibilities:Maintain and...

  • Business Intelligence and Data Warehousing Solutions Specialist

    2 days ago

    Mumbai, Maharashtra, India beBeeData Full time ₹ 10,00,000 - ₹ 25,00,000

    Job Opportunity OverviewKey Highlights:2-8 years of IT experience in Business Intelligence and Data warehousing solutions using OBIEE/OAC/OAS Knowledge of Analysis Design, Development, Customization, Implementation & Maintenance of OBIEE/OAS/OAC ResponsibilitiesThe ideal candidate will have 3-8 years of experience in the development and implementation of...

  • 3i Infotech

    11 hours ago

    Mumbai, Maharashtra, India 3i Infotech Limited Full time

    Position : Presales Solution Architect Digital Infrastructure Management Services (DIMS)Experience : 5-6 YearsJob Summary : We are seeking a highly skilled and dynamic Presales Solution Architect with 5-6 years of overall experience in IT infrastructure, including at least 3+ years in solutioning or technical pre-sales. The ideal candidate combines...

  • Brainvire Infotech

    4 weeks ago

    Mumbai, Maharashtra, India Brainvire Infotech Pvt. Ltd. Full time

    Job Description : Designation : Senior Software Engineer Full StackWhat you will do in this role : Full Stack development with expertise in ASP.NET, Angular, WebAPI, C#, and SQL.- Front-End Development : Design and develop dynamic and responsive user interfaces using Angular. Implement modern front-end technologies and best practices to ensure high...

  • Technical Support Consultant

    3 days ago

    Mumbai, Maharashtra, India ITC Infotech Full time

    Job Opportunity Support Consultant at ITC Infotech Location: Mumbai Experience Required: 3-5 Years Job Type: Full-Time Notice period: Immediate to 30 days only.Job Description: Support Consultant – Mumbai Location Role: L1.5 Support Consultant Responsibilities Provide first-level technical support and troubleshooting for applications built with...

  • Business Intelligence Developer with Expertise in Data Warehousing

    5 days ago

    Mumbai, Maharashtra, India beBeeDataWarehousing Full time ₹ 12,00,000 - ₹ 18,00,000

    Job Summary:We are seeking an experienced Business Intelligence developer to join our team. The ideal candidate will have a strong background in data warehousing, business intelligence tools, and software development.Key Responsibilities:Implement end-to-end Business Objects projectsDevelop expertise in data modeling, ETL tool management, and SQL...