- Data Management
- Power BI
- Data Collection
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 in the Research Services department as a Data Developer/Analyst.
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.
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 person in 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.
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.
Work directly with developers to implement 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 (extract, transform and load) 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.
The position requires a strong customer service orientation; the ability to manage multiple projects under deadline; the ability to work collaboratively as part of a team; a strong drive to learn and master new data techniques; along with a problem-solving personality
and the ability to work with diverse external stakeholders and groups.
A bachelor’s 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 that would provide the required knowledge, skills and ability, may be reviewed and considered.
The person in this position must have expertise in querying and manipulating relational databases, and be able to develop applications for editing, browsing or querying data. The position also requires experience with ETL (extract, transform and load) processes. The data developer/analyst must demonstrate a strong ability to translate technical material into language understood by non-technical audiences, in both oral presentations and written reports. He or she must also be able 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.
Excellent written and oral communication skills.
Exceptional project management and problem-solving skills.
Proficiency using FME, Alteryx, SQL Server Integration Services, SQL Server Reporting Services.
Proficiency in Python, SQL, R and/or SAS for processing and/or summarizing data.
Demonstrated knowledge of planning topics such as land use, transportation, housing, economic development, sustainable development and zoning.
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.
Proficiency using ESRI GIS applications, including spatial statistical analysis.
Proficiency with diverse data sets from federal, state and local agencies, such as the Decennial Census, American Community Survey (ACS), ACS Public Use Microdata Sample (ACS PUMS), Bureau of Labor Statistics (BLS), Longitudinal Employer-Household Dynamics (LEHD), and the Census Transportation Planning Package (CTPP).
Demonstrated experience with “Big Data” tools and datasets.
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.
Experience with visual analysis and dashboard creation using programs such as, Tableau or Power BI.
SALARY AND BENEFITS
Annual salary range for the Data Developer/Analyst starts between $60,000 to $80,000, depending upon qualifications. MARC offers an attractive team-oriented work environment along with a competitive fringe benefit package.