Database Architect

3 days ago


Minneapolis, Minnesota, United States Genesis10 Full time
Job Description:

The ideal candidate will have experience designing and implementing online transactional processing (OLTP) and online analytical processing (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.
Required Basic Qualifications:
  • 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).


  • Minneapolis, Minnesota, United States Capgemini Engineering Full time

    About the RoleWe are seeking a highly skilled Software Solution Architect to join our team at Capgemini Engineering. As a key member of our engineering team, you will have the opportunity to craft the future of technology and collaborate with skilled engineers to deliver detailed solutions.Key ResponsibilitiesBusiness Requirements Analysis: Translate...


  • Minneapolis, Minnesota, United States Synechron Full time

    About the RoleWe are seeking a highly skilled Data Modeler/Architect with Azure expertise to join our dynamic team at Synechron. As a key member of our data architecture team, you will play a crucial role in designing and implementing complex data models, leading our data analytics initiatives, and providing data architecture support to our clients.Key...


  • Minneapolis, Minnesota, United States Luminary Group Full time

    Job OverviewPosition Summary: The Program Architect will be responsible for the design and implementation of scalable solutions tailored for medical device networks and applications. This role requires a deep understanding of both business and technical requirements to ensure successful project delivery.Key Responsibilities:Architect and maintain a...


  • Minneapolis, Minnesota, United States Luminary Group Full time

    Position OverviewThe Luminary Group is seeking a highly skilled Program Architect to spearhead the design and implementation of innovative solutions tailored for the medical device sector.Key Responsibilities:Architect and develop a scalable and resilient solution, preferably utilizing Microsoft Azure, to meet the defined business and technical...


  • Minneapolis, Minnesota, United States Capgemini Engineering Full time

    Position: Senior Software Solutions ArchitectLocation: Minneapolis, MN (onsite)Position OverviewAs a Senior Software Solutions Architect at Capgemini Engineering, you will play a pivotal role in shaping the technological landscape. Collaborate with a talented engineering team and utilize your expertise to create comprehensive architectural frameworks that...


  • Minneapolis, Minnesota, United States Capgemini Engineering Full time

    Position: Enterprise Software Architect (Life Sciences)Location: Minneapolis, MN (onsite)Role OverviewAs an Enterprise Software Architect at Capgemini Engineering, you will play a pivotal role in shaping the technological landscape. Collaborate with a talented engineering team in Minneapolis, MN, to deliver comprehensive solutions that align with business...

  • Data Architect

    3 months ago


    Minneapolis, Minnesota, United States Apogee Enterprises Inc Full time

    Apogee Services Inc.Position SummaryIn this highly visible role, this individual will provide key leadership on all aspects of the company's data platform. The Data Architect will implement architectural standards and frameworks across software, quality, and infrastructure teams as technology emerges and as the business requires. ResponsibilitiesProvide...


  • Minneapolis, Minnesota, United States Luminary Group Full time

    Job OverviewThe Luminary Group is seeking a highly skilled Program Architect to spearhead the design and implementation of innovative solutions for medical device networks and applications. This role requires a deep understanding of both business and technical requirements to ensure successful project outcomes.Key Responsibilities:Architectural Design:...


  • Minneapolis, Minnesota, United States Capgemini Full time

    Position: MDM SaaS Solutions ArchitectCompany: CapgeminiEmployment Type: Full-TimeJob Summary:Capgemini is seeking a skilled Informatica IDMC MDM SaaS Solutions Architect. This role involves the design, development, and implementation of Informatica IDMC MDM SaaS solutions. The ideal candidate will possess expertise in Customer Data Integration (CDI),...


  • Minneapolis, Minnesota, United States CliftonLarsonAllen Full time

    CLA is a top 10 national professional services firm where our purpose is to create opportunities every day, for our clients, our people, and our communities through industry-focused wealth advisory, digital, audit, tax, consulting, and outsourcing services. Even with more than 8,500 people, 130 U.S. locations, and a global reach, we promise to know you and...


  • Minneapolis, Minnesota, United States C4 Technical Services Full time

    Salesforce Solutions Architect / Technical Lead Company: C4 Technical Services As a seasoned professional in systems software engineering, you will engage in intricate projects that necessitate advanced technical expertise. You will be responsible for making informed decisions on complex or ambiguous software engineering challenges, resolving conflicting...


  • Minneapolis, Minnesota, United States Cognizant Technonology Solutions Full time

    Senior Solutions Architect (Hybrid)Cognizant's Digital Engineering division is in search of a seasoned Senior Solutions Architect with a proven track record in crafting and developing impactful, scalable enterprise-level applications. Our team members are dedicated to producing high-quality, reliable, and maintainable code. You will collaborate closely with...


  • Minneapolis, Minnesota, United States Rose International Full time

    Position Overview:This role is hybrid, requiring presence in the office three days a week. Day shifts are available, and paid parking is provided at both locations.Key Responsibilities:Act as an Application Architect with a minimum of 10 years of experience in developing .NET applications and a strong background in ETL processes.Analyze existing ETL...


  • Minneapolis, Minnesota, United States Tata Consultancy Services Full time

    About the RoleTata Consultancy Services is seeking a highly skilled Salesforce Marketing Cloud Architect to join our team. As a key member of our digital transformation practice, you will be responsible for designing and implementing end-to-end marketing technology solutions for our clients.Key ResponsibilitiesFull-Lifecycle Implementations: Develop and...


  • Minneapolis, Minnesota, United States Rose International Full time

    Position Overview:This role is a hybrid position requiring three days a week in the office. The working hours are during the day, and paid parking is available at both locations.Key Responsibilities:We are seeking an experienced Application Architect with a minimum of 10 years in .Net application development and substantial expertise in ETL processes.Analyze...


  • Minneapolis, Minnesota, United States Rose International Full time

    Position Overview:This role offers a hybrid work model, requiring in-office presence three days a week. The position operates during day shifts and includes paid parking at both office locations.Key Responsibilities:Serve as an Application Architect with a minimum of 10 years of experience in developing .Net-based applications, alongside substantial...


  • Minneapolis, Minnesota, United States Rose International Full time

    Position Overview:This role offers a hybrid work environment, requiring three days a week in the office. Enjoy a day shift schedule with paid parking available at both locations.Key Responsibilities:We seek an Application Architect with a minimum of 10 years of experience in developing .Net-based applications and a strong background in ETL processes.Analyze...


  • Minneapolis, Minnesota, United States Daikin Applied Full time

    Job OverviewPosition Summary:As a pivotal member of our team, you will spearhead the technical direction for the development of our IoT Cloud framework, alongside the Cloud Services and Applications that underpin Daikin's connected equipment offerings. You will also oversee projects managed by other technical leaders within the Cloud Engineering division....


  • Minneapolis, Minnesota, United States Surescripts Full time

    Company Overview: Surescripts is dedicated to enhancing health intelligence sharing across the nation, aiming to improve patient safety, reduce costs, and ensure high-quality care. Role Summary: The Lead Systems Architect is responsible for maintaining the stability, integrity, and efficient design of systems and applications that underpin essential...


  • Minneapolis, Minnesota, United States INSPYR Solutions Full time

    Position: Senior Software Architect for .NET SolutionsLocation: Hybrid Work EnvironmentEmployment Type: Contract to HireCompensation: $65-75/hrEligibility: Must be a US Citizen, Green Card Holder, or Authorized to Work in the USKey Responsibilities:Analyze and comprehend existing ETL processes managed by the application team, utilizing tools such as SSIS,...