Database Architect

Oran Inc; Snowflake (AZ); Remote; USD 100,000 - 140,000; Full time

Job summary

A leading company is seeking a highly skilled Database Architect to enhance their enterprise data integration and business intelligence strategies. The role involves designing scalable data systems, managing data accuracy, and contributing to data architecture improvements. Ideal candidates should have strong experience in database development and a Bachelor’s degree in a related field.

Qualifications

• Minimum 5 years of experience in database architecture or related field.
• Proven experience in designing data systems, including relational databases.
• Ability to work independently and apply judgment effectively.

Responsibilities

• Design and build relational databases, data warehouses, and data marts.
• Develop strategies for data warehouse implementation and data acquisition.
• Verify data accuracy and ensure integrity across systems.

Skills

Database Development

Data Modeling

Business Intelligence Integration

Problem Solving

Communication

Education

Bachelor’s Degree in Computer Science

Bachelor’s Degree in Information Systems

Bachelor’s Degree in Data Analytics

Tools

SQL Server

Oracle

PostgreSQL

MySQL

Snowflake

Redshift

Power BI

Tableau

AWS

Azure

GCP

Job description

Position Title: Database Architect

Location: Remote
Position Type: Full-Time
Key Personnel: Yes (Designated by Oran Inc)

Position Overview:

Oran Inc. is seeking a highly skilled Database Architect to support enterprise data integration, modeling, and business intelligence initiatives. The selected candidate will be responsible for designing, implementing, and maintaining scalable data systems including relational databases, data warehouses, and data marts to support storage, processing, and decision-making. This role is critical to Oran Inc’s data strategy and is designated as Key Personnel.

The ideal candidate has strong experience in database development and architecture, data modeling, and enterprise-level business intelligence integration, and can operate independently using judgment and experience to meet objectives and deliver complex solutions.

Responsibilities:

• Design and build relational databases, data warehouses, and data marts to support enterprise data needs.

• Develop strategies for data warehouse implementation, data acquisition, archival recovery, and long-term data storage.

• Define and enforce business rules through stored procedures, middleware solutions, and data transformation tools.

• Create functional specifications and define user interfaces to ensure alignment with business and user requirements.

• Verify data accuracy, ensure integrity across systems, and maintain database performance and availability.

• Cleanse and manage datasets, removing obsolete data and ensuring compliance with data retention policies.

• Evaluate new data sources for compatibility, quality, and ease of integration with existing systems.

• Perform complex tasks and contribute to ongoing improvement of data architecture, modeling practices, and integration frameworks.

Minimum Qualifications:

• Education: Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, or a related field.

• Experience: Minimum 5 years of experience in database architecture, development, or a related field.

• Proven experience in designing and implementing data systems, including relational and analytical databases.

• Ability to work independently, applying professional judgment and experience to accomplish objectives.

Preferred Skills and Knowledge:

• Experience with modern database technologies (e.g., SQL Server, Oracle, PostgreSQL, MySQL).

• Experience with data warehouse and BI platforms (e.g., Snowflake, Redshift, Power BI, Tableau).

• Knowledge of ETL tools and middleware technologies.

• Familiarity with data governance, quality standards, and metadata management.

• Experience with cloud data architecture (AWS, Azure, or GCP).

• Understanding of data modeling best practices (star/snowflake schemas, normalization, etc.).

Work Environment:

• Remote position

• Requires strong communication and problem-solving skills.

• Ability to manage and prioritize multiple assignments and stakeholders.

• Collaborative and innovative team environment