Data Systems Manager

About The Kennedy Center

“I am certain that after the dust of centuries has passed over our cities, we, too, will be remembered not for victories or defeats in battle or in politics, but for our contribution to the human spirit.” – President John F. Kennedy

The Kennedy Center is the nation’s cultural center and living memorial to President John F. Kennedy. Located on the banks of the Potomac River in Washington, D.C., the Center presents performances across all genres, and is also home to artistic affiliates Washington National Opera and National Symphony Orchestra. 

At the Kennedy Center, we strive to foster belonging and empowerment at work. We are able to advance our mission because of our committed and passionate employees. We are fortunate to be able to leverage their diverse perspectives, life experiences and skills to inform how our workplace can be a safe, transparent, and replenishing community. The Kennedy Center is an equal opportunity employer and does not discriminate against any employee or applicant based on race, religion, gender identity, sexual orientation, disability, veteran status, marital status, pregnancy or related condition, or any other basis protected by law. 

Mission Statement: As the nation's performing arts center, and a living memorial to President John F. Kennedy, we are a leader for the arts across America and around the world, reaching and connecting with artists, inspiring and educating communities. We welcome all to create, experience, learn about, and engage with the arts. 

Why Join Us

We offer a comprehensive range of benefits to all full-time employees including: 

• Staff offers for discount tickets
• Retirement plan with organization matching (after 1 year of employment)
• Qualifying employer for the Public Student Loan Forgiveness Program (PSLF)
• Commuter programs including pre-tax options for discounted parking and SmartBenefits (WMATA)
• Annual Leave, Sick Leave, and Personal Days available immediately upon hire
• 11 paid holidays per year 
• Medical, Dental, and Vision benefits with FSA and HSA options, and paid FMLA
• Flexible work arrangements
• We like to have fun! Check out the Kennedy Center National Dance Day 2022 staff video!

Job Description

This position is for a strong SQL Developer with experience in combining multiple data sources into data warehouse or data lake for the purpose of creating reports and data visualizations from both transactional systems and analytic databases or data warehouses.  This position will be responsible for creating and editing SQL Server Reporting Services (SSRS) reports, editing or authoring stored procedures, views, functions and other database objects to support reporting and database jobs.  The database environments are SQL Server and Amazon Redshift Data Warehouse.  This position will understand a variety of AWS Data & Analytics services and how they interact.  They will be responsible for the support of the daily/weekly/monthly and ad hoc loading and transformation of data into the Enterprise Data Warehouse.  The tools currently used include SQL Server, AWS Data Migration Service, AWS Glue Notebooks, S3 buckets, Data Pipeline, SageMaker Notebooks, and QuickSight for data Visualization, Dashboards and scheduled report delivery. 

This position will enjoy working with a diverse set of users to understand their data and reporting needs, can thoroughly document and communicate complex business rules and reporting needs, and can creatively solve problems with data and reporting with innovative ideas. Experience with data analysis, the ability to see trends, spot outliers, and solve problems in data are required.

Key Responsibilities

• Primary developer on our Enterprise Data Warehouse.  This includes preparing source data for inclusion in our data warehouse, support of ETL jobs and revision of ETL, design of data warehouse tables and structures, modeling data for efficient and flexible reporting by end users.   It will also include generating data sets in a visualization tool (QuickSight, Tableau) for shared use across the organization and creating dashboards and data visualizations or consumption by all levels of the organization.
• Support KC departments with data needs and develop or maintain existing solutions that may involve SQL Server jobs, SSRS reports, SSIS packages,  MS Access Development or AWS automations.  These solutions may include reports, lists, integrations with other systems, automations, etc. to fulfill requests.
• Support and encourage SQL Best Practices, SSRS Best Practices and QuickSight best practices.  Participate in SQL review and change management activities, promote ddl changes to production and ensure code backups and source control usage.
• Support data hygiene and data governance activities along with the Business Systems team.  Provide support, thought partnering, review of process and code when performing data hygiene tasks or enforcing data governance rules.
• Support Data & Analytics team in maintenance of tools and systems including maintenance of technology (patching, upgrades) and advocacy with users (training, documentation).
• Other duties as assigned

Key Qualifications

• Bachelor’s degree in a technical field or equivalent
• 5 years experience in technical environment, working with data, performing data analysis, interacting with data as a technical resource.
• Significant hands-on experience writing SQL Code - stored procedures, views, and functions for Microsoft SQL Server as well as familiarity with database design standards in both a transactional database and a data warehouse.
• Experience with Amazon Redshift, AWS Glue, AWS QuickSight
• Knowledge of SSRS (SQL  Server Reporting Services), QuickSight or other visualization tools
• Well organized and detail oriented
• Proven ability to work within a technical team as well as function within a larger team of colleagues across the center.
• Flexibility to participate in after-hours on-call coverage as needed.
• Flexibility to be occasionally available nights and weekends to perform upgrades and other work.
• Candidate must be local or willing to relocate to the DMV area.