BI Architect

Oxford Global Resources; Franklin Lakes (NJ); On-site; USD 76,000 - 99,000; Full time

Job summary

Oxford Global Resources seeks a BI Architect to translate business needs into analytical data models supporting long‑term solutions. The role collaborates with BI Analysts and Data Architects to develop conceptual, logical, and physical data models with metadata, ensuring high quality and reuse across projects.

The position requires a Bachelor's in a data-related field and 8+ years as a Data Modeler/Architect; advanced degrees are a plus.

Qualifications

• Minimum of Bachelor's Degree in Computer Science or related field and 8+ years in data modeling/architecture.
• Advanced degree is a plus.

Responsibilities

• Work with BI Analysts and Data Architects to develop conceptual data models.
• Create logical and physical data models using best practices.
• Optimize and update models to support new and existing projects.
• Maintain conceptual, logical and physical data models and metadata.
• Recommend opportunities for reuse of data models in new use cases.
• Lead design and implementation of data warehouse and governance systems.
• Ensure data usage complies with privacy and security policies.
• Guide BI Analysts on platform limitations and capabilities.
• Establish standards and guidelines for developing data models.

Skills

Data modeling

Data architecture

Education

Bachelor's degree in Computer Science, Computer Information Systems, or related data field

Job description

Summary

The BI Architect will understand and translate business needs into analytical data models supporting long-term solutions.

Project Details

• Work with the BI Analysts & Data Architects to develop conceptual data models
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
• Optimize and update logical and physical data models to support new and existing projects
• Maintain conceptual, logical and physical data models along with corresponding metadata
• Recommend opportunities for reuse of data models in new use cases
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
• Lead and provide technical guidance for design and implementation of data warehouse and governance systems
• Ensure data usage is in line with privacy and security policies
• Perform reverse engineering of physical data models from databases and SQL scripts
• Evaluate data models and physical databases for variances and discrepancies
• Validate business data objects for accuracy and completeness
• Establish standards and guidelines for developing data models
• Guide BI Analysts and Self-Developed BI community on platform limitations and capabilities

Job Experience

Minimum of Bachelor's Degree in Computer Science, Computer Information Systems, or other data related field Advanced degree in Computer Information Systems or Computer Science a plus 8+ years of experience as Data Modeler /Data Architect creating data models and working in Data Architecture and Data Management solutions.

Hourly Rate

55-72

Equal Employment Opportunity

Oxford is an Equal Employment Opportunity Employer.

All qualified applications will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

Oxford will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.

• Oxford provides supplemental medical (we do not offer major medical), dental, vision, life, and disability benefit plans along with a 401(k) Retirement Savings Plan.
• Paid holidays based on eligibility and paid sick leave for applicable jurisdiction, as required.

Oxford is committed to working with and providing reasonable accommodation to individuals with physical and mental disabilities.

If you need special assistance or an accommodation while seeking employment, please email [e-mail].

We will make a determination on your request for reasonable accommodation on a case-by-case basis.