DMS MRO Data Engineer

About Arcticom, LLC Offering a broad range of information technology solutions, Arcticom, LLC provides network and systems administration, enterprise architecture and resource planning, certification and accreditation, software design, programming, maintenance of telecommunications and land mobile radio equipment and systems, help desk support and IT transformation services among other services. Arcticom offers impressive performance that is routinely recognized with exceptional ratings and commendations tied to installation successes. Satisfied Bering Straits Native Corporation (BSNC) family customers include the U.S. Air Force, Army, Navy, Coast Guard, the Departments of State, Justice, Commerce, Agriculture, Interior, Homeland Security, the General Services Administration, the Defense Logistics Agency and the U.S Census Bureau. About this position: DMS MRO Data Engineer Location - Dayton, OH The Essential Duties and Responsibilities are intended to present a descriptive list of the range of duties performed for this position and are not intended to reflect all duties performed within the job. Other duties may be assigned. To perform this job successfully, an individual must be able to satisfactorily perform each essential duty. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the position. Wage/Salary Range: $125k - 150k Applicants will be notified via phone or email within ten (10) business days of submittal. Essential Duties & Responsibilities • Build and optimize ETL data pipelines using Databricks and Apache Spark • Develop scalable data models leveraging Spark Data Frames and Spark SQL for efficient querying, aggregation, and integration against numerous diverse data sources • Utilize Python and Regular Expressions for advanced text parsing, pattern matching, and data cleansing to prepare structured datasets for downstream ingestion • Use APIs for seamless data exchange and automation across systems • Manage SharePoint data (lists, libraries, files, metadata) programmatically using Python and Microsoft Graph API • Leverage Microsoft 365 tools for documentation and collaboration • Develop and maintain Amazon Web Services (AWS) including S3 • Fully utilize the Microsoft 365 environment for cross-functional data sharing and productivity • Use Jira to track and manage issues, tasks, and project workflows • Collaborate with cross-functional teams and technical stakeholders to define data transformations of legacy systems to modern schemas • Leverage Subject Matter Expert (SME) collaboration to interpret business rules and build business logic into data extracts and transformation processes • Build and maintain strong working relationships with SME's, helping to identify requirements for data transformations based upon iterative product feedback Required (Minimum Necessary) Qualifications Education Requirements: Bachelor's (US accredited Required) Level of Experience Requirements: • Python: 4 years (Preferred) • SQL: 4 years (Preferred) • SharePoint Development: 3 years (Preferred) • Spark: 3 years (Preferred) • AWS: 3 years (Preferred) • S3: 3 years (Preferred) • AI: 2 years (Preferred) • Databricks: 2 years (Required) License/Certification • U.S. federal government security clearance (Preferred) • AWS Certified Solutions Architect (Preferred) • Databricks Certified Data Engineer Professional (Preferred) • Work Location: Hybrid remote in Wright-Patterson AFB, OH 45433 Requirements • Must be a U.S. Citizen • Must be able to obtain and maintain a favorable National Agency Check with Inquiries (NACI) clearance • Must reside within 50 miles of the customer site in Dayton, OH • Must have experience working with the Department of Defense (DoD) or another federal agency Knowledge, Skills, Abilities, and Other Characteristics • Bachelor's degree in computer science, engineering, or a related field from an accredited United States university • Technical skills, hands-on experience, and proficiency with: • Databricks, Apache Spark, and cloud-based data engineering and modeling • SQL for querying and managing relational data • AWS cloud services, including S3 • Python for data analysis, cleansing, and visualization • SharePoint lists, document libraries, and Microsoft Graph • Microsoft 365 apps and integration workflows • Developing and consuming APIs for data exchange between different systems • Jira or other agile workflow management systems for issue and project tracking • Artificial Intelligence (AI) proficiency to incorporate into daily activities and workflows • Proven ability to build trust and maintain strong partnerships with customers and stakeholders • Takes initiative and drives projects forward with minimal supervision, anticipating challenges before they arise • Meticulous in managing complex tasks and deadlines, ensuring accuracy and consistency across deliverables • Thrives in cross-functional environments, fostering open communication and teamwork across diverse groups • Rapidly assimilates new technologies and processes, adapting to evolving requirements in dynamic settings • Ability to work collaboratively with a diverse team of contractors and government personnel • Ability to work collaboratively with a diverse team of contractors, government personnel, and stakeholders from multiple organizations • Skilled in building strong customer relationships and engaging with SMEs to derive business logic for data transformation methods and rules Preferred • Certifications such as AWS Certified Solutions Architect or Databricks Certified Data Engineer • AI aware • Familiarity with Air Force-specific systems or DoD compliance frameworks • Live within 50 commutable miles of Dayton, OH Supervisory Responsibilities • This position will not have supervisory responsibilities. DOT Covered/Safety-Sensitive Role Requirements • This position is not subject to federal requirements regarding Department of Transportation "safety-sensitive" functions. Necessary Physical Requirements The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this role. Employees must always maintain a constant state of mental alertness. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Work Environment The work environmental characteristics described here are representative of those that must be borne by an employee to successfully perform the essential functions of the role. Employees must always maintain a constant state of situational awareness. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Additional Qualifying Factors As a condition of employment, you will be required to pass a pre-employment drug screening and have acceptable background check results. If applicable to the contract, you must also obtain and maintain the appropriate clearance levels required and must also be able to obtain access to military installations. Will be requested for verification purposes Shareholder Preference BSNC gives hiring, promotion, training, and retention preference to BSNC shareholders, shareholder descendants and shareholder spouses who meet the minimum qualifications for the job. Bering Straits Native Corporation is an equal opportunity employer. All applicants will receive consideration for employment without regard to any status protected by state or federal law, or any other basis prohibited by law.