Architect II, Data

American Bureau of Shipping (ABS); Houston (TX); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical insurance

Dental and vision

401(k) with company match

Paid holidays and vacation

Job summary

ABS Wavesight seeks a Data Architect II to design and implement database architecture, migrate data from legacy systems, and enable analytics for strategic decisions. Location preferred in Houston, TX or Knoxville, TN.

You will build relational databases, data models, data warehouses, and MD schemas, while advancing data strategy and governance across the organization.

Qualifications

• Bachelor's degree or recognized equivalent in data processing.
• 12 years of database design and analysis experience.
• 6 years of Oracle 11g+ experience.

Responsibilities

• Design and implement relational databases and data models.
• Migrate data from legacy systems to new solutions.
• Develop Databases, Data Warehouses, and Multidimensional Databases.
• Define and enforce organizational data strategy.
• Mentor junior team members and peers.
• Provide MIS support and data insights for decisions.

Skills

Data architecture

Database design

Mentoring

Self-starter

Agile dev

Problem solving

Education

Bachelor's degree in data processing

12 years database design/analysis

6 years Oracle 11g+

Tools

Oracle 11g

MS SQL Server

ETL technologies

IBM InfoSphere DataStage

Azure

PL/SQL

Job description

The Data Architect II is responsible for designing and implementing database architecture, design, analysis, migration, and security. Preferred locations for this role are Houston, Texas or Knoxville, Tennessee.

What You Will Do:

• Develop strategies for data acquisitions, archive recovery, and implementation of a database.
• Design and build relational databases, conceptual and logical data models, and flowcharts.
• Develop Databases, Data Warehouses, and Multidimensional Databases.
• Develop a strategy for Data Archiving, MDM, Reporting, and analytical needs.
• Develop database solutions to store and retrieve information.
• Act as a custodian of data and provide insights, assistance, and expertise in making business decisions based on data.
• Migrate data from legacy systems to new solutions.
• Define and enforce organizational-level data strategy.
• Provide operational support for Management Information System (MIS)Develops database solutions by designing the proposed system, defining the database's physical structure and functional capabilities, and security, backup, and recovery specifications.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Mentors junior team members and peers, providing expertise and guidance of tools and systems.

What You Will Need:

Education and Experience

Typically requires a bachelor's degree or recognized equivalent, from an accredited university, in a data processing discipline or equivalent industry experience. Typically requires 12 years of experience in database design and analysis and 6 years of experience in Oracle 11g or above.

Knowledge, Skills, and Abilities

• Experience in Enterprise Database development with at least 5 years of database design experience.
• Possesses a deep understanding of tools used in the Software Development Lifecycle (SDLC).
• Experience in Oracle 11g, MS SQL Server.
• Hands‑on experience with ETL technologies.
• IBM info sphere DataStage knowledge is a plus.
• Well‑versed in designing and implementing Data Marts, Multi Data Models, Star, and Snowflake Schemas.
• Knowledge and experience in MSBI technologies, and cloud exposure to Azure is a plus.
• Proficient in programming languages such as PL/SQL code.
• Demonstrated ability to work well with others.
• Proven capability to train employees in technically complex areas.
• Proactive, energetic self‑starter with good problem‑solving skills.
• Prior experience with Oracle DBA and knowledge of AGILE development principles is preferred.
• Ability to develop a working knowledge of ABS Rules, Guides, statutory regulations, and related instructions, as well as the ABS Employee Safety Policy.

Reporting Relationships:

This position reports to a Manager, Director, or Executive level position.

ABOUT US

About ABS Wavesight ABS Wavesight is the new ABS Affiliate maritime software as a service (SaaS) company dedicated to helping shipowners and operators streamline compliance while maintaining competitive,more efficient, and sustainable operations. Our mission is to develop world‑class software products that improve vessel performance for the health of our seas, environment and self. The ABS Wavesight portfolio is comprised of best‑in‑class proprietary technology and third‑party integrations that offer unparalleled insight into every aspect of a fleet's operations. Backed by ABS's 160‑year legacy of maritime innovation and experience, our products are collectively installed on more than 5,000 vessels across the global fleet. Learn more about ABS Wavesight by visiting www.abswavesight.com.

About Our Benefits

These benefits include, but are not limited to, medical insurance (PPO and HD), dental and vision insurance, Health Savings account (HSA), Flexible Savings Account (FSA), life insurance, accidental death and dismemberment insurance, disability leave programs, parental leave program, paid holidays, and paid vacation time. The Company provides an Employee Assistance Plan (EAP) that offers additional support in personal wellness, including work‑life services. ABS Wavesight also offers a 401K plan with a generous company match, subject to plan requirements.

Equal Opportunity

Equal Opportunity ABS Wavesight is committed to the equal employment opportunity of its employees and prohibits discrimination against any employee or qualified applicant based on race, color, creed, religion, national origin, sex, gender identity, age, disability, marital status, sexual orientation, citizenship status or veteran status, or other non‑work‑related characteristics that may be protected under the law of the Federal Government or specific state employment laws.

Notice

ABS and Affiliated Companies (ABS) will not pay a fee to any third‑party agency without a valid ABS Master Service Agreement (MSA) authorized and signed by Human Resources. Any resume, CV, application, or other forms of candidate submission provided to any employee of ABS without a valid MSA on file will be considered property of ABS, and no fee will be paid.

Other

This job description is not intended, and should not be construed, to be an all‑inclusive list of responsibilities, skills, efforts or working conditions associated with the job of the incumbent. It is intended to be an accurate reflection of the principal job elements essential for making a fair decision regarding the pay structure of the job.