The SQL Report Developer is responsible for plan, design, maintain, develop, and implement reports and dashboards based on the needs of end users, while optimizing database queries to improve efficiency and effectiveness.
Will work with experienced SQL Developers and Database Administrators to develop queries, create indexes, and stored procedures as it relates to Reporting Team needs. Requires knowledge of SSRS. Assist in training users on reporting tools and analysis of data.
Works with internal and external customers, including cross functional teams, to gather specifications for data and report requirements.
Manages complex technical reporting projects; utilizing best practices and maintaining detailed technical design documentation.
Creates and maintains a formal report writing process.
Creates, maintains, optimizes, and supports new and existing complex reports as specified by end users.
Creates and executes a data integrity/consistency plan for monitoring data across multiple platforms on a regular basis.
Develops SQL queries to extract, manipulate and/or calculate information to fulfill data and reporting requirements.
Develop, modify, maintain, and support custom reports (MS SQL, SSRS, Crystal Reports) for both ad-hoc and ongoing business needs.
Identify business challenges and improvement opportunities.
Creates and maintains a positive relationship with our user community.
Prompt and regular attendance is required.
Desirable experience in some or all of the following:
Knowledge in DevOps.
Knowledge in MS Azure
Experience with JIRA.
Experience with Bitbucket.
Experience in one or more of the following: Crystal Reports, Tableau, Power BI and Excel
Experience with unit testing frameworks.
Excellent analytical, mathematical, and creative problem-solving skills.
Excellent written and oral communication skills.
Excellent listening and interpersonal skills.
SQL Report Developer:
• 3 years Information Services database and/or direct report writing with SQL Server.
• 3 years of experience in SSRS
• Comprehensive knowledge and experience with SQL queries.
• Experience with ETL (Extract, Transform, Load).
• Ability to handle and manipulate large volumes of data.
• Demonstrated organizational, analytical, and project management skills.
• Ability to communicate verbally and in writing.
• Availability to travel 20%
• English: Advanced 80% – 90%