CRM Data Engineer (IS-2210-14)

Application Deadline: 25 April 2025

Department: Office of Digital Transformation

Employment Type: Full Time

Location: Washington, DC

Compensation: $142,488 - $185,234 / year

Description

OPEN DATE: March 25, 2025                    CLOSING DATE: April 25, 2025            POSITION TYPE: Trust FundAPPOINTMENT TYPE:  IndefiniteSCHEDULE: Full Time DUTY LOCATION: Washington, DC 

Position sensitivity and riskExample: Non-sensitive (NS)/Low Risk

Open to all qualified applicants or Unit Only or SI Only

What are Trust Fund Positions?Trust Fund positions are unique to the Smithsonian. They are paid for from a variety of sources, including the Smithsonian endowment, revenue from our business activities, donations, grants and contracts. Trust employees are not part of the civil service, nor does trust fund employment lead to Federal status. The salary ranges for trust positions are generally the same as for federal positions and in many cases trust and federal employees work side by side. Trust employees have their own benefit program, which may include Health, Dental & Vision Insurance, Life Insurance, Transit/Commuter Benefits, Accidental Death and Dismemberment Insurance, Annual and Sick Leave, Family Friendly Leave, 403b Retirement Plan, Discounts for Smithsonian Memberships, Museum Stores and Restaurants, Credit Union, Smithsonian Early Enrichment Center (Child Care), Flexible Spending Account (Health & Dependent Care).  Conditions of Employment

• 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.
• The position is open to all candidates eligible to work in the United States.  Proof of eligibility to work in U.S. is not required to apply.
• Applicants must meet all qualification and eligibility requirements within 30 days of the closing date of this announcement. 

OVERVIEW

This position is located organizationally in Engagement Solutions, Office of Digital Transformation (ODT), Office of the Deputy Secretary, Smithsonian Institution (SI). SI is a diverse museum and research complex dedicated to the increase and diffusion of knowledge. ODT leverages digital technology to advance this mission by developing cohesive constituent journeys that enable more meaningful and lasting relationships, better supporting visitor needs. This role leads the management of data supporting audience solutions, including the maintenance of constituent relationship management (CRM) and associated data platform(s) th

DUTIES AND 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. 
•  Leads and participates in SI-wide projects to assure the continued integrity of the CRM database and the reliability, timeliness and utility of data provided by the system.

QUALIFICATION REQUIREMENTS

Experience required for this position is as follows:

• 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 und