
1 - 10 employees
Founded 2023
💼 Consulting
🎖️ Defense
🔒 Cybersecurity
Consulting • Defense • Cybersecurity
Air InfoSec is a cybersecurity firm that secures critical IT and cloud systems and provides elite cleared cybersecurity talent. It delivers end-to-end services including infrastructure and cloud security, penetration testing and red team operations, incident response and digital forensics, threat hunting, and governance, risk & compliance consulting. Air InfoSec also offers recruiting, staffing, and talent-sourcing for cleared and certified professionals to support permanent, contract, and project-based cybersecurity needs, emphasizing disciplined, military-background teams for government and enterprise clients.
🔥 0 minutes ago
Where this job comes from
Posted on Air InfoSec's careers page, not through a job board
First seen by Remote Rocketship 0 minutes ago
Improve your chances of getting an interview by checking your resume score before you apply.

1 - 10 employees
Founded 2023
💼 Consulting
🎖️ Defense
🔒 Cybersecurity
Consulting • Defense • Cybersecurity
Air InfoSec is a cybersecurity firm that secures critical IT and cloud systems and provides elite cleared cybersecurity talent. It delivers end-to-end services including infrastructure and cloud security, penetration testing and red team operations, incident response and digital forensics, threat hunting, and governance, risk & compliance consulting. Air InfoSec also offers recruiting, staffing, and talent-sourcing for cleared and certified professionals to support permanent, contract, and project-based cybersecurity needs, emphasizing disciplined, military-background teams for government and enterprise clients.
• Participate in detailed sessions with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns • Develop reverse-engineering documentation for existing data extracts to support business reporting and extract needs • Design and implement ETL/ELT pipelines that move data into Snowflake using approved tools and frameworks • Translate business requirements into functional and technical specifications for future self-service analytics • Collaborate with data engineers and architects on data modeling, schema design, and transformation logic in Snowflake • Develop new database schemas that meet business and technical requirements • Validate data quality and reconcile source-to-target results across Mainframe, Lonestar, Open Systems, and Snowflake environments • Develop data conversion and system implementation plans and obtain approval of system and programming documentation • Support creation of Power BI datasets, semantic models, and dashboards using Snowflake as the primary data source • Troubleshoot data issues across the pipeline from Lonestar or Open Systems extract through Snowflake load to Power BI visualization • Document technical processes, data flows, and system dependencies • Participate in code reviews, testing cycles, and production support activities • Provide technical advice, assistance, and recommendations on report development
• 8 years of hands-on experience with Snowflake, including SQL, data loading, transformations, and performance tuning • 4 years of experience with ETL/ELT concepts, data pipelines, and data integration patterns • 5 years of experience analyzing complex data flows and troubleshooting issues across multiple systems • 4 years of experience with enterprise information management processes and methodologies, relational database management systems, and metadata management • 2 years of experience working in fast-paced, changing environments, achieving project delivery and deadlines, analyzing complex information, and developing plans to address identified issues • 2 years of experience applying interpersonal skills, including working with people under pressure, negotiating among multiple parties, resolving conflicts, and maintaining effective working relationships with personnel at various levels • Former Railroad Commission of Texas experience or an oil and gas industry background is strongly preferred • 3 years of experience with Informatica, Matillion, Azure Data Factory, or similar data integration tools is preferred • Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field is preferred • Candidates must be authorized to work in the U.S. • May be required to work outside normal business hours, including weekends, evenings, and holidays
• Remote work from home • Monday through Friday, 8:00 AM to 5:00 PM schedule • Excludes State holidays
Apply Now🕒 4 days ago
Senior SAP data architect defining S/4HANA, Datasphere, AWS, and enterprise data architecture. Designing coexistence and master-data strategy for a California client.
🕒 4 days ago
Senior Data Engineer building GenAI document-processing pipelines and RAG systems on AWS. Developing AI agents, vector databases, and CI/CD workflows for consulting clients.
🕒 5 days ago
Senior Data Engineer building AWS GenAI document-processing and RAG pipelines. Developing Bedrock AI agents, vector search, and scalable data workflows for enterprise documents.
🕒 October 13
Senior Data Engineer building Databricks lakehouse pipelines and datasets. Supporting Tableau, machine learning, and analytics across finance, sales, supply chain, and marketing.
🕒 September 30
Data Engineer building DataMiner pipelines, monitoring, and Power BI dashboards for Sand Cherry Associates’ network-performance clients. Translating telemetry into operational and executive insights.