Data Analyst

About CTData Collaborative (CTData)

CTData, a 501(c)(3) nonprofit, connects people and data to promote informed decision-making and to advance equity in Connecticut. We empower an ecosystem of data users by democratizing access to public data and building data literacy skills. CTData serves residents, nonprofits, policymakers, and funders in using data to drive policy, program, and service improvements. We strive to promote and engage data users in implementing equitable data practices across the state. To learn more, visit ctdata.org.

The Position

CTData is seeking an enthusiastic person who loves data, believes in our mission, and wants to grow within our organization to join our team as a Data Analyst. The Data Analyst will report to the Director of Data and Analytics and will work equally alongside both our Hartford Data Collaborative (HDC) Team and the Data Team on a variety of projects, including data linking, data analysis, report-writing, data visualizations, building dashboards, and more. This role encompasses a diverse set of responsibilities and opportunities to engage with both data and community members.

The Data Analyst will split their time supporting CTData’s Data Team and our integrated data-sharing initiative, HDC. HDC facilitates data sharing and data integration among a network of Hartford area non-profit organizations, government agencies, and philanthropic partners. Data integrated through HDC provides community and government organizations with a more holistic view of individuals, families, and households in Hartford.

The Data Analyst will be responsible for:

• Cleaning, transforming, and linking numerous datasets received by HDC from partner organizations.
• Analyzing Census Bureau data and state and non-profit administrative data.
• Creating accessible data reports and visualizations.
• Building interactive dashboards.
• Writing data stories and blog posts.

This position can be primarily remote, although occasional travel within Connecticut will be required. The successful applicant must live in Connecticut or be willing to relocate to Connecticut.

Applicants must be legally authorized to work in the United States.

Education and Experience Requirements

• A bachelor’s or master’s degree including strong quantitative analysis skills and training, preferably in data analytics, data science, social science, public health, public policy, or related fields.
• At least 2-3 years of experience (excluding schoolwork/coursework) with data analytics in a related field.

What We’re Looking For

• Proficiency in Python (or another language that could allow quick learning of Python), Excel, and SQL.
• Strong analytical skills to clean, manipulate, analyze, and interpret data with minimal guidance.
• Experience working with messy datasets, which often include data quality issues, inconsistencies, and missing records, and the ability to document data quality issues and translate those issues into learning opportunities for data providers.
• Ability to conduct accurate, reproducible analyses and clearly document methods.
• Ability to work both independently and collaboratively with staff and outside organizations, including data providers.
• Self-motivated, curious, and detail-oriented.

Nice to Have

• Experience linking datasets from multiple sources using probabilistic matching with personally identifiable information (for example, name, date of birth, address, and other information) or the ability to quickly learn.
• Experience with data governance, data security, and privacy best practices, including responsible handling of sensitive data and personally identifiable information (PII).
• Familiarity with Census Bureau data (ACS, decennial census) and public data in Connecticut.
• Experience conducting basic statistical analyses.
• Experience with GIS and mapping software (e.g., ArcGIS).
• Experience with Tableau or other visualization tools.
• Strong communication and writing skills and ability to translate complex data into clear, accessible insights.
• Experience or comfort with presenting analyses to external partners and clients.

We welcome applications from candidates who may not meet every criterion listed but possess a strong passion for the work we do. Your unique perspective and experience could be valuable additions to our team. If you believe you can contribute to our mission and thrive in a dynamic work environment, we encourage you to apply.

Benefits

• This is an exempt, salaried full-time position with an annual base salary of $60,000 to $68,000.
• CTData promotes a hybrid work policy with an office space in Hartford, CT. However, this position can be primarily remote with occasional travel within CT.
• 35-hour work week with a flexible work schedule
• 2 weeks of paid vacation time in the first year of employment (increasing to 3 weeks after 2 years of employment)
• 10 paid holidays plus one for your birthday
• Office is closed the week between December 25th and January 1st
• 3 personal days per year
• Accrual of 1 day of paid sick time per month
• Health, dental, and vision insurance
• 403(b) retirement plan
• Supportive and collaborative work environment

To Apply: Submit your resume, cover letter, and responses to additional questions on the application portal.

Please read this information:

You will be asked the following questions in the online application. Please keep your responses to each question to 4 sentences or fewer. A strong application will answer these questions in complete sentences with correct grammar. Incomplete responses will not be considered for the position.

• Do you live in Connecticut, or are you willing to relocate to Connecticut?
• The Data Team uses Python as its main programming language. Please describe your experience with Python (or any other programming language). Include libraries or packages that you use for data work.
• The Data Team and HDC team also use Excel. Please describe your experience with Excel.
• Describe your experience with cleaning, processing, and analyzing data.
• Describe your experience linking datasets from multiple sources using probabilistic matching. Experience in this is not required, but we expect candidates to have the skills to quickly learn.
• Do you use any AI tools in your work? If so, how do they support your workflow?

A strong resume will include:

• Clear and easy-to-read formatting.
• Concise, ideally 1-2 pages.
• Clearly identifying professional experience relevant to this position.
• Additional skills not clearly identified in your experience relevant to this position.

A strong cover letter might:

• Connect your experience to the qualifications of the position.
• Share a real-world example of your experience as it relates to this role.
• Explain why you are interested in working for CTData.

CTData encourages all qualified candidates to apply, regardless of disability. If you need reasonable accommodations to participate in the application or interview process, please let us know.

CTData Collaborative is an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Applications will be accepted until March 25 and reviewed on a rolling basis until the position is filled. No phone calls or emails, please.

• This is an exempt, salaried full-time position with an annual base salary of $60,000 to $68,000.
• CTData promotes a hybrid work policy with an office space in Hartford, CT. However, this position can be primarily remote with occasional travel within CT.
• 35-hour work week with a flexible work schedule
• 2 weeks of paid vacation time in the first year of employment (increasing to 3 weeks after 2 years of employment)
• 10 paid holidays plus one for your birthday
• Office is closed the week between December 25th and January 1st
• 3 personal days per year
• Accrual of 1 day of paid sick time per month
• Health, dental, and vision insurance
• 403(b) retirement plan
• Supportive and collaborative work environment