Data Analyst/SSRS Report/Report Writer/Advanced SQL

I.  DESCRIPTION OF SERVICES

Texas Comptroller of Public Accounts requires the services of 1 Data Analyst/Report Writer

As a Data Analyst, the candidate must have a strong background in developing and implementing advanced/innovative analytical dashboards in Tableau based on functional specifications from a user, group and/or organization. This position will work as part of project team interacting with Product Owners, internal/external stakeholders, application development, and other BI/Data Warehouse staff to ensure analytical dashboards needs are assessed, documented, designed, developed, and implemented. Cross training and knowledge transfer to current CPA staff will be an important task that the candidate will perform.

The Candidate must have experience in and be able to perform the following:

·        Expertise with Advanced SQL.

·        Working knowledge of Python.

·        Ability to work with the cross-functional business team to understand business problem and design best reporting solution.

·        Preferred knowledge of Qlik, SSSRS and Tableau or other similar Business Intelligence (BI) tools.

·        Ability to analyze requirements and specifications, develop, design, and coordinate the implementation of business intelligence reports and/or visualizations.

·        Ability to work with business customers, managers, analysts, and subject matter experts professionally and collaboratively to gather requirements/strategies for report development.

·        Ability to translate requirements into advanced database and business intelligence components design.

·        Ability to work with relational databases including SQL Server, Oracle, DB2, and others.

·        Ability to address and resolve complex technical issues with internal/external customers, build good communication protocols and update management team with weekly/monthly status.

·        Ability to perform extensive code reviews and analysis.

·        Required to adhere to software development lifecycle processes.

·        Required to prepare detailed documentation and transition knowledge to current staff.

·        Ability to present and demonstrate business intelligence reports and visualizations to business customers and managers.

The Candidate must have worked with modern BI and Data Warehouse technologies to ensure reports comply with standards and all data modeling artifacts are prepared accurately in a timely fashion. The Candidate must also be quality conscious and be dedicated to delivering superior products on time and within budget.

II.  CANDIDATE SKILLS AND QUALIFICATIONS

V.  OTHER SPECIAL REQUIREMENTS

CANDIDATE SKILLS AND QUALIFICATIONS:

• Strong written, verbal, and interpersonal communication skills.
• Must be able to work independently in a diverse team environment with local and remote teams
• Must possess problem-solving skills and ability to multi-task with readiness to put in extra efforts when necessary
• Perform related work as assigned
• Must be able to work independently
• Knowledge of software development methodologies
• Must possess problem-solving skills and ability to multi-task
• Must be able to work around projects and deadlines with readiness to put in extra efforts when necessary