79 Data Analyst V Jobs in Austin, TX
Dept of Family & Protectve Svc is Hiring a Data Analyst V Near Austin, TX
Essential Job Functions:
Performs data integrity functions in CAPPS Fin, subsystems and applications involving the maintenance of data fields within the chart of accounts, establishing/updating data fields in CAPPS Fin in preparation for the new fiscal year, performing combo edit rule maintenance to establish correct combinations of data fields, performing system tree maintenance to establish and maintain correct data hierarchy within CAPPS Fin and other subsystems and applications, and maintain electronic data interface (EDI) layout to ensure compliance with PeopleSoft and IRS regarding data formatting (15%)
Writes, extracts, queries and compiles data in the completion of audit requests, open records requests and ad hoc data requests involving writing and generating reports; extracting, querying, and compiling data; reconciling data, and researching deltas (15%)
Prepares comprehensive financial and technical reports such as the Monthly Financial Report (MFR), Legislative Annual Report (LAR), base reconciliation, Annual Financial Report (AFR), Schedule of Expenditures of Federal Awards (SEFA) and 1099 reporting by extracting, querying and compiling data out of CAPPS HR, CAPPS Financials, and databases for data presentation and interpretation in identifying data trends, inconsistencies, anomalies, redundancies, and for making recommendations to make data revisions to present a more accurate picture of the data and aid in management decision-making (15%)
Establishes data quality metrics, measures against results, recommends and implements improvements to data quality associated with processes such as determining and calculating the correct method of finance, forecasting and reallocating expenditures and in the process, performs related data quality assurance (15%)
Develops software applications, writes scripts and develops code to compile and present statistics requiring various views or models using computer programming languages such as SQL and Visual Basic (10%)
Determines, develops and implements technical solutions to collect, process, house and display data such as developing databases, developing complex queries, creating spreadsheets, and designing SharePoint sites and develops, documents and implements related data standards (10%)
Performs data analysis using statistical tools such as SAS and TOAD and applying industry standard methods and techniques (10%)
Serves as subject matter expert related to issues of data integrity, and data quality and assurance and consults with other departments (internal and external) to determine data needs; performs other duties as assigned (10%)
Attends work regularly in accordance with agency leave policy.
Knowledge Skills Abilities:
Knowledge of data analysis and statistical data modeling and security protocols for data access, data handling, and protecting and distributing confidential data
Knowledge of budget process
Knowledge of general ledger accounting operations
Knowledge of budget and general ledger financial reporting
Knowledge of information technology and business services
Knowledge of public assistance cost allocation plans or other similar cost allocation methodologies
Knowledge of project management principles
Knowledge of human resource systems
Skill in communicating effectively with functional staff
Skill in managing multiple and competing priorities
Skill in various programming languages
Skill in various computer and system tools and applications
Skill in documenting business processes
Skill in problem solving and critical thinking
Ability to implement and use new technology and work processes to benefit the organization
Ability to design, develop and implement technological solutions
Ability to explain, advocate, express facts and ideas, and negotiate with individuals and groups, internally and externally
Ability to build, establish, and maintain effective working relationships and coalitions
Ability to work effectively in a team environment
Ability to produce results through planning, development and implementation automated solutions and business processes
Initial Selection Criteria:
Experience writing scripts or code to extract, compile and present data or models using computer programming languages such as SQL.
Experience preparing comprehensive financial or technical reports.
Experience developing and implementing technical solutions to collect, process, house and display data, developing databases, developing complex queries, complex spreadsheets, or designing SharePoint sites.
Experience establishing data quality metrics, recommending and implementing improvements to data quality associated with processes.
MOS Code:
There are no direct military occupation(s) that relate to the responsibilities, and registration or licensure requirements for this position. All active duty, reservists, guardsmen, and veterans are encouraged to apply if they meet the qualifications for this position.
As a state agency, DFPS is required Texas Administrative Code (TAC 206 and 213) to ensure all Electronic Information Resources (EIR) follow accessibility standards. The staff must be familiar with the WCAG 2.1 AA and Section 508 to create accessible content including but not limited to; Microsoft Office documents, Adobe PDFs, webpages, software, training guides, video, and audio files.
HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.
In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.
Job Summary
Full Time
$117k-151k (estimate)
03/24/2024
06/29/2024
The following is the career advancement route for Data Analyst V positions, which can be used as a reference in future career path planning. As a Data Analyst V, it can be promoted into senior positions as a Data Analytics Supervisor that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Data Analyst V. You can explore the career advancement for a Data Analyst V below and select your interested title to get hiring information.
If you are interested in becoming a Data Analyst, you need to understand the job requirements and the detailed related responsibilities. Of course, a good educational background and an applicable major will also help in job hunting. Below are some tips on how to become a Data Analyst for your reference.
Step 1: Understand the job description and responsibilities of an Accountant.
Quotes from people on Data Analyst job description and responsibilities
A data analyst also helps the business use the present data to make better business decisions and deliver better services to consumers.
12/10/2021: Lynchburg, VA
Their role will be like to work on collaborative, multidisciplinary teams with leaders where they can review and analyze data and to develop the presentation for the data consumption across the organization.
02/10/2022: Temple, TX
Data analysts work constantly with stakeholders, fellow colleagues and data suppliers, so good communication skills are essential.
12/21/2021: New London, CT
Many data analysts are required to create presentations of their findings to share with stakeholders and other key members of an organization.
12/24/2021: Alamogordo, NM
Gathered requirements, analyze data and create functional/technical specifications to functionality required by new business rules, regulations or standards change.
03/03/2022: Santa Maria, CA
Step 2: Knowing the best tips for becoming an Accountant can help you explore the needs of the position and prepare for the job-related knowledge well ahead of time.
Career tips from people on Data Analyst jobs
Data analysts typically work with existing data to solve defined business problems.
02/20/2022: Laramie, WY
Data analysts rely on various tools to collect and make sense of their data.
01/17/2022: Melbourne, FL
Banks and financial firms need data analysts for financial reporting and forecasting.
03/04/2022: Akron, OH
Data analysts often work directly with more senior data team members like data scientists or data engineers.
03/02/2022: Grand Forks, ND
Predictive analysis refers to a data analyst's ability to use data, machine learning and statistical algorithms to predict the likelihood of future outcomes based on previous historical data.
02/26/2022: Las Vegas, NV
Step 3: View the best colleges and universities for Data Analyst.
Similar Jobs
Popular Articles
