Salesforce Developer

You will work closely with internal stakeholders and external data providers to manage periodic data loads, schema changes, and historical backfills. Strong SQL expertise is essential, along with experience supporting static and incrementally growing datasets in a massively parallel processing (MPP) environment., * Design, develop, and maintain ETL/ELT pipelines for large, structured datasets

• Own and support 3-5 primary datasets, handling scheduled loads (monthly, quarterly, or annual) and schema updates
• Perform full reloads and historical backfills as data models evolve
• Collaborate with internal partners and third-party data providers to ensure accurate, timely data delivery
• Ensure pipelines are scalable, repeatable, secure, and well-documented
• Implement and enforce data quality, validation, and integrity controls
• Conduct regular and ad hoc data audits, reviews, and investigations
• Produce technical documentation for data structures, processes, and standards
• Identify opportunities to improve data ingestion, modeling, and quality processes
• Support PostgreSQL schemas in a Greenplum (MPP) data warehouse environment
• Participate in Agile/DevOps workflows, working independently or as part of a database/data platform team, * Greenplum or other MPP database platforms
• Python for data processing or automation
• Exposure to Databricks environments
• Familiarity with cloud platforms (AWS)
• Tableau or other BI/reporting tools, OperationsAuditingWorkflow ManagementAutomationGovernanceVersion ControlFull Stack DevelopmentSQL (Programming Language)ScalabilityAgile MethodologyResearchLinuxDevOpsTableau (Business Intelligence Software)Data StructuresBash (Scripting Language)Amazon Web ServicesPerformance TuningData QualityData ModelingBusiness ValuationTechnical DocumentationBusiness IntelligenceData WarehousingExtract Transform Load (ETL)Real EstateCritical Illness InsuranceGitlabData EngineeringData ProcessingData IngestionDatabricksBusiness TransformationMortgage LoansPostgreSQLData ValidationParallel ProcessingGreenplum

• Advanced SQL (complex querying, performance tuning, data validation)
• PostgreSQL data modeling and schema management
• ETL / ELT pipeline development
• Data warehousing concepts and best practices
• Linux / Bash scripting
• Git and GitLab version control workflows
• Experience working with large-scale, structured enterprise datasets, * Bachelor's degree in a STEM-related field (or equivalent practical experience)
• 4-10+ years of relevant data engineering experience (level dependent)
• Proven experience developing and maintaining complex SQL across relational databases
• Strong understanding of data quality, governance, and validation practices
• Ability to work independently with minimal supervision
• Senior-level candidates should demonstrate subject-matter depth and serve as a technical resource to others

This is a Contract position based out of Kansas City, MO. Pay and Benefits

The pay range for this position is $70.00 - $85.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

* PostgreSQL data warehouse running on Greenplum MPP architecture * Approximately 25 heterogeneous datasets totaling 300+ TB * Data domains include financial, credit, mortgage, risk, real estate, and market data * Some datasets contain billions of rows and grow incrementally over time * Data is generally static between loads, with full reloads performed on refresh * Mix of manual and automated loads, primarily driven by Linux and Bash scripting * Production and contingency environments are mirrored for resiliency * Limited downstream BI usage (e.g., select Tableau feeds), We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company., We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com., The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. Remote