BI Developer

Job opening ID
2388

Posting title
BI Developer

Roles and responsibilities
12 month contract position
W2 with full benefits
Customer and contract specific training will be required and provided.


Job Description:
Will be a member of the Business Intelligence and Analytics Program Office, which initiates new BI projects as well as provides support for existing applications. The developer will be responsible for creating backend processes to load the data warehouse from data sources, as well as web services to deliver data to front end applications. Tasks include:
-Data analysis using SQL
-Data modeling
-ETL design and development using Informatica PowerCenter
-Debugging, testing, and QA
-Implementation and user support
-Utilities, scripting, and automation
-Providing estimates to project management
-Supporting daily operations and maintenance as needed
-Abiding by standards and procedures
-Documenting code and processes
The developer will be part of a team comprising other BI developers, systems analysts, and front end developers.


Required Skills:
•Must be a US Citizen or Green Card Holder
•Offer contingent on ability to successfully pass a background check and drug screen
•5+ years of ETL Design/Development experience
•5+ years of SQL development experience
•Experience developing RESTful web services with either Java/Jersey or Node.js/Express.js/Python
•Ability to develop and test Oracle PL/SQL procedures and triggers, perform SQL tuning and rewrite code as necessary
•Ability to develop and maintain functional and technical documentation
•Experience with reporting tools such as Cognos, OBIEE, Tableau, etc.
•Experience with Web Services, JSON, XML, and RAML
•Knowledge of BI/Data Warehouse concepts, including star schema and aggregation processes
•SDLC/Agile Methodology
•Excel and math skills
•Strong written and verbal communication skills
•Eagerness and ability to learn
•Analytical and problem-solving skills
•Ability to function independently with minimal oversight and direction

Desired Skills:
•PL/SQL
•Oracle EBS R12
•Informatica
•OBIEE RPD Development
•JavaScript and Angular JS
•Experience with dockerized deployments to AWS
•Experience with microservices
•Analytics applications such as Tableau
•Languages such as R or Python
•Keen understanding of statistics


Number of positions
1

Location
Pasadena

State
California