Database Architect Lead

7 days ago


Los Angeles, California, United States System Soft Technologies Full time

We are seeking an experienced Database Architect Lead to join our team at System Soft Technologies.

About the Role:

This senior-level position involves leading the design and implementation of complex database solutions using DBT and Snowflake. The ideal candidate will have a strong background in SQL development, data modeling, and data transformation using DBT. This role will involve collaborating closely with Power BI developers, participating in all stages of the reporting software development cycle, and creating complex SQL statements to support data visualizations.

  • Develop and maintain comprehensive documentation on database models, tables, guidelines, methods, and standards.
  • Design and maintain complex SQL queries and create tables and views used by Power BI developers for visualizations.
  • Facilitate SQL design sessions and code walk-throughs, ensuring adherence to development standards and best practices using DBT.
  • Conduct unit testing and assist in user testing to ensure quality, functionality, and alignment with requirements.
  • Work closely with stakeholders throughout all phases of the reporting software development lifecycle: requirements gathering, analysis, design, testing, implementation, and production support.
  • Provide guidance and training to other team members on development processes, standards, and best practices.
  • Ensure code quality and consistency by following established standards and implementing industry best practices.
  • Provide recommendations for improvements to development standards and application architecture, incorporating emerging technologies where applicable.

Requirements:

  • 5+ years of SQL development experience
  • Minimum of 2 year of experience as a DBT developer with a strong focus on Snowflake.
  • Proficiency in creating and maintaining SQL statements to generate tables and views for Power BI.
  • Strong knowledge of Snowflake, DBT, Git, Visual Studio Code, and pull request workflows.
  • Familiarity with database modeling and developing data transformations with SQL and DBT.
  • Ability to communicate effectively with technical and non-technical team members.
  • Detail-oriented with excellent problem-solving skills.

Compensation: $130,000 - $190,000 per annum.

Benefits:

  • Comprehensive health insurance package
  • Retirement savings plan
  • Flexible work arrangements
  • Professional development opportunities

