Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)
Skills
Data Modeling
Data Governance
Data Quality
Data Warehouse
ER/Studio
ERwin
SQL
Snow Flake Schema
XML
JSON
Job Details
The following requirement is open with our client.
Title : Data Modeler
Location : Dallas, TX (Onsite)
Duration : 12+ Months
Rate : Open
Visa Status : H1B/ EAD
Relevant Experience (in Yrs.) : 10+
Job Description:
- Design scalable data models optimized for Snowflake's cloud-native architecture, including use of virtual warehouses, clustering keys, and materialized views.
- Develop conceptual, logical, and physical data models that align with financial regulatory requirements (e.g., Basel III, SOX, GDPR).
- Collaborate with data engineers and architects to implement models that support real-time analytics, fraud detection, and risk management.
- Ensure data quality and consistency across diverse financial systems such as trading platforms, customer onboarding, and compliance tools.
- Integrate structured and semi-structured data (e.g., JSON, XML) using Snowflake's native capabilities to support complex financial reporting.
- Document data lineage and metadata to support auditability and transparency for internal and external stakeholders.
- Optimize data storage and query performance using Snowflake-specific features like automatic clustering and query profiling.
- Support data governance initiatives by aligning models with enterprise data catalogs, stewardship policies, and access controls.
- Collaborate with business analysts and compliance teams to translate financial reporting needs into robust data structures.
- Continuously refine models based on evolving financial products, market conditions, and regulatory changes.
Technical Skills
- Proficiency in designing conceptual, logical, and physical data models.
- Strong SQL skills and experience with Snowflake-specific features (e.g., Snowpipe, Streams, Tasks, Time Travel).
- Familiarity with data modeling tools (e.g., ER/Studio, ERwin, dbt, or similar).
- Understanding of data warehousing principles, dimensional Modeling, and normalization techniques.
- Experience integrating structured and semi-structured data (e.g., JSON, XML) in Snowflake.
Must Have Skills
- SQL
- Data Modeling tools (e.g., ER/Studio, Erwin, dbt)
- Snowflake
Thanks & regards,
Shireesha Thanniru
Technical Recruiter
ASCII Group, LLC Website: ;/strong>
38345 W 10 Mile Rd, Suite 365, Farmington, MI 48335, US
Office: Email:
LinkedIn :
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.