Data Warehouse Programmer

$80,000 - $128,000/Yr

Peraton - Scott Air Force Base, IL

Full-time

Scott Air Force Base, IL

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The Data Warehouse Programmer at Peraton will be responsible for designing, developing, and maintaining data pipelines and architectures that support USTRANSCOM operations. This role involves transforming fractured data sources into a consolidated structure to create decision advantages, thereby aiding USTRANSCOM in its mission to project and sustain the Joint Force. The position requires collaboration with data scientists and engineers to optimize data flows and ensure compliance with data governance policies.

Responsibilities

• Provide data engineering expertise to create the data foundation for critical operations support areas such as time-series forecasting, aerial refueling analysis, and transportation demand and capacity planning.
• Apply current best practices to design, maintain, and optimize the data infrastructure of a multi-faceted center of analysis for global transportation.
• Enable data collection, management, transformation, and access via data pipelines that convert raw data into usable formats for data scientists and other data consumers.
• Develop, update, and design data schema and data ontologies to maximize the effectiveness of available tools and analytical products.
• Support organizational transitions between data platforms.
• Optimize data flows from multiple sources into a distributed data storage framework by leveraging efficient, distributed data processing techniques.
• Communicate regularly with data scientists, data engineers, and data consumers to understand current and future analytical efforts and tools.
• Adapt to errors, technology outages, and changing requirements to minimize delays in providing support to USTRANSCOM operations.
• Analyze data and apply data validation rules to minimize data gaps and improve integrity.
• Ensure compliance with all applicable data governance and security policies.
• Provide quality documentation for all work to ensure transparency and operational continuity.
• Maintain an up-to-date knowledge of data technology trends.

Requirements

• Minimum of 5 years experience in data engineering, data warehousing, or a related field with a BS/BA in Computer Science, Engineering, Information Management, Mathematics, or a related field from an accredited college or university; 3 years experience with an MS/MA.
• Knowledge of back-end development and experience with SQL and NoSQL databases.
• Experience with Cloud-based database structures and concepts (Databricks, etc.).
• Proficiency in using data transformation languages such as Python, SQL, and R.
• Strong understanding of data modeling, ETL principles, and data architectures.
• Demonstrated skills in solving problems and responsibility for ensuring customer satisfaction.
• Proven experience effectively prioritizing workload to meet deadlines and work objectives.
• Must enjoy working in a team environment with frequent customer contact and have excellent oral communication and interpersonal skills.
• U.S. citizenship and ability to obtain a Secret clearance (interim clearance required to commence task work).

Nice-to-haves

• Active DoD Secret clearance.
• Experience with USTRANSCOM or Department of Defense military logistics.
• Experience with the Palantir Foundry platform.
• Proficiency in using PySpark.

Benefits

• Paid Time-Off and Holidays
• Retirement
• Life & Disability Insurance
• Career Development
• Tuition Assistance and Student Loan Financing
• Paid Parental Leave
• Medical, Dental, & Vision Care