Business Intelligence Developer

  • location: Pasadena, CA
  • type: Permanent
  • salary: $100,000 - $125,000 per year
easy apply

job description

Business Intelligence Developer

job summary:
An S&P 500® company, is an urban office REIT uniquely focused on world-class collaborative life science and technology campuses in AAA innovation cluster locations. Founded in 1994, we pioneered this niche and has since established a significant market presence in key locations, including Greater Boston, San Francisco, New York City, San Diego, Seattle, Maryland, and Research Triangle Park. We are known for its high-quality and diverse tenant base. We have a longstanding and proven track record of developing Class A properties clustered in urban life science and technology campuses that provide its innovative tenants with highly dynamic and collaborative environments that enhance their ability to successfully recruit and retain world-class talent and inspire productivity, efficiency, creativity, and success.


This person will still qualify for a discretionary bonus this year

13 days PTO + 9 Sick days + 12 holidays

Fitness reimbursement of eligible expenses up to $70 per month

401K: Company contribution equal to 6% of the employee's annual compensation

depending on individual eligibility - vested immediately

A complimentary healthy lunch is provided every Wednesday and on the last Friday of

every month

location: Pasadena, California
job type: Permanent
salary: $100,000 - 125,000 per year
work hours: 9 to 5
education: Bachelors
  • 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
  • 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

  • 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
Key Skills:

Power BI

Will have to do some Admin - 70% Dev 30% Admin

Very hands on position

Presentation skills (will be forward facing working directly with CTO & AVP of Tech)

Need to be resourceful, won't have someone giving directions


IT team is 26 people. At the start it was only 5 people in IT Department. They have grown to 26, and they want to double!

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

    PHP Developer

  • location: Los Angeles, CA
  • job type: Temp to Perm
  • salary: $60 - $65 per hour
  • date posted: 9/20/2018