Strategic Data Analyst II - Market Intelligence and Pricing

Strategic Data Analyst II - Market Intelligence and Pricing OpenGov is the leader in AI and ERP solutions for local and state governments in the U.S. More than 2,000 cities, counties, state agencies, school districts, and special districts rely on the OpenGov Public Service Platform to operate efficiently, adapt to change, and strengthen the public trust. Category-leading products include enterprise asset management, procurement and contract management, accounting and budgeting, billing and revenue management, permitting and licensing, and transparency and open data. These solutions come together in the OpenGov ERP, allowing public sector organizations to focus on priorities and deliver maximum ROI with every dollar and decision in sync. Learn about OpenGov’s mission to power more effective and accountable government and the vision of high-performance government for every community at OpenGov.com http://OpenGov.com. JOB SUMMARY We are seeking a highly analytical and technically strong Data Analyst to join our GTM Strategy and Pricing team. This role focuses on building and maintaining scalable data models in Snowflake that power market intelligence and pricing strategy. You will own the end-to-end lifecycle of market and account-level datasets, including sourcing, ingestion, transformation, governance, and delivery into dashboards and field-facing systems. This position is distinct from other data roles in that it focuses specifically on strategic datasets regarding market data, pricing enablement, and scalable data infrastructure which help power c-level decision making You will report to the Strategy and Pricing Manager and partner closely with Sales, Product, Finance, and Data Engineering stakeholders. RESPONSIBILITIES - Translate business requirements into scalable data products: Partner with GTM Strategy stakeholders to gather requirements, translate business needs into structured data frameworks, and deliver production-ready datasets with full end-to-end ownership from scoping through implementation. - Build and operationalize competitive pricing intelligence: Consolidate and normalize competitive pricing data, develop analytical models to evaluate pricing positioning and trends, and establish repeatable processes to continuously update and maintain these models end to end. - Own scalable Snowflake data models for market analytics: Consolidate and transform CRM, financial, and external data into governed datasets that support market sizing, segmentation, and strategic analysis. - Expand account-level market intelligence coverage: Identify, evaluate, and operationalize high-value external datasets such as budget documents, procurement calendars, grants data, demographic sources, and leadership changes. - Scale ingestion of complex external data sources: Develop repeatable normalization workflows and implement automation techniques that convert raw and unstructured inputs into production-ready schemas. - Deliver actionable insights to leadership and field teams: Build and maintain Looker dashboards and structured outputs that clearly surface pricing and market intelligence insights. MINIMUM QUALIFICATIONS - Bachelor's degree in a quantitative field such as Business Analytics, Economics, Statistics, Mathematics, Computer Science, or a related discipline. - 2-4 years of experience in data analysis, business intelligence, or a similar quantitative role, with a strong emphasis on deriving strategic insights. - Expert proficiency in SQL for data extraction and manipulation from large, complex datasets. - Demonstrable experience with modern Business Intelligence (BI) tools (e.g., Looker (Preferred), Tableau, Power BI, Qlik Sense) for dashboard creation and data visualization. - Strong analytical, problem-solving, and critical thinking skills with a proven ability to translate raw data into actionable business recommendations. - Excellent communication (written and verbal) and presentation skills, with the abi ... (truncated, view full listing at source)