Ohio Staffing
Data Engineer Ii
Arcticom, a company within the BSNC family, is currently seeking a qualified Data Engineer II for a remote role. The Data Engineer II will need experience working in a DoD data environment and knowledge of Air Force data sources. They will need a strong understanding of data wrangling and cleaning, including skills in preparing and structuring raw data for enriching and transformation. The right hire will be performing transformation tasks such as converting data types, standardizing formats, normalization, aggregations, storage and retrieval, removing duplicates, fixing typos, and handling missing values. They will need to perform data mining, not data analytics. Applicants will be contacted via phone or email within ten business days of submittal. Essential Duties and Responsibilities: 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 recommendations for resolution. Qualifications - Experience, Education and Certification: 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 S3 storage and migration Clusters iQuery SQL Editor API implementation Nice to have: SharePoint development knowledge Lists and Libraries REST APIs Power Automate Microsoft 365 ecosystem Jira Knowledge
Arcticom, a company within the BSNC family, is currently seeking a qualified Data Engineer II for a remote role. The Data Engineer II will need experience working in a DoD data environment and knowledge of Air Force data sources. They will need a strong understanding of data wrangling and cleaning, including skills in preparing and structuring raw data for enriching and transformation. The right hire will be performing transformation tasks such as converting data types, standardizing formats, normalization, aggregations, storage and retrieval, removing duplicates, fixing typos, and handling missing values. They will need to perform data mining, not data analytics. Applicants will be contacted via phone or email within ten business days of submittal. Essential Duties and Responsibilities: 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 recommendations for resolution. Qualifications - Experience, Education and Certification: 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 S3 storage and migration Clusters iQuery SQL Editor API implementation Nice to have: SharePoint development knowledge Lists and Libraries REST APIs Power Automate Microsoft 365 ecosystem Jira Knowledge