Data Analyst II (Full Time) - Austin or Sugar Land

Job Description

Job Description

POSITION PURPOSE

Will work closely with our BI team and IT Management to help derive internal business intelligence reporting and development to create, improve and maintain ad hoc and automated reporting and dashboards. Hands-on experience with SQL is also required. Ideally, will be familiar with predictive analysis and data visualization techniques using relevant tools (e.g. Tableau, Power BI)

ESSENTIAL FUNCTIONS AND BASIC DUTIES

• Help teams on the technical design and implementation of applications using existing and emerging technology platforms
• Help align with firm data management standards and ensure applications within the portfolio are in line with those standards
• Write SQL queries, stored procedures and utilize SQL Server to generate reports and respond to requests from users for data
• Work closely with other technology members to ensure quality of monitoring
• Clearly communicate problem/resolution process to users or management
• Contribute technical documentation and application procedures
• Assure compliance to change management and security policies

The above statements describe the general nature and level of work only. They are not an exhaustive list of all required responsibilities, duties, and skills. Other duties may be added, or this job description amended at any time.

SUPERVISORY RESPONSIBILITIES:

This role does not have supervisory duties.

QUALIFICATIONS

Education/Certification:

• Bachelor’s degree in Computer Science, Information systems or equivalent

Required Knowledge:

• Excellent understanding of Relational Database Design
• Working knowledge of ETL using SSIS or comparable tool
• Effective analyst able to work closely with non-technical users
• Knowledge of MS Access, MS Visual Studio, Crystal Reports or Datawatch Monarch is a plus

Experience REQUIRED:

• Strong technical experience in database development, performing DDL operations, writing queries and stored procedures, and optimizing database objects
• Experience with Data management standards such as data governance is a plus

Skills/Abilities:

• Solid reporting skills preferably using SSRS
• Establishment and implementation of reporting tools to create reports and dashboards using SSRS, Power BI, Tableau, or similar analytic tool
• Proficiency in interpersonal communication, presentation, problem solving and analytical skills
• Must be flexible and willing to adapt to changes and can establish and maintain effective working relationships with staff and other departments/agencies.
• Be self-driven with the desire to achieve measurable, specific results within tight time frames
• Excellent written and verbal communication and presentation skills

• Must be willing to work after-hours
• Must work well in a team environment
• Must be able to interface with users and vendors
• Must have sense of urgency and ownership to support financial applications, with architectural and system component knowledge preferred

• Proficiency in interpersonal communication, presentation, problem solving, and analytical skills
• Ability to manage multiple tasks and projects simultaneously with attention to detail and accuracy.
• Must be a self-starter that is driven to understand and complete tasks within the guidelines and timeframes assigned.

Hours: Monday - Friday 8:00 AM - 5:00 PM.