MRO Data Engineer

Bering Straits Native Corporation; Dayton (OH); On-site; USD 135,000 - 155,000; Full time

Job summary

Arcticom, LLC is seeking a Data Engineer in Dayton, OH to design and optimize ETL pipelines using Databricks and Spark. You will build scalable data models, perform data cleansing with Python, and enable cross-system data exchange via APIs and Microsoft Graph.

You will work closely with SMEs and stakeholders to transform legacy data into modern schemas, leveraging AWS services and SharePoint for data management and collaboration.

Qualifications

• Education: Bachelor's degree in computer science, engineering, or related field from a US university.
• Experience: U.S. Citizen; ability to obtain favorable NACI clearance; near Dayton within 50 miles; DoD or federal agency experience preferred.

Responsibilities

• Build and optimize ETL data pipelines using Databricks and Apache Spark.
• Develop scalable data models using Spark DataFrames and Spark SQL for diverse data sources.
• Use Python and regex for data cleansing and parsing to produce structured datasets.
• Use APIs for data exchange across systems.
• Programmatically manage SharePoint data via Python and Microsoft Graph API.
• Leverage Microsoft 365 tools for documentation and collaboration.
• Develop and maintain AWS infrastructure including S3.
• Collaborate with cross-functional teams to transform legacy data to modern schemas.
• Engage with SMEs to define business rules for data transformation.

Skills

Databricks

Apache Spark

SQL

Python

SharePoint

Microsoft Graph

Microsoft 365

APIs

Jira

AI

Data transformations

SME collaboration

Education

Bachelor’s degree in computer science, engineering, or related field

Tools

Databricks

Spark

AWS

S3

SharePoint Development

Microsoft Graph

Job description

Requisition Number: MRODA006245

• Full-Time
• Hybrid

Locations

Showing 1 location

Dayton, OH
Dayton, OH, USA

• Pay or shift range: $135,000 USD to $155,000 USD The estimated range is the budgeted amount for this position. Final offers are based on various factors, including skill set, experience, location, qualifications and other job-related reasons.

Description

About Arcticom, LLC

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.

About this position: 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: $135k - $155k

Applicants will be notified via phone or email within ten (10) business days of submittal.

• 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 degree in computer science, engineering, or a related field from an accredited United States university
• Level of Experience 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

• 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
• 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
• Relationship Management and Teamwork
• 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
• Experience
• 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
• S. federal government security clearance (Preferred)
• AWS Certified Solutions Architect (Preferred)
• Databricks Certified Data Engineer Professional (Preferred)

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.

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.

Work Location: Hybrid remote in Wright-Patterson AFB, OH 45433

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.

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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.