BI Architect

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 :

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 oxfordbenefitsgroup@oxfordcorp.com . We will make a determination on your request for reasonable accommodation on a case-by-case basis.