ODI ETL Developer Senior Consultant

Harwood, MD
Sep 14, 2021
Sep 17, 2021
Full Time
OverviewGuidehouse is a leading global provider of consulting services to the public and commercial markets with broad capabilities in management, technology, and risk consulting. We help clients address their toughest challenges and navigate significant regulatory pressures with a focus on transformational change, business resiliency, and technology-driven innovation. Across a range of advisory, consulting, outsourcing, and digital services, we create scalable, innovative solutions that prepare our clients for future growth and success. The company has more than 10,000 professionals in over 50 locations globally. Guidehouse is a Veritas Capital portfolio company, led by seasoned professionals with proven and diverse expertise in traditional and emerging technologies, markets, and agenda-setting issues driving national and global economies. For more information, please visit: .ResponsibilitiesResponsibilities:As a ETL/ ODI/ OBIEE developer, you'll help lead the design, development and implementation of the data extractions, transformations and load procedures including analysis of existing source systems and data sources, operations and maintenance and business process reengineering projects, as well testing and release management. You'll help lead our clients and the project team through a structured process to analyze, test, validate and review the solutions being implemented. Define and execute on a robust plan to ensure all client requirements are met, while pushing the team to continuously innovate and streamline the data quality assurance/testing process. Our professionals help our clients transform their business processes, improve internal controls, improve efficiency of operations, increase transparency and performance management, and to comply with Federal laws and regulations. The nature of our projects is extremely fluid and requires self-motivated individuals that are willing to develop solutions on their own or in a team of highly skilled professionals. Project members are provided the opportunity to interact with our clients' senior management, as well as the opportunity to enhance their skills in the area of technical competency, business development, client service and people development.QualificationsRequired:The successful candidate will have proven experience implementing and supporting Oracle Data Integrator /ETL system integrations, data warehouses and reporting solutions and support data analysis functions (including budgets and planning data, financial transaction data, testing and validation) for commercial entities and federal agencies. The candidate shall oversee and lead the development of the ODI components and support process improvement recommendations and implementation to enterprise systems and functions. Specifically, the following skills and experiences are requested:Minimum Years of Experience: Experience of three or more years is required with experience with Oracle Data Integrator (ODI) and ETL tools and procedures, Oracle Business Intelligence (OBIEE), business process review, testing and data quality assurance activitiesAbility to offer insights based on experience and through functional business process analysis, supporting budget and financial management initiatives within the federal civilian sectorApply a structured quality assurance methodology towards complex projects. Oversee quality assurance and testing of the business processes and solutions, managing and ensuring testing milestones are achieved as per the project timeline.Responsible for development and maintenance of assigned enterprise architecture project and takes project from planning through final delivery. Interfaces with all areas affected by the project including end users, computer services, and client services.Provides technical and analytical guidance for enterprise architecture. Recommend data integration solutions and execute on the ETL solutions.Possesses extensive knowledge of and hands"A' on experience with oracle data integrator or other ETL toolsMinimum Skills/Qualifications: At least 3 years' experience in Oracle ETL tools, Oracle Enterprise performance Management or OBIEE Oracle ADF Framework or Custom UI (Java, Angular JS, Visual Studio, .Net) applications.Experience with Oracle Data Integrator, OBIEE, Hyperion Planning and Essbase Applications.Experience with Oracle OBIEE Data Analytics tool. Supports workflow set up, configuration and edit check development. Supports data migration. Supports software releases.Evaluate and test software applications, compile data and produce relevant reports.Leverage advanced technical skills and knowledge to excel in an application systems analyst career.Overseeing implementation of required hardware and software components for approved applications, coordination tests of the application system for proper performance. (Functional understanding)Lead project and task owners and ensure that cohesive progression in testing standards.Minimum Skills/Qualifications: At least 3 years' experience in Oracle Data Integrator and related ETL applications.Degree Holds a four year degree from an accredited college or university.Professional Certification (Quality Assurance, Testing tools, Lean Six Sigma Certified Green Belt, PMP, CAPM) preferredExcellent verbal and written communication skills (including presentation skills)Understanding of functions affecting budget and financial data (eg, Procurement and Acquisitions, Formulation, Execution, Reporting)Understanding of funding and financial accounting structures (eg, Funds, cost types, Object Class)Experience and comfort with MS Excel and other MS Office productsAggregate and synthesize data from authoritative systems into metrics and analyticsAbility to quickly comprehend complexity and convey findings in concise, well-written narrativesPrior business process and data analysis experience with HHS, NIH, CMS, CDC or FDA preferredAdditional RequirementsThe successful candidate must not be subject to employment restrictions from a former employer (such as a non-compete) that would prevent the candidate from performing the job responsibilities as described.DisclaimerAbout GuidehouseGuidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.Rewards and BenefitsGuidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.Benefits include:Medical, Rx, Dental & Vision InsurancePersonal and Family Sick Time & Company Paid HolidaysParental Leave and Adoption Assistance401(k) Retirement PlanBasic Life & Supplemental LifeHealth Savings Account, Dental/Vision & Dependent Care Flexible Spending AccountsShort-Term & Long-Term DisabilityTuition Reimbursement, Personal Development & Learning OpportunitiesSkills Development & CertificationsEmployee Referral ProgramCorporate Sponsored Events & Community OutreachEmergency Back-Up Childcare ProgramPosition may be eligible for a discretionary variable incentive