CoStar delivers real-time, verified commercial real estate data that helps clients confidently spot great opportunities and make smart choices ahead of competitors. By combining the power of CoStar’s independent research organization – the industry’s largest – with global data delivery, software, and application solutions, clients can act on opportunities with confidence.
Senior ERP Data Integration Analyst is primarily responsible for guiding the development and improvement of systems/data integrations for Oracle Fusion ER. The role is a member of Financial Business Systems, in the Finance organization, providing direct support to the company’s Global migration to Oracle Cloud ERP. The role is a key, hands-on contributor in the business migration projects. The role is positioned to be a key-contributor to building and supporting System to System data integrations needs of the organization.
Responsible for the movement of data between systems and data stores, maintaining the integrity of data, providing for required transformations, and ensuring error-free, timely, and documented execution.
Determine and design changes to existing systems integrations that improve performance or enhance operations as driven by business needs
Analyze new systems procured or acquired, and working with business and technical teams, develop functional and technical requirements to integrate them with or into existing company systems/data stores, primarily Oracle Fusion ERP
Work collaboratively with the administrators of the system integration tools and other integration analysts
Detect and diagnose integration processing exceptions and systematically resolve them through developed solutions
Use your quality skills not only on data analysis but also testing new data transformation applications.
Strive to maintain clean, consistent and complete data.
Partner with data providers, clients and internal support teams to identify and support the correction of data issues. Based on your analysis, you will propose improvement opportunities.
Support the migration of business systems and integration of business data associated with corporate acquisitions, systems consolidations, and business process improvements
Manipulate and transpose large data sets in a database in order to effectively troubleshoot issues and conduct data analysis.
Establish, monitor, and maintain alerting/notifications and metrics related to all integrations
BS in information systems, computer science, mathematics, finance, accounting, statistics or related
3 + years of experience as a financial or business analyst
5+ years of experience designing, developing, and executing integrations in a developer or administrator role with demonstrated use of Oracle ICS/OIC with Oracle ERP (preference for more Oracle Cloud than Oracle EBS)
Strong knowledge Oracle PaaS integration tools (ICS/OIC) required. Knowledge of other tools (EiPaaS, ETL, sFTP, SSIS) like Dell Boomi, Mulesoft, Informatica, etc.,) would be valued.
Strong understanding of Oracle Applications (Oracle Cloud ERP) base tables and interface tables
Strong skills in the design, development, testing and deployment of custom OTBI and BI Pub reports used in integrations
Strong SQL skills for processing/analyzing large data sets and supporting the translation from user requirements to technical requirements
Strong Excel skills (Power Pivot/Query, V-Look-up, Advanced charting/formulas) VBA
Solid understanding of data systems, including data relationships and data modeling with the ability to learn and understand various data environments
Solid general knowledge of business operations, objectives, strategies, process and information flow
Solid understanding of data systems, including data relationships and data modeling (especially the Oracle Cloud ERP) with the ability to learn and understand various data environments
PREFERRED QUALIFICATIONS AND SKILLS
Proven ability to read and analyze raw data files and compare with transformed data to identify processing problems.
Excellent interpersonal skills
Excellent critical thinking skills to help solve business problems and make decisions- required
Strong preference for experience in service industry; advertising, marketing, leasing, commercial finance, subscriptions
Strong written and verbal communication skills to effectively relate data to coworkers
Demonstrated ability to manage time and prioritize projects to meet deadlines
Demonstrated ability to lead and develop small technical teams
Sound planning and organizational skills with a strong attention to detail
Experience operating in a SOX-regulated company, understanding of ITGC’s
Solid knowledge of reporting tools Oracle (OTBI, FRS, OAC, BICS), SQL (SSRS, SSAS, SSIS), BI Tools (Tableau, Power BI, Qlik, etc.) to support the development and maintenance of business reporting would be value
OVERVIEW OF COMPANY
Founded in 1987, CoStar Group is the leading provider of commercial real estate information, analytics, and online marketplaces. Our suite of online services enables clients to analyze, interpret and gain unmatched insight on commercial property values, market conditions and current availability. Behind some of the most well-known brands in the industry, CoStar Group includes CoStar, the largest provider of CRE research and real-time data; LoopNet, the most heavily trafficked mobile and online real estate marketplace; Apartments.com, the premier rental home resource for renters, property managers and owners; STR, the leading provider of performance benchmarking and comparative analytics to the hotel industry; BizBuySell, the largest online marketplace for businesses-for-sales; and Lands of America, the leading operator of online marketplaces for rural real estate.
Headquartered in Washington, DC, CoStar Group maintains offices throughout the U.S. and in Europe, Canada, and Asia with a staff of over 4,300 worldwide.
WHAT’S IN IT FOR YOU
Working at CoStar Group means you'll enjoy a culture of collaboration and innovation that attracts the best and brightest across a broad range of disciplines. In addition to generous compensation and performance-based incentives, you'll be supported in both your professional and academic growth with internal training, tuition reimbursement, and an inter-office exchange program.
Our benefits package includes (but is not limited to):
Comprehensive healthcare coverage: Medical / Vision / Dental / Prescription Drug
Life, legal, and supplementary insurance
Commuter and parking benefits
401(K) retirement plan with matching contributions
Employee stock purchase plan
Paid time off
On-site fitness center and/or reimbursed fitness center membership costs (location dependent), with yoga studio, Pelotons, personal training, group exercise classes, as well as Segways and bikes available for use during the day
Complimentary gourmet coffee, tea, hot chocolate, prepared foods, fresh fruit, and other healthy snacks
Be part of a team of professionals enjoying the opportunity to learn, do, and grow in a rewarding atmosphere. But don't just take our word for it -- see why our team chose to work at and stay at CoStar Group: https://www.youtube.com/watch?v=CVbJRnJ2sX0
CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing
About CoStar Group
CoStar Group is the leading provider of online real estate marketplaces, information, and analytics in the commercial and residential property markets.