Datavail Infotech

1 week ago


Mumbai, 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)
  • Datavail Infotech

    1 week ago


    Mumbai, 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 delivering innovative technology solutions. As an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), and a partner with Oracle and MySQL, we...

  • Datavail Infotech

    1 week ago


    Mumbai, India Datavail Full time

    About the Role :We are seeking a highly skilled Data Architect with proven expertise in designing, implementing, and optimizing enterprise-scale data solutions leveraging Azure Databricks, Snowflake, and modern data engineering frameworks. The ideal candidate will combine deep technical proficiency with strong architectural vision to drive robust, scalable,...

  • Datavail Infotech

    6 days ago


    Mumbai, India Datavail Full time

    Job Title : PostgreSQL Database Administrator.Education : Any Graduation.Experience : 8+years.Location : Skills : - PostgreSQL Open Source and EDB PostgreSQL.- AWS, Microsoft Azure and GCP PostgreSQL.- Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni and pg_repack.Job Description : - 7+ years of relevant Experience.- Good knowledge of...


  • Mumbai, Maharashtra, India Datavail Full time

    Role Overview : We are seeking an experienced Principal Consultant - Oracle Cloud Financials to lead end-to-end implementations and provide functional expertise across Oracle ERP Cloud Financials modules. This role requires strong business acumen in finance, hands-on Oracle Cloud ERP experience, and the ability to drive successful client engagements through...


  • Mumbai, Maharashtra, India Datavail Full time

    Job Title : AI Architect. Location : Hyd/Mum/Bang. Exp Level : 15+. Education : Any Dgree. Job Summary :- Scope out, design and oversee the architecture of AI and machine learning solutions across products and platforms for our clients.- Collaborate with team members to translate business requirements into AI-enabled solutions at either a Roadmap, Proof of...


  • Mumbai, Maharashtra, India Datavail Full time

    Title : Oracle Cloud EPM ESSBASE Consultant. Location : : 8+ Years. Position Summary : We are looking for an experienced Oracle Hyperion Infra + Functional Techno-Admin who can manage Hyperion infrastructure while also having functional/technical & Migration knowledge of Hyperion applications. The role combines environment administration, performance...