Transportation Data Analyst (Immediate Opening)

Weslaco, TX, United States
Jan 17, 2019
Position at IDEA Public Schools

At IDEA Public Schools, we believe in college for ALL and we are committed to ensuring that all of our students graduate from college. IDEA Public Schools has grown from a small school to the fastest-growing network of tuition-free Pre-K-12 public charter schools in the United States sending 100% of our students to college. 58% of our students graduate from college in 6 years - that's 8 times the national rate for students in our communities!

IDEA was founded in 2000 as a single school with 150 students in the Rio Grande Valley. When interest exceeded building capacity, to meet the demands, IDEA's co-founders committed to serving more students in the Rio Grande Valley of Texas and beyond. We now serve nearly 45,000 students across Texas and Louisiana. By 2022, IDEA will serve 100,000 students. Be on the lookout for IDEA schools opening near you-with continued growth in our current regions and new launches in Tarrant County (Fort Worth/Arlington), New Orleans, Houston (2020), Permian Basin (2021), and Tampa Bay (2021)!

When you choose to work at IDEA, you are part of our IDEA Team and Family. You will work alongside team members who set and reach ambitious goals every day, are excited to continue to grow with IDEA, and work relentlessly to make college for all a reality.

To learn more about IDEA, check out this video .

Role Mission: The Transportation Data Analyst supports the Transportation Department in systems management and service improvement. Duties include : coordinating with software vendors to bridge gaps, provid ing reports to HQ personnel, and monitor ing the security of our systems in alignment with IDEA's Information Technology policies. He/she will partner with internal and external stakeholders to achieve strong measurements of Transportation data and meet or exceed data management expectations, with a strong focus on data integrity, analytics, and staff satisfaction in an effort to continuously improve our systems.


1. Create systems for maintaining data metrics and accuracy for all aspects of the Transportation team

• Set up dashboards with metrics for team from multiple organizational systems to ensure accuracy in all functions

• Monitor data accuracy and adjusts, when necessary, with rationale and r eport on discrepancies and root causes , work ing towards improvements each month

• Monitor the Transportation Dashboard created by the School Operations Project Analyst and partner with Transportation Functional areas to identify and resolve any discrepancies.

• Run audits to ensure legacy systems have accurate data , and c reate meaningful comparisons using data to drive future results of the Transportation Department

• Execute end-of-year process & work closely with cross functional teams and supervisors to disseminate information to staff regarding year end data.

• Manage successful partnerships with third party administrators , such as TPA, to identify and resolve discrepancies, ensure data accuracy between systems, and cultivate and support deliverables with producers through consistent communication and relationship building.

• Proactively and reactively a ddress employee concerns and issues of system functionality with a high degree of professionalism and a customer service orientation .
  • Communicate with employees about anticipated issues and makes accommodations as deemed necessary , ensuring timely follow up with staff (24-48 hours).
  • Assist with new hires by providing support to staff members and continuously communicating with new hire

2. Serve as the administrator for the Transportation HUB, ensuring 100% accuracy of data.

• Provide the appropriate level of access to all stakeholders

• Understand and anticipate user needs and experience s and make changes and improvements where appropriate.

• Monitor use and resolve system issues within 24 hours of identification.

• Partner with the Development team to develop systems for managing data across multiple systems.

• Manage all training material to be posted to the HUB, and a ct as a strategic partner to users, providing training, coaching, and support to resolve issues within 24 hours.

3 . Develop database queries and reports to enhance the operational efficiencies of the Transportation Department related processes , with 100% of Critical and Ad hoc Reports/Analysis requests executed accurately and on time .

• Complete and document all requests with an expected completion date based on current workload

• Develop and maintain ad hoc reports as needed for the Transportation Department leveraging SQL Server Reporting Services (SSRS) and other report options such as Excel and Power BI

• Assist the Transportation Department in developing ways to leverage SSRS, ODBC or other SQL report writing tools to make analyzing data more efficient and effective

• Develop and maintain documentation for any applications and reports that are implemented through ODBC, SSRS, Excel, Power BI, etc.

4 . Serve as the Transfinder, Servicefinder & Synovia security and System Administrator for Systems Information

• Maintain permissions, updates, servers and database for the district's systems

