Data Architect, Senior

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

Benefits offered by this job

Medical insurance

401K plan

Paid holidays

Job summary

The Senior Data Architect at American Bureau of Shipping (ABS) leads the design and implementation of database architecture, security, migration, and ongoing data analysis to support enterprise MIS. You will design relational databases, conceptual and logical data models, data warehouses, and multidimensional schemas, and develop archiving and data migration strategies.

A bachelor’s degree and about 10 years in database design/analysis are expected, with Oracle 11g experience and strong

Qualifications

• Bachelor’s degree or equivalent in data processing or related field.
• 10 years of database design/analysis experience, including 6+ years with Oracle 11g+.
• Hands-on ETL experience; IBM InfoSphere DataStage knowledge is a plus.

Responsibilities

• Develop strategies for data acquisitions, archive recovery, and database implementation.
• Design and build relational databases.
• Create conceptual and logical data models and data flowcharts.
• Design and develop Data Warehouses and Multidimensional Databases.
• Develop data archiving strategies.
• Migrate data from legacy systems to new solutions.
• Provide MIS operational support.

Skills

Data architecture

Database design

PL/SQL

ETL development

AGILE

SDLC

Oracle DBA

Education

Bachelor’s degree or recognized equivalent in data processing or related field

Tools

IBM InfoSphere DataStage

Oracle 11g

Job description

Job Description

The Senior Data Architect is responsible for the design and implementation of database architecture, design and analysis, migration, and security.

What You Will Do

• Develop strategies for data acquisitions, archive recovery, and implementation of a database.
• Design and build relational databases.
• Design conceptual and logical data models and flowcharts.
• Design and develop Databases, Data Warehouses, and Multidimensional Databases.
• Design and develop a strategy for Data Archiving.
• Develop database solutions to store and retrieve information.
• Migrate data from legacy systems to new solutions.
• 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.

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 10 years of experience in database design and analysis, including 6 years of experience in Oracle 11g or above.
• Hands-on experience with ETL technologies. IBM info sphere DataStage knowledge is a plus.

Knowledge, Skills, And Abilities

• Experience in Enterprise Database development with at least 3 years of database design experience.
• Possesses a deep understanding of tools used in the Software Development Lifecycle (SDLC).
• Experience in Oracle 11g or above.
• Well-versed in designing and implementing Data Marts, Multi Data Models, Star, and Snowflake Schemas.
• Proficient in a programming language 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

We set out more than 160 years ago to promote the security of life and property at sea and preserve the natural environment. Today, we remain true to our mission and continue to support organizations facing a rapidly evolving seascape of challenging regulations and new technologies. Through it all, we are anchored by a vision and mission that help our clients find clarity in uncertain times.

ABS is a global leader in marine and offshore classification and other innovative safety, quality, and environmental services. We’re at the forefront of supporting the global energy transition at sea, the application of remote and autonomous marine systems, cutting‑edge technical solutions, and many more exciting advancements. Our commitment to safety, reliability, and efficiency is ever‑present, guiding our clients to safer and more efficient operations.

About Our Benefits

ABS Bureau proudly offers a variety of industry‑leading benefits designed to enhance the life and well‑being of our employees and their families. 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 support in personal wellness, including work‑life services. ABS Bureau also offers a 401K plan with a generous company match, subject to plan requirements.

Equal Opportunity

ABS Bureau 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.