Levi Ray & Shoup Inc
Database Designer
Levi Ray & Shoup Inc, Minneapolis, Minnesota, United States, 55400
LRS
Primary Navigation
Who We Are
History (https://www.lrs.com/who-we-are/history/)
Company Overview
Leadership (https://www.lrs.com/who-we-are/leadership/)
A Message from Our CEO
What We Believe (https://www.lrs.com/what-we-believe/)
Our Mission
LRS Philosophy & Values (https://www.lrs.com/what-we-believe/lrs-philosophy-values/)
Community Involvement
Wilkerson (https://www.lrs.com/what-we-believe/wilkerson/)
Divisions
Careers
Get Hired
Our Culture (https://www.lrs.com/careers/our-culture/)
Benefits
Diversity (https://www.lrs.com/careers/diversity/)
Internships
Offices (https://www.lrs.com/offices/)
LRS Offices
Contact (https://www.lrs.com/contact/)
News
Global NavigationEmployee Login (http://www2.lrs.com) File Transfer
Filters
Careers
Added Sep 19, 2024 Database Designer (26506) Minneapolis, MN | Contract Apply (https://evoportalus.tracker-rms.com/LRS/apply?jobcode=26506&shownonlrs=True)
For additional information on how we handle your data, seewww.LRS.com/privacy
Job Description
Fulcrum Consulting, an LRS company is seeking a Database Designer with our client in Minneapolis, MN.
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.
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.
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).
Fulcrum Consulting, an LRS company, is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status or protected veteran status.
Primary Navigation
Who We Are
History (https://www.lrs.com/who-we-are/history/)
Company Overview
Leadership (https://www.lrs.com/who-we-are/leadership/)
A Message from Our CEO
What We Believe (https://www.lrs.com/what-we-believe/)
Our Mission
LRS Philosophy & Values (https://www.lrs.com/what-we-believe/lrs-philosophy-values/)
Community Involvement
Wilkerson (https://www.lrs.com/what-we-believe/wilkerson/)
Divisions
Careers
Get Hired
Our Culture (https://www.lrs.com/careers/our-culture/)
Benefits
Diversity (https://www.lrs.com/careers/diversity/)
Internships
Offices (https://www.lrs.com/offices/)
LRS Offices
Contact (https://www.lrs.com/contact/)
News
Global NavigationEmployee Login (http://www2.lrs.com) File Transfer
Filters
Careers
Added Sep 19, 2024 Database Designer (26506) Minneapolis, MN | Contract Apply (https://evoportalus.tracker-rms.com/LRS/apply?jobcode=26506&shownonlrs=True)
For additional information on how we handle your data, seewww.LRS.com/privacy
Job Description
Fulcrum Consulting, an LRS company is seeking a Database Designer with our client in Minneapolis, MN.
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.
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.
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).
Fulcrum Consulting, an LRS company, is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status or protected veteran status.