Job Title: Data Analyst / Report Writer
Location: Austin, TX 78704 (Remote)
Duration: 12 Months
Note: Client needs a hybrid of programming in SQL and application in Tableau and Python Job Summary:
Incumbent transforms data into information that can be utilized to make business decisions and actions.
The work involves acquiring data from multiple sources, creating reports on a regular basis, correcting any code issues, populating integration templates, and ensuring that databases remain error-free and organized.
Responsibilities:
Extract, load, and transform data from multiple sources (DB2, Oracle, Postgres).
Examine data quality issues for consistency and accuracy, and identify resolutions.
Investigate inconsistencies.
Apply your expertise in quantitative analysis, data visualization, statistical methods, and data mining.
Develop reports and visualizations using PowerBI, Tableau, and/or JasperStudio.
Create reports and populate migration templates for vendor migration projects using SQL.
Maintain and update reports created in Oracle DB and DB2.
Skills and Requirements:
Expertise in SQL (Mandatory).
Understanding of common reporting and file transfer technologies.
Proficiency in PowerBI, Tableau, G Suite (e.g.vlookups, sumifs, pivots), and Snowflake.
Experience with Jasper Studio & AdHoc.
Bachelor's Degree in a related field.
Willingness to work in a very collaborative environment.
Ability to reason and operate independently to solve complex business problems.
Ability to learn quickly and work in a dynamic environment with minimal supervision.
Familiarity with system migration for organization-wide supplier diversity programs is preferred, but not required.
Financial services experience is a plus, but not required.
Experience:
Requires minimum 4 years related work experience in excess of degree requirements.
Preferred experience in successful project management function in cloud-based management.
software/application implementation preferably in Facilities, construction in school districts, or k12 organizations.
Preferred experience with business analysis, requirements gathering, process development, and implementation.
of Enterprise Resource Planning system (ERP) including Business, Finance, Payroll, Position Control, and Employee.
Compensation, Recruiting, Hiring, Onboarding, Procurement, Maintenance, Employee Evaluation, and Professional learning management functions.
Preferred experience in a K12 organization in a central office or school position.
Preferred experience implementing or using Facilities/Construction enterprise systems such as Tririga, Procore, and others.
Preferred experience implementing or using enterprise systems such as Frontline Education, Tyler Munis, Workday, Lawson, or other Finance, HR, or Payroll functions.
Education:
Bachelor's Degree: Computer Science, MIS, or related field (Required).