Lead Data Modeler

Lead Data Modeler - Microsoft Fabric

As the Lead Data Modeler, this individual will play a crucial role partnering to shape data architecture and drive data modeling best practices within the organization. The ideal candidate will work closely with cross-functional teams to understand business requirements and translate them into efficient and scalable data models using Microsoft Fabric technologies.

This role is open to C2C and 1099 resources.

Work from home (WFH) on US Eastern time zone.

Responsibilities:

Analyze, Design and Implement Data Models:

• Analyze legacy and recent data usage across applications.

• Develop conceptual, logical, and physical data models.

• Implement relational, dimensional databases.

• Create data models optimized across different data domains.

• Optimize models for data query performance using best practices.

Collaboration:

Work with business analysts, data architects, data administrators and database & BI developers.

Provide technical leadership and mentorship to data modelers and other team members, fostering a culture of continuous learning and improvement.

Translate enterprise requirements into effective data models.

Be a thought leader. Stay updated on industry trends and emerging technologies related to data modeling and Microsoft Fabric, recommending innovative solutions to enhance existing data architecture.

Standards and Best Practices:

• Implement data governance policies and standards to ensure data quality, integrity, and security within the Microsoft Fabric environment.

Define, review and document data modeling and design standards.

Hands-On Expertise:

Perform hands-on modeling, design, configuration, development, and performance

tuning.

Work proactively to address project requirements.

Qualifications:

Bachelor's degree in computer engineering, computer science, information systems, or a related field.

8+ years in data analytics, data modeling, or data architecture.

Proficiency in data modeling for transactional, operational reporting, and analytical solutions (EDW, Data Lake).

Experienced with Dimensional Modeling and Data Warehouse Modeling.

Experience using data modeling tools (e.g., IDERA Data Architect, Erwin).

Knowledge of SQL and its use in data access and analysis.

Experience in remodeling and/or re-platforming of legacy application databases.

Knowledge of cloud-based databases (e.g., Azure/Fabric).

Exposure to data architecture implementation on Azure/Fabric preferred.

Certifications in Microsoft Fabric or related technologies are a plus.

Excellent communication, problem-solving, organizational, and analytical skills.

Ability to work independently and collaboratively.