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
Never miss an opportunity! Create an alert based on the job you applied for.