Previous Job
Previous
BI Developer
Ref No.: 18-00634
Location: Burbank, California
Position Type:Direct Placement
Title: BI Developer
Location: Burbank, CA
Full-Time Employment with Client
  • Develop and support the SQL Server BI universe by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex T-SQL queries
  • Design and implement SQL Server 2008 R2/SQL Server 2012 Analysis Services multi-dimensional cubes
  • Automation via scripting tools such as PowerShell (in addition to T-SQL)
  • Create and support data load processes via SSIS and database refreshes
  • Identify inefficiencies and gaps in current BI process and reporting solutions
  • Package queries into stored procedures and jobs for scheduling
  • Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications
  • Design and implement data warehouse
  • Develop automated data audit and validation process to ensure end users are getting the right data
  • Experience with full implementation of SDLC
  • Participate in project planning to analyze business requirements and outline solutions
  • Participate in documenting all ETL processes and flows
  • Leads small to medium technical projects for organization projects across platforms or business areas
  • Create and update business intelligence documentation
  • Meet with functional users in understanding, analyzing, and improving their business processes and procedures.
  • Manage applications contracts and maintain vendor relationships.
  • Coordinate with vendors and resolve issues.
  • Develop documentation for applications administration procedures.
  • Conduct training as needed.
  • Other duties as assigned.

Qualifications and Education Requirements:
  • A bachelor's degree is required.
  • 8-10 years of software development and systems analysis experiences is preferred. Experiences with software development life cycle and software/systems architecture best practices.
  • Experience with the Ellucian PowerCampus Student Information System is highly desired or other ERP systems.
  • Expertise should include: programming, project management, report building, process analysis, and web page development.
  • At least three years of building complex electronic reports requiring relational database design experience. Statistical analysis experience is a plus.
  • High expertise with information technology, along with the ability to communicate about those subjects to those with less or no expertise.
  • Experience and familiarity with project management.
  • Ability to work effectively with people at all levels of the University.
  • Ability to work collaboratively.
  • Strong oral, written communication skills and sound interpersonal skills.
  • Experience and proficiency in Microsoft SQL Server 2005/ 2008 R2/2012 and all its products and features, such as SSIS, SSAS, SSRS and Replication
  • Good knowledge of BI Methodology and best practices
  • Excellent communication skills to be able to work with business owners to develop and define key business questions and to build data sets that answer those questions
  • High-level development skills and experience with T-SQL, SSIS, SSAS PowerShell scripting and performance tuning
  • Ability to read, analyze, interpret, and prepare technical documents
  • Ability to design systems and applications based on analysts of business unit requirements
  • A strong interest in business reporting and automation
  • Must enjoy learning new technologies and meet new challenges with enthusiasm