Data Architect

```html

About the Company

The Data Strategy and Analytics Lead will be a key player in establishing a robust, scalable, and accessible data practice for the State of Connecticut. This role requires a unique combination of technical expertise, strong analytical skills, and a highly strategic mindset to drive awareness and adoption of data and analytics. This person will strategize, maintain, and expand on existing data structures including pipelines, databases, and dashboards, while also helping to build a sustainable data practice that drives government-wide optimization and ensures ethical use of data to benefit all residents.

About the Role

You will guide teams in leveraging data to improve the end-to-end user journey, identify product and service challenges, and foster a culture where data is integrated into everyday operations. You will also ensure the integrity, uptime, and accessibility of data technology to support the state’s initiatives.

Responsibilities

• Data Strategy and Leadership:
• Help lead the development and execution of the state’s data practice, focusing on clear and actionable strategies and aligning with organizational goals.
• Work closely with stakeholders to identify critical data needs and design solutions that address them.
• Identify opportunities to integrate machine learning, NLP, and AI-assisted analytics into government service improvement initiatives.
• Mentor and guide non-technical teams to build their confidence and capability in using data for decision-making.
• Analysis and Measurement:
• Collect, compare, and analyze complex data sets to identify trends, patterns, and actionable opportunities.
• Present findings in clear, visually engaging formats tailored to audiences with varying levels of data literacy.
• Create detailed reports, dashboards, and presentations that drive organizational improvements and adoption of insights.
• Lead development of statewide data maturity and impact measurement frameworks to assess progress in data-driven decision-making.
• Technical Maintenance and Expansion:
• Establish and maintain enterprise data architecture standards, including metadata management, data lineage, and interoperability across systems such as Salesforce, Sitecore, and Azure.
• Maintain and optimize existing pipelines, databases, and dashboards while advancing the state’s data innovation agenda.
• Design new ways to use data, AI, and analytics to modernize services and improve resident outcomes.
• Develop and implement strategies to scale data systems as needs grow, ensuring performance and data integrity.
• Oversee ETL processes to integrate data from new sources and improve workflows.
• User Engagement and Enablement:
• Design and deliver training programs to help non-technical teams incorporate data and analysis into their regular workflows.
• Collaborate with teams to develop KPIs and frameworks for measuring the impact of data-driven initiatives.
• Facilitate workshops, office hours, and regular program updates to ensure alignment across teams.
• Cross-Functional Collaboration:
• Partner with leadership, IT teams, and other stakeholders to identify priorities and implement solutions.
• Act as a liaison between technical teams and business stakeholders, ensuring alignment and understanding.

Qualifications

Data Collection & Analysis - at least 3 years of measurable experience in the following:

• Analyzing user data and metrics to drive specific business goals. Emphasis on Google Analytics and other behavioral and analytical data.
• Using data to isolate complex problems and develop workable solutions.
• Utilizing predictive analysis, gap analysis, quantitative reporting, user research, and statistical analysis.
• Providing insights and recommendations based on data.
• Bridging the data divide between technical, product, and customer-facing teams.
• Developing and applying data models to improve the collection and analysis of data.
• Crafting compelling presentations and narratives from data findings. Emphasis on Power BI dashboards.
• Engaging in data experiments that provide cross-persona or enterprise-level analysis.
• Data cleansing, optimizing, and ETL.
• Developing and analyzing user surveys.
• Organizing and storing data and queries for easy access in future work projects.
• Documenting data collection and analysis procedures.
• Preparing and executing ROI analysis.

Required Skills

Technical Expertise - at least 3 years of measurable experience in the following:

• Managing data pipelines, ETL processes, and databases (e.g., SQL, Power BI, Azure Data Lake).
• Proficiency in Python or R for data manipulation and analysis.
• Experience with modern data stack technologies (e.g., Synapse, Databricks, Snowflake, Airflow, or equivalent orchestration tools).
• Data modeling, data governance, and data quality best practices.
• Administering analytics software and platforms (GA4, GTM, SPSS, Excel, Microsoft Office Suite).
• Using business intelligence tools like Tableau or Power BI.
• Experience with all types of big data, both structured and unstructured.
• Data collection from on-prem and cloud platforms like Microsoft, Azure, and Salesforce.
• Leveraging statistical analysis and algebra.
• Leveraging economics, business/systems analysis, and quality assurance.
• Manipulating large, complex data sets.
• Documenting data processes and configurations.

Preferred Skills

Strategy, Communications, and Governance - at least 3 years of measurable experience in the following:

• Must have led a data function, practice, or vertical - not just participated in one.
• Experience presenting analytical insights and data strategies directly to leadership.
• Developing a data practice that incorporates strategy, training, tool development, and support.
• Communication and collaboration with cross-functional teams and government partners.
• Crafting compelling presentations and narratives from data findings.
• Explaining data analysis to stakeholders with varying levels of data comprehension.
• Using data to help internal teams improve capabilities and operations.