Senior Data Architect/Data Modeler

Posted Yesterday
Be an Early Applicant
Silver Spring, MD, USA
In-Office
120K-160K Annually
Senior level
Artificial Intelligence • Information Technology • Software • Cybersecurity
The Role
Designs and modernizes scalable database architectures and data models supporting NOAA Fisheries applications. Responsibilities include developing centralized data stores, validation models, APIs, cloud database prototypes, reporting solutions, data roadmaps, schemas, and performance improvements across SQL, NoSQL, on-premises, and cloud environments. The role collaborates with application, infrastructure, leadership, and contractor teams while documenting target architectures and supporting technology modernization.
Summary Generated by Built In

Overview:

T&T is in search of a talented senior Data Architect and Data Modeler to join our team in developing a scalable data models for the NOAA Fisheries. This position will span different projects across multiple Regional Offices (e.g. SERO) and Fisheries Science Centers (e.g. NEFSC), creating a unified data and validation models to support regional and science missions across Fishery applications and data initiatives.

The candidates 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 application modernization by consolidating data in to database, and enhance reporting capabilities across applications and databases.

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
  • 6+ 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:  

  • Knowledge of Government operations and NOAA missions
  • 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

Skills Required

  • BA or BS degree
  • 6+ years of experience building, architecting, designing, and modernizing legacy database systems and developing target-state architectures
  • Experience working in an agile operating model
  • Experience with proof-of-concepts and technology evaluation
  • Ability to architect and model mission-critical RDBMS, BI, OLTP, OLAP, and multi-DBMS solutions
  • Experience creating schemas, tuning databases, and maintaining production database environments
  • Programming, scripting, and query experience with SQL Server, Oracle, NoSQL databases, Snowflake, AWS, and Azure data services
  • Extensive experience with data analysis, data profiling, data flows, and data modeling
  • Experience with Service-Oriented Architecture
  • Knowledge of government operations and NOAA missions
  • Experience working with RESTful endpoints
  • Experience architecting big data solutions using data lakes, data modeling, and data products
  • Experience with MongoDB, Tableau, Apache Cassandra, and Snowflake
  • Experience with cloud-native database design
  • Expertise architecting and developing database solutions
  • Experience with NoSQL and GraphQL technologies
  • Experience programming in an object-oriented language
  • Ability to design entity-relationship diagrams and produce engineering design documents
  • Ability to apply complex business logic to programs, scripts, and queries interfacing with large databases
  • Ability to analyze data and improve data structure and integrity
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Falls Church, VA
128 Employees
Year Founded: 2004

What We Do

T and T Consulting Services, Inc. (TATCS) is a woman-owned small business delivering IT and business solutions to the federal government. Its offerings span agile software development and digital transformation, cloud and infrastructure modernization, enterprise IT and network operations, cybersecurity, AI and data analytics, and web design/UI/UX. The company also provides advisory services, helping public-sector clients modernize systems, secure operations, and use data and emerging technologies to meet mission needs.

Similar Jobs

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Inside Sales Representative

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
16 Locations
40000 Employees
45K-85K Annually

CDW Logo CDW

Billing Specialist

Artificial Intelligence • Cloud • Information Technology • Consulting • Cybersecurity • Infrastructure as a Service (IaaS)
Remote or Hybrid
US
15100 Employees
55K-76K Annually

Wipfli Logo Wipfli

Tax Manager

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
107K-144K Annually

Lowe’s Logo Lowe’s

Warehouse Part Time Overnight

Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Hybrid
Hagerstown, MD, USA
300000 Employees

Similar Companies Hiring

Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account