Technical Data Scientist/ETL Engineer

$160,000 - $180,000/Yr

GovCIO - Lansing, MI

Full-time

Remote - Lansing, MI

About the position

GovCIO is currently seeking a Technical Data Scientist/ETL Engineer to join our ETL Team, which is dedicated to ingesting and visualizing data from various cloud sources while alerting on deviations from normalization. This position is fully remote, allowing for flexibility while contributing to impactful projects. The successful candidate will be responsible for developing, inspecting, mining, transforming, and analyzing data to create descriptive and predictive models that enhance productivity and decision-making, ultimately providing strategic mission impact. In this role, you will apply data wrangling tools, including ETL and ELT processes, along with programming languages to collect and blend data from operational and relevant external systems. You will engage in data analysis by utilizing data mining, machine learning, and statistical analysis techniques to create predictive and descriptive models. These models will be integrated to develop segmentation, clustering, forecasting, classification, and other analytical frameworks. Additionally, you will leverage data visualization tools to interpret and present findings in a compelling and usable manner, ensuring that insights are actionable and beneficial to stakeholders. The position requires close collaboration with both business and data subject matter experts (SMEs) to prioritize business and information needs. You will generate new business insights through the extraction, storage, transformation, analysis, and visualization of diverse data sets. This includes collecting and transforming structured, unstructured, relational, and NoSQL data using ETL and ELT tools, as well as developing custom code using various programming languages. You will also be expected to understand and utilize distributed methods, such as MapReduce, to handle multi-Terabyte data collections effectively. Your analytical skills will be put to the test as you analyze data using data mining, machine learning, and statistical algorithms available in commercial off-the-shelf (COTS) tools, such as SAS, SPSS, and Oracle. You will build analytical solutions using programming languages like R and Python, along with relevant programming libraries. The role also involves interpreting and evaluating the accuracy of results through iterative, agile methods, ensuring that the insights derived are reliable and actionable.

Responsibilities

• Develops, inspects, mines, transforms, and analyzes data to create descriptive and predictive models that impact productivity and decision making.
• Applies data wrangling tools including ETL, ELT, and programming languages to collect and blend data from operational and relevant external systems.
• Applies data mining, machine learning, and statistical analysis on data to create predictive and descriptive models.
• Integrates models to develop segmentation, clustering, forecasting, classification, and other models.
• Applies data discovery and data visualization tools to interpret and present findings in a compelling manner.
• Maintains and integrates analytical systems with operational systems, verifying the accuracy of data and analytics.
• Generates new business insights through data extraction, storage, transformation, analysis, and visualization of diverse data sets.
• Collects and transforms structured, unstructured, relational, and NoSQL data using ETL and ELT tools and develops custom code using programming languages.
• Understands and uses distributed methods that scale to multi-Terabyte sized data collections.
• Analyzes data using data mining, machine learning, and statistical algorithms available in COTS tools and builds analytical solutions using programming languages and libraries.
• Interprets and evaluates accuracy of results through iterative, agile methods.
• Works closely with data SMEs, business, and management to prioritize business and information needs.

Requirements

• HS Diploma with 9+ years of experience/professional.
• Must have or obtain IAT level II/III certification & CE Certificate (i.e., CompTIA Security+(CE)).
• Demonstrated experience or certifications in Linux and/or AWS GovCloud technologies.

Nice-to-haves

• Strong interpersonal skills to collaborate with customers and internal cross-functional teams.
• Experience with virtual and/or cloud-based servers and applications (AWS GovCloud Specific).
• Excellent technical documentation and reporting skills.
• Effective written and oral communication skills.
• Experience working in an Agile environment.
• Certification(s) in relevant technologies.
• Active Top Secret clearance.