US
0 suggestions are available, use up and down arrow to navigate them
Reports Writer in US

Create Job Alert.

Get similar jobs sent to your email

Apply to this job.
Think you're the perfect candidate?
SSRS Report Writer at

SSRS Report Writer

Phoenix, AZ (Onsite) Full-Time
Posting Date12/15/22

Application DeadlineOpen Until Filled

Pay RangeMin - 1st Quartile - Mid - Max
$77,480.00 - $90,324.00 - $103,168.00 - $128,856.00

The expected ENTRY pay range for this position based on experience and equity within the Judicial Branch is $105,000.00 to $115,000.00.

This position is exempt under the FLSA.

Standard Judicial Branch business hours are Monday through Friday from 8 am to 5 pm. This position may allow for a teleworking schedule dependent on the needs of the Judicial Branch.

What We Offer
We offer generous paid time off, paid sick leave, and 10 paid holidays! We have affordable medical, dental, and vision insurance, and our employees are entitled to coverage by one of several State-sponsored retirement pension plans, our employee assistance program, and wellness incentives. Additionally, our employees have the option of life insurance, disability, a group legal plan, and pet insurance. Click here to learn more!

Job TypeUnclassified - Judicial

DepartmentD800 Superior Court

About the Position
The Microsoft SSRS Report Writer position is responsible for delivering full life-cycle reporting solutions using industry standard business intelligence tools to expose data and KPI's to executive management. You will be responsible for the design, development, testing and maintenance of simple to complex reports and ad-hoc dataset requests. You will also assist departments in identifying any need for further data sources and content that will move the Courts forward with data driven decision making. This role requires you to be a leader in quality control and highly knowledgeable about report-writing and business intelligence best practices.

This position is expected to work closely with the Judicial Branch Data Integrity & Analytics (DIA) department which assesses needs, builds relationships, manages projects and provides research, data, reports and presentation materials for the Judicial Branch of Arizona in Maricopa County and the strategic agenda of the Supreme Court of Arizona. This position is expected to work with data analysts to design and provide appropriate data reports to help with high-level research and analysis on complex issues.

ABOUT THE SUPERIOR COURT:
The Superior Court of the Judicial Branch of Arizona in Maricopa County is dedicated to providing a safe, fair and impartial forum for resolving disputes, enhancing access to our services, and providing innovative, evidenced-based practices that improve the safety of our community and ensure the public's trust and confidence in the Judicial Branch. The Superior Court in Maricopa County, one of the largest, most innovative and progressive trial courts in the nation, seeks innovative individuals to join our team who will embrace our vision of excellence and the principles inherent in the Rule of Law...every person, every day, every time. We fulfill these principles through a culture that values fairness, respect, integrity, innovation, and safety.

POSITION QUALIFICATIONS
We recognize your time is valuable, so please apply if you meet the following required qualifications:
Education:
  • Bachelor's degree in Computer Science or a technology related discipline
Experience:
  • Three (3) years of experience in developing SSRS reports, SSRS report server optimization, developing high performance complex business reports and creating ad hoc reports
  • OR

    Combined education and experience qualifications:
  • A combination of education and relevant work experience may substitute for the minimum qualifications on a year for year basis.
  • Our Preferred Candidate has:
  • Experience with Microsoft SQL Server Reporting Services and developing DTS / SSIS packages.
  • Experience in different data replication methods such as log shipping, replication, etc.
  • Knowledge and understanding of design principles (physical and logical) and architecture.
  • Experience with HTML, DHTML, Java Script, CSS and page layout as well as knowledge of Microsoft IIS 6/7.
  • Experience with reporting service administration, data mining, and Microsoft Dynamics.
  • Knowledge, skills, and abilities:
    Knowledge of:
    • Microsoft SSRS Reporting Services
    • Relational database design, stored procedure creation, and query building using MS-SQL Server
    Skill in:
    • Creating and maintaining SSRS Reports
    • Analytical, critical thinking and problem solving
    • Structured source control using Microsoft Team Foundation Server
    • Agile process
    • Database performance evaluation and data forensics
    Ability to:
    • Establish and maintain positive working relationships
    • Multitask and cope with high volume and time-critical work environment
    • Conduct data forensic operations, audit trails and log mining capabilities
    • Design and develop business critical applications
    ESSENTIAL JOB TASKS
    (This is not an all-inclusive list of all job duties that may be required; employees will be required to perform other related duties as assigned.)
    • Utilize SQL or other database software to query and report on data obtained from Integrated Court Information System (iCIS) and other sources.
    • Collaborate with a database administrator, analysts, and court administration staff from all departments to design and create database structures including tables, procedures, views and functions, largely for DIA research and reports.
    • Develop quality assurance (QA) reports to improve data integrity.
    • Support deployment of reports into production and maintain after release.
    • Test developed reports for accuracy, efficiency, and stability.
    • Fulfill ad hoc requests from Judicial Branch, often in conjunction with DIA, by querying data and providing reporting in a timely manner.
    • Consult with DIA, court staff, and other customers regarding report design, enhancement, and maintenance.
    • Prepare detail and summary reports with large and complex relational database tables.
    • Work with DIA and Judicial Branch departments to automate reports to address the unique and dynamic needs of each unit.
    • Update existing reports to fulfill new requested changes.
    • Provide technical assistance to resolve any reporting issues and/or errors in SSRS.
    • Support staff members in the use of developed reports.
    • Prepare business requirements, data dictionary, and other documentation for existing and new reports.
    • Analyze existing reports and develop documentation for report characteristics, e.g. filters, calculations, etc.
    • Analyze user business requirements and develop solutions.
    • Write clear, concise, and grammatically correct project scoping documents, technical statements of work, project plans, test plans and change requests.
    • Assist analysts to gather and analyze requirements for new or updated processes.
    • Interact in a team setting with co-workers including other programmers, database administrators, business analysts and management analysts.


    Working conditions:Mostly an office setting in a high volume, fast-paced environment. Requires long periods of sitting while completing computer activities. May require travel to and from job related locations during the course of a scheduled workday.

    Additional Information
    Attention Current Maricopa County Employees: As of 1/1/2022, the Judicial Branch of Arizona in Maricopa County formalized itself as a separate entity and employer from Maricopa County. To learn more about how that may affect you please click here.
    Judicial Branch Human Resources reserves the right to move forward candidates based on the information provided directly on the application. The hiring authority will select the successful candidate based on departmental needs.

    Typically, successful candidates are hired at a salary rate up to the midpoint of the range, based on applicable experience, internal equity, and budgetary allowances.

    All Judicial Branch offers of employment and continued employment are contingent upon passing a thorough background and/or fingerprint check. Applicants must completely and fully answer any questions regarding felony and misdemeanor convictions including any convictions that have been expunged or set aside. Failure to include criminal history information is grounds for termination of an offer and employment. A conviction may not automatically disqualify an applicant.

    Judicial Branch facilities are located throughout Maricopa County. This position may be reassigned to other locations. Assignments will be made based upon the needs of the department.

    The Judicial Branch in Maricopa County is an EEO/ADA Reasonable Accommodation Employer.

    Apply Now!
    Apply to this job.
    Think you're the perfect candidate?

    Help us improve CareerBuilder by providing feedback about this job:

    Job ID: 2310411951

    CareerBuilder TIP

    For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

    By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.