Data Software Engineer Staff

Overview Who We Are: Ever wonder who brings the entertainment to your flights? Panasonic Avionics Corporation is #1 in the industry for delivering inflight products such as movies, games, Wi-Fi, and now Bluetooth headphone connectivity! How exciting would it be to be a part of the innovation that goes into creating technology that delights millions of people in an industry that’s here to stay! With our company’s history spanning over 40 years, you will have stability, career growth opportunities, and will work with the brightest minds in the industry. If you want to learn more about us, visit us at And for a full listing of open job opportunities go to Responsibilities The Data Software Engineer Staff will be responsible for all aspects of data acquisition, data transformation, analytics and operationalization to drive high-visibility, cross-division outcomes. Lead investigation, evaluation, testing initiatives. Support software developers, database architects, data scientists on data initiatives and will deliver optimal data solutions. What we are looking for: Data Operations Develop distributed, scalable, and reliable data pipelines that ingest and process data at scale and in real-time. Create data environments and/or data sets to serve a wide range of data users, including but not limited to Data Scientists, Data Analysts, Business Analysts etc Perform offline analysis of large data sets using components of a big data software ecosystem. Troubleshoot and determine root cause of complex data provenance, metadata issues and engineering questions that may involve interfacing with various technical staff in multiple organizations and with differing levels of expertise. Investigate, evaluate, test and recommend technical solutions for future systems. Author extract, transform and load (ETL) scripts for moving and curating data into data sets for storage and use by a datalake, data warehouse and datamart. Data Management Own product features from the development phase through to production deployment (end-to-end). Provide solutions for the design and implementation of Hadoop EMR Cluster/ Big Data Infrastructure. Deploy Hadoop/Big Data/Spark and database storage Infrastructures in AWS cloud. Evaluate big data technologies and prototype solutions to improve data processing architecture. Monitor and install HDFS/Hadoop/Spark and related software releases, third-party utilities with emphasis on overall system performance. Develop tools and procedures to monitor and automate system tasks on servers and clusters. Collaborate with other teams to design, develop, and deploy data tools that support both operations and product use cases. Evaluate and advise on technical aspects of open work requests in the product backlog with the project lead. The salary range of $112,000 – $188,000 annually is just one component of Panasonic’s total package. The final offer amount may vary based on factors including but not limited to individual’s knowledge, skills, experience, and location. Qualifications What we are looking for: Bachelor’s degree in computer science, computer engineering, or a related technical field. 8+ years of professional experience as a data software engineer; or 12+ years of related experience as a data software engineer in lieu of Bachelor's degree. 2+ years of experience with AWS cloud computing design, provisioning, and tuning. Related AWS certification, preferred. Previous experience as a Data Engineer / Database Administrator and/or Business Intelligence Analyst. Proven knowledge of database concepts, object and data modeling techniques and design principles. Proven knowledge of database architectures, software, and facilities. Advanced experience with programming languages - Python (required), Scala, Ruby, R Database technologies - SQL, performance tuning concepts, AWS RDS, RedShift, MySQL. Advanced experience with big data batch processing tools: Hadoop MapReduce, ElasticSearch, PIG, Hive, Cascading/Scalding, Apache Spark, AWS EMR. Advanced experience with stream-processing systems: Kinesis, Kafika, MQTT. Advanced experience with relational NoSQL databases including DyanamoDB Code/Build/Deployment - git, jenkins, aws code. Excellent verbal and written communication skills necessary to effectively collaborate in a team environment and present and explain technical information and provide advice to management. Leads complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results. Proven experience in complex technical and business matters. Ability to champion significant projects, programs and business initiatives using demonstrated creativity and ingenuity. Ability to lead and mentor junior engineers and colleagues. What we offer: At Panasonic Avionics Corporation we realize the most important aspects in leading our industry are the bright minds behind everything we do. We are proud to offer our employees a highly competitive, comprehensive and flexible benefits program. Paid time off: Exempt Salaried employees receive unlimited PTO. This means that there is no fixed number, range, or limit to the amount of Personal and Vacation Days that may be taken for exempt employees. Non-exempt hourly employees accrue 14 vacation days per year + 7 sick days + 3 personal days. Accrual rate increases with tenure. All employees receive 11 company paid holidays per year plus a paid company-wide shut down in the U.S. between Christmas and New Year. Insurance: Medical insurance offerings from Aetna and Kaiser (CA &HI). Options for Employee Only, Employee + Spouse/Domestic Partner, Employee + Children, or Family. Dental PPO and DMO options & Vision insurance through EyeMed or VSP. 401K with 50% match on up to 8% contribution, full vested from day 1. Other offerings include: Wellness Program, Counseling services, FSA & HSA, Life Insurance for employee, spouse and child, AD&D Insurance, Long-term and Short-term disability, Critical Illness Insurance, Accident Insurance, Legal Assistance, Pet Insurance, Identity Theft Protection, Dependent Care FLSA, Education Assistance, Commuter Program, Employee Purchase Program, Service Award Program. Panasonic is proud to be an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability status, protected veteran status, and any other characteristic protected by law or company policy. All qualified individuals are required to perform the essential functions of the job with or without reasonable accommodation. Pre-employment drug testing is required for safety sensitive positions or as may otherwise be required by contract or law. Due to the high volume of responses, we will only be able to respond to candidates of interest. All candidates must have valid authorization to work in the U.S. Thank you for your interest in Panasonic Avionics Corporation. #LI-WS1 Salary Range $119,000 - $200,000 annually REQ-156348