Data Analyst

Position overview

Key responsibilities

• Analyze large relational datasets for trends, performance gaps, shortages, degraders, and operational inefficiencies.
• Write and optimize production SQL using Redshift and Oracle SQL Developer, including CTEs, window functions, complex joins, and aggregations.
• Investigate discrepancies and implement data validation checks for accuracy, completeness, consistency, and integrity.
• Support ETL pipelines and automated data ingestion, transformation, and validation workflows.
• Build scheduled and orchestrated processes with cron, AWS services, Airflow, or equivalent tools.
• Automate data pulls, file processing, and pipeline validation using Python, Bash, or PowerShell.
• Maintain automated reports and dashboards and deliver daily, weekly, and monthly reporting on schedule.

Required qualifications

• U.S. citizenship is required under applicable federal contract requirements; candidates must be able to obtain and maintain the required security clearance.
• Bachelor's degree in Data Analytics, Information Technology, Computer Science, or a related technical field.
• At least 3 years of professional experience in data analysis or a related field.
• Strong experience with large relational datasets, including in sensitive or controlled environments.
• Advanced SQL proficiency, including joins, aggregations, and query optimization; Redshift and Oracle experience preferred.
• Experience troubleshooting discrepancies, validating data, and maintaining data accuracy and integrity.
• Familiarity with ETL, pipelines, and automated data workflows.
• Experience maintaining recurring reports and dashboards, with attention to data quality.

Preferred qualifications

• Three to six years of post-college professional experience.
• Predictive analytics or modeling experience.
• Python or R proficiency for data analysis.
• Experience with automation tools, scheduling frameworks, or executive-level decision support.

Compensation

• Posted compensation range is USD 81,000–95,000 per year; final offer depends on relevant experience, skills, education, certifications, work location, responsibilities, and applicable contract requirements.

Benefits

• Benefits may include health and life insurance, paid time off, paid holidays, disability coverage, retirement savings, and professional development; eligibility and benefits vary by position.

About SteerBridge