Location
North Charleston, SC | United States
Job description
CommIT Enterprises, Inc. is seeking a Data Pipeline Engineer to join the team in Charleston, SC-*can also be remote! The Data Pipeline Engineer will be a critical part of a fast-moving Marine Corps product development team. This team is responsible for the design, development, testing, implementation and support for a wide range of cloud-based data integrations, data pipelines, data warehousing solutions, and delivery of Business Intelligence (BI) services to Marines globally.
Established in 2001, CommIT is a Certified Veteran-Owned Small Business (CVOSB) providing innovative technical engineering and data science services. Our enterprise systems support includes the Department of Defense’s (DoD) GCSS-MC, CAC2S, TBMCS-MC, and the Department of Veteran’s Affairs’ (VA) telehealth communications. We offer acquisition management, systems engineering, Agile software development, cloud management, IT modernization, data analytics, cybersecurity, and training, including leading-edge DevSecOps, automated testing, and mobile application development.
Your essential job functions will include but may not be limited to-
- Identify and deliver data pipeline solutions
- Build data pipeline solutions and processes to enable data warehousing, analytics and reporting for the USMC Logistics community
- Responsible for everything related to existing and future Data Pipelines
- Work with the Product Owner team and data analysts to develop efficient ETL processes using Apache Nifi, and other data pipeline tools
- Build performant data transformations for analysis and reporting
- Utilize modern ETL/ELT practices to move data into our Data Lake (AWS S3) and Warehouse (AWS Redshift)
- Own the design, code development, code reviews, testing, data quality monitoring, deployment activities and operations support for all Nifi data flows
- Work alongside the infrastructure, data ingestion, data warehouse and analytics teams to manage and optimize ETL and data pipeline parameters, scheduling, monitoring and alerting
- Support development of data dictionary, connection guides, operations and user support SLAs
- Basic SQL operations required to Load data into the Data Warehouse (AWS Redshift)
- Proven analytical, troubleshooting, and problem-solving skills
- Ability to communicate well cross-functionally, including non-technical users
- Must have a strong background in building ETL workflows. Apache Nifi is preferred, but other similar tools such as AWS Glue, Talend, DataBricks, etc
- Ability to be self-starting, responsive and collaborative in a remote environment working with a distributed team
- Stay current with the latest design and technology trends and adopt modern techniques as appropriate
- Familiarity with operating in Cloud environments
- Proficiency in one or more database platforms (e.g., MySQL, Oracle, SQL Server)
- Strong understanding of SQL and ability to optimize queries for performance
- Familiarity with database monitoring tools to track performance metrics
- Experience with open-source software
- Experience with AWS GovCloud
- Familiarity with AWS Glue and AWS Redshift
- Familiarity with BI tools, e.g. Microsoft Power BI and AWS QuickSight
- Basic Linux command line experience
- Experience with NNCompass functionality
Required Experience and Education:
- Education: BS Degree in Electrical/ Electronic/ Computer /Software Engineering, Physics, or Computer Science from an accredited College or University
- Experience: Six (6) years of experience in DoD C4ISR systems, or information technologies to include: Systems Analysis, Systems Architecture, Systems/Equipment Support, Test and Evaluation, and Logistics support of C5ISR requirements. Three (3) years of technical experience in support of DoD C4ISR systems, or information technologies. Experience may be achieved simultaneously OR :
Education: Technical training in Computer Science, Information Systems, Engineering, Business, and Supply Chain related scientific or technical discipline or 10 years of Marine Corps experience in Maintenance, Communications, Logistics, or in the Retail Supply (SMU/Reparable Issue Point/RIP) and Organizational Supply field preferably.
Experience: Twelve (12) years of hands-on experience with a USMC supply, maintenance or logistics IT system, GCSS-MC, to include
three (3) of the following five (5) areas: Systems Requirements, Operational Requirements, Data Analysis, Test & Evaluation, and Training. Experience may be achieved simultaneously. Recognized expert who has demonstrated industry and/or public service (e.g., federal, state, or local) leadership in Defense Acquisitions University Level I or II (Life Cycle Logistics or Program Management) and experience with Major Automated Information System (MAIS).
Security Requirements:
- Secret Clearance
- U.S. Citizenship
- DOD 8570 compliant – Security + and OS certification
Equal Opportunity Employer:
CommIT Enterprises, Inc. is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, physical or mental disability, genetic factors, military/veteran status or other characteristics protected by law.
Job tags
Salary
