Match score not available

Database Designer at Horizontal Talent

Remote:

Full Remote

Contract:

Experience:

Mid-level (2-5 years)

Work from:

Minnesota (USA), United States

Offer summary

Proficiency in SQL., Knowledge of data modeling..

Horizontal Talent Human Resources, Staffing & Recruiting SME https://www.horizontaltalent.com/

201 - 500 Employees

Key Responsibilities:

Database Design & Architecture:

Design, develop, and optimize Snowflake databases for both OLTP and OLAP systems.
Create and maintain data models, including conceptual, logical, and physical models.
-evelop and implement database schemas, tables, views, indexes, and other database objects.

Data Integration & ETL Processes:

Design and manage data integration solutions, including ETL/ELT processes.
Collaborate with data engineers to implement data pipelines for data ingestion, transformation, and loading into Snowflake.

Performance Tuning & Optimization:

Analyze and optimize database performance, including query performance, indexing strategies, and storage management.
Monitor and troubleshoot database performance issues and implement solutions to improve efficiency.

Collaboration & Communication:

Work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand data requirements and deliver database solutions.
Provide technical guidance and mentorship to junior database designers and developers.

Documentation & Compliance:

Maintain comprehensive documentation of database designs, architectures, and processes.
Ensure data security, privacy, and compliance with relevant regulations and best practices.

Technical Skills

Soft Skills

Preferred Qualifications:

Snowflake certification.
Experience with cloud platforms such as AWS,
Familiarity with other database technologies (e.g.MySQL, PostgreSQL, Oracle etc.).
Experience with data visualization and reporting tools (e.g., Tableau, Power BI).