Report Developer III at Wheels in SCHAUMBURG, Illinois

Job Description:

Job Description:




JOB OVERVIEW



The Report Developer III will be responsible for reporting analysis, requirements gathering and report development. Must demonstrate thorough knowledge of SSRS, BI, data warehouse development, and data analysis. Design, develop and maintain standard and ad hoc reports that serve to provide decision support to internal and external data users. Reports will be developed using a variety of reporting tools, including SSIS, SSRS, and other BI tools.


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.



KEY RESPONSIBILITIES - ESSENTIAL FUNCTIONS



• Ability to understand business needs and information and translate into a creative reporting solution in accordance with end user and client requirements.


• Design, develop and maintain SQL queries and support ad hoc requests for data, while adhering to departmental standards. Design, develop and maintain reports, including tabular reports, scorecards and dashboards, while adhering to departmental standards.


• Design, develop and maintain database stored procedures, while adhering to departmental standards.


• Identify and troubleshoot business process or data quality issues that show up in the reports and subsequently communicate to resolve and eliminate problems.


• Demonstrates proficiency in developing complex expressions to calculate, group, filter, parameterize, optimize and format custom reports.


• Demonstrates proficiency in developing and formatting different types of reports such as Cross-Tab, Conditional, Drill-down, Drill Through, Top N, Summary, Inline Queries, Multiple Tab and Sub reports, and using cubes in reports Perform quality assurance testing for all reports, created or modified and assists end users with acceptance testing.


• Optimizes reports to isolate problems or determine more efficient query execution methods.


• Creates and modifies report schedules in InfoBurst packages or Microsoft Reporting Services.


• Participates in quality assurance testing and peer code reviews.


• Researches and resolves reporting and data issues in a timely and effective manner.


• Maintains current knowledge of standard languages and coding methods. Suggests enhancements to departmental standards as needed and assists in the design of standard reporting templates.


• Provides technical assistance to others in the department on code development.


• Prepares required documentation as outlined by departmental standards.


• Other duties and responsibilities as assigned.



LEADERSHIP RESPONSIBILITIES



• This position has no leadership responsibilities.



COMPETENCIES - SKILLS



• Works independently, productively manages time to achieve work objectives, organizes tasks, and maintains flexibility in meeting work demands. Possesses a strong sense of teamwork and cross-departmental collaboration.


• Ability to analyze data and use problem solving skills to produce complex reports. Ability to define problems, collect data, establish facts, and draw valid conclusions.


• Ability to adapt communication style, content, and format for varying circumstances and audiences of all levels and functional areas. Ability to communicate with an audience of technical and non-technical users with varied levels of computer literacy.


• Assumes responsibility and accountability for work and projects while focusing on results that exceed expectations.


• Demonstrates resourcefulness and responsiveness in completing projects and maintains a positive attitude toward individual and departmental tasks and projects.



EDUCATION AND EXPERIENCE



• Bachelor's degree, preferably in a technical field, with 5+ years applicable experience in Information Technology.


• 3 to 5 years hands-on experience in a developer role, with core expertise in data analysis, query design, and reporting using Microsoft Business Intelligence Development Studio (BIDS) in SQL Server 2008 environment.


• Report design and visualization experience required. Proficient in creating and modifying T-SQL queries and stored procedures in SQL Server 2008 R2.


• Basic understanding of data warehousing concepts, terminology and architecture. Ability to use enterprise business intelligence reporting tools to develop reports from using large volumes of data and/or data warehousing tables.


• Experience with SSRS Business Intelligence Developer Studio, SQL Server Management Studio, Visual Studio, SQL Server Integration Services (SSIS), and/or other (non-Microsoft) reporting platforms required.


• Experience in relational and dimensional modeling a plus, ETL/SSIS experience a plus.



JOB SPECIFICATIONS, PHYSICAL DEMANDS AND WORK ENVIRONMENT




Work Environment: This position is in Georgia or Illinois and operates in a professional office environment.



Positions Type/Standard Schedule: This is a full-time position, Monday through Friday.



Travel: No Travel required for this position.



Physical Demands: Speak, hear, and see, and to use hand and fingers for computer keyboard and phone. Sit or stand for extended periods of time. Reach above head to pull paper attachments.



DISCLAIMER



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.


EEO Statement



Wheels is a Drug-Free Workplace. All employment is contingent on successful completion of drug and background screening.


Wheels is an equal opportunity affirmative action employer and administers all personnel practices without regard to race, color, religion, sex, age, national origin, sexual orientation, gender identity or expression, marital status or domestic partnership status, disability, protected veteran status or military status, genetic information, or any other category protected under applicable law. Wheels is committed to taking affirmative steps to promote the employment and advancement of minorities, women, persons with disabilities and protected veterans.