3 jobs found

Assistant/Associate Program Coordinator - Asset Management San Francisco, CA $87,984.00 - $128,648.00 Annually THIS POSITION IS OPEN UNTIL FILLED AND MAY BE CLOSED AT ANYTIME IF YOU ARE INTERESTED IN THIS OPPORTUNITY, WE ENCOURAGE YOU TO APPLY IMMEDIATELY ABOUT MTC The Metropolitan Transportation Commission (MTC) is the transportation planning, financing and coordinating agency for the nine-county San Francisco Bay Area. For more information about MTC, visit mtc.ca.gov. MTC was created by the California Legislature in 1970. The federal government, state Legislature and Bay Area voters have assigned MTC a wide-ranging portfolio of duties.  MTC directly distributes more than $700 million a year to local public transit agencies and other recipients, and prioritizes requests from local agencies for millions more in scarce state and federal funds. Acting as the Bay Area Toll Authority (BATA), MTC collects in excess of $600 million a year in bridge tolls, and allocates these funds for the operation and upkeep of the region's seven state-owned toll bridges. We plan, invest and coordinate to keep the Bay Area mobile, sustainable and prosperous. We are committed to preserving the diverse communities and natural beauty that make the Bay Area a desirable place to live and work, while addressing the needs of a growing population. About the Position The Program Coordinator - Asset Management position will be filled at either the Assistant or Associate level and is under the supervision of the Principal - Asset Management.  The person in this position will support the transportation asset management program, as well as project-related database integration and analysis efforts, and manage other programs as necessary. The primary focus of the position will be on supporting the following: Data integration workflows and providing primary database administrative support for multiple projects; Enhancement and maintenance to the existing Regional Transit Capital Inventory, (a comprehensive regional database of the transit assets that are owned by transit agencies in the San Francisco Bay Area); Implementation of regional transit asset management systems in response to federal authorization; Coordination of asset management activities with the transit operators; and Other duties as may be assigned, to include local streets and roads and highway asset management programs as needed. SKILLS AND ABILITIES The ideal candidate will have the following knowledge, skills and abilities: Ability to: Work with large and diverse data sets Work with a variety of spatial data formats, including ArcGIS common formats (shapefile, gdb, arcsde) and WKT/GeoJSON Communicate clearly and concisely (both orally and in writing) Create repeatable workflows for integrating disparate datasets/databases Prioritize and undertake multiple tasks Research and analyze complex and technical issues Document and translate technical analyses for policy makers and lay audiences, and apply data to practical uses for achieving broad policies Carry assignments through to completion, on time and with minimal supervision Represent MTC and develop consensus among local agencies Prepare correspondence, reports, and presentations to a wide variety of audiences Work independently. Knowledge of: Microsoft SQL Server/MySQL/PostgreSQL or transferrable knowledge of other database platforms Advanced Excel (Pivot Tables, Spreadsheet Models, Advanced functions, LOOKUPS, Conditional Functions, String Manipulation) Databases conceptual and physical design, creation, management and optimization techniques or have an understanding of data APIs and how they can be used to share data between different databases/systems ArcGIS / ArcGIS Server / ArcGIS Online Quantitative analysis Desirable Skills/Experience: Prior TERM Lite experience Knowledge of Github/Git for code version control Tableau or other visualization software Front end web development HTML, Javascript, CSS. (Bootstrap and Angular JS are a plus) Understanding of transit operations Understanding of capital asset costing and life cycle planning Understand transportation planning principles and policy MINIMUM QUALIFICATIONS An appropriate combination of education and experience that has provided the required knowledge, skills and abilities is qualifying.  A typical way of obtaining the required qualifications is: Education: Completion of a bachelor's degree from an accredited college or university, in an appropriate field related to the area of assignment, such as transportation planning, project management, public finance, transportation engineering, economics, business or public administration, or a related discipline. (Applicants with a degree issued from an institution outside of the United States must have their transcripts evaluated by an academic accrediting service and provide proof of equivalency along with the application.).  A Master's degree is preferred. Experience: One year of experience in an appropriate field related to the area of assignment. Preference will be given to applicants with additional professional work experience.   License/Certificate: Possession of a valid California Class C driver's license and a safe driving record, or the ability to provide alternate transportation which is approved by the appointing authority.   ESSENTIAL DUTIES AND RESPONSIBILITIES Under the supervision of the Principal - Asset Management, the essential duties and responsibilities include, but are not limited to, the following: Project Support: Coordination of asset management activities with the transit operators. Enhancement and maintenance to the existing Regional Transit Capital Inventory (a comprehensive regional database of the transit assets that are owned by transit agencies in the San Francisco Bay Area). Support the development of workflows for the integration of spatial data from multiple project databases (e.g. Regional Transportation Plan and Transportation Improvement Program databases). Work with consultants, staff, and transit agencies, on strategic planning efforts related to transit asset management. Prepare and present materials for Commission consideration; follow agency procedures and standards and work cooperatively with project sponsors and MTC staff to ensure that materials are timely, accurate, and professional. Database Administration: Data integration workflows and providing primary database administrative support for multiple projects. Policy Analysis: Perform complex policy analysis related to state and regional transportation projects and programs. Technical/Data Analysis: Research and analyze complex and technical issues. Work with large and diverse data sets. Create repeatable workflows for integrating disparate datasets/databases, Document and translate technical analyses for policy makers and lay audiences, and apply data to practical uses for achieving broad policies, Maintain a regional transportation asset inventory for the Bay Area's transit systems (RTCI). Ensure data from the systems are consistent and regionally compatible. Analyze, synthesize, and project future needs and utilize FTA software called TERM Lite. Assist with activities related to a regional Safety/Vision Zero program; specifically, around development of a regional safety data system, rolling out safety policies and coordination of a regional Safety/Vision Zero task force. Policy Development: Support Transportation Asset Management implementation and policy development. The Program Coordinator - Asset Management will perform other job related duties as assigned. All employees at MTC are classified as Disaster Services Workers.

