Oracle Analytics Architect with Banking/Financial Services Data Warehouse Experience
Full Time
New York, NY 10006
Posted
Job description
Overview:
At Perficient you’ll deliver mission-critical technology and business solutions to Fortune 500 companies and some of the most recognized brands on the planet. And you’ll do it with cutting-edge technologies, thanks to our close partnerships with the world’s biggest vendors. Our network of offices across North America, as well as locations across the globe, will give you the opportunity to spread your wings, too.
We’re proud to be publicly recognized as a “Top Workplace” year after year. This is due, in no small part, to our entrepreneurial attitude and collaborative spirit that sets us apart and keeps our colleagues impassioned, driven, and fulfilled.
About Our Business:
Perficient's Business Analytics and ERP Business Unit is focused on delivering state-of-the-art solutions to our clients in the areas of ERP, CPM and Analytics. Perficient's Oracle Practice has a deep and longstanding partnership with Oracle that we leverage to ensure our clients get the most up-to-date and relevant solutions for their business need. Perficient is a leader in implementing Oracle Cloud solutions.
Perficient currently has a career opportunity for an Oracle Analytics Architect with experience in the Financial Services and Banking industry.
Job Overview:
This role is considered part of the Business Unit Senior Leadership team and may mentor delivery team members.
Responsibilities:
More About Perficient
Our work enables clients to improve productivity and competitiveness; grow and strengthen relationships with customers, suppliers and partners; and reduce costs. Perficient's professionals serve clients from a network of offices across North America and offshore locations in India and China. Traded on the Nasdaq Global Select Market, Perficient is a member of the Russell 2000 index and the S&P SmallCap 600 index.
Perficient is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national, origin, disability status, protected veteran status, or any other characteristic protected by law.
At Perficient you’ll deliver mission-critical technology and business solutions to Fortune 500 companies and some of the most recognized brands on the planet. And you’ll do it with cutting-edge technologies, thanks to our close partnerships with the world’s biggest vendors. Our network of offices across North America, as well as locations across the globe, will give you the opportunity to spread your wings, too.
We’re proud to be publicly recognized as a “Top Workplace” year after year. This is due, in no small part, to our entrepreneurial attitude and collaborative spirit that sets us apart and keeps our colleagues impassioned, driven, and fulfilled.
About Our Business:
Perficient's Business Analytics and ERP Business Unit is focused on delivering state-of-the-art solutions to our clients in the areas of ERP, CPM and Analytics. Perficient's Oracle Practice has a deep and longstanding partnership with Oracle that we leverage to ensure our clients get the most up-to-date and relevant solutions for their business need. Perficient is a leader in implementing Oracle Cloud solutions.
Perficient currently has a career opportunity for an Oracle Analytics Architect with experience in the Financial Services and Banking industry.
Job Overview:
As an Oracle Analytics Consulting Architect, you will participate in all aspects of the Data Warehouse and Analytics solution development lifecycle which includes requirements gathering, estimation, technical design, implementation, documentation, testing, deployment, and support. This Architect role is primarily related to Oracle Fusion Analytics Warehouse (FAW) for ERP and Oracle Analytics (OBIEE/OAS/OAC). In addition, the candidate is expected to have extensive experience working on Financial Services reporting and banking related data warehouse solutions. As a member working in a team environment, you will collaborate with both the client’s business and technical stakeholders as well as other Perficient architects and technical consultants.
This role is considered part of the Business Unit Senior Leadership team and may mentor delivery team members.
- Interface with financial bank business users about financial services related operational and regulatory reporting and data requirements.
- Lead requirements gathering, design, development, testing and rollout of data warehouse and analytics solutions.
- Setup Oracle Fusion Analytics Warehouse (FAW) for ERP and configure data model extensions to include custom Oracle Autonomous Data Warehouse (ADW) facts and dimensions and custom reporting Subject Areas for data sourced from outside Oracle Fusion ERP.
- Manage development team deliverables related to Oracle Analytics and ETL processes.
- Design all aspects of data modeling to address business analytics requirements. This includes designs of star schemas, staging tables, data lineage, hierarchies, historical analysis with snapshotting, slowly changing dimensions, aggregates, and incremental data load strategies.
- Perform analysis of business requirements, analyze data sources, and perform data mapping between multiple source systems and a target data warehouse.
- Familiarity with ETL processes on Oracle Data Integrator or a similar platform.
- Play a lead role in testing and resolution of issues related to various analytics components including functionality, reliability, performance, and data accuracy.
- Demonstrate the ability to adapt and work with team members of various experience levels.
- Minimum of 8 years of experience with Oracle BI (any of the following platforms: OBIEE/OAS/OAC/OBIA/FAW).
- Minimum 6 years of experience in the financial services industry and bank related data warehouse solutions.
- Banking/Financial Services and Regulatory reporting experience is required.
- Deep expertise with OBIEE/OAS/OAC administration, security configuration, data model creation, and dashboard development.
- Familiarity with Oracle Fusion Analytics Warehouse for ERP including configuration with OCI and Oracle Cloud ERP, and extensibility with external data sources.
- Deep experience with data modeling and data lineage design
- Experience with ETL design concepts, maintenance, and load plan management.
- Strong debugging, problem solving and investigative skills. Ability to assimilate disparate information (log files, error messages etc.) and pursue leads to find root cause problems.
- Strongly skilled in SQL querying.
- Self-starter who can work independently.
- Ability to work effectively with various organizations in pursuit of problem solutions.
- Strong written and oral communication skills; Ability to communicate effectively with technical and non-technical staff.
- Desire to mentor younger team members and develop their skills.
- Experience working on multiple concurrent projects.
- Excellent problem-solving skills.
- Be independent and self-driven.
- Bachelor’s Degree in MIS, Computer Science, Math, Engineering, Accounting or comparable major.
- Must be open to travel.
Preferred skills and education:
- Master's Degree in Information Systems, Business Administration, or related field is preferrable.
- Leadership and team management experience with ability to provide strategic planning and oversight
- Experience leading customer workshop sessions to educate customers on the latest technology trends and best practices
- Track record of leadership roles delivering solutions within defined timeframes
- Experience working with a globally distributed team and managing off-shore teams
Perficient full-time employees receive complete and competitive benefits. We offer a collaborative work environment, competitive compensation, generous work/life opportunities and an outstanding benefits package that includes paid time off plus holidays. In addition, all colleagues are eligible for a number of rewards and recognition programs including billable bonus opportunities. Encouraging a healthy work/life balance and providing our colleagues great benefits are just part of what makes Perficient a great place to work.
More About Perficient
Perficient is the leading digital transformation consulting firm serving Global 2000 and enterprise customers throughout North America. With unparalleled information technology, management consulting and creative capabilities, Perficient and its Perficient Digital agency deliver vision, execution and value with outstanding digital experience, business optimization and industry solutions.
Our work enables clients to improve productivity and competitiveness; grow and strengthen relationships with customers, suppliers and partners; and reduce costs. Perficient's professionals serve clients from a network of offices across North America and offshore locations in India and China. Traded on the Nasdaq Global Select Market, Perficient is a member of the Russell 2000 index and the S&P SmallCap 600 index.
Perficient is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national, origin, disability status, protected veteran status, or any other characteristic protected by law.
Disclaimer: The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time.
#LI-BA1
colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.