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.
