Designs and maintains SQL Server star-schema data warehouses, SSIS ETL pipelines, and SSAS semantic models for financial reporting. Integrates data models with Power BI, implements SCD logic, row-level security, KPI calculations, and data quality controls. Produces technical documentation covering data models, ETL, lineage, security, and operating procedures. Requires strong T-SQL, data warehousing, performance tuning, and Microsoft BI experience, with finance-domain knowledge and stakeholder communication skills preferred.
Location: Mumbai
Experience: 2–4Years
Employment Type: Full-time
Position Overview:
We are seeking a hands-on Sr. Database Engineer with deep expertise in the Microsoft data and BI ecosystem to join our team for a strategic finance data warehousing and reporting engagement. The role focuses on designing and building a star-schema data warehouse on Microsoft SQL Server, developing high-performance ETL pipelines using SSIS, constructing SSAS semantic models, and integrating these with Power BI for enterprise-grade financial reporting.
The ideal candidate has worked on similar on-premises Microsoft BI implementations and is comfortable owning the full data pipeline from source extraction to semantic layer delivery.
Key Responsibilities:
- Design, build, and maintain a star-schema data warehouse on SQL Server with fact and dimension tables for each finance domain.
- Implement SCD Type 1 and Type 2 dimension maintenance logic with a master data change notification mechanism.
- Build and maintain SSAS tabular/multidimensional models as the centralized semantic layer with KPI calculations and business rules.
- Integrate the semantic layer with Power BI datasets; support Power BI report development team with data model optimization.
- Implement row-level security (RLS) aligned to report recipient groups; maintain the role-entity mapping table independently.
- Embed data quality measures in the data warehouse: uniqueness, completeness, validity, and integrity checks.
- Create comprehensive technical documentation: data model, ETL flows, data lineage, KPI calculations, RLS design, and operating manuals.
Required Qualifications & Experience:
- 2–4 years of hands-on experience with Microsoft SQL Server including database design, performance tuning, and administration.
- Strong hands-on experience developing and managing SSIS packages for complex ETL pipelines – scheduling, error handling, logging, incremental loads.
- Proven experience building SSAS tabular or multidimensional models; semantic layer design with centralized KPI definitions and business rules.
- Deep expertise in star/snowflake schema data warehouse design with fact and dimension tables, SCD Type 1/2 implementations.
- Experience integrating SSAS/SQL Server data models with Power BI; and Power BI dataset design.
- Strong proficiency in advanced T-SQL – stored procedures, views, CTEs, window functions, query performance tuning.
- Experience implementing row-level security (RLS) in SQL Server and/or Power BI.
- Experience with data quality frameworks – building validation checks, reconciliation logic, and data integrity monitoring.
Preferred / Bonus Skills:
- Experience with Oracle Fusion ERP data extraction
- Familiarity with Zebra BI visuals within Power BI
- Experience with SharePoint list-based collaboration and commenting integrations.
- Awareness of Power BI Service application deployment, bookmarks, drill-down/drill-up navigation, and guided navigation patterns.
- Finance domain knowledge – General Ledger, AP, AR, Treasury, Revenue reporting cycles.
- Microsoft certifications (DP-500, PL-300, or equivalent).
Soft Skills & Expectations:
- Excellent communication skills – able to engage with finance stakeholders and translate business requirements into technical data models.
- Strong documentation skills – ability to produce clear technical documentation, operating manuals, and data dictionaries.
- Ownership mindset – comfortable taking end-to-end responsibility for data pipeline delivery.
- Comfortable working in a rapid phased delivery engagement
Oneture Technologies Mumbai, Maharashtra, IND Office
Mumbai, India
Similar Jobs
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Develop scalable backend payment software and cloud-native applications. Responsibilities include designing, coding, testing, deploying, and documenting solutions; participating in prioritization; reviewing code and automation; driving quality and technology standards; collaborating with product stakeholders; mentoring engineers; and improving development processes. The role focuses on Java, Spring Boot, DevOps, Oracle, automation testing, and secure financial transaction systems.
Top Skills:
Automation TestingCloud ComputingDevOpsJavaOracleSpring Boot
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Owns production readiness and lifecycle operations for payment platform services. Responsibilities include improving CI/CD pipelines, DevOps automation, monitoring, capacity planning, incident response, postmortems, resiliency, deployment gating, root-cause analysis, and operational risk management. Partners with development, product, and operations teams to improve reliability and customer experience while mentoring junior engineers.
Top Skills:
ArtifactoryBitbucketChefCi/CdDb2DevOpsGitJavaJenkinsMavenOracleSQLUnix
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Build and maintain petabyte-scale data pipelines, entity-centric data models, and distributed workflows using Databricks and Spark. Partner with data science teams to productionize ML features and artifacts, optimize ETL/ELT processes, and implement testing, monitoring, observability, and incident response. Collaborate with governance and operations teams to ensure secure, compliant data management while supporting scalable merchant identity and trust-profile systems.
Top Skills:
SparkAWSCi/CdDatabricksGCPPythonSQL
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
