OBIEE Developer
| Company | Cigna Group |
|---|---|
| Location | Mississauga, ON, Canada |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior |
Requirements
- BS in Computer Science, Software Engineering or related degree or equivalent combination of education and related experience
- Strong analytical and problem-solving skills
- Ability to work independently and in a team environment
- Ability to define problems, analyze data, establish facts, and quickly draw valid conclusions
- 5+ years of experience designing, developing, supporting and maintaining enterprise level business intelligence application(s); performing OBIEE maintenance, catalog migration, role based security, repository development and administration
- 3+ years of experience in designing ETL jobs, preferably with ODI, and associated tasks: troubleshooting, tuning, documentation, migration between environments
- 3+ years of experience performing Oracle database support, maintenance, and development using PL/SQL and SQL
Responsibilities
- Participate in the design of analytics solutions supporting at an Enterprise level; planning reporting projects to include but not limited to requirements analysis, project scoping, data analysis, and business logic transformation; changing and optimizing repository layers, models, and subject areas
- Collaborate with BI System Analyst to create required reports using reporting tools like OBIEE, BI Publisher; profile data necessary to meet reporting requirements
- Design, develop, and support visualization tools including but not limited to dashboards, scorecards, operational and scheduled reports, ad-hoc queries, and decision support
- Analyze and optimize queries, review OLAP data structures for tuning overall design
- Implement, document, and perform OBIEE administration processes and policies
- Perform detailed data analysis for online analytical processing (OLAP) and associated ETL jobs
- Design, implement, troubleshoot, and optimize ETL jobs and related mappings
- Provide data cleansing input to application developers, and coach DBAs for ETL job troubleshooting
- Document and publish with the team all existing ETL jobs and processes
- Oracle database development using SQL, and Oracle PL/SQL; Core skills to administer, monitor, and troubleshoot Oracle DBs; Basic knowledge on patching and maintenance tasks on Oracle DBs
- Work closely with Data Architect for database schema changes
- Ensure high availability for OBIEE, ODI, DB, through systems administration/support and change management
- Ensure continuous support and maintenance for OBIEE, ODI, and Oracle DBs through fixes, patches, and upgrades, according to business schedules and requirements
- Communicate task status, roadblocks, and critical matters to management promptly
- Assist level 1 technical support as needed, provide level 2 technical support or open level 3 service requests with support entity or application vendor
Preferred Qualifications
- Experience in working all or most tasks in RHEL systems, understanding WebLogic and Fusion Middleware, Identity Management concepts, basic Linux tasks and operations
- Basic knowledge of Linux operating system, storage systems, networking concepts
- Familiarity with agile concepts and methodology