Software Engineering Intern - Enterprise Data & Systems (Salesforce & Snowflake) (Graduate/Master's)

WEX•Chicago, IL

1d•$30 - $45•Hybrid

About The Position

The WEX Summer Internship Program is a 13-week paid program running from late May to mid-August, designed to provide interns with real-world experience and skill development. The program includes mentorship, professional development, and weekly learning experiences, with opportunities for high-performing interns to lead initiatives. WEX offers remote, hybrid, and onsite options, with the goal of converting top interns to full-time employees or offering extended roles. This specific internship focuses on a critical enterprise challenge: establishing a customer repository within the core enterprise architecture and CRM (Salesforce) by unifying data from the data warehouse (Snowflake). The intern will collaborate with architects, engineers, and business leaders to identify data sources, gather requirements, and design data ingestion patterns. This role offers hands-on experience with enterprise systems, mentorship, and exposure to cloud data stacks and CRM architectures.

Requirements

Pursuing a Master’s degree in Computer Science, Machine Learning, Software Engineering, or a related field.
A natural curiosity and tenacity for digging beneath the surface of complex systems to figure out how data flows, where discrepancies lie, and which source represents the ground truth.
An instinct to build tools, scripts, and data models that solve problems systematically rather than with one-off manual patches.
Solid academic or project experience writing structured SQL queries (joins, aggregations, window functions) and understanding relational database principles (foreign keys, indexing, entity relationships).
Working knowledge of at least one programming or scripting language (e.g., Python, Java) and standard version control workflows (Git/GitHub).
Demonstrable aptitude and enthusiasm to learn both enterprise platforms quickly is paramount.
Ability to translate complex data structures into plain language when interviewing stakeholders and gathering requirements.

Nice To Haves

Prior hands-on experience with Snowflake or Salesforce is a plus.

Responsibilities

Investigate Source Systems: Trace data lineage across disparate systems (billing platforms, transactional processors, legacy portals, and operational services) to identify where key customer, account, and relationship attributes truly originate.
Define Customer Schema: Partner with product managers, business analysts, and functional leads across Sales, Service, and Operations to document requirements for what constitutes the "single source of truth" for customer identity in Salesforce.
Data Quality & Validation: Perform exploratory data analysis to evaluate consistency, detect schema drift, address duplicate records, and define mapping rules between upstream source models and their destinations.
Build for Reusability: Assist in designing and building scalable, modular data extraction, transformation, and ingestion workflows so future source integrations can plug in with minimal custom code.
Harness Snowflake: Write optimized SQL transformations, views, and data processing routines within Snowflake to clean, normalize, and stage customer datasets for downstream consumption.
Integrate with Salesforce: Collaborate with Senior Salesforce Developers and Enterprise Architects to map staged Snowflake data into standard and custom Salesforce objects.
Active Mentorship & Agile Sprints: Participate in daily stand-ups, backlog grooming, and architectural design reviews alongside senior systems engineers.
Testing & Documentation: Document data dictionaries, entity-relationship diagrams (ERDs), integration flows, and automated validation tests to ensure maintainability.
AI & Automation Exploration: Leverage AI-assisted developer workflows and modern automation tooling to accelerate querying, schema mapping, and documentation generation.