External Job Description Description - External Research Analyst Economic Research Department Performs supporting economic research at an intermediate level. Prepares analysis in support of department projects. Uses database knowledge to compile statistical data and prepare reports and forecasts. Develops recommendations and presentations on topics studied. Contributes to multiple research teams. Possesses and applies broad knowledge of analytical concepts, practices and procedures to accomplish moderately difficult assignments. The level of work is considered intermediate and staff work under general supervision. This job has no direct reports. Principal Duties and Responsibilities Collaborates with analysts to define user requirements and conduct design review for the development of basic to medium of complexity applications using client server and/or Web technologies Develops basic to medium level of complexity Web and/or client server applications Assists in providing all required customer service and training for automated systems Resolves basic to medium level of complexity automation and/or data problems Identifies opportunities for process improvements and proposes solutions Performs analysis and projections of financial, economic or demographic data Compiles data, and prepares written reports, graphs and charts Conducts market research, trend analysis and prepares forecasts Uses and designs new analytical models, databases or applications Develops a variety of written materials for various audiences Frequently contributes to project teams Performs other duties as requested Education and Experience Bachelor's Degree or equivalent experience as noted below; major in economics, business, finance, or public policy preferred Minimum of 2-3 years of experience Knowledge and General Skills  Strong analytical and problem solving skills  Strong written and oral communication skills  Exceptionally strong interpersonal and teamwork skills  Demonstrated project management skills  Able to work on multiple projects at one time  Knowledge of business practices and statistical methods Specific Technical Skills Advanced MATLAB programming. Intermediate Stata, R, and Python programming. Intermediate SQL and Database Management. Intermediate LaTeX. Version Control and Test-driven development. Experience with Bloomberg, Haver, FRED Other Requirements Applicants must be U.S. Citizens or hold green cards with the intent to become a U.S. Citizen. As a condition of employment, Federal Reserve Bank of Chicago employees must comply with the Bank’s ethics rules, which generally prohibit employees, their spouses/domestic partners, and minor children from owning securities, such as stock, of banks or savings associations or their affiliates, such as bank holding companies and savings and loan holding companies. If you or your spouse/domestic partner or minor child own such securities, and would not be willing or able to divest them if you accepted an offer of Bank employment, you should raise this issue with the recruiter for this posting, who can provide you contact information for our ethics official if necessary. 

FileMaker Developer - Mid Level As a Mid-Level FileMaker Developer at Quantus you will be supporting our employees use of our custom developed FileMaker Solution while working with management to co-develop future software solutions. We are seeking an individual that is passionate about using FileMaker to create unique business applications. Someone that gets excited about finding and integrating the latest technology that will further enhance our competitive advantage. We are seeking some that is energized and confident when troubleshooting and debugging existing systems, with one eye on detail and design, always trying to figure out how things can work better. ROLE AND RESPONSIBILITIES As a mid-level developer you will be expected to provide the following support: Work locally in our office in BLUE BELL, PA In-person collaboration will be needed as we build this new department and design future applications remote work will be available as the role and department matures Support existing FileMaker Solution: Provide training and support to the end users of our business applications Technically proficient to handle support for all employees with no supervision Track bug fix and feature requests, review priorities and status of requests monthly with management Load existing solution onto a development server and co-design a plan to support near-term iterations of our existing solution Includes establishing best practice for version management and interim validation testing prior to deployment Collaborate on database design, including architecture, security, data integrity, schema design and normalization, server deployment and management, create layouts, scripts, calculations, field definitions, relationships, reports Co-design a future version of our existing FileMaker solution which shall include a hosted / local network version, a synchronized mobile version, and webapp version Ability to integrate systems with other technologies such as OAuth, XML, JSON, PHP, REST, FM BetterForms Work closely with Project Coordinator and other FileMaker Developers, to design, implement, and maintain systems with a high level of quality. Ability to work in a Project Management environment and handle multiple project requests and multiple deadlines QUALIFICATION AND REQUIREMENTS 5+ years FileMaker experience FileMaker Certified Developer (latest version) Excellent communications and basic project management skills Ability to perform job functions with a minimum of supervision Strong understanding of relational database design PREFERRED SKILLS UX/UI talents are critical to delivering usable responsive solutions Familiarity with REST, JSON, OAuth, XML, PHP, OData is a plus Design--Generates creative solutions; Translates concepts and information into images; Uses feedback to modify designs; Applies design principles; Demonstrates attention to detail Ability to provide samples of your development work WHAT WE OFFER Encouraging and supportive work environment Opportunity for professional development and growth Training, mentoring, and opportunity to obtain professional certifications Opportunities to attend annual FileMaker Developer conference Competitive salary, short-term disability insurance, health plan, 401K with company match, company contribution to Health Savings Account, profit sharing, (+ optional: LTD, Critical Illness and Accident Insurance) Annual performance reviews, salary increases, and bonuses as earned PI115627011