
Datavail Infotech
1 week ago
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 timeAbout 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 timeAbout 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 timeJob 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 timeRole 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 timeJob 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 timeTitle : 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...