Mid-Ohio Regional Planning Commission
The Mid-Ohio Regional Planning Commission (MORPC) is seeking an enthusiastic and qualified Data Analyst to join our Data & Mapping team. A strong candidate will possess the right combination of technical expertise, creativity, a collaborative spirit, and self-motivation; and will have a passion for using data to understand and address community needs, with a particular focus on issues of diversity, equity, and inclusion. Comfort gathering, manipulating, and drawing insights from a wide range of datasets and formats is a must. Increasingly, our work incorporates the development of online tools to effectively deliver information and resources to our audiences, so experience with application or web development is ideal. The Data & Mapping team manages MORPC’s internal data resources and provides data collection, analysis, and visualization support to the agency’s other departments in areas ranging from Planning & Sustainability, to Transportation & Infrastructure Development, to Residential Services, to Communication & Engagement. Externally, we work directly with local governments, community partners, and residents to meet their data and mapping needs. The Data & Mapping team is also responsible for furthering MORPC’s Regional Data Agenda, which outlines our role as a regional leader in data and digital infrastructure.
Examples of Duties
• Serves as project manager for Data & Mapping projects and as Data & Mapping lead on projects initiated by other MORPC departments • Compiles and maintains MORPC’s data resources including demographic, socio-economic, transportation, development, land use, and other planning-related data • Organizes, transforms, and performs statistical modeling to identify trends, analyze scenarios, and develop regional forecasts • Develops web applications that enhance the use of and access to MORPC’s data resources • Collaborates with others on the data team to develop and manage MORPC’s data management system • Creates support documentation outlining procedures • Prepares and presents research reports and summaries to government officials, citizen groups, and professional organizations • Develops project design, methodology, scheduling, and recommendations for planning projects with supervisor oversight • Responds to a broad variety of requests for information from MORPC colleagues, member agencies, community partners, and residents • Updates job knowledge by participating in educational opportunities, reading professional publications, maintaining professional networks, and participating in professional organizations
Qualification (must haves):
• A bachelor’s degree in data science, planning, economics, computer science, or a related field • Experience applying a range of statistical analysis to practical decision-making contexts • Coding, software, and database development skills (e.g., Python, R, SQL) • High level of comfort gathering and synthesizing “messy” data from a wide range of sources and in a variety of formats • Analytical/problem solving skills and genuine enthusiasm about pushing technical limits and finding creative solutions • Strong communication skills and a positive approach to working with peers, the public, and outside agencies • Commitment to advancing diversity, equity, and inclusion in the region Additional desired skills
• An advanced degree in data science, planning, economics, computer science, or a related field • Ability to design, maintain, and monitor databases, especially SQL • Familiarity with demographic, transportation, and land use planning studies and the data that informs them • Experience with ESRI ArcGIS software, geospatial data, and web-mapping platforms (e.g., ArcGIS Online, CartoDB, Mapbox) • Experience with web-based data visualization tools (e.g., Tableau, PowerBI, D3, Google Charts)
MORPC serves as a resource for local officials as they make decisions about economic growth, development, transportation, energy, and environmental sustainability. Through a variety of transformative programs and services, we work to improve the lives of all Central Ohio residents and make the region stand out on the world stage. We recognize that a healthy work/life balance is key to the long-term success of our employees and our organization, and we provide robust benefits to promote that balance. MORPC employees receive a free system-wide transit pass and discounted access to other alternative transportation modes to provide options for commuting to work. We encourage all employees to pursue opportunities for professional and personal growth through generous tuition reimbursement and participation in local and national organizations. We also offer flexible schedules and remote work options to support the individual needs of our team members. One of Central Ohio’s greatest strengths is the diversity of our communities, and to best serve our region, MORPC strives to reflect that diversity. Our work is made better when our team can draw on a wide range of personal experiences and backgrounds, and when each member is open to learning from the experiences of others, both internally and externally. As an equal opportunity employer, we fully support all applicable state and federal laws and regulations and do not discriminate against applicants for employment or employees because of race, color, creed, religion, ancestry, national origin, sex or gender, sexual orientation, gender identity or expression, age, disability or other handicap, genetic information, marital/familial status, veteran status, or income or status with regard to public assistance in any aspects of our personnel policies, working conditions or relationships with employees and applicants for employment.