Skip to content
Kansas City Skyline

Nonprofit Jobs

Find a job that you're passionate about. Nonprofit Connect is your career headquarters offering the premier nonprofit job board in the region.

Browse our list of nonprofit jobs.

Data Developer / Analyst

Posted: 06/19/2022

Data Analyst/Developer - Research Services Department

About Us
The Mid-America Regional Council, the Kansas City area’s nonprofit association of city and county governments and metropolitan planning organization, is seeking a qualified professional to serve on our Research Services team in strong partnership with our Information Technology team and help enhance MARC’s technical capacity.
Governed by a board of 33 local elected officials, MARC provides a forum for the region to work together to advance the social, economic, and environmental progress of the Kansas City region. MARC promotes regional cooperation through leadership, planning and action. Our work is organized around eight key policy goals: efficient transportation and quality places; a healthy environment; a competitive economy; effective local government; safe and secure communities; thriving older adults and communities; quality early learning; and exemplary core capacities. We are committed to core values of integrity, innovation, collaboration, diversity and inclusion, excellence in performance, and service leadership. For additional information visit www.marc.org.

About This Position
MARC’s Research Services department provides data and analytical support to promote the achievement of the above policy goals.  To provide this support, Research Services seeks to expand its capacity to collect data from a wide variety of sources, integrate and analyze the data, and communicate the results (both online and in written reports) with public and private decision-makers.  

The successful candidate for this position will demonstrate proven, working experience with data management concepts and activities including an understanding of industry best practices for data sourcing, data quality, metadata and enterprise data management policy and procedures.  While most of the work will involve designing and implementing the enterprise data systems needed to support regional decision-making and problem-solving, this position also requires someone with the ability to analyze and present the data by making it understandable to program staff, upper management and public officials.

The data developer/analyst will collaborate with internal staff and external clients (local governments, civic organizations, and others) to understand their data needs, design efficient and appropriate methods to integrate the necessary information and deliver effective solutions. This position develops and manages projects; automates routines or processes to efficiently work with large datasets; uses best practices for relational databases to create, develop and maintain enterprise data systems; analyzes spatial data; helps to create online content to facilitate data access and aid decision making; and provides training and problem-solving support to MARC staff and participating agencies.
 
What You Will Do
The data developer/analyst position includes the following responsibilities:

  • Collect, edit, and maintain data; ensure data is accurate, current, and complete through quality assurance procedures; establish routines for data; transform data into meaningful end-user information.  Use various techniques such as data mining, process automation, workflow modifications and agency collaboration to develop new and enhance existing datasets.
  • Utilize database objects that follow data warehousing best practices and assist in implementation using applicable tools, SQL stored procedures, and user-defined functions. 
  • Lead efforts to design, develop, and implement flexible data warehouse architecture, including development of both physical and logical data models.  Design, develop, and maintain various ETL processes to automate data processing, as well as data cleansing, integrity and validity testing.
  • Respond to end-user questions, inquiries, and ad-hoc requests, including data development, reports and presentations and map production.  Work directly with end-users to evaluate solutions, fulfill requests, and recommend solutions that support sound decision making.
 
About You
Requirements:
  • A degree in Data Analytics, Data Science, Computer Science, Business Analytics, Geography, GIS, Economics, Statistics, or a related field with a strong data management or analysis component is preferred. Any equivalent combination of education, training, and experience, which would provide the required knowledge, skills and ability, may be reviewed and considered.
  • Expertise in querying and manipulating relational databases, and be able to develop applications for editing, browsing, or querying data.
  • Experience with ETL (extract, transform and load) processes.
  • Demonstrate a strong ability to translate technical material into language understood by non-technical audiences, in both oral presentations and written reports.
  • Ability to analyze data using a wide variety of techniques, including statistical analysis programs and geographic information systems (GIS). 
 
Preference will be given to individuals with:
  • Strong Microsoft SQL experience.
  • Proficiency using FME, SQL Server Integration Services, SQL Server Reporting Services.
  • Proficiency in Python, SQL, R and/or SAS for summarizing data used in statistical analysis.
  • Proficiency using ESRI GIS applications, including spatial statistical analysis.
  • Demonstrated experience with “Big Data” tools and datasets.
  • Experience managing transportation-related data such as crash locations or transit schedules from GTFS (General Transit Feed Specifications). MARC is especially interested in experience using high-volume data coming from “smart transportation” devices and “smart city” initiatives, including traffic signals, mobile phone locations, embedded sensors, vehicle GPS, etc.
  • Experience with visual analysis and dashboard creation using programs such as Tableau or Power BI.
  • Demonstrated knowledge of planning topics such as land use, transportation, housing, economic development, sustainable development and zoning.
  • Knowledge of land use modeling tools, spatial and statistical data analysis, interpretation, report preparation, and presentations.
  • Familiarity with the principles and practice of scenario planning.
  • Proficiency with diverse data sets from federal, state, and local agencies, such as the Decennial Census, American Community Survey (ACS), Bureau of Labor Statistics (BLS), and Longitudinal Employer-Household Dynamics (LEHD).
Soft Skills You Will Need:
  • Exceptional project management and problem-solving skills.
  • Excellent written and oral communication skills.
  • Strong customer service orientation.
  • The ability to manage multiple projects under a deadline.
  • The ability to work collaboratively as part of a team.
  • The ability to work with diverse external stakeholders and groups.
Additional Information
This is a full-time exempt position. The starting salary range is $60,000 - $80,000, depending on qualifications and experience.  This position is open until filled. MARC offers an attractive team-oriented work environment along with a competitive fringe benefit package.

To apply, complete our online application form and attach your cover letter and resume. Learn more at www.marc.org/jobs.

MARC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Job Type: Full Time

Salary Range: $50,000 - 74,999,$75,000 - 99,999