Data Warehouse Reporting Analyst - Judge Group

The Data Warehouse Reporting Analyst Sr. collaborates with the Information Technology Services (ITS) and Data Warehouse (DW) teams to develop and support organization-wide reporting. The incumbent participates in gathering and documenting report requirements and is responsible for designing, building, and administering reporting solutions for requesting departments. Assistance will be provided to departmental Business/Data Analysts in developing reports using available Business Intelligence (BI) tools. 

The incumbent will also develop ad-hoc reports for business users as applicable and participate in the design and development of the reporting infrastructure using Structured Query Language (SQL) Server technologies and BI reporting tools.

Position Responsibilities

• Participate in a mission-driven culture of high-quality performance, with a member focus on customer service, consistency, dignity, and accountability.
• Assist the team in carrying out department responsibilities and collaborate with others to support short- and long-term goals/priorities for the department.
• Lead the development of business and functional requirements for reports.
• Design, develop, test, and implement reports/dashboards and Extraction, Transformation, and Loading (ETL) processes to fulfill business requirements as needed.
• Serve as a subject matter expert across the organization and assist users with reporting (including ad-hoc reporting) and analysis activities and tools.
• Support user training, testing, documentation, and the roll-out of reports and end-user reporting tools.
• Administer Business Intelligence security, deployment, upgrades, and maintenance.

Required Abilities

The successful candidate should possess the ability to:

• Develop and maintain code using Microsoft SQL Server and Business Intelligence tools.
• Administer Business Intelligence tools.
• Follow detailed procedures to apply security policies consistently.
• Understand business requirements and propose practical solutions.
• Build consensus and work effectively within cross-departmental teams.
• Listen to customers (e.g., staff) to understand and respond positively to their requests.
• Demonstrate exceptional initiative and follow-through on projects with minimal supervision and guidance.
• Initiate and maintain cooperative relationships with coworkers, managers, supervisors, customers/clients, and members of the public.
• Take direction, accept constructive criticism, and be diplomatic when reviewing the work of others.
• Solve problems and work on multiple projects in a fast-paced, deadline-driven environment.
• Communicate clearly and concisely, both orally and in writing.
• Utilize computer and appropriate software (e.g., Microsoft Office: Word, Outlook, Excel, PowerPoint, Access, Project) and job-specific applications/systems to produce correspondence, charts, spreadsheets, and other relevant information.

Experience & Education

• High School diploma or equivalent required.
• 5 years of experience with general relational databases and reporting development required.
• 5 years of experience with BI data warehousing reporting analysis, design, testing, and administration required.
• 5 years of experience developing Microsoft SQL Server stored procedures and using reporting tools such as SQL Server Reporting Services (SSRS), Tableau, or similar platforms.