Active Security Clearance with appropriate Polygraph
Experience with big data processing technologies like Spark, Pyspark, and Python
Proficient in data mapping, extraction, transformation, and loading (ETL)
Skilled in building analytic reports using tools like CloudWatch and Kibana
Experience processing OS and Data Logs into reports and dashboards
Familiarity with SQL, MySQL, and PostgresSQL
Knowledge of data file types such as XML and JSON
Responsibilities
Support new system capabilities and enhancements in cloud computing environments
Maintain and extend bulk data pipelines for multiple applications
Develop and document ETL processes, including source-target mapping
Interface with customers to clarify objectives and requirements
Contribute to Agile development processes by defining tasks and scope
Perform data quality analysis and extensive data reviews
Create analytic reports and metrics dashboards from processed data
Benefits
Employer contributions to health care plan (medical, dental, vision)
Generous retirement plan with matching program
Life insurance options (basic, voluntary, AD&D)
Paid time off for vacation, sick leave, and public holidays
Short-term and long-term disability coverage
Opportunities for training and development
Employee assistance program
Full Job Description
As a Data Scientist at Avalore, you will support the requirements for new system capabilities, the extension and maintenance of bulk data pipeline and enhancements for multiple applications in the customers' cloud computing environment.
Requirements
Active Security Clearance with appropriate Polygraph
Demonstrated experience utilizing big data processing tech such as Spark, Pyspark, and Python.
Demonstrated experience data mapping, extraction, transformation and loading.
Demonstrated experience building analytic reports in tools such as CloudWatch and Kibana.
Demonstrated experience processing and converting of OS and Data Logs into reports and metrics Dashboards.
Demonstrated experience with Regular Expressions (RegEx).
Demonstrated experience with SQL, MySQL, PostgresSQL.
Demonstrated experience with Data file type processing XML, JSON.
Demonstrated experience with IDEs and Data Modeling through Notebooks and Visual Studio.
Demonstrated experience ETL'ing data from disparate structured & unstructured data formats into enriched, query-friendly structured data in indexed files.
Demonstrated experience performing extensive data review and data quality analysis.
Demonstrated experience developing ETL design documentation including source and target mapping and data dictionary information.
Demonstrated experience interfacing with customers and integration partners for gaining and clarifying detailed objectives.
Demonstrated experience supporting Agile development by contributing to tasking definition, scope and review.
Desired:
Demonstrated experience deploying capabilities on the Databricks unified analytics platform.
Demonstrated experience with Elastic Map Reduce to run big data workloads.
Demonstrated experience in joining multiple complex data sets using Spark.
Demonstrated experience in tuning Spark streaming and batch jobs for cluster utilization and speed.
Demonstrated experience in deploying complex, notebook-based pipelines.
Demonstrated experience in Python data analysis libraries such as Pandas.
Demonstrated experience utilizing Cloud services such as Lambda, SNS/SQS, or EC2.
Demonstrated experience with DevOps tools to include Cloudwatch, Lambda, SQS, Dynamo and RDS.
Demonstrated experience working with Elastic, ElasticSearch/Logstash/Kibana (ELK stack).
Work Environment:
Moderate noise (i.e. business office with computers, phone and printers) and /or occasional Loud noise (airfield, large equipment).
Ability to sit at a computer terminal for an extended period of time.
Physical Demands:
While performing the responsibilities of the job, the employee is required to sit, stand, talk, and hear.
Employee is often required to sit and use their hands and fingers to operate a computer.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Travel:
Up to 10%/ Occasional travel.
Benefits
Eligibility requirements apply.
Employer Contributions to Health Care Plan (Medical, Dental & Vision)
Retirement Plan (401k, IRA) with a generous matching program
Life Insurance (Basic, Voluntary & AD&D)
Paid Time Off (Vacation, Sick & Public Holidays)
Short Term & Long Term Disability
Training & Development
Employee Assistance Program
Salary at Avalore is determined by various factors, including but not limited to location, the individual's particular combinaition of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements.
