"Alerted.org

Project Overview:

T&T is in search of a talented Data Architect and Data Modeler to join our team in developing a scalable data model for the National Fisheries Logbook. This pivotal project will span multiple Regional Offices, creating a unified data and validation model to support various headless applications for vessel logging.

The candidate will work closely with Regional Offices to design and implement a centralized data store, develop scalable APIs for seamless integration with React applications and PWAs, drive the standardization and efficiency of vessel log tracking by consolidating data into a national database, and enhance reporting capabilities across client Regional Offices.

Objective: Transition from isolated vessel log tracking systems to a centralized national database to improve standardization, reporting, and efficiency across our client’s Regional Offices. This is one of the first pilot programs of its kind to take a holistic platform and data model approach. The positions responsibilities and growth may expand to incorporate other application types moving forward.

Primary Responsibilities:

+ Exhibit strong leadership in modern database design, architectural principles, and technological modernization.

+ Assist in scaling a common validation model that can be utilized for the applications

+ Enhance existing database and storage design for optimal efficiency.

+ Reengineer database architecture and system design, introducing innovative technologies.

+ Implement API architecture for seamless data communication within applications.

+ Create detailed documentation and diagrams.

+ Collaborate effectively with the application team, infrastructure team, leadership, and other contractors.

+ Develop holistic database solutions rather than temporary fixes.

+ Prototype new technology solutions in the cloud and other modern databases, tools, and designs.

+ Participate in defining target state applications and data technology architecture roadmaps.

+ Contribute to T&T proposal activities and other duties as assigned by T&T managers/supervisors.

Required** **Skills & Qualifications:

+ BA or BS degree

+ 5+ years of experience building, architecting, designing, and modernizing legacy database systems and building new target state architecture

+ Organizational experience in an agile operating model

+ Established work in proof of concepts and technology.

+ The ability to architect and model mission critical RDMS, BI, OLTP, OLAP, and solutions leveraging multiple DBMS technologies is required; Ability to create new schemas on how production databases run, tune, and maintain in a production environment

+ Program systems, scripts, and queries in conjunction with SQL Server, Oracle databases, NoSQL databases (Like MongoDB), Snowflake, on both on-prem and cloud environments with DB such as. Amazon RDS, AWS Glue, PostgreSQL, MySQL, DynamoDB, Elasticsearch; Microsoft Azure cloud data services (or equivalent) utilizing Functions, Data Factory, Managed Instances

+ Extensive experience with Data Analysis, Data Profiling, Data Flows, and Data Modeling is required

+ Experience in a Service Oriented Architecture

Desired Skills & Qualifications:

+ Python

+ Experience programming and requesting information from RESTful endpoints

+ Experience architecting big data solutions using Data Lake, Data Modeling , Data Products

+ Experience with MongoDB, Tubleau, Apache Cassandra, Snowflakes

+ Experience with Cloud native DB design

+ Expertise in architecting and developing database solutions

+ Experience with No SQL and GraphQL technologies

+ Experience programming in an object-oriented language

+ Design ERDs and produce high quality engineering design documents

+ Willingness and ability to apply complex business logic to programs, scripts, and queries that interface with large databases

+ Provide rational analysis of data and means to improve structure and integrity.

**Benefits:** Competitive benefits package including: health, dental, vision, life insurance coverage, 401(k) Plan, Training Programs, Accrued Paid Time Off (PTO) and Paid Holidays.

_Equal Opportunity Employer/Veterans/Disabled_