Data Architect

Overview

We are seeking an experienced Data Architect to lead the design, development, and maintenance of our enterprise data architecture and data warehouse systems. This role will collaborate cross-functionally with key stakeholders to deliver scalable, secure, and high-quality data solutions that support strategic business goals. The ideal candidate will bring a strong background in data modeling, architecture best practices, and data governance to ensure consistency, accuracy, and integrity across the organization.

Benefits

• Medical, Dental & Vision
• Company provided STD, LTD, Life, & AD&D
• Flexible Spending Account (FSA)
• Health Savings Account (HSA)
• 401(k) with company match
• Paid Time Off (PTO)
• Employee Stock Ownership Plan (ESOP)
• Wellness Program
• Parental Leave Benefit
• Tuition Reimbursement
• Employee Referral Program
• Propane Discounts

Responsibilities

• Design, develop, and optimize data architecture and data warehouse solutions to support business intelligence, analytics, and operational reporting needs.

• Define, recommend, and implement data architecture standards, principles, and best practices to ensure alignment with company goals and industry standards.

• Collaborate with technical and business teams to understand data requirements and translate them into scalable architecture solutions.

• Ensure data quality, integrity, and consistency across systems through the implementation of data governance and validation processes.

• Provides guidance and expertise to the enterprise systems team in the areas of data design, database architecture, metadata, and repository.

• Develops, maintains, and supports the enterprise data warehouse system and corresponding data marts. 

• Troubleshoots and tunes existing data warehouse applications. 

• Conducts research into new data warehouse applications and determines viability for adoption.

• Assists with coordinating and streamlining recurring operational activities.

• Evaluates existing subject areas stored in the data warehouse.

• Incorporates existing subject areas into an enterprise model.

• Develop a long-term strategic roadmap for enterprise data architecture that supports business growth and innovation.

• Interviews, gathers, understands, analyzes, documents, presents, and designs/diagrams complex business processes and constructs functional specifications for bug fixes, enhancements, or new development projects.

• Monitors database issues and directs resources to resolve highest-priority issues.

Qualifications

• Bachelor’s degree in computer science or information systems.
• 5 or more years related experience.
• Oracle data warehouse design and development experience.
• Deep understanding of data warehousing concepts, ETL/ELT pipelines, and modern data platforms (OLTP, Data Warehouse/Star Schemas, etc.)
• Proven track record of working with cross-functional teams and aligning data strategies with business objectives.
• Experience with data governance frameworks and practices.
• Strong experience with data modeling tools.
• Experience with PL/SQL, Discoverer and Discoverer
• PL/SQL programming skills.