Data Architect

• Tools: ERWin, PowerDesigner, SQL Server Modeling, dbt semantic models.

• Strong SQL, stored procedures, normalization/denormalization strategies.

• Dimensional modelling for BI (Star/Snowflake).

• Data vault modeling for large-scale ingestion.

• Develops conceptual, logical, and physical models.

• Designs models for AMI (interval, event, register), CIS, Billing.

• Supports model versioning, metadata management, data dictionaries.

• Works closely with Data Architect, Dev teams, and Business SMEs.

Salary Range: $100,000-$135,000 a year

#LI-CM2