Data Architect II

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.
• 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

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

• 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
• paid vacation time
• Employee Assistance Plan (EAP) that offers support in personal wellness, including work-life services
• 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