Job Summary:
We are seeking an experienced and results-driven Senior BI & Data Warehouse Specialist for our clients in India.
Job Requirements:
Design, implement, maintain, and optimize data warehouse architecture and BI solutions.
Manage and support BI platforms (ETL/data integration, reporting, analytics) across multiple tools and environments — including but not limited to SAS, MicroStrategy, SAP Business Objects, Cognos, and IBM DataStage, ensuring high availability and performance.
Lead data migrations, environment upgrades and system maintenance activities while managing user access, permissions, and security.
Perform ETL / data-integration tasks, data mapping, data cleansing, transformation, and loading from multiple data sources (on-premise and cloud).
Optimize query performance and data models (e.g. star / snowflake schemas, dimensional modeling) for efficient storage and retrieval.
Collaborate with business stakeholders (from domains such as Telecom, Retail, Banking) to gather requirements, translate business needs into technical specifications, and deliver reporting/data-analytics solutions.
Develop, maintain, and optimize reports, dashboards, and data visualizations for stakeholders to drive business decision-making.
Ensure data quality, governance, and security across data pipelines and BI systems; maintain documentation for data models, ETL processes, metadata, and system configurations.
Provide production-support, troubleshoot issues, perform root-cause analysis for data/BI issues, and implement corrective actions as needed.
Mentor junior team members, share best practices, and contribute to continuous improvement of BI/data warehousing processes and standards.
Qualifications:
10 + years of experience in BI, Data Warehouse, and ETL environments — administering, supporting, and optimizing enterprise-scale BI/ DWH systems.
Strong hands-on experience with BI platforms such as SAS, MicroStrategy, SAP Business Objects, Cognos, DataStage (or similar).
Expertise in relational databases (e.g. SQL Server, Oracle Database) with deep knowledge of SQL, query optimization, stored procedures, and performance tuning.
Proven experience in data modeling, dimensional modeling (star/snowflake schemas), data warehousing architecture, ETL/data integration, data migration, and data governance.
Experience working in domains such as Telecom, Retail, or Banking — ability to understand domain-specific data requirements and deliver relevant BI solutions.
Exposure to cloud environments (e.g. AWS or other cloud-based data services) — understanding cloud-based data warehousing, scalability, and associated best practices.
Strong analytical, problem-solving and troubleshooting skills.
Excellent communication and stakeholder-management skills — ability to translate business requirements into technical solutions and present data insights clearly to non-technical stakeholders.
Important Notice:
Just Jobify does not require personally identifiable information (PII data) such as ID card details, driver's license details, passport number etc. We only require a means to contact you, such as your mobile number or email address. Please upload CV/resume without PII data.
Full Time