MUMBAI · FULLTIME
Database - Sr. Database Engineer - Microsoft BI Stack (SSIS/SSAS)
ONETICK TECHNOLOGIES
Mumbai · onsite · Posted 27d ago
Sourced from
Undisclosed2–4 yrsfulltimeMumbai
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.7s
- Found the form on Naukri · 14 questions to answer1.4s
- Decided the answers for all of them2.2s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Sr. Database Engineer Microsoft BI Stack (SSIS/SSAS)
2-4 years
Navi Mumbai
Full-Time
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
Required Skills
SSIS SSAS SQL Server
Disclaimer: This job posting and location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Section · 02
Skills
data qualitydata extractionData lineageApplication DeploymentDatabase Designdata warehouseBusiness Requirementsdata modelsError HandlingAPdeploymentERPCommunication SkillsData WarehousingAdministrationETL PipelinesETL
Section · Company
About ONETICK TECHNOLOGIES
ONETICK TECHNOLOGIES
Software Product
35
employees
2014
12 years old
Faridabad
IN
₹4.5L PA avg
Avg at ONETICK TECHNOLOGIES
About
Onetick Technologies offers IT services that transform businesses digitally, focusing on web solutions and software applications to enhance operational efficiency.
Industries
Software Product
Employee ratings
10 reviews
4.2/ 5
Culture
4.2
Career growth
4.1
Work-life
4.1
Employees rate it well for
Skill Development43Company Culture42
Find them on