Date Posted: 09/11/2024
Hiring Organization: Rose International
Position Number: 470837
Job Title: Database Designer
Job Location: Minneapolis, MN, USA, 55402
Work Model: Hybrid
Shift: M-F 8:00- 4:30 PM
Employment Type: Temporary
Estimated Duration (In months): 7
Min Hourly Rate($): 50.00
Max Hourly Rate($): 57.00
Must Have Skills/Attributes: Data Modeling, Designing, OLAP, OLTP, Snowflake
Job Description
***Only qualified Database Designer candidates located within the State of South Dakota to be considered due to the position requiring an onsite presence***
The ideal candidate will have experience designing and implementing OLTP and OLAP databases, specifically focusing on Snowflake. This role involves collaborating with various stakeholders to design scalable and efficient database solutions that meet the business needs.
Technical Skills:
• Proficiency in SQL and database query optimization
• Strong understanding of data modeling techniques and best practices
• Experience with ETL/ELT tools and processes.
• Familiarity with data warehousing concepts and architecture
• Knowledge of data security and compliance practices
Soft Skills:
• Excellent problem-solving and analytical skills
• Strong communication and collaboration skills
• Ability to work independently and as part of a team
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)
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
• Develop 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
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).