ETL Developer (AWS Cloud and Python/Pandas/SQL) Job at Southwest Business Corporation, San Antonio, TX

VUxSS3E5dUtXeW40RUpSN29qTEdNVUFWelE9PQ==
  • Southwest Business Corporation
  • San Antonio, TX

Job Description

SWBC is seeking a talented individual to design and develop ETL (Extract/Transform/Load) integration processes for the Data Management Team. This will include data analysis, source to target data mapping, job scheduling, development and testing of iWay Service Manager (iSM) process flows and Data Quality Center (DQC) plans. There will also be Structured Query Language (SQL) ETL programs. This individual will interact with data owners, external vendors, and business users to resolve data questions and anomalies and will mentor other staff members and participate in technical design sessions.


Why you'll love this role:

SWBC is heavily engaged in the development of new cloud applications. The successful candidate will apply ETL (extract, transform, load) skills to ensure these applications integrate with each other seamlessly. In this role, developers will work closely with programming languages, ETL software, databases, and server infrastructure. Beyond that, they’ll be working on a wide variety of tasks ranging from team management, technical hurdles, and meeting and coordinating with others outside the department regularly.

Essential duties include the following:

  • Communicates with customers to obtain data requirements and performs data analysis on data provided.
  • Designs and implements data integration modules for ETL functions.
  • Develops aggregation, monitoring, and alerts tools and modules.
  • Participates in the overall development process through architecture guidance, design, and code reviews.
  • Designs, implements, and maintains a report, monitor, and dashboard framework.
  • Investigates new technologies and advances, especially in the areas of ETL and Cloud.
  • Performs all other duties as assigned.

Serious candidates will possess the minimum qualifications:

  • Bachelor’s Degree in Computer Science, Information Technology, or related field from an accredited four-year college or university or equivalent experience required.
  • Minimum of three (3) years in ETL development using Information Builders or similar products such as Microsoft, IBM/Cognos, Business Objects, and/or Informatica, which includes database development using various versions of Microsoft SQL Server.
  • Extensive knowledge of different data languages, formats and syntax, including SQL, JavaScript Object Notation (JSON), Extensible Markup Language (XML), etc.
  • Working knowledge of relational database systems such as Microsoft SQL Server or IBM DB2. (Microsoft SQL Server preferred).
  • Proven work experience as an ETL developer.
  • Cloud-hosted server experience.
  • Knowledge of cloud data sources like S3, Aurora, Relational Database Service (RDS), DynamoDB and EC2 is a plus.
  • Experience with AWS ETL tools like Glue (Python), Data Pipeline and Talend.
  • Understanding of data cleansing, data verification, and data configuration.
  • Strong analytical, organizational, and detail oriented skills.
  • Strong communication (both verbal and written) and interpersonal skills.
  • Ability to troubleshoot and solve complex technical problems.
  • Working knowledge of Microsoft Office to include MS Excel.
  • Experience in an agile environment.
  • Able to lift 10-20 lbs. of computer equipment.
  • Must be able to sit for long periods of time at the computer developing.
  • Able to stoop, kneel, and stand while performing hardware support.Able to travel locally and nationally.

SWBC offers*:

  • Competitive overall compensation package
  • Work/Life balance 
  • Employee engagement activities and recognition awards 
  • Years of Service awards
  • Career enhancement and growth opportunities 
  • Leadership Academy and Mentor Program
  • Continuing education and career certifications 
  • Variety of healthcare coverage options
  • Traditional and Roth 401(k) retirement plans 
  • Lucrative Wellness Program

*Based upon employee eligibility 

Additional Information:

SWBC is a Substance-Free Workplace and requires pre-employment drug testing.

Please note, SWBC does not hire tobacco users as allowed by law.

To learn more about SWBC, visit our website at If interested, please click the appropriate apply button.

Job Tags

Work experience placement,

Similar Jobs

Corona-Norco Unified School District

Biology and Chemistry Teacher - Eligibility Pool 2024/2025 School Year Job at Corona-Norco Unified School District

 ...continual training and professional development. Additionally, all teachers and administrators have access to participate in our induction...  ...# Credential # Single Subject: Chemistry and Biological Sciences. Please upload the Document's Detail of your credential... 

Gentle Dental

Dental Assistant, Ortho (EFODA) Job at Gentle Dental

 ...At Gentle Dental, we value our teammates smile as much as our patients smile. Our vision is to provide exceptional, lifelong, integrated...  .... Estimated at 1 Monday per month. Benefits ~ Employee Assistance Program ~ Medical and pharmacy, dental, vision (for employees... 

American Honda Motor Co.

Stability Equipment Engineer Job at American Honda Motor Co.

What Makes a Honda, is Who makes a Honda Honda has a clear vision for the future, and its a joyful one. We are looking for individuals with the skills, courage, persistence, and dreams that will help us reach our future-focused goals. At our core is innovation. Honda is... 

OmniInclusive

Technical Associate - Research & Development Job at OmniInclusive

 ...mechanical analysis. Support additional prototyping and optimization development initiatives relevant to strategic goals as they arrive....  ...collection and analysis. Clearly and concisely communicate research to team members of varying technical backgrounds Demonstrate... 

Lowell Obervatory

Facilities and Grounds Maintenance Assistant Job at Lowell Obervatory

 ...POSITION ANNOUNCEMENTFacilities & Grounds maintenance ASSISTANT The Facilities & Grounds Maintenance position is responsible for the upkeep of exterior grounds year round for scientific research sites, office buildings, and public visitor ; This position reports to...