13 days old

Business Intelligence Developer

Pasadena, CA 91101
  • Job Code
  • Jobs Rated
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.


Jobs Rated Reports for Computer Programmer

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Business Intelligence Developer

Randstad Technologies
Pasadena, CA 91101

Share this job

Business Intelligence Developer

Randstad Technologies
Pasadena, CA

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Computer Programmer
61st2018 - Computer Programmer
Overall Rating: 61/220
Median Salary: $82,240

Work Environment
Very Low
Very Poor
Powered ByCareerCast