Snowflake Expert
2 weeks ago
We are seeking a highly skilled Snowflake SME to join our team at Resource Informatics Group. As a Snowflake SME, you will be responsible for creating, testing, and implementing enterprise-level applications with Snowflake, designing and implementing features for identity and access management, and creating authorization frameworks for better access control.
Key Responsibilities:
- 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 Client 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
Requirements:
- Knowledge of SQL language and cloud-based technologies
- 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, Teradata, etc.
- Snowflake warehousing, architecture, processing, administration
- Data ingestion into Snowflake
- Enterprise-level technical exposure to Snowflake applications
-
Sr Data Architect
2 weeks ago
Baltimore, United States Apex Systems Full timeJob#: 2035801 Job Description: Sr Data ArchitectApex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years' experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our...
-
MDM Lead Developer
2 weeks ago
Baltimore, United States Winning Edge Solutions, LLC Full timeJob Description: MDM Lead Developer in Baltimore, MD (Hybrid - 3 days onsite) - Direct Client role Key Skills: Data architecture, data management solutions, workflows, Master Data, Agile The Lead Developer will be a technical expert in Master Data and Reference Data Management and responsible for the development and delivery of the business-critical data...