Oracle Data Architect

Applications Software Technology (AST) was founded on one simple thought, we put our people and our customers first, and you can never lose. AST is a globally recognized award-winning full-service enterprise Cloud transformation and systems integrator, specializing in Oracle Cloud, Salesforce, Oracle NetSuite, and JD Edwards, serving clients in the Public and Commercial Sectors for 29 years. Clients look to AST for leadership and assistance in systems integration, business process redesign, project management, systems administration, and training. From on-premises applications to modern Cloud technology, AST’s services encompass all aspects of Enterprise Resource Planning, Business Intelligence, Enterprise Performance Management, Customer Experience, and Middleware. AST also offers flexible Managed Services, supporting the needs of over 200 Public Sector and Commercial customers around the globe. If you're someone with energy, drive, and creativity, AST might be the place for you.

Currently, we are looking for a highly experienced, team-oriented, Oracle Data Architect to join our technology services team. This is a US based, remote and full-time/permanent only with travel to client site as needed.

What You'll Do:

• Lead Solution Architecture and Presales for Reporting & Analytics solutions for Oracle cloud
• Consult on AST managed engagements, including implementations and upgrades
• Design, develop, test, and implement solutions using Oracle Fusion Analytics Warehouse (FAW), Fusion Data Intelligence (FDI), Oracle Analytics Cloud (OAC), OBIEE and Oracle ADW
• Provide support to Project Team as well as Team members to troubleshoot and help in addressing the problems in applications
• Provide subject matter expertise in Reporting & Analytics solutions for Oracle cloud
• Facilitate knowledge transfer

What You Bring:

• Minimum 10+ years’ experience Architect Reporting & Analytics solutions for Oracle cloud
• Minimum 6+ years of Oracle cloud data model knowledge in HCM, Finance, and Supply chain
• Must have implementation experience of FAW/FDI using Oracle Analytics Cloud (OAC), OBIEE and Oracle ADW
• Minimum 10+ years of experience in BI Publisher, OTBI, OAC, OBIEE and Oracle ADW
• Minimum 5+ years of expertise in building Analytics solutions like Tableau or Power BI
• Primary focus on developing customer solutions using Oracle's analytics offerings: Oracle Analytics Cloud, Data Visualization, Fusion Analytics for Warehouse (FAW), Fusion Data Intelligence (FDI), OBIEE, OBIA, Machine Learning, and Autonomous Data Warehouse (ADW)
• Development and maintenance of Oracle Fusion Analytics Warehouse: building data models, reports, and dashboards, end-user training and support, managing data models, data pipelines, security and performing any customizations.
• Managing users, groups, application roles and data access in FAW environment, customizing as per business needs.
• Enable FAW augmentation to support external data integration with other data platforms.
• Should have extensive, hands on, end to end implementation experience using OAC/OBIEE Reporting tools - BI Publisher, Analysis & Dashboards
• Expertise in design and development of Oracle BI Repository (RPD) solution
• Experience in configuring OBIEE / OBIA security (Authentication and Authorization - Object level and Data level security) as well as tuning and multiple source systems
• Advanced knowledge of OBIA pre-built content and experience with customizing/extending OBIA pre-built content of different modules
• Understanding of Business Intelligence (BI) tools, Data Warehouse (DW), Data Modelling concepts and SQL/PLSQL
• Knowledge of Database, Cloud Concepts, Autonomous Data warehouse (ADW), Data Integration (ODI/Golden Gate) is an added advantage
• BI products certifications preferred
• Experience in AI/ML is preferred

What We Bring:

At AST, people are the center of everything we do, and we work to provide you with benefits beyond a paycheck. We strive to develop and recognize our people at all levels and give them the rewards they deserve. We offer full benefits including medical, dental, vision, retirement/401k, disability, life insurance, and unlimited PTO for all our North American employees to balance your work and life. We also offer additional benefits, such as commuter benefits, legal insurance, pet insurance, sabbatical leave, education reimbursement, parental leave, and much more.

Our Culture:

At AST, people are the center of everything we do. In 29 years of business, we know that putting our people first is the key to success. Our passion for people has earned us multiple awards. Here are some of the most recent:

• 2024 Chicago Tribune Top Workplaces by Energage (6th consecutive year)
• 2024 National Cultural Excellence for Woman-Led Organizations by Energage
• 2024 National Cultural Excellence for Innovation by Energage
• 2023 National Cultural Excellence for Remote Work by Energage
• 2023 National Cultural Excellence for Innovation by Energage
• 2023 National Cultural Excellence for DE&I Practices by Energage
• 2023 National Cultural Excellence for Leadership by Energage

We foster a culture of trust, ownership, and innovation at every level of the organization. All doors are open and everyone’s ideas matter, giving our people the ability to quickly understand our customers’ needs and translate those needs into action. While we celebrate individual wins, we always strive for shared success. We are One AST.

Statement of Non-Discrimination: We value global diversity and are committed to building a diverse and inclusive workplace where we learn from each other. AST is proud to be an equal opportunity employer, making all employment decisions, including recruiting, hiring, training, and promoting without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status or any other characteristic or classification protected by law. The salary for this position is between $140K to $190K per year, A link to AST's benefits can be found here: https://astcorporation.com/wpctent/uploads/2025/01/AST-Benefits-Summary_2025.pdf