Business Intelligence Developer

  • location: Pasadena, CA
  • type: Permanent
easy apply

job description

Business Intelligence Developer

job summary:
Essential Duties and Responsibilities:

  • Architect and tune database data schema, tables, store procedures, functions, triggers and permissions using Microsoft SQL Server and Azure Databases as a service
  • Devise and build data processing jobs for the creation and maintenance of tables and views
  • Manage the logical and physical design of a BI Data Warehouse, including the creation of tables, views, procedures, packages and other database objects in support of OLAP cubes for analytics and system dashboards and reporting
  • Work from business requirements to perform ETL, Reporting, and Analytics functions
  • Document data profiling results, data dictionaries, business glossaries, and data analysis findings
  • Analyze bottlenecks, deadlocks, expensive queries and remediate accordingly
  • Support the database development and production of custom applications for integration and collaboration initiatives
  • Develop data products and analytics to empower operational and exploratory analyses
  • Develop deep understanding of people data model & dash; write queries and manage data transformation to enable analytics and reporting
  • Support, train, interface and participate with peers, users and vendors as needed
Core Competencies:

  • Excellent understanding of data modeling
  • ETL development
  • Strong familiarity of core SQL development
  • TSQL - expert level (required)
  • Debugging
  • Writing optimized code
  • Experience with BI Tools
  • SSIS - expert level
  • SSRS - intermediate level
  • SSAS - expert level
  • Other OLAP technologies
  • Understanding of SQL AZURE as a service
  • Experience with Data Visualization
  • In-depth knowledge of programming concepts and the Software Development Lifecycle (SDLC)
  • Exposure to cloud apps
  • Power BI
  • Good knowledge of DAX and M Language
  • Power Apps (nice to have but not required)
  • Microsoft FLOW (nice to have but not required)
  • JD Edwards exposure (highly desirable but not required)
  • MSSQL Back End
Qualifications and Experience:

  • Bachelor's degree in Engineering/Computer Science or commensurate with job experience
  • 5+ years of experience of MS SQL BI development and administration
  • Excellent documentation skills
location: Pasadena, California
job type: Permanent
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

easy apply

get jobs in your inbox.

sign up

related jobs

    Sr. Java Developer

  • location: Pasadena, CA
  • job type: Contract
  • salary: $73 - $78 per hour
  • date posted: 7/3/2018

    PHP Developer

  • location: Los Angeles, CA
  • job type: Contract
  • salary: $50 - $65 per hour
  • date posted: 7/6/2018