Data Architech

Qloron Pvt Ltd; Maharashtra; Vor Ort; INR 1.800.000 - 3.000.000; Vollzeit

Zusammenfassung

Qloron Pvt Ltd in Maharashtra, India seeks an experienced Data Architect / SQL Server Data Engineer to design an on-premises, SQL-first Medallion Architecture (Bronze, Silver, Gold) and govern ingestion for a greenfield NetSuite ERP using SuiteAnalytics Connect and SuiteQL.

You will build T-SQL frameworks for data quality, survivorship and matching within the Silver layer, model Kimball-style dimensional models (Star/Snowflake), optimize Power BI semantic models, and balance SSIS pipelines with

Qualifikationen

• Experience designing and enforcing an on-premises SQL-first Medallion Architecture (Bronze, Silver, Gold).
• Proven ability to migrate legacy ERP historical data and integrate with cloud ERP data.
• Strong knowledge of NetSuite data model, SuiteAnalytics Connect, SuiteQL, and ODBC drivers.

Aufgaben

• Design and enforce a robust ingestion framework with metadata-driven approaches.
• Develop T-SQL frameworks for data quality, matching, and survivorship in the Silver layer.
• Model Kimball-style dimensional models (Star/Snowflake) for reporting/analytics.
• Balance SSIS pipelines with hybrid SaaS platforms like Fivetran within strict security boundaries.

Kenntnisse

Data architecture

SQL Server

ETL/ELT

Power BI

SuiteAnalytics Connect

SuiteQL

T-SQL

Data quality

Data modeling

Security

Tools

SQL Server 2025 Standard Edition

SuiteAnalytics Connect

SuiteQL

T-SQL

SSIS

Fivetran

Power BI Service

Gateway (On-Premises)

Jobbeschreibung

QT-MA-09-746
We are looking for an experienced Data Architect / SQL Server Data Engineer to design and enforce an on-premises SQL-first Medallion Architecture (Bronze, Silver, Gold) using SQL Server 2025 Standard Edition. The role will focus on building robust, metadata-driven ingestion frameworks for a greenfield NetSuite ERP, leveraging SuiteAnalytics Connect and SuiteQL, with particular emphasis on engineering reliable hard-delete detection mechanisms. The candidate will develop custom T-SQL frameworks for data quality, matching, and survivorship within the Silver layer to address the deprecation of Microsoft DQS and MDS, while designing Kimball-style dimensional models, including Star and Snowflake schemas, optimized for downstream reporting and analytics through Power BI Service and the Enterprise On-Premises Data Gateway. The role also requires evaluating and implementing high-volume ingestion solutions, balancing metadata-driven SSIS pipelines with hybrid SaaS platforms such as Fivetran, while operating within strict network security boundaries. The ideal candidate should have expert knowledge of SQL Server internal architecture, including Resource Governor, temporal tables, and columnstore indexes for analytical workloads on Standard Edition, along with proven experience migrating legacy ERP historical data and integrating it with new cloud ERP operational data in an on-premises data warehouse. Strong knowledge of the NetSuite data model, ODBC drivers, SuiteAnalytics Connect, and connection concurrency limits is required, as well as mastery of Power BI semantic model design, DAX, Row-Level Security (RLS), and gateway capacity planning. The candidate should also have strong experience designing automated, idempotent ETL/ELT frameworks that clearly separate extraction logic from business transformations and ensure reliable, maintainable, and scalable data pipelines.