The Smithsonian Institution is looking to solve the problem of managing data supporting audience solutions, including the maintenance of constituent relationship management (CRM) and associated data platform(s), to advance its mission by developing cohesive constituent journeys that enable more meaningful and lasting relationships, better supporting visitor needs.
Requirements
- Mastery knowledge of complex CRMs, Cloud Data Management tools and other databases including Salesforce, Oracle, Peoplesoft, Redshift, Glue, Athena, and Snowflake
- Mastery knowledge of and skill in implementing data integration processes and patterns to append, unify, validate, and enrich data
- Mastery knowledge of and skill in data modeling, warehousing, quality management, workflow automation, ETL, and database management systems
- Expert skill running data conversions and quickly understanding complex data sets.
- Expert skill in data engineering processes
- Experience in using Apache Spark, SQL, Python, R, T-SQL, and KQL.
- Knowledge of and skill in implementing CI/CD pipelines for automating data engineering processes
Responsibilities
- Develops, documents, promulgates and maintains CRM data management policies and procedures, and strategies for data quality integrity.
- Develops, tests, and maintains data pipelines and automations and ensures they meet standards for data availability, quality and integrity.
- Drives automation of processes, develops new applications, and manages the integrations of the CRM system.
- Maintains the data dictionary for all CRM data elements and ensures that each instance of the data complies with corresponding data validation rules.
- Cleanse and enhances CRM data through data services and processes that append, unify, validate and enrich data (e.g. Address verification, demographic data appends, deduplication, email and phone verification, etc)
- Ensures data availability and usability, optimizes performance and facilitates modern data analytics and reporting.
- Ensures technologies, software, and data management methodologies are adapted to meet CRM data and reporting requirements.
Other
- Pass Pre-employment Background Check and Subsequent Background Investigation for position designated.
- Complete a Probationary Period.
- Maintain a Bank Account for Direct Deposit/Electronic Transfer.
- Applicants must meet all qualification and eligibility requirements within 30 days of the closing date of this announcement.
- Strong communication and technical writing skills
