Snowflake Data Modeller/dba Jobs in Open Hall, Newfoundland and Labrador, Canada
Create alert for “Snowflake Data Modeller/DBA”
Open Hall, Newfoundland and Labrador, Canada
You've reached the end
Try refining your search for more options
Snowflake Data Modeller/DBA
About the role
Job Category: Developer
Job Type: Full Time
Job Location: Remote
Job status: Open
Job Description
About xCroTek
xCroTek is a product- and service-based AI software company that builds innovative, AI-powered solutions to drive intelligent automation and digital transformation. We specialize in creating scalable, impactful technologies for modern businesses.
Job Overview
We are seeking an experienced Snowflake Data Modeler/Architect to design, optimize, and implement enterprise data models that support advanced analytics and reporting needs. The ideal candidate will have strong expertise in data modeling techniques, Slowly Changing Dimensions (SCD Type 2), Change Data Capture (CDC) in Snowflake, and SQL performance tuning. This role also involves hands-on use of data modeling tools (ERWIN or similar) and the creation of detailed data mapping documents for integration teams.
Key Responsibilities
Design, implement, and maintain conceptual, logical, and physical data models in Snowflake. Apply advanced data modeling techniques (e.g., normalization, denormalization, star/snowflake schemas, data vault modeling). Implement and optimize SCD Type 2 and Snowflake CDC patterns for historical data tracking and incremental processing. Work closely with data engineers, BI developers, and integration teams to define data mapping documents, transformation logic, and business rules. Utilize ERWIN (or similar modeling solutions) to document and manage enterprise data models. Conduct SQL performance tuning and ensure scalable query execution on large data volumes. Collaborate with business stakeholders to translate functional requirements into technical data models. Define and enforce data modeling standards, best practices, and governance across projects. Support integration teams with clear metadata, lineage, and documentation for ETL/ELT pipelines. Provide architectural guidance for data warehouse/lakehouse solutions in Snowflake.
Required Skills
1-5 years of experience in data modeling, architecture, and enterprise data warehouse design. Hands-on expertise with Snowflake (warehouses, schema design, CDC, performance tuning). Proficiency in SQL (complex queries, optimization, and debugging). Strong knowledge of SCD Type 2 implementations and change data capture methodologies. Experience with ERWIN or equivalent data modeling tools. Proven ability to create data mapping documents and transformation rules for integration teams. Deep understanding of data warehouse and dimensional modeling concepts. Strong analytical, problem-solving, and communication skills.
Preferred Qualifications
Experience with ETL/ELT tools (Informatica, dbt, Matillion, Talend, etc.). Exposure to cloud integration platforms (Azure Data Factory, AWS Glue, GCP Data Fusion). Familiarity with data governance, data quality, and master data management (MDM). Experience in agile delivery environments.
How To Apply
Interested candidates should submit their resume and a brief cover letter explaining their interest in the role to hr@xcrotek.com. Please include “Snowflake Data Modeller/DBA” in the subject line.
Apply with a one-page cover letter and CV to hr@xcrotek.com
SHARE THIS INSIGHT
Copied!
Not the right fit? Search for Snowflake Data Modeller/DBA jobs in Open Hall, Newfoundland and Labrador, Canada
About xCroTek AI
xCroTek is a leading provider of cutting-edge AI and software solutions, dedicated to enabling businesses to harness the power of artificial intelligence for strategic advantage. Our specialized services include:
- Advanced AI Technologies: Implementation of machine learning, deep learning, NLP, and computer vision to drive intelligent automation and insights.
- Generative AI Solutions: Development of sophisticated generative AI models for content creation, data synthesis, and innovative applications.
- AI-Driven Automation: Streamlining operational processes through intelligent automation tools and workflows.
- Intelligent Chatbot Development: Creating interactive and efficient chatbot solutions for enhanced customer engagement and support.
- Predictive Analytics: Utilizing data-driven insights to forecast trends, optimize resource allocation, and improve decision-making.
We partner with premier cloud providers, including AWS, Google Cloud, and Microsoft Azure, to ensure robust and scalable AI deployments. xCroTek is committed to delivering tailored AI-powered software, virtual assistants, and automation solutions that drive measurable growth and efficiency for our clients.