Data Architect

Senior Data Modeler / Data Architect Location: Las Vegas Hybrid Mode Client: Win Resorts Through CTS About the Role: Senior Data Modeler / Data Architect to join our advanced data warehouse team. The ideal candidate will possess deep expertise in data analysis, data profiling, SQL, and Snowflake, and will play a pivotal role in designing, implementing, and optimizing our data models and architecture. This role is critical in supporting data-driven decision-making across the organization, ensuring data consistency, quality, and accessibility. Key Responsibilities: Data Modeling and Architecture: Design and implement robust, scalable, and efficient data models (conceptual, logical, and physical) to support various business applications and analytics needs. Develop data architecture strategies that align with enterprise goals and support a modern data warehouse infrastructure. Data Analysis and Profiling: Conduct in-depth data analysis and profiling to assess data quality, identify gaps, and establish requirements for data warehouse. Work closely with business stakeholders to gather and interpret data requirements, ensuring that models meet business needs. SQL Development and Optimization: Write, optimize, and maintain complex SQL queries for data analysis. Tune SQL queries and database performance, ensuring efficient use of resources and optimal query execution times. Snowflake Data Warehousing: Architect and manage the Snowflake environment, leveraging best practices for data partitioning, clustering. Collaboration and Leadership: Collaborate with data engineers, data scientists, and business analysts to optimize data infrastructure and support advanced analytics. Drive data governance and data quality initiatives, ensuring compliance with regulatory requirements. Required Skills and Qualifications: Education: Bachelor's or Master's degree in Computer Science, Information Systems, or a related field. Experience: 10+ years in data modeling, data architecture, or a similar role within a data warehouse environment. Technical Proficiency: Data Modeling: Deep knowledge of data modeling principles, including ER modeling, star schema, and dimensional modeling. SQL: Advanced SQL skills with experience in query optimization, stored procedures, and SQL tuning. Snowflake: Extensive experience working with Snowflake, including data warehousing best practices, performance tuning, and security configurations. Data Orchestration: Knowledge in Airflow and Azure Data Factory to automate and schedule data workflows. Data Profiling and Analysis: Experience in data profiling, data cleansing, and quality checks to ensure data reliability and consistency. Data Integration & Transformation: Familiarity with ETL processes and tools, including Databricks and other cloud-based data transformation tools. Data Governance: Knowledge of data governance frameworks and data management best practices. Preferred Skills: Familiarity with other cloud platforms (e.g., Azure, AWS, GCP) and big data technologies. Experience with BI tools like Power BI or Tableau. Knowledge of scripting languages (e.g., Python, Bash) for automation and data manipulation. Kasmo Global