Remote: Business Intelligence Developer

We need a Sr. Business Intelligence Developer with OBIEE, Microsoft BI, Tableau and Informatica experience for a 3-6+ month contract role at our Healthcare industry client in Los Angeles, CA.

This means we strongly prefer someone who lives in CA, ideally in Southern CA.

Must-haves

• At least 5 years of experience in Business Intelligence and OBIEE reporting development. At least 5 years of experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Management Studio (SSMS). Must have knowledge with creating Extract, Transform and Load (ETL) technology. We need strong Tableau Core Skills. Informatica Strongly preferred. Currently a resident of California, preferably Southern California area (strongly preferred).

Job Summary

The Business Intelligence Developer III position works on projects to meet business application needs. This position is a key contributor in creating and supporting standard and ad hoc reports to IT and Business Senior Management. This position is responsible for working with Business Analysts and key business contacts to translate functional and technical specifications into a comprehensive reporting design; Assists in requirements analysis, data analysis, data mapping, report development & testing, report modifications and documentation; Determines and develops strategy and framework for consistent report standards. Under limited supervision, the individual performs research/audit and analyzes high level complex/advanced data; defines, designs and develops new/enhanced reports in support of strategic planning, portfolio and project management, resource management and development of standard processes; works closely with business clients to resolve issues and enhance systems utilizing problem solving skill; assesses and evaluates technology needs to recommend solution options; performs interface analysis on detail level. Acts as a Subject Matter Expert, serves as a resource and mentor for other staff.

Duties

Liaison between Information Technology ( I.T.) Business Intelligence developmental team and business clients and defining solutions. Work with Business Analysts and key business contacts to translate functional and technical specifications into a comprehensive reporting design.

Design of database architectures, data warehouses and data migrations. Designs, programs, tests, debugs, maintains and documents hardware/software for an advanced level of projects to meet business application needs interpreting policies, procedures and guidelines.

Accountable for creating business intelligence packages, and implementing user reporting solutions based upon business requirement and content knowledge. Determine development strategy and framework for consistent report development standards. Create and support standard and ad hoc reports to IT and Business Senior Management.

Meet with technical leaders to document and vet business requirements, identify effective reporting techniques, identify the best data sources for reach report field, identify risks and constraints, and design reporting formats.

Perform project management activities to drive projects to completion on schedule with junior team members and mid-Level business professionals. Complete projects/tasks on a timely basis, according to commitments made to stakeholders and management.

Develop, implement, and maintain ETL (extract, transform, and load) solutions to bring new data into the data warehouse.

Applies subject expertise in evaluating business operations and processes. Identifies areas where technical solutions would improve business performance. Consults across business operations, providing mentorship, and contributing specialized knowledge. Ensures that the facts and details are correct so that the project s/program's deliverable meets the needs of the department, organization and legislation's policies, standards, and best practices. Provides training, recommends process improvements, and mentors junior level staff, department interns, etc. as needed.

Perform other duties as assigned.

Required:

At least 5 years of experience in Business Intelligence and OBIEE (Oracle Business Intelligence Enterprise Edition) reporting development.

At least 5 years of experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Management Studio (SSMS).

Hands-on experience developing reports using various tools and processes.

Required:

Must have knowledge with creating Extract, Transform and Load (ETL) technology.

Ability to multitask and prioritize work.

Ability to adapt to changing tools and technologies.

Must possess communication skills to work with the project team to determine and document reporting requirements.

Advanced knowledge of applicable hardware/software configurations and programming.

Excellent verbal and written communication skills.

Service oriented, decisiveness, emotional intelligence, knowledge of the business, problem solving/analytical thinking, Quantitative Prioritization, Results oriented, team focus.