Lead Data Analyst


About the Lead Data Analyst position:

The Lead Data Analyst reports to the Chief Information Officer and works as an integral member of the Federation’s IT and data teams. The Lead Data Analyst will support the organization’s growing data analysis and data visualization efforts, expanding our existing Business Intelligence (BI) and data mining capabilities, and continuing to strengthen the organizational capacity to make data-driven decisions. The Data Analyst will manage and support projects and partnerships across the organization to identify and address existing and new data analysis and data modeling needs.

The Lead Data Analyst will be responsible for 1) leading the overall use, expansion, and staff training of our existing BI solution and other data analysis tools, 2) partnering with team members in Development, Marketing, Fiscal, and Planning to understand and support cross-organization analytical requests, 3) devising methods for identifying patterns and trends in data to derive business insights and 4) managing our BI partner relationship to ensure capabilities meet organizational needs. The Lead Data Analyst will work in close collaboration with the data stewardship & research and application development teams and be a key member of this multi-functional group that is responsible for the cultivation, management, and analytical use of the organization’s data.

Essential Functions:

  1. Lead the organization’s efforts to expand capabilities and utilization of our existing BI solution.
  2. Develop analysis and data visualizations to support organizational analytical needs using all available data sources.
  3. Facilitate brainstorming and analysis sessions with key stakeholders to understand business problems or questions and translating into analysis, reports, and visualizations which are actionable and understandable.
  4. Collaborate closely with the Federation’s marketing team and provide analytical support for initiatives that enhance constituent communications.
  5. Analyze key performance indicators and performance metrics in order to surface potential new opportunities and factors of variance.
  6. Synthesize data trends and patterns to support recommendations for action.
  7. Perform ad-hoc analysis on a regular basis, assist in special projects, support recurring reporting requests for leadership and suggest opportunities for data improvements throughout the organization.
  8. Document data models and processes in a clear and concise manner for technical and non-technical audiences.
  9. Provide ongoing staff training and education opportunities to advance the organization’s knowledge of data analysis capabilities.
  10. Provide day-to-day management and support of our Microsoft BI solution and external BI partner.
Required Qualifications:
  1. Bachelor’s or master’s degree in information systems, data science or related field of study.
  2. 2+ years of relevant experience in data analysis, business intelligence, or related field.
  3. Experience building data visualizations, analysis, and reports in Power BI or similar.
  4. Knowledge of data warehousing concepts and business intelligence best practices.
  5. Experience using Microsoft Excel to perform advanced analysis
Knowledge, Skills & Abilities:
Knowledge, Skills & Abilities:
  1. Demonstrated problem-solving skills.
  2. High level written and verbal communication skills and proven ability to liaison with end users.
  3. Ability to work independently, prioritize and engage in a variety of tasks simultaneously while consistently meeting short deadline situations.
  4. High attention to detail, follow-up, self-motivated, proactive and solution focused.
  5. Previous experience in non-profit data analysis a plus.
  6. Experience using Microsoft SQL Server, a plus.
  7. Experience writing DAX expressions a plus.
  8. Experience with statistical programming languages (R, Python, SAS or similar) a plus.

If you are qualified and interested in this exceptional opportunity, please send your resume and cover letter, in a pdf format, to .

Our Benefits

  • Affordable medical and dental insurance
  • Paid vacation, holiday, and sick days
  • 403(b) plan
  • Life insurance
  • Long term disability
  • Wellness programs
  • Employee Assistance Program (EAP)