- Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Data Warehousing Programmer.
Urgent! Data Warehousing Programmer Job Opening In USA, USA – Now Hiring Zolon Tech
To acquire the advantage, Zolon Tech is seeking a Data Warehousing Programmer.
Roles and Responsibilities:
Spearheaded migration of WHD legacy data from DB2 and Oracle into Snowflake using AWS DMS, designing scalable and secure ETL pipelines for the DOL's Data Analytics Capability (DAC) platform.
Built and maintained staging areas, data marts, and secure cloud data lakes using Amazon S3, implementing automated data transfer scripts and orchestration frameworks.
Designed and optimized Snowflake data models, partitioning strategies, Streams, Tasks, and Snowpipes for near-real-time data ingestion and automated batch workflows.
Administered cloud-based Snowflake environments, ensuring high availability, performance tuning, schema evolution, query optimization, and capacity planning.
Supported transition and modernization efforts in compliance with WHD's PWS deliverables, including system documentation, testing, deployment, and operational continuity.
Participated in requirements gathering with WHD and OCIO stakeholders, contributing to architectural planning, documentation, and cloud readiness assessments.
Developed low-level design specifications and collaborated on solution prototypes to validate architecture decisions and support Agile release trains.
Integrated event-driven architectures using AWS Lambda and EventBridge for ETL automation, leveraging SNS/SES for notifications and error handling workflows.
Ensured adherence to federal cybersecurity and privacy compliance frameworks, including data encryption, access control, and secure development practices in line with NIST 800-53.
Facilitated knowledge transfer, created SOPs and support documentation, and participated in Go-Live readiness and post-deployment stabilization for WHD data platforms.
Designed and managed Snowflake Tasks, Streams, Stored Procedures, Views, and Materialized Views to support orchestrated near-real-time data processing workflows.
Automated ETL/ELT pipelines using Snowflake Stored Procedures in JavaScript and SQL, and monitored pipeline performance and stability across environments.
Integrated AWS S3 with Snowflake using external stages and Snowpipe to enable continuous and secure data ingestion.
Led JAD/RAD sessions to gather business requirements and translated them into actionable data warehouse deliverables and technical documentation.
Analyzed complex business needs and provided end-to-end support from design through post-deployment stabilization.
Qualifications:
14+ years of experience in enterprise data warehousing, integration, and administration, including 7+ years of onsite experience in the
Extensive hands-on experience with cloud-based data warehousing using Snowflake and AWS (S3, EC2, Lambda, DMS).
Proven expertise in data migration from legacy systems (DB2, Oracle) to cloud platforms aligned with federal modernization initiatives.
Strong understanding of ETL/CDC frameworks, metadata management, schema design, and workload optimization in Snowflake.
Familiarity with federal IT compliance and governance, including FISMA, NIST 800-53, and HSPD-12 standards.
Demonstrated success in leading Agile and Waterfall-based SDLC environments, collaborating with multi-disciplinary teams.
Experienced in performance tuning, query optimization, capacity planning, and system monitoring in cloud and hybrid architectures.
Performed data profiling, mapping, and transformation for raw data ingestion and business-facing data marts to support cross-domain analytics.
Developed validation queries and automated checks to address data quality issues, improving data trust and governance adherence.
Supported data discovery, lineage tracing, and documentation efforts to enhance data transparency and usability across WHD platforms.
Experienced in end-to-end data warehousing practices, including requirement analysis, data modeling, development, and support.
Strong analytical skills and a track record of resolving complex data quality and integration issues.
Knowledgeable in data governance, metadata management, and cost optimization in Snowflake environments.
Hands-on experience with relational databases like SQL Server and Oracle.
Skilled in data lineage, cataloging tools, and Snowflake monitoring techniques.
Familiar with version control systems (, Git) and CI/CD pipelines for data engineering.
Location: Remote
Clearance: Ability to obtain Public Trust
✨ Smart • Intelligent • Private • Secure
Practice for Any Interview Q&A (AI Enabled)
Predict interview Q&A (AI Supported)
Mock interview trainer (AI Supported)
Ace behavioral interviews (AI Powered)
Record interview questions (Confidential)
Master your interviews
Track your answers (Confidential)
Schedule your applications (Confidential)
Create perfect cover letters (AI Supported)
Analyze your resume (NLP Supported)
ATS compatibility check (AI Supported)
Optimize your applications (AI Supported)
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
European Union Recommended
Institution Recommended
Institution Recommended
Researcher Recommended
IT Savvy Recommended
Trades Recommended
O*NET Supported
Artist Recommended
Researchers Recommended
Create your account
Access your account
Create your professional profile
Preview your profile
Your saved opportunities
Reviews you've given
Companies you follow
Discover employers
O*NET Supported
Common questions answered
Help for job seekers
How matching works
Customized job suggestions
Fast application process
Manage alert settings
Understanding alerts
How we match resumes
Professional branding guide
Increase your visibility
Get verified status
Learn about our AI
How ATS ranks you
AI-powered matching
Join thousands of professionals who've advanced their careers with our platform
Unlock Your Data Warehousing Potential: Insight & Career Growth Guide
Real-time Data Warehousing Jobs Trends in United States, United States (Graphical Representation)
Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Data Warehousing in United States, United States using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 70869 jobs in United States and 683 jobs in United States. This comprehensive analysis highlights market share and opportunities for professionals in Data Warehousing roles. These dynamic trends provide a better understanding of the job market landscape in these regions.
Great news! Zolon Tech is currently hiring and seeking a Data Warehousing Programmer to join their team. Feel free to download the job details.
Wait no longer! Are you also interested in exploring similar jobs? Search now: Data Warehousing Programmer Jobs United States.
An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Zolon Tech adheres to the cultural norms as outlined by Expertini.
The fundamental ethical values are:The average salary range for a Data Warehousing Programmer Jobs United States varies, but the pay scale is rated "Standard" in United States. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.
Key qualifications for Data Warehousing Programmer typically include Computer Occupations and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.
To improve your chances of getting hired for Data Warehousing Programmer, consider enhancing your skills. Check your CV/Résumé Score with our free Resume Scoring Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.
Here are some tips to help you prepare for and ace your job interview:
Before the Interview:To prepare for your Data Warehousing Programmer interview at Zolon Tech, research the company, understand the job requirements, and practice common interview questions.
Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Zolon Tech's products or services and be prepared to discuss how you can contribute to their success.
By following these tips, you can increase your chances of making a positive impression and landing the job!
Setting up job alerts for Data Warehousing Programmer is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!