Senior Developer Sas - Data Validation
We are a growing information technology company that offers its employees a culture of success, the chance to work on revolutionary federal IT infrastructure, and the opportunity to grow alongside cutting-edge technology that is reshaping the industry. We are seeking forward thinking candidates that have strong experience in operational support and can help take to the next level in a pro-active stance.
Chameleon Integrated Services has expertise in operations management, quality systems, data operations and cybersecurity. We secure some of the most sensitive data for the Department of Defense and for other U. S. federal government agencies. We are known for the great care we take with clients and employees, and we believe in promoting from within.
We offer a Full Benefits package including:
- Competitive Employee Health Insurance options including dental
- 100% company paid vision plan
- 401K plan with generous company match and no vesting period
- 100% company paid Life insurance
- 100% company paid long and short-term disability insurance
- Training allowance
- PTO and more
- must explicitly reflect 7+ years of total data engineering or data analysis experience with verified history executing complex database routines.
- Clear and extensive recent experience coding with SAS programming languages, SAS DATA step processing, and specialized PROC SQL scripting.
- Must accept a flexible production posture capable of supporting a seven-day-per-week operational reporting environment, including staggered schedules, holiday coverage, or weekend windows.
- Perform daily data validation scripts to guarantee data quality and structural integrity across multiple federal reporting channels.
- Execute meticulous row count and record-count reconciliation routines to pinpoint structural anomalies or missing data segments.
- Lead data profiling and field validation efforts to track variable distributions and identify unexpected categorical values.
- Ensure strict compliance with data handling mandates by confirming that personal privacy and PII variables are hidden during active profiling.
- Review and cross-check materialized view tables to eliminate data discrepancy and maintain perfect consistency across distinct reporting assets.
- Conduct automated source-to-target reconciliation protocols to map administrative statistics cleanly into target databases.
- Create repeatable validation routines, compile error exception logs, and carefully document validation results to ensure complete audit readiness.
- Expert level SAS programming architecture including SAS DATA step structures and advanced SAS macro configuration.
- Complete mastery of relational database languages utilizing advanced PROC SQL and equivalent SQL methodologies.
- Functional familiarity operating within enterprise database environments such as Oracle, SQL Server, or PostgreSQL architectures.
- Practical familiarity analyzing large federal administrative datasets using BI tool visualizations or Tableau embedding patterns.
- Comprehensive mastery handling highly restricted datasets while safeguarding PII and SPII under federal privacy definitions.
- Direct experience operating within federal statistical program standards, data governance boundaries, and secure infrastructure environments.
- Knowledge of federal reporting deliverables including automated reconciliation flows and rigorous quality control checking policies.
- Direct experience writing automated exception reporting layers for large scale federal law enforcement or administrative statistics programs.
- Prior domain background navigating large data pipelines managed by DHS, CBP, ICE, USCIS, Census, DOJ, or HHS.
- Deep technical familiarity parsing complex immigration trends, border security workflows, or localized healthcare and benefit dataset arrays.
Requires 7+ years of data analysis or engineering experience, extensive SAS programming, SAS DATA step and PROC SQL expertise, database experience, U.S. citizenship, and ability to meet DHS suitability requirements.
Key Responsibilities
- validating data
- reconciling records
- profiling variables
Skills & Tools
SAS, SAS DATA step, PROC SQL, SQL, Oracle, SQL Server, PostgreSQL, Tableau
Job Details
- Category: Data and Analytics
- Seniority: Senior Level
- Commitment: Contract
- Workplace: Remote — St. Louis, Missouri, United States
- Languages: English
Benefits
- 401k matching
- Generous paid time off
- Retirement plan
About Chameleon Integrated Services
An information technology company providing operations management, data operations, quality systems, and cybersecurity services to federal agencies. — Industry: Information Technology