Job Title: Senior Snowflake Data Engineer

Job Duties: Architect Snowflake solutions and lead Daily Standup Scrum for the EADM and CSD teams. Create and validate Matillion jobs for data loading between Snowflake, Aurora PostgreSQL, and AWS S3. Develop Python scripts for Google Geocode API integration and schedule tasks on EC2 instances via Matillion. Verify data between Netezza and Snowflake; create scripts for data validation and reporting. Use Time Travel and streams for incremental data loading in Snowflake. Develop Snowflake Procedures, Views, and Tasks; schedule tasks for internal processes. Perform zero-copy cloning for testing and data cleansing between Netezza and Snowflake. Conduct end-to-end testing and regression testing; validate data in Aurora PostgreSQL. Create SQL scripts, test scripts, and views for data validation. Manage historical and incremental data loads; ensure accuracy. Work with DBT for customer processes; generate Snowflake cost estimates. Commit Matillion code to the WM Git repository and work in Agile methodology. Required Tools and Technologies: Snowflake, Netezza, Aginity workbench, Squirrel Sql, Salesforce, DataStage 11.5, SQL, Pl/SQL, UNIX, Toad, Python, Snowsql, Sql Developer, Citrix, Open Air, Jira.

Other: Full Time.

Requirements: Bachelor's degree in Electrical and Electronics Engineering or Equivalent + 5 years of experience in job offered or related. Any suitable combination of education, training or experience accepted. 

Location: Lorton, VA

Respond to: HR – Code BKP, Applied Logic LLC, 7601 Sheffield Green Way, Lorton, VA 22079.

This position is eligible for our employee referral program