Data Warehouse Developer

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

job description

Data Warehouse Developer

job summary:
We are an urban office REIT uniquely focused on world-class collaborative science and technology campuses in AAA innovation cluster locations. We are known for its high-quality and diverse tenant base. We have a longstanding and proven track record of developing Class A assets clustered in urban 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.

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

  • Bachelor's degree in Engineering/Computer Science or commensurate with job experience
  • 5+ years of experience of Data Warehouse development and administration
  • Excellent documentation skills
skills: Core Competencies:

  • Excellent understanding of data modeling
  • ETL development
  • Strong familiarity of core SQL development
  • TSQL - expert level (required)
  • Debugging
  • Writing optimized code
  • SSIS - expert level
  • SSRS - intermediate level
  • SSAS - expert level
  • Other OLAP technologies
  • Understanding of SQL AZURE as a service
  • In-depth knowledge of programming concepts and the Software Development Lifecycle (SDLC)
  • Exposure to cloud apps
  • BI Tool experience (nice to have but not required, Power BI preferred)
  • 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

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

    Android Developer

  • location: Pasadena, CA
  • job type: Contract
  • salary: $55 - $59.37 per hour
  • date posted: 11/30/2018

    iOS Developer

  • location: Pasadena, CA
  • job type: Contract
  • salary: $55 - $59.37 per hour
  • date posted: 11/30/2018

    Sr. Software Engineer

  • location: Pasadena, CA
  • job type: Contract
  • salary: $55 - $59.37 per hour
  • date posted: 12/11/2018