Similar Jobs

View More

Senior Business Intelligence Engineer

This job is no longer active. View similar jobs.

POST DATE 8/11/2016
END DATE 10/12/2016

Cox Corporate Services, Inc. Irvine, CA

Irvine, CA
AJE Ref #
Job Classification
Full Time
Job Type
Company Ref #
Mid-Career (2 - 15 years)
Bachelors Degree



The Senior Business Intelligence Engineer will work within the Enterprise Data Services (EDS) team to design, develop, test, maintain and support data analytics and reporting solutions. The individual will work closely in a team consisting of Solutions Architects, Data Engineers, Business Analysts, System Analysts, Quality Assurance Engineers and Database Administrators in developing complex reports / applications and data warehouse solutions to meet stated requirements, develop detailed specifications and unit test plans for implementation.

The individual must be capable of understanding the Hadoop ecosystem; its complex object design and underlying data model of the system. The individual must be comfortable with data-centric applications using Hadoop tools, Netezza, Informatica, Informatica BDE (Big Data Edition), HIVE, MapReduce and Spark as well as a working knowledge of the Hadoop Distributed File System (HDFS).

The individual must have excellent communication skills, work well in a team environment, enjoy solving complex problems and be able to work in a fast-paced environment.

Position responsibilities:

* Design and develop complex reports and dashboards, utilizing advanced components such as: advanced metrics, Free Form SQL, extensive knowledge/experience of graphs.

* Provide innovative creative reporting solutions to complex business goals.

* Perform detailed data analysis, validation, and identify data quality issues.

* Ability to tune reports for best SQL performance to run efficiently in a large data volume environment.

* Create ad-hoc reports as requested and provide on-going analytical support for these requests.

* Assist in architecture and migration of MicroStrategy schema objects

* Assess new initiatives to determine the work effort and estimate the necessary time-to-completion.

* Create test plans and scenarios for development unit testing.

* Work with peers to carry out unit testing of new development.

* Document new development, procedures or test plans as needed.

* Participate in data builds and deployment efforts.

* Participate in projects through various phases.

* Minimal overnight travel (up to 10%) by land and/or air.

* Performs other related duties as assigned.


* Must be passionate, flexible and innovative in utilizing all up to date available tool functionality, experience, and any other resources, to effectively deliver to very challenging and always changing business requirements with continuous success.

* Must be able to interface with various business units to understand the requirements and prepare documentation to support development.

* Must be capable of understanding the complex object design and the underlying data model of the system, as well as have a highly skilled attention to the business requirements details.

* Must demonstrate a clear understanding of BI, Data Warehouse and Hadoop operating environments and related technologies.

* Experience with major Hadoop distributions like Cloudera (preferred), HortonWorks, MapR, BigInsights, or Amazon EMR is essential.

* Experience developing within the Hadoop platform including Java, MapReduce, Hive, Pig, and Pig UDF.

* Minimum 3 to 5 years experience in any combination of industry leading Business Intelligence toolsets, such as MicroStrategy, Tableau, Platfora, Datameer, etc.

* Ability to coach and mentor others on the design, development, and usage of the Business Intelligence tool product suite.

* Strong native SQL skills

* Strong experience in data warehousing concepts and techniques (e.g. Kimball etc.).

* Ability to work in a fast-paced, team oriented environment.

* Ability to complete the full lifecycle of software development and deliver on time.

* Ability to work with end users to gather requirements and convert that to working documents.

* Strong interpersonal skills with a heads-up programming attitude.

* Bachelor's degree (B. A.) from four-year college or university; or four to six years related experience and/or training; or equivalent combination of education and experience.

* Utilize complex computer operations (intermediate programming in 3rd and 4th generation languages, relational databases, and operating systems) and advanced features of software packages (word-processing, spreadsheet, graphics, etc.).

* Ability to read, analyze, and interpret the most complex documents. Ability to respond effectively to the most sensitive inquiries or complaints. Ability to write speeches and articles using original or innovative techniques or style.

* Ability to make effective and persuasive speeches and presentations on controversial or complex topics to top management, public groups, and/or boards of directors.

* Ability to apply advanced mathematical concepts such as exponents, logarithms, quadratic equations, and permutations. Ability to apply mathematical operations to such tasks as frequency distribution, determination of test reliability and validity, analysis of variance, correlation techniques, sampling theory, and factor analysis.

* Ability to apply principles of logical or scientific thinking to a wide range of intellectual and practical problems. Ability to deal with nonverbal symbolism (formulas, scientific equations, graphs, musical notes, etc.,) in its most difficult phases. Ability to deal with a variety of abstract and concrete variables.

Non-essential skills, knowledge and abilities:

* Tableau certification (Certified Professional) and familiarity with version 9 a strong plus.

* MicroStrategy certification (MCE) and familiarity with version 10 a strong plus.

* Experience with Agile and Scrum development process desirable.

* Experience with Netezza is a plus.

* Experience with MicroStrategy SDK is a plus.

Role Specific Competencies:

Corporate Responsibility

* Deals with others in a straightforward and honest manner, is accountable for actions, maintains confidentiality, supports company values, and conveys good news and bad. Establishes open, candid, trusting relationships. Treats all individuals fairly and with respect.

Decision Making/Judgment

* Recognizes problems and responds, systematically gathers information, sorts through complex issues, seeks input from others, addresses root cause of issues, makes timely decisions, can make difficult decisions, uses consensus when possible, and communicates decisions to others.


* Meets commitments, works independently, accepts accountability, handles change, sets personal standards, stays focused under pressure, and meets attendance/punctuality requirements.


* Tackles problems and takes independent action, seeks out new responsibilities, acts on opportunities, generates new ideas, practices self-development.

Interpersonal Skills

* Has good listening skills, builds strong relationships, is flexible/open-minded, negotiates effectively, solicits performance feedback and handles constructive criticism.

Job Knowledge

* Understands duties and responsibilities, has necessary job knowledge, has necessary technical skills, understands company mission/values, keeps job knowledge current, is in command of critical issues.


* Manages a fair workload, volunteers for additional work, prioritizes tasks, develops good work procedures, manages time well, and handles information flow.


* Is attentive to detail and accuracy, is committed to excellence, looks for improvements continuously, monitors quality levels, finds root cause of quality problems, owns/acts on quality problems.

Self Development

* Seeks out and accepts feedback, is a proactive learner, takes on tough assignments to improve skills, keeps knowledge and skills up-to-date, turns mistakes into learning opportunities.

Sense of Urgency

* Prioritizes well, shows energy, reacts to opportunities, instills urgency in others, and meets


Cox Enterprises is a leading communications, media and automotive services company. With revenues of $18 billion and approximately 60,000 employees, the company's major operating subsidiaries include Cox Communications (cable television distribution, high-speed Internet access, telephone, home security and automation, commercial telecommunications and advertising solutions); Cox Automotive (automotive-related auctions, financial services, media and software solutions); and Cox Media Group (television and radio stations, digital media, newspapers and advertising sales rep firms).

The company's major national brands include Autotrader, Kelley Blue Book and Manheim. Through Cox Automotive, the company's international operations stretch across Asia, Australia, Europe and Latin America. To learn more about Cox's commitment to people, sustainability and our communities, please visit

Company Size:
5,001-10,000 Employees
Social Media:
6305 Peachtree Dunwoody Rd
Atlanta, GA 30328

View Larger Map