Hiring: Business Intelligence Developer / Administrator - Wagner Equipment Co.

[devonmiller]

Job Description
Wagner Equipment Co., the Caterpillar dealership serving Colorado, New Mexico, and Far West Texas is seeking a BI Developer / Administrator for our Aurora facility. Wagner Equipment Co. offers excellent benefits, tuition reimbursement, medical, dental, vision insurance, and more. This position does not offer relocation reimbursement. Wagner Equipment Co. is an equal opportunity employer EOE.

This position continually enhances and develops the initiatives and offerings of the IT Development department through the Business Intelligence department.  The BI Developer/Administrator supports the Company's enterprise wide reporting efforts through the administration, development, and maintenance of BI applications, complex queries and other applications as required. Additionally, this position will serve as a mentor to other BI developers and act as a liaison to training efforts.


ESSENTIAL FUNCTIONS AND BASIC DUTIES

Administrative
• Maintains and enhances OLAP cubes and underlying relational definition tables once created by updating changes in reporting structure, hierarchies, or adding additional dimensions as requested
•Administers BI tool suite: including user security, audit logging, framework/catalogs, automation of cube builds and data loads, query and server optimization, project management, training and support
•Documents processes, report and query specifications, and other pertinent data to recreate or maintain applications
•Works directly with other Caterpillar dealers and consultants to leverage BI
applications and adapt best practices in BI development and use
•Manages joins, relationships, field attributes, aggregations, and underlying report content integrity

Organizational
• BI development, deployment, maintenance, and support as requested by various stakeholders. BI development includes, but not limited to, ad-hoc queries, cubes, reports, dashboards, metrics, scorecards, report bursting, and event notifications.
•Interfaces with other departments to ensure all reporting needs are being met
•Collaborates with the DBA to ensure data is being updated and backed up
•Knowledge of tables, views, stored procedures, and triggers
•Integrates multiple disparate data sources into a single source for reporting and analysis
•Utilizes ETL tools to schedule and automate data transfer/replication into data marts
•Supports the department in a variety of ways including but not limited to, data mining, developing complex queries, researching/recommending software tools to meet specific needs, and assisting in data cleansing or program conversion efforts.

Interpersonal
• Effectively discusses, translates, and describes highly technical subjects to a non-technical
audience
•Gathers and analyzes business requirements and then executes and delivers a solid end
product
•Trains the organization on how to use business intelligence products
•Actively contributes to a highly collaborative BI workgroup via peer code review and idea sharing

Technical
• Ability to learn new technologies and quickly adapt
•Ability to interpret and write SQL, XML, and MDX code
•Application of best practices in BI data presentation and report design
•Installation, configuration, and maintenance of the BI environment


Desired Skills & Experience
Required Education: Bachelor's degree in IT or MIS, or equivalent experience
Preferred Education: Master's degree in BI, IT or MIS, or equivalent experience

Required Experience: Intermediate (3-5 yrs)
Preferred Experience: Advanced (5+ years)

Experience Defined: Basic (1-3 yrs)       Intermediate (3-5 yrs)       Advanced (5+ yrs)
Technical - Advanced
Administrative / Clerical Experience - Intermediate
Customer Service Experience - Intermediate
Supervisory/Mgmt Experience - Basic

Required Skills and Competencies
Product Knowledge                Organizational Skills
Communication Skills             Attention to Detail
Interpersonal Skills                 Problem Solving
Analytical Skills                       Responsiveness
Professionalism                      Multitasking
Telephone Skills                     Teamwork

Preferred Computer Skills
IBM Cognos Business Intelligence (v8 / 10) - Advanced
Microsoft Office Suite - Intermediate
SQL - Intermediate
Knowledge of current technological advancements - Basic