Job Summary:
SIRITECH SOLUTIONS CORP is seeking an experienced Data Modeler Engineer to design and implement enterprise-grade data models supporting large-scale Snowflake and Data Warehouse modernization initiatives within a banking environment. The role requires hands-on experience in data modeling and collaboration with various stakeholders to ensure data quality and alignment with business requirements.
Responsibilities:
• Design and implement enterprise logical and physical data models for scalable data platforms
• Define enterprise data modeling standards, structures, and best practices supporting Snowflake environments
• Conduct impact analysis and ensure model alignment with business and reporting requirements
• Engineer conceptual, logical, and physical ER models for enterprise-grade data platforms
• Design high-performance data warehouse schemas including Star and Snowflake schemas for analytics optimization
• Develop and optimize Fact and Dimension tables supporting reporting and BI workloads
• Apply dimensional modeling techniques including Kimball methodology and Data Vault 2.0 architecture
• Support Snowflake data modeling, clustering, query optimization, and performance tuning activities
• Utilize advanced SQL for data transformation, validation, and query optimization
• Collaborate with ETL teams to design scalable and efficient enterprise data pipelines
• Ensure enterprise data integrity, governance, metadata management, and data quality standards
• Translate business requirements into scalable, future-ready enterprise data models
• Design end-to-end Data Warehouse architecture across staging, core, and presentation/BI layers
• Support enterprise modernization and data warehouse optimization initiatives
• Collaborate with business teams, architects, ETL developers, and stakeholders on enterprise data strategies
• Maintain enterprise modeling documentation, standards, and governance practices
• Support performance tuning and scalable data platform improvements
• Ensure alignment between business needs, enterprise architecture, and reporting requirements
Qualifications:
Required:
• Minimum 810+ years of strong hands-on Data Modeling and Data Warehouse experience required
• Strong expertise in enterprise data modeling and ER modeling concepts
• Strong Snowflake experience including architecture, clustering, and performance tuning
• Advanced SQL skills supporting transformations, validations, and query optimization
• Strong understanding of SAS for data analysis and business logic interpretation
• Experience with ETL concepts, Data Warehousing, and scalable data pipeline design
• Experience designing Star and Snowflake schemas for reporting and analytics workloads
• Expertise in Dimensional Modeling (Kimball) and Data Vault 2.0 methodologies
• Strong experience developing Fact and Dimension tables for enterprise reporting systems
• Experience supporting enterprise data governance, integrity, and metadata management
Preferred:
• Experience supporting Snowflake modernization and enterprise analytics initiatives preferred
• Strong enterprise architecture, performance optimization, and stakeholder collaboration experience preferred
• Experience translating business requirements into scalable enterprise data solutions preferred
Company:
SiritechSolutions Corp (“Siritech”) is an IT professional services firm providing expertise to empower clients’ businesses. Founded in 2023, the company is headquartered in Tampa, Florida, US, , with a team of 51-200 employees. The company is currently Growth Stage.