Salesforce Database Developer
New
T
Tripoint SolutionsFederal technology
Remote. The selected candidate must be currently located in, or willing to relocate to, a state supported by Tripoint Solutions corporate offices: AL, CO, DC, DE, FL, GA, IL, IN, KS, LA, MD, MN, MS, NC, NJ, OH, PA, SC, TN, TX, or VA.Full-TimeSenior
Salary104,000 - 124,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years of database development experience, including 2+ years working with Salesforce data.
- Required Skills
- PythonSQLAmazon RDSJiraConfluence
Requirements
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- 5+ years of database development experience, including 2+ years working with Salesforce data.
- Current hands-on Salesforce data development within the last 12 months, including SOQL, Bulk API, Data Loader, and large data volume design.
- Strong working knowledge of the Salesforce data model, including objects, relationships, sharing, and record access.
- Advanced SQL skills, including stored procedures, query tuning, and data modeling.
- Hands-on ETL development between Salesforce and external data stores, delivered to production within the last 12 months.
- Experience with Amazon Redshift or RDS, S3, and AWS Glue.
- Python skills for data pipelines and automation.
- Active Salesforce Trailblazer account with a public profile.
- Current, verifiable Salesforce Certified Platform Administrator certification; list certifications on the resume and provide a Trailblazer profile URL.
- Preferred: Salesforce Education Cloud or EDA data experience; Salesforce Platform Data Architect, Platform Developer, Data 360 Consultant, or Agentforce Specialist certification; Salesforce Data 360 experience; AWS Certified Data Engineer Associate or AWS Certified Solutions Architect; AWS GovCloud experience; federal government technology program experience; current favorably adjudicated federal background investigation.
Responsibilities
- Design and build database schemas, tables, views, and stored procedures for reporting and data warehousing.
- Develop Salesforce data solutions using SOQL, SOSL, Bulk API, Data Loader, and Apex batch processing for large data volumes.
- Develop and maintain ETL jobs and pipelines between Salesforce, connected third-party systems, and AWS data stores using AWS Glue, MuleSoft, and related services.
- Optimize the Salesforce data model for performance using indexing, selective queries, skinny tables, and archiving.
- Tune queries and pipelines for performance and reliability, and monitor scheduled jobs.
- Build data validation and reconciliation checks into pipelines.
- Carry out data migration and reconciliation for the Education Cloud migration.
- Apply encryption, least-privilege access, and federal security hardening standards to data stores.
- Estimate work in hours, log time against Jira tickets, and document designs in Confluence.
View Full Description & ApplyYou'll be redirected to the employer's site