> Markdown version of [/jobs/ext/1316138-on-site-database-architect-w-obiee](https://www.wearedevelopers.com/jobs/ext/1316138-on-site-database-architect-w-obiee). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # ON-SITE - Database Architect w/ OBIEE - **Company:** Greycell Labs - **Location:** Menands, NY, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** .NET Framework, Data Analysis, Application Integration Architecture, Health Informatics, Computer Programming, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Migration, Data Warehousing, Relational Databases, Database Design, Oracle Business Intelligence Enterprise Edition, Oracle (Applications), Performance Tuning, System Availability, Data Analytics, Star Schema - **Published:** July 17, 2026 - **Apply:** https://www.dice.com/job-detail/8f07d81a-3463-4bb9-8080-d2954da0f463 ## About the Role * 84 Months Experience developing and maintaining logical and physical dimensional data models, including star schema, snowflake schema, and data migration strategies in enterprise data warehouse and business intelligence environments. * 84 Months Experience using data modeling tools (e.g., Erwin) for data model design, documentation, and review to ensure compliance with enterprise data standards and development best practices. * 84 Months Experience in relational data management, database design, and development using Oracle technologies, including advanced SQL programming for data analysis, optimization, and reporting in data warehouse environments. * 72 months of experience supporting healthcare analytics environments, including maintenance and troubleshooting of OBIEE reporting solutions and ETL processes to ensure data availability, accuracy, and business continuity. * 48 Months Experience in designing enterprise data integration architecture using Informatica, including implementing best practices and mentoring team members for data warehouse and reporting solutions. * 48 Months Experience participating in business analysis and requirements gathering sessions, including translating business requirements into data and reporting requirements. * 48 months of experience using business intelligence tools (e.g., OBIEE 11g) to support data analytics, reporting, and enterprise decisionsupport solutions. * 24 Months Experience designing and implementing enterprise OBIEE dashboards and reports, including repository (RPD) development, metadata modeling, and performance tuning for high-volume data mart environments. * 24 Months Experience establishing and enforcing enterprise data governance, lineage, and data quality frameworks to ensure data integrity, compliance, and reliable reporting across data marts and reporting environments. * Bachelor's degree in IT field ## Description Detailed Job Description: The NYWIC (New York Women, Infants, and Children) system is a statewide application that supports the administration of New York's WIC nutrition program, which provides nutritional assistance and health services to eligible women, infants, and children. The Division of Nutrition relies on custom applications to support the delivery of these programs. The NYWIC MIS-EBT project provides a .NET/Oracle-based platform that enables efficient program operations and ongoing enhancements to meet evolving business needs. Within this environment, the DataMart team is responsible for the design, development, and ongoing maintenance of the enterprise data warehouse and reporting layer supporting the NYWIC application. The team includes Business Analysts, Data Modelers, Informatica Developers, and OBIEE Developers who work collaboratively to deliver and sustain data solutions.The team continuously implements enhancements and updates to the DataMart as the core application evolves, ensuring accurate, reliable, and timely reporting for business users, program administrators, and regulatory stakeholders. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [The Innovation Formula: Fast Prototyping, Data Analysis, and Real User Insights](https://www.wearedevelopers.com/videos/1421-the-innovation-formula-fast-prototyping-data-analysis-and-real-user-insights) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)