Skip navigation
Open Source Data Analyst - 60-95k

Open Source Data Analyst - 60-95k

Apply Now

COMPETITION SNAPSHOT

Applications Submitted
for this Position
Most Common Years
of Experience
is the most
common degree type

Job Description

Does the idea of analyzing complex data inspire you? Are you ready to make smart decisions that result in superior business solutions?   Our client is seeking a Senior BI Engineer that will be responsible for data analysis, problem solving, investigation and creative thinking using data as a focal point.  This role is a key member of the core analytics team with substantial opportunity to impact business results and corresponding career and personal growth.  The role requires working closely with the business to collect data needed for various operational needs through data exploration and once validated, building ETL processes into a scalable data warehouse environment.

Responsibilities:

  • Design, develop, and maintain initial-load and incremental ETL processes
  • Function as a data expert to advise business analysts in the usage of the data
  • Respond to data queries/analysis requests from various groups within the company
  • Extract and analyze data from various sources, mostly MySQL databases using SQL, ETL and OLAP tools (Pentaho) 
  • Analyze and capture meaningful and operationally actionable information from very large scale relational database
  • Document data requirements and process and validate data components as required
  • Represent technical projects and initiatives while understanding core business goals
  • Act as a liaison between technical and analysis teams
  • Help optimize SQL queries and processes
  • Identify data quality issues and their root causes
  • Design, develop, and maintain the logical and physical dimensional data model of the enterprise data warehouse
  • Interact with internal and external support teams on non-functional (infrastructure, security, user admin) requirements

Job Requirements

Desired Skills & Experience
  • Bachelor’s degree in a technical field (i.e. engineering, computer science, math, etc.)
  • 3-5 years of experience in SQL programming with strong understanding of query optimization and aggregating data using complex SQL code.  i.e., using functions such as SUM, COUNT, CASE statements, etc.
  • Experience with MySQL databases and knowledge of query tools and/or BI tools like Business Objects or Pentaho
  • Experience with Unix/Linux operating system
  • Solid Data Warehouse ETL developer with at least 2 to 3 yrs. of tool based ETL development experience
  • Solid understanding of dimensional modeling and data mart development
  • Experience working in an Agile development environment
  • Expert knowledge of Excel Graphs, Charts, and Pivot Tables
  • First-rate analytical and problem-solving skills, and flawless attention to detail
  • Mastery of prioritizing and self-management, but seeks help when necessary
  • An appetite for an early stage company – must be able to multitask efficiently and work comfortably in a changing environment
  • Sees problems as opportunities for improvement and takes initiative to solve them
  • Excellent verbal/written communication and problem solving skills; ability to communicate information to a variety of groups at various technical levels 

Job Snapshot

Base Pay $70,000.00 - $100,000.00 /Year
Employment Type Full-Time
Job Type Education, Information Technology, Science
Education 4 Year Degree
Experience 3 to greater than 15 years
Manages Others Not Specified
Industry Internet - ECommerce, Computer Software
Required Travel None
Job ID PH-174374
CareerBuilder Tip:
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder.com you are agreeing to comply with and be subject to the CareerBuilder.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Open Source Data Analyst - 60-95k


Enter notes about this job:

Cancel