Data Warehouse BI & Visualization Developer

Technology - Engineering Woodland Hills, California


Description

The Data Warehouse – BI Visualization Engineer will enable the company’s use of data as a strategic asset of corporate goals and objectives. He or She will be responsible for strategically designing, developing, and implementing enterprise-level BI solutions, data integrations and analytical applications. This role is responsible for understanding and documenting data sources, usage and lineage for enterprise information.  The DW-BI & Visualization engineer must drive the completion of projects within the established scope, while simultaneously planning for and managing unknown future BI requirements in a dynamic environment.

The ideal candidate will have extensive hands on experience as a Visualization Designer working with Tableau, creating  prototypes,  dashboards and data warehouses. 

Preference will be given to engineers who have worked with Google Data Studio, Looker and Tableau. 



Responsibilities:
  • Play an instrumental role in developing the data warehouse and BI strategy and initiatives.
  • Analyzes business and technical requirements, translate them to high level design documents.
  • Design and implement BI tools and processes for data intake from multiple sources.
  • Establish and maintain data security and compliance, access controls, data governance.
  • Design and implement user analytical and visualization tools.
  • Provide support to the BI users on the effective use of reporting tools and data structure
  • Identify requirements, design, create, deploy, monitor and support BI reports and dashboards, shared object and cubes to empower discovery and information-sharing for business partners.
  • Utilize expertise and knowledge of data modeling, ETL, and report design for department initiatives, and produce detailed documentation including data flow diagrams, logical diagrams, and physical diagrams as needed.
  • With minimal supervision work on a wide range of projects interfacing with development teams, business analysts, IT management and members of the business units

Qualifications:
  • Bachelor’s Degree in Computer Sciences, Information Systems or related fields.
  • 5+ years of intense technical experience in the areas of data architecture, data modeling, data management, data warehouse environment
  • Deep understanding of warehouse design, data engineering and/or data governance.
  • Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation, and optimization.
  • Deep understanding of relational and dimensional database domains.
  • Strong experience with data warehouse, ETL and BI technologies.
  • Advanced query and SQL skills.
  • Software and scripts development experience.
  • Extensive knowledge of on-prem and cloud-based IT infrastructure.
  • Strong background in master data management, metadata management, information lifecycle design, and development.
  • Knowledge of Salesforce, Marketo, Adaptive Planning, and NetSuite database structure is a big plus.
  • Expertise with data visualization tools such as Tableau, Google Data Studio, and Looker.
  • Strong analytical and troubleshooting skills.
  • Highly motivated self-starter, detail and quality oriented and ability to handle multiple competing priorities.
  • Must be a strong team player with a positive attitude and enthusiasm to get things done.
  • Presentation skills to various levels of the organization including executive management.
  • Excellent communication (both written and verbal), interpersonal skills and experience.