Data Report and Analysis Specialist (On-site)

Description

Please note this position is hybrid with on-site work in Williamsburg, VA. The compensation range for this role $65-75k with full benefits including health, vision, dental, 401k and pension program. We are unable to provide work authorization sponsorship or relocation assistance for this position.

Who We Are

Founded in 1926, the Colonial Williamsburg Foundation is a private, not-for-profit educational, historic, and cultural institution that owns and operates one of the largest and best-known museum complexes in the world. Our mission is “that the future may learn from the past” through preserving and restoring 18th-century Williamsburg, Virginia’s colonial capital. We engage, inform, and inspire people to learn about this historic capital, the events that occurred here, and the diverse peoples who helped shape a new nation. Today, Colonial Williamsburg is the largest living history museum in the U.S. The Historic Area is the 301-acre restored colonial capital with 88 original buildings and 525 buildings reconstructed to how they appeared in the 18th century through extensive archaeological, architectural, and documentary research. The Historic Area is staffed by highly trained, historically dressed interpreters and expert tradespeople who bring the 18th century to life. The Foundation also owns and operates two world-class museums, the DeWitt Wallace Decorative Arts Museum, and the Abby Aldrich Rockefeller Folk Art Museum, and a renowned research library, the John D Rockefeller Jr Library. Additionally, Colonial Williamsburg is home to five world class accommodations at the Williamsburg Inn, Williamsburg Lodge Autograph Collection, the Griffin Hotel, the Williamsburg Woodlands Hotels and Suites and the unique Colonial Houses in the Historical Area. Visitors may also indulge in food and drink at our many on site restaurants and taverns that blend a historically inspired dining experience with today’s evolved tastes. Each year over 5 million people visit Williamsburg and another 20 million engage with us digitally.

About the Position

The Data Report and Analysis Specialist will provide technical, reporting, and analytical support primarily to the Annual Giving (AG) department, with support to other departments as able. The role will be responsible for extracting, transforming, and loading (ETL) data into actionable reports, establish and maintain scalable data processes that provide data validation and serve as the primary source of direct response analysis and interpretation for the AG team. Additionally, this role will develop, through collaboration, the technical requirements for direct response campaigns, track key metrics and identify from the data opportunities to optimize campaigns. From a technical perspective, this role will create programmatic scripts to facilitate seamless flow of data, assist in the management and organization of data architecture, and create needed data elements as part of building a robust reporting structure.

Essential Functions:

1. Oversee the ETL process, extracting data from diverse sources and transforming it into a structured format for analysis.
2. Translate the business needs and goals of the AG team into technical specifications that will achieve and optimize outcomes through robust reporting and data analysis.
3. Develop and maintain scripts to enhance data flow efficiency, ensuring a streamlined and reliable data pipeline.
4. Collaborate with cross-functional teams to understand data requirements and report specifications. Create, implement, and interpret custom reports for internal stakeholders, most specifically the AG team.
5. Design visually appealing and easy-to-understand data visualizations using tools like Tableau, Power BI, or similar.
6. Interpret complex data sets and translate findings into actionable insights for stakeholders.
7. Assist with the management and optimization of data architecture, ensuring scalability, integrity, and security.
8. Apply advanced data analysis techniques and statistical methods to uncover trends, patterns, and correlations.
9. Perform data improvement functions, including:
   • Data cleansing
   • Data validation
   • Data quality management
   • Data enrichment
10. Demonstrate proficiency in specialized data functions such as:
    • Geospatial analysis
    • Natural Language Processing (NLP)
    • Machine Learning concepts

Qualifications:

• Experience with complex database structures and requirements.
• Statistical analysis skills and expertise in applying advanced analytics techniques.
• Proficiency in data visualization tools (Tableau, Power BI, etc.) and data analysis tools (SQL, Excel, etc.).
• Strong scripting skills (SQL, Python, R, etc.) for developing and automating data processes.
• Advanced knowledge of ETL processes and best practices.
• Familiarity with machine learning concepts is a plus.
• Excellent problem-solving and critical-thinking abilities.
• Stay updated on industry trends and best practices in data reporting, ETL processes, data architecture, and specialized data functions.
• Collaborate with the central IT team to troubleshoot and resolve any database or data-related issues.
• Strong attention to detail and accuracy in data interpretation.
• Effective communication skills for conveying complex insights.
• An individual contributor with a strong ability to work collaboratively in a team environment.
• Proven experience in specialized data functions (e.g., geospatial analysis, predictive modeling).
• Experience in a matrixed, nonprofit environment.

Required and Preferred Education & Experience:

Required: Bachelor’s degree or equivalent with 3-5 years of experience.

Preferred: Master's degree in a relevant field, certification in data analysis, ETL processes, or reporting tools, 5-7 years of experience.