Data Architect II
American Bureau of Shipping Career Site Open At a glance
Mid-level Data Architecture & Governance role at American Bureau of Shipping Career Site. Houston · full-time · no salary stated · we estimate $99,518–$156,000 across the United States.
American Bureau of Shipping Career Site has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Plan how databases are acquired, recovered, archived and implemented, then build relational databases and data models
- Create databases, warehouses and multidimensional structures that support storage, retrieval and analytical work
- Move information from legacy systems into new solutions and set organization-wide rules for managing data
- Specify database structure, capabilities, security and recovery, then provide MIS support and resolve user issues
- Guide junior colleagues and peers on database tools and systems, and contribute data expertise to decisions
What you bring
- A bachelor’s degree in a data processing field or equivalent industry experience
- Typically, twelve years in database design and analysis, including six years with Oracle 11g or later
- At least five years designing databases in enterprise development, with experience in Oracle, MS SQL Server and ETL
- Experience with SDLC tools, data marts and dimensional models, plus PL/SQL programming skills
Who this fits
This mid-level role suits an experienced database architect who can design and migrate data systems while supporting users and mentoring colleagues. You’ll report to a manager, director or executive-level leader.
From the employer
The Data Architect II is responsible for designing and implementing database architecture, design, 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, 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.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.