Sr. Data Modeler – OLAP / Erwin / ER Studio / SQL

Sr. Data Modeler OLAP / Erwin / ER Studio / SQL Location: McLean, VA (5 Days Onsite) Interview: Video Type: Contract Rate: (Cliff Services W2) Client Domain: Leading Banking & Financial Services Institution Experience: Minimum 8 Years Required Relocation: Candidates Willing to Relocate are Welcome Visa: All Visa Types Welcome About The Role We are seeking a Senior Data Modeler with deep expertise in OLAP architecture and enterprise data modeling tools to join a high-impact data team within a leading banking and financial services environment. The ideal candidate brings strong hands-on experience with Erwin and ER/Studio, a solid command of SQL, and excellent communication skills to effectively collaborate with business stakeholders, data architects, and engineering teams. This is a fully onsite role requiring daily presence at the McLean, VA office. Candidates willing to relocate to the McLean, VA area are encouraged to apply. Key Responsibilities • Design, develop, and maintain conceptual, logical, and physical data models for enterprise banking and financial services data domains • Architect and implement OLAP-based data structures including star schemas, snowflake schemas, and data marts to support business intelligence and reporting requirements • Use Erwin Data Modeler and ER/Studio as primary tools for creating, managing, and versioning enterprise data models • Collaborate with data architects, business analysts, and downstream consumers to understand data requirements and translate them into accurate and scalable data models • Develop and maintain data dictionaries, data lineage documentation, and metadata repositories • Work closely with ETL/ELT teams to ensure data models are implemented accurately in the data warehouse and downstream systems • Perform impact analysis for data model changes and communicate implications to technical and business stakeholders • Enforce data modeling standards, naming conventions, and best practices across the organization • Conduct model reviews and provide guidance and feedback to junior data modelers and analysts • Ensure data models comply with banking regulatory requirements, data governance policies, and security standards • Participate in Agile/Scrum ceremonies including sprint planning, backlog grooming, and reviews • Produce clear and concise technical documentation, presentations, and model specifications for both technical and non-technical audiences Required Qualifications • Minimum 8 years of hands-on experience in data modeling within large-scale enterprise environments • Strong expertise in OLAP architecture including star schema, snowflake schema, and dimensional modeling concepts • Hands-on proficiency with Erwin Data Modeler conceptual, logical, and physical model development • Hands-on proficiency with ER/Studio for enterprise data model design and management • Strong SQL skills for data validation, querying, and model verification across relational databases • Experience working in banking, financial services, or other heavily regulated industries • Excellent verbal and written communication skills ability to present complex data concepts clearly to both technical and business audiences • Strong understanding of data warehousing concepts, data governance, and metadata management • Experience collaborating across cross-functional teams including data engineering, BI, and business stakeholders Preferred Qualifications • Experience with cloud-based data platforms such as Snowflake, Redshift, or Azure Synapse • Familiarity with data governance tools such as Collibra, Alation, or IBM IGC • Knowledge of banking data domains including retail banking, lending, risk, compliance, or finance • Exposure to Agile delivery methodologies and sprint-based project execution • Experience with data lineage and cataloging tools Please share Resume at gurudeepthi.g@gmail.com