Data Engineer II

SUMMARY Arcticom, a company within the BSNC family, is currently seeking a qualified Data Engineer II for Remote role. Data Engineer II will need experience of working in a DoD data environment and knowledge of Air Force data sources. Will need a strong understanding of Data Wrangling and Cleaning - Skills in preparing and structuring raw data for enriching and transformation. The right hire will be performing transformation tasks examples : converting data types, standardizing formats, normalization, aggregations, storage and retrieval, removing duplicates, fixing typos, handling missing values, etc. They will need to perform data mining NOT data analytics : Data analytics is the process of interpreting data to find trends and patterns through BI tools. On the other hand, data mining is the exploratory process of extracting valuable hidden information from a large dataset. Applicants will be contacted via phone or email within ten (10) business days of submittal. ESSENTIAL DUTIES & RESPONSIBILITIES 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. Transforms data into a format that can be easily analyzed by functional users and managers, analyzes data requirements. Interfaces with users to extract functional needs and determine requirements. Consults with customers to identify and specify requirements; develops overall functions and systems requirements and specifications. Extracts data from multiple information systems, transforms into Excel tables for review and validation by data consumers at various locations; performs data extraction, data validation, data cleansing, and data verification. Develops Structured Query Language (SQL) queries to query or retrieve data from multiple databases and to performing various operations on the data such as filtering rows and columns as well as simple data manipulation, Documents Extract, Transform, and Load (ETL) methodology and maintains a consistent and repeatable approach. Performs research to resolve problems or errors within the data and makes recommendation for resolution. QUALIFICATIONS - EXPERIENCE, EDUCATION AND CERTIFICATION 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 accommodations may be made to enable individuals with disabilities to perform the essential functions. Required (Minimum Necessary) Qualifications

• Ten years experience.
• Bachelor’s degree in Computer Science, Information Systems, Business, or related discipline.
• Skilled at prioritization and multi-tasking
• 7-10 years experience with these specific Languages / Technologies :
• Spark
• Python
• SQL
• Databricks
• Cloud environment knowledge oS3 storage and migration oClusters
• iQuery SQL Editor
• API implementation Nice to have :
• SharePoint development knowledge oLists and Libraries oREST APIs oPower Automate oMicrosoft 365 ecosystem
• Jira Knowledge, Skills, Abilities, and Other Characteristics
• Experience of working in a DoD data environment and knowledge of Air Force data sources.
• Data Wrangling and Cleaning - Skills in preparing and structuring raw data for enriching and transformation.
• Transformation tasks examples : converting data types, standardizing formats, normalization, aggregations, storage and retrieval, removing duplicates, fixing typos, handling missing values, etc.
• Data Mining NOT Data Analytics : Data analytics is the process of interpreting data to find trends and patterns through BI tools. On the other hand, data mining is the exploratory process of extracting valuable hidden information from a large dataset.
• Team player.
• Attentive to detail.
• Ability to organize and execute multiple priorities and deadlines.
• Ability to identify and communicate potential problems and opportunities.
• Ability to identify, evaluate, and advocate for alternative paths and solutions.
• Ability to speak, write, and communicate effectively with clients, partners, teammates, and other stakeholders at various levels. 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 job. Employee must maintain a constant state of mental alertness at all times. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Essential and marginal functions may require maintaining physical condition necessary for bending, stooping, sitting, walking or standing for prolonged periods of time; most of time is spent sitting in a comfortable position with frequent opportunity to move about. DOT COVERED / SAFETY-SENSITIVE ROLE REQUIREMENTS
• This position is not subject to federal requirements regarding Department of Transportation “safety-sensitive” functions. WORK ENVIRONMENT Work Environment characteristics described here are representative of those that must be borne by an employee to successfully perform the essential functions of this job. The job is performed in an office setting with exposure to computer screens and requires extensive use of a computer, keyboard, mouse, and multi-line telephone system. The work described herein is primarily in a modern office setting. Occasional travel may be required. SUPERVISORY RESPONSIBILITIES
• No supervisory responsibilities. 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 the appropriate clearance levels required and 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.