Database Architect

LinTech Global•Monterey, CA

1d•Onsite

About The Position

The person in this position is responsible for performing analysis, modification, documentation, and support of daily operations for the data warehousing and reporting system. Responsibilities include supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support. The duties will include planning, installation, maintenance during or after-work hours, troubleshooting, and managing all Database Developer servers and applications. Achieves organizational goals by defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases. Maintains database by determining structural requirements and developing and installing solutions. Ensures security of all information and computer systems and digital data. Ensures adherence to government regulations and guidelines for technological systems and safeguarding of data. Defines infrastructure for design and integration of internet computing systems by analyzing information requirements, studying business operations and user-interface requirements, and directing development of physical database. Confirms architecture capability and flexibility to support high availability web applications by developing analytical models and completing validation tests. Determines platform architecture, technology, and tools.

Requirements

AA/AS Degree in a related discipline from an accredited college or university or three years of related experience.
Minimum of 5 years of experience designing and developing data warehouses
Proven track record of successfully implementing complex data warehouse projects
Experience with relational database design/modeling using tools.
Expert-level SQL coding/querying skills in SQL Server and/or MySQL
Proficient in SQL and advanced SQL query optimization techniques
Expertise in data warehouse technologies like Snowflake, Redshift, or Teradata
Knowledge of ETL tools and methodologies
Familiarity with data modeling concepts (dimensional, star schema, snowflake schema)
Understanding of data analysis, business principles, and operations
Software architecture and design
Network design and implementation
Ability to clearly present technical information to fellow technical professionals as well as non-technical peers
IAT Level II Certification is required to Start (CCNA Security, CSA+, GICSP, GSEC, Security+ CE, or SSCP) Certification
A NACLC Public Trust Clearance is required to Start.

Responsibilities

Supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support.
Planning, installation, maintenance during or after-work hours, troubleshooting, and managing all Database Developer servers and applications.
Defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases.
Determining structural requirements and developing and installing solutions to maintain the database.
Ensuring security of all information and computer systems and digital data.
Ensuring adherence to government regulations and guidelines for technological systems and safeguarding of data.
Defining infrastructure for design and integration of internet computing systems by analyzing information requirements, studying business operations and user-interface requirements, and directing development of physical database.
Confirming architecture capability and flexibility to support high availability web applications by developing analytical models and completing validation tests.
Determining platform architecture, technology, and tools.