9Dot HR

Business Intelligence Developer

US-CA-Pasadena
1 month ago
# of Openings
1
Category
Information Technology

Overview

As a member of our Data Services team, the Business Intelligence Developer will be integral to delivering enterprise-level solutions for large multi-dimensional databases, aggregating data from multiple sources into an efficient data warehouse, and fulfilling ETL/Data Integration initiatives. The BI Developer should have a firm grasp of BI implementation methodologies and will have had in-depth experience with the Microsoft BI Stack (SSIS, SSRS and SSAS).

Responsibilities

  • Write complex, relational, and highly-optimized multi-dimensional database queries
  • Build and maintain reports in SSRS, Tableau
  • Design and provide operational support of BI solutions; monitor/optimize queries and data loads, address concerns on data integrity, monitor performance, and communicate functional and technical issues
  • Create and customize Data Warehouse data marts as needed
  • Perform scripting and programmatic tasks related to data integration projects, data cleansing and manipulation
  • Create and maintain data distribution between EDI and the 3rd party data sources via API and/or SFTP
  • Convert business objectives into technical requirements; and deliver data solutions/metrics to stakeholders that leads to more impactful data analysis
  • Collaborate, share/gain knowledge with teammates; grow BI’s total impact to the organization. 
  • Self-organize tasks to ensure business priorities are met and progress is communicated effectively in an agile development environment

Qualifications

  • Advanced SQL programming ability and experience with a major RDBMS (SQL Server, Oracle, MySQL, Postgres etc.)
  • Solid experience with database platforms, especially MS SQL Server
  • Experience building ETL/Data Integration processes. Experience with a major ETL tool (SSIS, Informatica, Talend etc.)
  • Experience designing data warehouse structures (Data Marts, Cubes)
  • Knowledge of database modeling paradigms (3NF, Dimensional etc.)
  • Experience using a scripting or object-oriented programming language
  • Experience with MS SQL Server Integration Services (SSIS)
  • Experience working major BI tools (SSRS, Tableau, Looker, etc)
  • Knowledge of SFTP file transfer and API interfaces for data exchange 

Education / Experience:

  • Academic background in Statistics, Computer Science, or Information Management
  • Relevant experience in a report development, data science, business analytics, business intelligence or comparable data engineering role, including data warehousing and business intelligence tools, techniques and technology
  • Solid understanding of relational and dimensional database structures, theories, principles, and practices

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.