Job Description

JOB TITLE:

Sr Snowflake Developer

 LOCATION:

Owings Mills, MD (2 days onsite, 3 days remote. Must be onsite day 1)

 DESCRIPTION:

Compass Pointe has partnered with a global financial company in the Owings Mills, MD area that is looking for a Sr Snowflake Developer.

RESPONSIBILITIES:
• Knowledge of SQL language and cloud-based technologies (SQL - 10 years).
• Data warehousing concepts, data modeling, metadata management.
• Data lakes, multi-dimensional models, data dictionaries.
• Performance tuning and setting up resource monitors.
• Snowflake modeling – roles, databases, schemas.
• SQL performance measuring, query tuning, and database tuning.
• ETL tools with cloud-driven skills.
• Ability to build analytical solutions and models.
• Root cause analysis of models with solutions.
• Hadoop, Spark, and other warehousing tools.
• Managing sets of XML, JSON, and CSV from disparate sources.
• SQL-based databases like Oracle SQL Server, and Teradata.
• Snowflake warehousing, architecture, processing, administration.
• Data ingestion into Snowflake.
• Enterprise-level technical exposure to Snowflake applications.

REQUIREMENTS:

• 10+ years of experience.
• 5+ years of experience with Snowflake.
• Create, test, and implement enterprise-level apps with Snowflake.
  • Design and implement features for identity and access management.
  • Create authorization frameworks for better access control.
  • Implement novel query optimization, major security competencies with encryption.
  • Solve performance issues and scalability issues in the system.
  • Transaction management with distributed data processing algorithms.
  • Possess ownership right from start to finish.
  • Build, monitor, and optimize ETL and ELT processes with data models.
  • Migrate solutions from on-premises setup to cloud-based platforms.
  • Understand and implement the latest delivery approaches based on data architecture.
  • Project documentation and tracking based on understanding user requirements.
  • Perform data integration with third-party tools including architecting, designing, coding, and testing phases.
  • Manage documentation of data models, architecture, and maintenance processes.
  • Continually review and audit data models for enhancement.
  • Maintenance of ideal data pipeline based on ETL tools.
  • Coordination with BI experts and analysts for customized data models and integration.
  • Code updates, new code development, and reverse engineering.
  • Performance tuning, user acceptance training, application support.
  • Maintain confidentiality of data.
  • Risk assessment, management, and mitigation plans.
  • Regular engagement with teams for status reporting and routine activities.
  • Migration activities from one database to another or on-premises to cloud.