Interactive Data Corporation is a trusted leader in financial information. Thousands of financial institutions and active traders, as well as hundreds of software and service providers, subscribe to our fixed income evaluations, real-time market data, fixed income analytics, desktop solutions and web-based solutions. Interactive Data delivers a comprehensive set of products and services designed to meet the needs of the front, middle and back offices at some of the largest and most well-known institutions around the world. These clients trust Interactive Data to provide a wide range of global reference data and listed markets pricing, ultra-low latency data and trading infrastructure services to facilitate electronic trading and sophisticated analytical tools for investment managers including our eSignal Suite of Products . Interactive Data’s offerings can help clients around the world with mission-critical functions, including portfolio valuation, regulatory compliance, risk management, electronic trading and wealth management. Headquartered in Bedford, Massachusetts Interactive Data has more than 2,500 employees in offices worldwide.
We currently have a great opportunity for an experienced individual to take on the role of Business Intelligence / Data Warehouse / ETL Developer in the MIS (Management Information Systems) department, based at the Company’s Corporate Headquarters in Bedford MA.
This position will serve as a technical resource performing development, implementation and maintenance of ETL, data warehouse and business intelligence (BI) solutions, primarily around Oracle Business Intelligence - Enterprise Edition (OBI-EE) and supporting technologies.
Reponsibilities: Design, develop and deploy ETL solutions, including data retrieval and cleansing functions, load automation
Design, develop and maintain BI solutions, including reports, analyses, dashboards and repository
Design, develop and maintain Data Warehouse solutions, including star schema, 3NF / staging tables and processes
Ensuring data modeling and architecture standards are met
Work with users to understand business requirements, objectives, desired features, and input and output requirements
Optimize performance of reports and databases
Document development, logic, coding, testing, changes, and installation
Perform preliminary quality assurance and data validation prior to user acceptance testing
Adhere to organizational standards, policies and procedures so as to ensure controls are in place and goals are met
2+ years hands-on experience building BI solutions using SQL and OBI-EE (BI Server, BI Answers, BI Delivers, BI Dashboards, Briefing Books, BI Publisher)
3+ years hands-on experience using ETL tools such as Oracle Warehouse Builder, Informatica or Oracle Data Integrator, including activities such as ETL process automation, data extraction and transformation, and load automation
3+ years Data Warehouse development experience, with at least 1 full life-cycle implementation of a data mart or data warehouse
Can translate user requirements to a data model, using excellent data modeling skills
Demonstrates strong knowledge of SQL performance-tuning on Oracle 10g RDMBS or higher
Excellent analytical capabilities; strong written and verbal communication skills; ability to work independently, being proactive and accountable for own deliverables
Consulting experience with multiple clients and/or industries a plus
Experience preferred with one or more of the following: Oracle Ebusiness Suite, Oracle BI Applications (and DAC), Informatica, Unix scripting, SAP BPC, Java, XML, Agile Scrum methods
Bachelor’s or equivalent with 5+ years of experience or Master’s or equivalent with 2+ years of experience
Diversity creates a healthier atmosphere: Equal Opportunity Employer.
Trust is Confidence, Transparency is Clarity, Risk is Everywhere, Speed is Advantage, and Wealth is Opportunity.
Keyword: oracle, business intelligence, reporting, reports developer, OBI-EE, ETL, data warehouse
From: Interactive Data