Job Description :
Position Summary:
The Sr. Programmer / Analyst is responsible for performing analysis, modification, and daily support of the Business Intelligence activities that are of a high level of complexity and business impact under minimal supervision.
This position will work closely with Information Technology and business personnel to understand business requirements and ensure that developed and purchased applications properly function to meet business needs across the organization.
The Sr. Programmer / Analyst will consult with members of the business community at all levels to identify current operation procedures, clarify program objectives, interpret and evaluate business requirements and provide effective, efficient and innovative system and programming solutions in a fast-paced team oriented environment.

Major Accountabilities:
Use strong analytical skills to produce a well-structured ETL data model design to support intuitive dashboards
Design ETL processes and data flows to align with long-term Data Warehouse Architecture
Managing multiple data sources and projects to support analytics objectives
Define and oversee best practices to guide long-term enterprise data quality.
Build and maintain relationships with business information owners to implement our BI strategy
Work with business users to collect requirements for analytics, dashboards, and reports.
Provide documentation on interfaces, jobs, schemas, standard operating procedures, data movement and databases
Oversee Change Management Process for Business Intelligence solutions assuring all code changes are properly documented in the BI and data warehousing space
Provide training and technical support to business users
Interpreting, debugging, and optimizing ODI SQL outputs
Understanding of application configuration, primarily Oracle Data Integrator (ODI)
Understanding of design concepts in ELT vs ETL
Guide long term integration application direction including administration, testing and future upgrade assessments
Manage ETL processes in Linux/UNIX/Windows operating systems

Minimum Qualifications:
Bachelor’s degree in Computer Science, Management Information Systems or other technical discipline or equivalent work experience
Eight years previous programmer and programmer/analyst experience working with end users in requirements gathering, analysis, and application design and development in a client server and/or web based environment.
Five years Oracle or similar database design and support experience
Experience guiding Data Warehousing and Business Intelligence best practice design principles
Must have experience with multi-source extract and varying data warehouse design concepts
Strong knowledge of BI tools
Proven experience working with data warehousing, ETL, operational reporting, business intelligence concepts, tools and procedures
Strong technical experience working with data modeling principles and techniques
Experience working with data warehousing concepts, terminology, and architecture
Microsoft Windows operating system experience and Office applications
Strong written and verbal communication skills
Participate in on-call and after-hours application and end user support.
             

Similar Jobs you may be interested in ..