At Shire, we are proud and grateful to employ military veterans and thank them for their contributions to our company and our country. See where your military experience can play a role at Shire by using our military skills translator job search tool below:
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