Database Architect

Job Title: Database Architect
Location: White Plains, NY
Employer: 4Consulting, Inc
Position Type: Full Time
Worksite: Remote

1. Design and develop logical and physical data models for Silver and Gold layers of a medallion data warehouse and lakehouse architecture.
2. Assess existing database models for usability, performance, and efficiency, and recommend improvements aligned with business requirements.
3. Lead stakeholder workshops to define future-state database models supporting General Ledger, Trial Balance, and other financial datasets.
4. Establish data modeling standards and best practices to improve database scalability, extensibility, data quality, and integration across financial data sources.

Education	Bachelor’s degree in Computer Science, Information Technology, Engineering, Business, or related field, or equivalent combination of education and experience.
Experience	6–9 years of experience in database architecture, data modeling, data warehousing, lakehouse design, and financial data management.
Technical Skills	Snowflake, Database Architecture, Logical Data Modeling, Physical Data Modeling, Data Warehousing, Lakehouse Architecture, Medallion Architecture, Dimensional Modeling, SQL, Data Integration
Business / Domain Skills	Experience supporting Finance and accounting data environments, including General Ledger, Trial Balance, financial reporting, reconciliation, and enterprise financial data management. Experience designing and maintaining logical and physical data models that support financial business processes, data consistency, reporting requirements, and evolving business needs. Experience analyzing financial data structures and source-system information from enterprise finance platforms to identify data quality issues, modeling gaps, inefficiencies, and opportunities for improved financial data integration. Experience collaborating with Finance stakeholders and functional teams to assess current-state data models, define future-state requirements, establish data modeling standards, and improve the usability and extensibility of financial data for analytics and reporting.
Communication	Ability to communicate with technical and business stakeholders.
Documentation	Ability to prepare project documentation, status updates, and deliverables.
Work Authorization	Must be legally authorized to work in the United States. Sponsorship may be considered where permitted by company policy and project requirements.

1. Experience modeling financial data from SAP, Oracle, JD Edwards, or similar enterprise financial systems.
2. Experience applying Third Normal Form (3NF), star schema, and snowflake schema modeling practices.
3. Strong stakeholder workshop facilitation, analytical problem-solving, and technical advisory skills.