Job Description
POSITION DETAILS
Position title
Report Developer
Manager position title
Engineering and QA Manager
Company
TEG
Department
Technology
COMPANY INFORMATION
About TEG
TEG is Asia Pacific's leading Ticketing, Live Entertainment and Data Analytics company. TEG includes Ticketek, TEG Analytics, TEG Dainty, TEG Digital, TEG Live, TEG Insights, Eventopia, Qudos Bank Arena, Softix, Life Like Touring, The Entertainment Store, Brickman Exhibitions and TEG Asia. Our success is built upon more than 35 years experience in the Australian and New Zealand market with a long standing and iconic presence in the live entertainment and sporting industry.
About Technology
The Technology team are a group of motivated and ambitious IT professionals who support the delivery of an integration lead innovation strategy. We have a culture of individual initiative, problem solving and a willingness to commit to resolution.
PURPOSE OF THE ROLE
Position Overview
Working in an agile environment, the Report Developer is a member of a Scrum team applying solution design skills, strong report technical knowledge, best practice design and code quality disciplines, and sound interpersonal skills in the development of software solutions.
As a Report Developer, you will be responsible for the development of new and existing reports (primarily SSRS) to meet internal business requirements. Data sources will range from SQL databases including SQL Server, Redshift/Postgres, Snowflake to Document databases (MongoDb) and REST & SOAP web endpoints. You will work with stakeholders, business analysts and architects to best interpret and meet user requirements whilst maintaining a focus on accuracy, performance and maintainability.
KEY RESPONSIBILITIES
- ROLE RESPONSIBILITIES
- Design, create and test SQL reports using SSRS and other reporting technologies
- Work with the business analysts, QA Engineers and Architects to interpret user requirements and complete specifications for reports
- Validate report functionality with QA internal staff/end users
- Create and maintain other reporting and data schema documentation as necessary
- Complete development and configuration activities including clean-up, bug-fixing post initial build and support for troubleshooting and release activities.
- Respond to users to troubleshoot and/or improve existing reports
- Collaborate with team members to maintain quality standards using the Agile/Scrum methodology
Employee Responsibilities
- Demonstrate a positive and professional communication style
- Participate in and support a team environment
- Communicate in a clear, timely and consistent manner
- Share information in a positive way
- Follow TEG company policies and procedures
- Support and participate in a safe workplace culture
POSITION REQUIREMENTS
Essential experience & skills
- Good communications skills, written and verbal
- A minimum of 3 years of experience with SQL Server Reporting Services
- Data analysis skills together with report writing and query skills in MS SQL and Transact-SQL
- Highly skilled in table joining, use of temporary tables, ability to step through complex queries, familiar with indexing strategies, creating stored procedures, and utilising views
- Strong troubleshooting and debugging skills, results driven, attention to detail and fast learner.
- Demonstrated high level of numeracy and accuracy
- Ability to work autonomously and as part of a team
- Experience in Microsoft SQL Server 2012/2016/2019 Database Platforms and Microsoft Reporting Services 2012/2016/2019 Development
- Ability to identify, prepare, analyse and present data
Desirable experience & skills
- Tertiary qualifications in Information Technology
- Proven skills in Python, Shell, SQL variants and AWS technologies such as RDS, S3, Kinesis for more advanced reporting requirements
Key Business Relationships/Interactions
Internal stakeholders
- Technical leads
- Technology team
External stakeholders
- Suppliers and technology partners
OTHER KEY CONSIDERATIONS FOR THIS POSITION