Data Intelligence Analyst

Sales Operations Irvine, California


Description

Design and maintain data systems Drive data warehousing efforts and responsible for developing and maintaining ETL data feeds/transfers through BI reports and dashboards

Responsibilities

  • Extract information from a variety of sources into our SQL Server Data Warehouse by matching and cleansing customer information
  • Maintain database tables and design new BI architecture to align with other systems
  • Generate custom reports summarizing business, sales, and financial data for review by executives, senior leadership, and sales team
  • Develop, test, and implement new business metrics and a variety of third-party data
  • Improve and create new processes with data structure automation
  • Create and maintain documentation requirements, process workflows, and project timelines
  • Collaborate with other teams across the organization

Qualifications
  • Bachelor’s degree in Information Systems, Management Information Systems, or related field.
  • Minimum of five years of experience with SQL Server Management Studio
  • Strong experience in SQL Server Reporting Services
  • Strong experience in Tableau
  • Strong experience with development of ETL processes
  • Ability to translate data models into visualizations through reporting.
  • Strong data management and analytical abilities
  • Demonstrate ability to work in a dynamic, collaborative and fast paced environment
  • Ability to thrive in a demanding, change-oriented, fast paced environment requiring a high degree of deadline-driven productivity
  • Excellent project management skills
  • Ability to meet deadlines and handle and prioritize multiple requests
  • Able to identify upstream and downstream impact analysis through applications, systems, and processes.
  • Exceptional written communication skills and ability to communicate effectively at all levels of the organization.
  • Creative and analytical thinker with strong problem-solving skills.
  • Ability to work independently and manage multiple projects while meeting deadlines
  • Excellent organizational, interpersonal and teamwork skills