What We Offer:

  • A dynamic and collaborative work environment
  • Ongoing professional development and training
  • Opportunities for career growth and advancement
  • A competitive compensation package


  • Los Angeles, California, United States CodeForce Full time

    Job DescriptionWe are seeking an experienced Database Systems Architect and Lead Developer to join our team at CodeForce.About the RoleThis is a challenging role that requires a deep understanding of database systems, including hierarchical (IMS), relational (DB2), and file-based (ADABAS) databases. As a Database Systems Architect and Lead Developer, you...


  • Los Angeles, California, United States BlackLine Full time

    We are seeking a highly skilled Lead Database Architect to join our team at BlackLine.Company OverviewBlackLine is a leading provider of cloud software that automates and controls the entire financial close process. Our vision is to modernize the finance and accounting function to enable greater operational effectiveness and agility.We are committed to...


  • Los Angeles, California, United States BlackLine Full time

    Unlock Career Growth with BlackLineAt BlackLine, we're committed to empowering accounting and finance leaders worldwide to achieve Modern Finance. As a Master Database Architect, you'll play a vital role in shaping the performance, delivery, stability, and security of our databases.This position requires collaboration with cross-functional teams to define...


  • Los Angeles, California, United States Shuvel Digital Full time

    Company OverviewShuvel Digital is a leading digital solutions provider, constantly innovating and pushing the boundaries of technology. Our team is passionate about delivering cutting-edge solutions that drive business growth.About the RoleWe are seeking a highly skilled Sr. Database Architect to join our team. This is a key position responsible for...


  • Los Angeles, California, United States ZipRecruiter Full time

     Company OverviewZipRecruiter is a leading online employment marketplace that connects job seekers with top employers. Job SummaryWe are seeking an experienced Enterprise IT Architect to join our team. As a key member of our technology organization, you will be responsible for designing and implementing complex enterprise architectures, leveraging your...


  • Los Angeles, California, United States ZipRecruiter Full time

    Job SummaryWe are seeking a highly skilled Data Architect to design, develop and maintain conceptual and logical database models. The successful candidate will have a strong understanding of system requirements analysis and migration methods for existing data.About the RoleDevelop innovative database solutions to store and retrieve company...


  • Los Angeles, California, United States City National Bank Full time

    City National Bank seeks a seasoned Cloud Solution Architect Lead to design, develop, and maintain on-premises and cloud native applications.Key Responsibilities:Lead the design and development of cross-functional, multi-platform application systemsDrive technical excellence through automated testing and validationsAnalyze performance issues and execute...


  • Los Angeles, California, United States Cedars-Sinai Medical Center Full time

    Grow Your Career at Cedars-SinaiThe Enterprise Information Services team at Cedars-Sinai recognizes that clinical transformation and information system optimization rely on aligning the right people, processes, and technologies.Cedars-Sinai has solidified its position as a global healthcare technology leader, earning top accolades in prestigious surveys.Why...


  • Los Angeles, California, United States eTek IT Services, Inc. Full time

    eTek IT Services, Inc. is seeking an experienced Cloud Data Architect Lead to join our team.About the RoleWe are looking for a skilled professional to lead our cloud data architecture efforts and drive innovation in data management.The successful candidate will have a minimum of 6 years of experience in full-cycle software development and information systems...


  • Los Angeles, California, United States cesna Full time

    About the RoleWe are seeking an experienced Cloud Infrastructure Architect Lead to join our team at Cesna, a leading fintech company. The successful candidate will play a critical role in designing, implementing, and maintaining our cloud infrastructure.As a key member of our engineering team, you will be responsible for ensuring the reliability,...


  • Los Angeles, California, United States Cedars-Sinai Medical Center Full time

    Job OverviewCedars-Sinai Medical Center is seeking a highly skilled Senior SQL Database Administrator to join its Enterprise Information Services team. This role will lead and work closely with the EIS DBA technology team in designing, installing, maintaining, fixing, and optimizing SQL Server database instances for departmental and enterprise-wide...


  • Los Angeles, California, United States City National Bank Full time

    Job Overview:">">The Full Stack Senior Engineer role at City National Bank involves leading the design and development of cross-functional, multi-platform application systems.">This senior-level position requires expertise in C#, .Net Core, Azure cloud platform, and other technologies to resolve complex issues in creative and effective ways.">The ideal...


  • Los Angeles, California, United States eTek IT Services, Inc. Full time

    Job OvervieweTek IT Services, Inc. is seeking an experienced Senior AWS Solutions Architect Leader to lead our cloud computing initiatives.Compensation and BenefitsThe estimated annual salary for this role is $140,000 - $180,000 based on industry standards and the location of remote work.Job ResponsibilitiesWe are looking for a highly skilled and motivated...


  • Los Angeles, California, United States Forhyre Full time

    Job Description:We are seeking a highly skilled Senior Database Solutions Developer to join our team at Forhyre.This role involves designing, implementing, and maintaining conceptual and logical database models to ensure efficient storage and retrieval of company information.The ideal candidate will have hands-on experience with SQL and Oracle, as well as...


  • Los Angeles, California, United States StubHub Full time

    Job OverviewAt StubHub, we are on a mission to redefine the live event experience on a global scale. Whether someone is looking to attend their first event or their hundredth, we're here to delight them all the way from the moment they start looking for a ticket until they step through the gate. The same goes for our sellers. From fans selling a single...


  • Los Angeles, California, United States Apex Systems Full time

    Job OverviewWe are seeking an experienced Lead Gameplay Architect to join our team at Apex Systems. This is a fantastic opportunity for someone with a passion for designing and implementing high-quality gameplay mechanics.


  • Los Angeles, California, United States ConsultNet Full time

    Are you a seasoned Salesforce expert looking to leverage your skills in a dynamic role? ConsultNet has an exciting opportunity for a Technical Salesforce Architect to join our team!About the RoleWe are seeking a highly experienced and skilled Technical Salesforce Architect to contribute to the maintenance and enhancements of our clients' two highly developed...


  • Los Angeles, California, United States Fawkes IDM Full time

    Job OverviewFawkes IDM seeks an experienced Senior Network Architect Lead to oversee the firm's network and infrastructure. The successful candidate will be responsible for implementing secure solutions, assessing current and future needs, and managing IT systems.


  • Los Angeles, California, United States Northern Impact Full time

    About Northern ImpactWe are a dynamic architecture firm based in the heart of Downtown Los Angeles, with offices across the country. Our portfolio showcases high-rise residential, mixed-use, commercial, higher education, civic, and interiors projects. We pride ourselves on our great studio culture and commitment to excellence.Role OverviewThis is an...

  • Lead Architect

    7 days ago


    Los Angeles, California, United States ZipRecruiter Full time

    The position of Lead Architect - Project Director at ZipRecruiter is an exceptional opportunity for a seasoned professional to oversee and direct architectural projects from design conception through construction administration.Job SummaryWe are seeking a highly skilled and experienced Lead Architect - Project Director to join our team. The ideal candidate...