Programmer Anst Prin
Falls Church, VA
Pay Range: $67.00-$70.79/hour
Job Description:
Design and implement data pipelines to ingest, extract, transform, load (ETL) data and store large datasets from various sources. Build and maintain data warehouses, including data modeling, data governance, and data quality. Ensure data quality, integrity, and security by implementing data validation, data cleansing, and data governance policies
Key Responsibilities:
- Optimize data systems for performance, scalability, and reliability
- Collaborate with customers to understand their technical requirements and provide guidance on best practices for using Amazon Redshift
- Work with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand data requirements and deliver data solutions
- Provide technical support for Amazon Redshift, including troubleshooting, performance optimization, and data modeling o Identify and resolve data-related issues, including data pipeline failures, data quality issues, and performance bottlenecks
- Develop technical documentation and knowledge base articles to help customers and AWS engineers troubleshoot common issues
Required Qualifications:
- 8 years’ experience in data engineering, with a focus on designing and implementing large scale systems
- 5+ year of hands-on experience in writing complex, highly optimized queries across large data sets using oracle, SQL Server and Redshift.
- 5+ years of hands-on experience using AWS Glue, python/Pyspark to build ETL pipelines in a production setting, incluind writing test cases.
- Strong understanding of database design principles, data modeling and data governance.
- Proficiency in SQL includes query optimization, indexing and performance.
- Experience with data warehousing concepts including start and snowflake schematics.
- Relevant cloud certification (eg AS certified Data analytics.
- Experience with AWS services
- Bachelor’s or master’s degree in computer science or a related field, with at least 6 years of experience in Information Technology
Military experience equivalency may substitute for some requirements.
***For consideration for this opportunity, please email your resume to info@uspro.net and include in your message the job title AND five-digit number that follows the job title***
Equal Opportunity Statement:
USPRO is an equal opportunity employer and will consider all applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, disability and/or other protected categories. We are also committed to providing reasonable accommodation(s) to qualified individuals with disabilities or needs, as required by law.
