Quick overview
Job description
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.
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- TC

VP, DataRecently posted Auto Apply
Thyme Care · Remote · Remote · Posted 18 Nov 2026 🇺🇸
RecruitingLookerCompliance+6$250.8k - $295k/yr - CE
Data Architect Auto Apply
Ceso · Columbus · Hybrid 🇺🇸
SQLETLBackground Checks+6Technology$85.9k - $167.0k/yr - BH
Principal Data Architect Auto Apply
Bhhc · Bay Area · Hybrid 🇺🇸
OnboardingSnowflakeCRM+8Technology$226.7k - $236.3k/yr - SI
SAP BDC Data ArchitectRecently posted Auto Apply
SAP IT Business Systeme · Miami, FL · Hybrid · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementProcurementProject ManagementTechnology$151.9k - $340.9k/yr - 3C

Senior Consultant - Data Platforms & ArchitectureRecently posted Auto Apply
3Cloud · Remote - US · Remote · Posted 16 Nov 2026 🇺🇸
ArticulateDatabricksIntellectual Property+3Salary not listed - AI

Data Platform Principal Architect, Seattle/San FranciscoRecently posted Auto Apply
Airwallex · US - Seattle · Hybrid · Posted 16 Nov 2026 🇺🇸
ComplianceDatabricksKafka+3Salary not listed - NG

Senior Data ArchitectRecently posted Auto Apply
Nimble Gravity · LATAM (Remote) · Remote · Posted 15 Nov 2026 🇺🇸
SQLApache SparkCompliance+7TechnologySalary not listed - ST

Senior Data ArchitectRecently posted Auto Apply
Steerbridge · Vienna · Hybrid · Posted 13 Nov 2026 🇺🇸
GCPSQLGit+14Technology$150k - $185k/yr - WO
Data Architect/Engineer- Bilingual Korean/ English) Auto Apply
Woongjin, Inc · Plano, TX · On-site · Posted 13 Nov 2026 🇺🇸
Microsoft ExcelGenerative AITechnology$110k - $120k/yr - RL

Head of Data (Remote)Recently posted Auto Apply
Rocket Lawyer · California; Colorado ; North Carolina ; Utah · Hybrid · Posted 13 Nov 2026 🇺🇸
GCPSQLSnowflake+8$204.9k - $361.0k/yr - 9W

Database Architect Auto Apply
9th Way Insignia · United States - Remote · Remote · Posted 12 Nov 2026 🇺🇸
SQLT-SQLAWS+7$78.5k - $88k/yr - V4
Databricks Architect (Remote, US) Auto Apply
V4C.ai · United States · Remote · Posted 13 Nov 2026 🇺🇸
SQLApache SparkETL+9Salary not listed