• Act as a Liaison between the Transportation department and other departments that use our data , and ensure the data is being utilized in dashboards and reports accurately

• Attend workshops and trainings to implement industry standard best practices in the management of our departments systems

• Be r eadily available to provide phone support to restore lacking system/functionality

• Coordinate with vendors/business partners to implement new information systems , communicate system issues, and follow up to resolve issues in a timely manner

• Collaborate with IDEA IT department to implement measures as to resolve all recurring issues

• Provide technology vendors our feedback so they may expand the functionality of a system

5 . Manage departmental hardware with 100% accounted for at end of year

• Manage current computer hardware inventory and coordinate with Campus Managers/IT dept to purchase replacements as needed throughout the year

• Project departmental technology needs for the following fiscal year and make budget related recommendations to the Transportation Director

• Coordinate with the IT dept to keep the latest security features and improvements

• Annually review vendor pricing and negotiate for best value on behalf our department

6 . Implement at least one improvement project for the Synovia system with measurable benefits to the end user

• Audit campus locations to identify improvement opportunities by end user

• Coordinate with supervisor to map out the process to implement solution

• Write stand-alone programming script(s) that interface with Synovia to create efficiencies

• Attend state and national conferences to acquire new knowledge and skills in industry and apply to current role

7 . Live Values of IDEA

• Believes and is committed to our mission: that all students are capable of getting to and through college

• Is driven by outcomes and results, and wants to be held accountable for them

• Has a propensity for action, willing to make mistakes by doing in order to learn and improve quickly

• Thrives in an entrepreneurial, high-growth environment; is comfortable with ambiguity and change

• Seeks and responds well to feedback, which is shared often and freely across all levels of the organization

• Works through silos and forges strong cross-departmental relationships in order to achieve outcomes

• Embodies IDEA's core values

  • Mission Focus - focuses on IDEA's core purpose of getting all students into college
  • Record of Results - holds high expectations for self and others to achieve and surpass intended goals
  • Managing Others through influence to Deliver Results - leads team to achieve measurable and ambitious results
  • Problem Solving - able to synthesize, analyze, and prioritize data and opportunities to develop strategies for achieving quantifiable goals
  • Coaching & Developing - develops team through formal and informal methods; makes professional development a top priority
  • Communication - effectively conveys information using a variety of channels and techniques
  • Continuous Improvement - proactively identifies opportunities to improve and consistently reflects on past actions to guide future decisions


• Education: Bachelor's degree in Computer Science or Computer Information Systems or Economics or related field

• Experience: 2-3 years in Information Systems or related field

• Bilingual Spanish required

• Advanced proficiency in MS Office products including (but not limited to) Excel, Word, Outlook, Access, Power BI, PowerApps, Forms, PPT, SharePoint, InfoPath, etc., and other data tools to analyze data and provide appropriate visualizations and insights

• SQL knowledge required

Knowledge and Skills:
  • Strong analytical and quantitative skills with demonstrated ability of converting raw data into meaningful analysis and recommendations
  • Technical expertise regarding data models, database design development, data mining and segmentation techniques.
  • Demonstrate flexibility, adaptability and be self-motivated .
  • Ability to create & implement policy and procedures.
  • Business awareness and knowledge of management practices.
  • Ability to work effectively with internal and external stakeholders.
  • Strong organization, communication, and interpersonal skills.
  • Ability to work extended workdays to support business needs
  • Excellent customer service skills, both written and oral, and maintain confidentiality in all matters
  • Excellent verbal, written, presentational, and interpersonal skills to interact with carriers and staff at all levels in Spanish/English
  • Excellent time management and organizational skills and the ability to handle multiple tasks in a demanding work environment
  • Ability to work across diverse teams in a high-growth organization
  • High levels of accuracy, reliability and veracity


IDEA Public Schools does not discriminate on the basis of race, color, national origin, age, sex or disability, in admission or access to, or treatment of employment in its programs and activities. Any person having inquiries concerning the organization's compliance with the regulations implementing Title VI of Civil Rights Act of 1964 (Title VI), Section 504 of the Rehabilitation Act of 1973 (Section 504), or Title II of the Americans with Disabilities Act of 1990 (ADA), may contact IDEA Human Resources at (956) 377-8000.

Similar jobs

Similar jobs