Job Description
Position Overview
SteerBridge Strategies is seeking a highly skilled Data Analyst to support mission-critical operations in a secure, controlled data environment. This role focuses on advanced data analysis, automation, and reporting to drive informed decision-making at leadership levels. The ideal candidate will have strong SQL expertise, experience working with large datasets, and the ability to translate complex data into actionable insights.
Key Responsibilities
- Data Analysis & Insights
- Analyze large, relational datasets to identify trends, inefficiencies, and performance gaps
- Translate raw data into actionable insights to support leadership decision-making
- Identify degraders, shortages, and operational inefficiencies
- SQL Development
- Write clean, efficient, and production-ready SQL (Amazon Redshift, Oracle SQL Developer)
- Utilize advanced SQL techniques (CTEs, window functions, complex joins, aggregations)
- Optimize queries for performance and scalability
- Troubleshoot and resolve data discrepancies across multiple data sources
- Data Quality & Validation
- Implement automated validation checks (row counts, duplicates, completeness, integrity)
- Ensure accuracy and consistency of data before reporting
- Identify and resolve root causes of data inconsistencies
- Automation & ETL Processes
- Support and maintain ETL pipelines and data workflows
- Build automated processes for data ingestion, transformation, and validation
- Implement scheduling/orchestration tools (cron, AWS services, Airflow, or equivalent)
- Ensure processes run without manual intervention
- Scripting & Process Automation
- Develop scripts using Python, Bash, or PowerShell
- Automate data pulls, file processing, and pipeline validation
- Integrate scripts into end-to-end workflows
- Reporting & Dashboards
- Develop and maintain automated reports and dashboards
- Support daily, weekly, and monthly reporting requirements
- Ensure reports are accurate, consistent, and delivered on schedule
Required Qualifications
Education & Experience
- U.S. Citizenship required with the ability to obtain a Secret Clearance
- Bachelor’s degree in a technical field (Data Analytics, Information Technology, Computer Science, or related)
- Minimum 3+ years of professional experience in data analysis or a related field
- Strong experience working in sensitive or controlled data environments
- Advanced SQL proficiency (Amazon Redshift, Oracle preferred)
- Experience with large, relational datasets and data structures
- Strong understanding of joins, aggregations, and query optimization
- Experience troubleshooting data discrepancies and ensuring data integrity
- Familiarity with ETL processes and data pipelines
- Experience building recurring reports and dashboards
- Strong attention to detail and data validation skills
Interpersonal & Professional Skills
- Strong communication skills with the ability to translate technical concepts for non-technical and operational stakeholders.
- Ability to develop relationships with collaborators, program providers, community partners, and military personnel.
- Able to successfully prioritize and manage multiple critical projects simultaneously with a high degree of accuracy.
- Experience working on applied data projects involving diverse organizations to collect, analyze, and interpret data.
Preferred Qualifications
- 3–6 years of post-college professional experience
- Experience with predictive analytics or modeling
- Proficiency in Python or R for data analysis
- Experience with automation tools and scheduling frameworks
- Experience supporting executive-level decision-making
Core Competencies
|
Analytical Thinking |
Collaboration & Teamwork |
Attention to Data Quality |
|
Problem Solving |
Ownership & Accountability |
Continuous Learning |
Position Overview
SteerBridge Strategies is seeking a highly skilled Data Analyst to support mission-critical operations in a secure, controlled data environment. This role focuses on advanced data analysis, automation, and reporting to drive informed decision-making at leadership levels. The ideal candidate will have strong SQL expertise, experience working with large datasets, and the ability to translate complex data into actionable insights.
Key Responsibilities
- Data Analysis & Insights
- Analyze large, relational datasets to identify trends, inefficiencies, and performance gaps
- Translate raw data into actionable insights to support leadership decision-making
- Identify degraders, shortages, and operational inefficiencies
- SQL Development
- Write clean, efficient, and production-ready SQL (Amazon Redshift, Oracle SQL Developer)
- Utilize advanced SQL techniques (CTEs, window functions, complex joins, aggregations)
- Optimize queries for performance and scalability
- Troubleshoot and resolve data discrepancies across multiple data sources
- Data Quality & Validation
- Implement automated validation checks (row counts, duplicates, completeness, integrity)
- Ensure accuracy and consistency of data before reporting
- Identify and resolve root causes of data inconsistencies
- Automation & ETL Processes
- Support and maintain ETL pipelines and data workflows
- Build automated processes for data ingestion, transformation, and validation
- Implement scheduling/orchestration tools (cron, AWS services, Airflow, or equivalent)
- Ensure processes run without manual intervention
- Scripting & Process Automation
- Develop scripts using Python, Bash, or PowerShell
- Automate data pulls, file processing, and pipeline validation
- Integrate scripts into end-to-end workflows
- Reporting & Dashboards
- Develop and maintain automated reports and dashboards
- Support daily, weekly, and monthly reporting requirements
- Ensure reports are accurate, consistent, and delivered on schedule
Required Qualifications
Education & Experience
- U.S. Citizenship required with the ability to obtain a Secret Clearance
- Bachelor’s degree in a technical field (Data Analytics, Information Technology, Computer Science, or related)
- Minimum 3+ years of professional experience in data analysis or a related field
- Strong experience working in sensitive or controlled data environments
- Advanced SQL proficiency (Amazon Redshift, Oracle preferred)
- Experience with large, relational datasets and data structures
- Strong understanding of joins, aggregations, and query optimization
- Experience troubleshooting data discrepancies and ensuring data integrity
- Familiarity with ETL processes and data pipelines
- Experience building recurring reports and dashboards
- Strong attention to detail and data validation skills
Interpersonal & Professional Skills
- Strong communication skills with the ability to translate technical concepts for non-technical and operational stakeholders.
- Ability to develop relationships with collaborators, program providers, community partners, and military personnel.
- Able to successfully prioritize and manage multiple critical projects simultaneously with a high degree of accuracy.
- Experience working on applied data projects involving diverse organizations to collect, analyze, and interpret data.
Preferred Qualifications
- 3–6 years of post-college professional experience
- Experience with predictive analytics or modeling
- Proficiency in Python or R for data analysis
- Experience with automation tools and scheduling frameworks
- Experience supporting executive-level decision-making
Core Competencies
|
Analytical Thinking |
Collaboration & Teamwork |
Attention to Data Quality |
|
Problem Solving |
Ownership & Accountability |
Continuous Learning |
