Senior Programmer Analyst - Data Engineer​/ETL Developer

Senior Programmer Analyst - Data Engineer/ETL Developer

Position:
Senior Programmer Analyst (Data Engineer/Architect)

Location:

Richmond, Virginia 23219 (Hybrid, 1 week office, 1 week remote)

Duration: 12 months

Job

• Excellent communication skills is an absolute must for effective collaboration with various stakeholders.
• Strong understanding of data warehousing (dimensional modeling, ETL, etc.) and RDBMS concepts.
• Minimum 5 years of experience with an ETL tool such as Talend, Informatica, etc.
• Minimum 5 years of experience in SQL, stored procedures, and table design.
• Minimum 5 years of experience in SQL query optimization and ETL data loading performance.
• Experience in Snowflake cloud data warehouse is strongly preferred.
• Experience in shell scripting is preferred.
• Experience in real‑time streaming technologies is preferred.
• Experience deploying machine learning models and automating processes in production is a plus.
• Experience with cloud technologies (AWS, Azure, GCP) is a big plus.
• Knowledge of Denodo tool is a plus.
• Knowledge of any data governance and data quality tool is a plus.

• Excellent communication skills is an absolute must for effective collaboration with various stakeholders.
• Ability to lead, collaborate, or work effectively in a variety of teams, including multi‑disciplinary teams.

• Define the data architecture vision aligned with business goals.
• Establish data standards, policies, and governance frameworks.
• Provide technical guidance to development teams.
• Communicate data architecture decisions to executives and non‑technical teams.
• Design, develop and maintain secure, consistent and reliable ETL solutions supporting critical business processes across the various business units.
• Develop, test and validate data flows; prepare ETL processes to meet complex business requirements, including designing and implementing end‑to‑end solutions using BI platforms.
• Partner with infrastructure, application, and architect teams to design complex transformations for various data elements and provide business insights.
• Assist the production support team in resolving production job failures, data issues, and performance tuning.

• 5+ years of hands‑on experience as a Data Engineer/Architect.
• Minimum 5 years of experience with an ETL tool such as Talend, Informatica, etc.
• Minimum 5 years of experience in SQL, stored procedures, and table design.
• Minimum 5 years of experience in SQL query optimization and ETL data loading performance.

Minimum high‑school diploma or equivalency (required).

PTR Global is a leading provider of information technology and workforce solutions. With over 5,000 professionals, PTR Global delivers services across the U.S. and Canada. For more information, visit

Pay Range: $68–$72 /hr. W2

The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, the skills, education, training, credentials, and experience of the candidate, and other conditions of employment. Our full‑time consultants have access to benefits, including medical, dental, vision, and 401(k) contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.

• We never ask job applicants to pay any fee, purchase products, or provide sensitive financial information. Any banking details required after an offer will be handled during the official onboarding process.
• If you receive suspicious messages, emails, or phone calls claiming to be from PTR Global, do not respond or click on any links. Contact us directly at +1 214‑740‑2424 or email