Data Reporting and Analytics Consultant IV - Geospatial, Spatial, GIS, Python, R

A Python Developer, will be responsible for developing, maintaining, and improving data pipelines that integrate a variety of data sources, including APIs, databases, and shared network drives. The developer will work alongside a team of Business Consultants, Data Analysts and Developers, experienced in R and Python.

This individual contributor is primarily responsible for driving strategic data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, preparing data for analytic efforts, and interpreting data analyses. This position executes creative data analytic approaches leading to actionable outcomes, develops, implements, and automates business and reporting solutions, and develops analytical and/or statistical workflows enabling informed business decisions.

Essential Responsibilities:

• Design, implement, and maintain data pipelines leveraging multiple data sources using Python.


• Leverage common methods and toolsets (Both Open Source and Proprietary) for geospatial data processing, storage, and analytics.


• Leverage Git to collaborate with other developers in maintenance and expansion of the team’s established code base, including using branch/merge best practices and participating in reviews of pull requests.


• Experience with dependency management and working in containerized environments


• Ensure the optimization, scalability, and resilience of data extraction, transformation, and load (ETL) processes via data engineering best practices


• Advocate for programming best practices such as encapsulation, abstraction, unit testing, and documentation. Develop and maintain internal packages for workflow standardization.


• Gather data and information on targeted variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across sources; completing routine data refresh and update; developing and/or delivering tools for electronic data collection; and providing user training, support, and documentation.


• Prepare data for analytic efforts by integrating and consolidating data; ensuring data quality and accuracy; profiling data inaccuracies and recommending process improvements or system changes to enhance overall quality of the data; and cleaning and creating final data set(s) for analysis.


• Collaborate with teammates and internal stakeholders to understand/define business needs. (Including: determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.)


• Execute creative data analytic approaches leading to actionable outcomes by defining and calculating metrics to be analyzed; defining, calculating, and validating algorithms; and conducting analyses, including descriptive, correlational, inferential, and/or predictive statistics.


• Interpret data analyses by applying findings to contextual settings; and developing insights, reports, and presentations telling a compelling story to stakeholders to enable and influence decision making; and providing context related to data interpretations and/or limitations as appropriate.


• Refine analysis into repeatable workflows and reports that can be automated.


• Practice self-development and promote learning in others by proactively providing information, resources, advice, and expertise to coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback.


• Complete work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks as appropriate; and recognizing and capitalizing on improvement opportunities.