Would you like to be part of a focused, dedicated team? Do you want to work and grow with other motivated, ambitious people?

Wagner Equipment Co. offers challenging career opportunities, extensive training and employee development along with an opportunity to grow your career and thrive under Wagner’s reputation for excellence. We offer excellent benefits and supply you with the tools you need to maximize your potential and grow within Wagner.

Benefits include:

• Paid Time Off (PTO) Plan - Up to 96 hours of PTO in your first year 8 company paid holidays
• Medical, dental, and vision insurance 
• Life and AD&D Insurance
• Retirement Plans - 401K and Roth 401K , eligible employees can receive a company contribution up to 7%
• Tuition Reimbursement 
• Employee Assistance Program (EAP)
• CEFCU- Citizens Equity First Credit Union - Employees have access to services include payroll deductions savings, accounts, loans, VISA card, and more.
• Additional Benefits include: Unum Supplemental life Insurance, Aflac Critical Illness Accidental Insurance, ID WatchDog and discounted employee phone plans.

The Business Intelligence (BI) Developer/Administrator position continually enhances and develops the initiatives and offerings of the IT Development/Deployment 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.

Pay rate: $65,000.00 - $85,000.00 Annually
Pay rate is dependent upon education & experience. 

Essential Functions:

Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

• Maintains and develops databases in SQL Server, providing integration and replication services as required through other systems to support the business intelligence tools
• Manages data security, connections, and documentation of data structures in SQL Server
• Maintains and enhances cubes and underlying relational definition tables once created by updating changes in reporting structure, hierarchies, or adding additional dimensions as requested
• 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
• Provides 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
• Assists with DBA functions to ensure data is being accurately managed for BI Tools, both SQL and admin roles
• Applies 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
• 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
• Ability to learn new technologies and quickly adapt
• Ability to interpret and write query languages such as SQL and XML
• Applies best practices in BI data presentation and report design
• Supports Installation, configuration, and maintenance of the BI environment
• Other duties as assigned by manager

Required Education and Experience:

• High School Diploma or GED
• Bachelor’s degree in IT or MIS or equivalent experience
• Minimum of 3 years experience, with 5 years experience preferred
• 3-5 years administrative/clerical experience
• 3-5 years customer service experience

Preferred Skills and Competencies

• Advanced knowledge of reporting tools such as IBM Cognos Business Intelligence (v10)
• Understanding of business concepts and operational metrics
• Understanding of database design and data integrity concepts
• Python experience
• Advanced SQL experience

Physical Demands & Competencies:

• Standing, walking, talking, sitting, use of hands & hearing
• Sedentary work that primarily involves sitting/standing but may require occasionally lifting and/or moving up to 25 pounds
• Data Entry, telephone, reading/writing, reasoning, organizational, communication & math skills
• Safety & Product Knowledge
• Attention to Detail
• Analytical Skills
• Interpersonal Skills
• Problem Solving
• Telephone Skills
• Ability to Multi-task
• Basic knowledge of current technological advancements
• Intermediate knowledge of Microsoft Office Suite
• Familiarity with at least one significant reporting tool such as Cognos and multidimensional reporting
• Judgement skills, planning and project management

Work Environment:

• Noise: Quiet
• Indoors

Travel Requirements:

• 1-25%

Other Duties:

Job Offers are contingent upon all required pre-employment screenings which may include but are not limited to background checks, drug/alcohol testing, fit for duty testing, and any other job-related tests/screenings.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Requirements are representative of minimum levels of knowledge, skills and/or abilities. To perform this job successfully, the employee must possess the abilities or aptitudes to perform each duty proficiently.

Wagner Equipment Co. is an EEO/AA/Veterans/Disabled employer.