Architect - Data Modeler

Anlage Infotech (India) P Ltd; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Anlage Infotech (India) P Ltd is seeking a senior Data Modeler with 10+ years of experience to design scalable data models using dimensional modelling, Medallion Architecture, and Databricks. You will lead data modeling and data engineering efforts, ensure data quality, and document architecture and analysis artifacts.

The role emphasizes mentoring teams and delivering business-driven data solutions across source to reporting layers, with remote work flexibility.

Qualifications

• 10+ years of data modelling experience.
• Knowledge of business process flow and architectural diagram creation.
• Knowledge of ingesting datasets from source to Silver and reporting layers as per project needs.
• Knowledge of DBKS Workspace, cluster details for the current PBNA Datalake and access request process.
• Knowledge and experience on medallion architecture, table normalisation techniques and dimensional modelling.
• Hands-on experience with at least 1 data modelling tool.
• Hands-on experience in data engineering using pyspark, ASQL and Databricks.
• Strong SQL and data analysis skills.
• Data quality and profiling.
• Ability to document standards deliverables such as STTM, data models, analysis docs, and UAT tests.

Responsibilities

• Lead and mentor Data Modeling and Data Engineering teams while delivering business-driven data solutions.
• Create architectural diagrams and maintain documentation including STTM and analysis artifacts.
• Ensure end-to-end data ingestion and governance across source to reporting layers.

Skills

Data modelling

PySpark

SQL

ASQL

Databricks

Medallion architecture

Dimensional modelling

Data quality

Data profiling

Documentation

Team mentorship

Tools

Databricks Workspace

DBKS Workspace

Cluster management

Data modeling tools

Job description

Techno functional role. Specific contribution expected from the role:

Data Modeler with 10+ years of experience in designing scalable data models using dimensional modeling, normalization techniques, and Medallion Architecture, with expertise in PySpark, SQL, ASQL, Databricks, data quality, profiling, and end-to-end data ingestion from source to reporting layers. Strong experience in business process mapping, architectural diagram creation, Databricks workspace and cluster management, data modeling tools, and documentation including STTM, data models, analysis documents, and UAT test cases/results. Knowledge of AI-driven productivity tools, data governance (data lineage, metadata management), and CPG domain, with the ability to lead and mentor Data Modeling and Data Engineering teams while delivering business-driven data solutions.

Location: Remote. Shift Timing: Normal (Day Shift)

Must have

• 1. Have 10+ years of data modelling experience.
• 2. Knowledge on Business process flow and architectural diagram creation.
• 3. Knowledge of the process to ingest any particular dataset from source to Silver and then till population in various Reporting layer/format as per the project needs.
• 4. Knowledge of DBKS Workspace, cluster details for the current PBNA Datalake and their access request process.
• 5. Knowledge and experience on medallion architecture, table normalisation techniques and dimensional modelling
• 6. Hands on experience on at least 1 data modelling tool.
• 7. Hands on experience in Data engineering using pyspark , ASQL and Databricks.
• 8. Strong SQL and data analysis skills.
• 9. Data quality and profiling.
• 10. Ability to document all standards deliverables of a data modeller such as STTM, data models, Analysis documents, UAT test cases and results.
• 11. Knowledge and understanding on AI and its uses for productivity improvement

Skill Set

Data Modeler,SQL,PySpark