CRM Data Engineer (IS-2210-14)

Company: Smithsonian Institution
Location: Washington
Posted on: March 28, 2025

Job Description:

CRM Data Engineer (IS-2210-14)Application Deadline: 25 April 2025Department: Office of Digital TransformationEmployment Type: Full TimeLocation: Washington, DCCompensation: $142,488 - $185,234 / yearDescriptionOPEN DATE: March 25, 2025CLOSING DATE: April 25, 2025 This job will close once 250 applications are received which may be sooner than the closing date.POSITION TYPE: Trust FundAPPOINTMENT TYPE: IndefiniteSCHEDULE: Full TimeDUTY LOCATION: Washington, DCPosition sensitivity and risk: Non-sensitive (NS)/Low RiskOpen to all qualified applicants.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.OVERVIEWThis 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).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 REQUIREMENTSExperience 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 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.
    • Expert knowledge of trends and best practices in data management in order to recommend their utility in a CRM system.
    • Experience applying project planning and control techniques to successfully manage, control and evaluate overall data cleanup efforts in a CRM.
    • Strong communication and technical writing skills.
    • Preferred: Experience working in Nonprofit and/or Federal environments.Education completed outside the United States must be deemed equivalent to higher education programs of U.S. Institutions by an organization that specializes in the interpretation of foreign educational credentials. This documentation is the responsibility of the applicant and should be included as part of your application package.Any false statement in your application may result in rejection of your application and may also result in termination after employment begins.Join us in "Inspiring Generations through Knowledge and Discovery."Resumes should include a description of your paid and non-paid work experience that is related to this job; starting and ending dates of job (month and year); and average number of hours worked per week.What To Expect Next: Once the vacancy announcement closes, a review of your resume will be compared against the qualification and experience requirements related to this job. After review of applicant resumes is complete, qualified candidates will be referred to the hiring manager.Relocation expenses are not paid.The Smithsonian Institution provides reasonable accommodation to applicants with disabilities where appropriate. Applicants requiring reasonable accommodation should contact OHRTrustbranch@si.edu. Determinations on requests for reasonable accommodation will be made on a case-by-case basis. To learn more, please review the Smithsonian's .The Smithsonian Institution is an Equal Opportunity Employer. We believe that a workforce comprising a variety of educational, cultural, and experiential backgrounds support and enhance our daily work life and contribute to the richness of our exhibitions and programs. See Smithsonian EEO program information: .
      #J-18808-Ljbffr

Keywords: Smithsonian Institution, Washington DC , CRM Data Engineer (IS-2210-14), Engineering , Washington, DC