Software Systems Engineer - II

America Networks is a leading sensor and networking solutions partner for companies in any Industrial, Manufacturing, and Waste management space. We design and manufacture sensors for storage tanks, water metering, energy metering, gas monitoring, and asset management. Our founders are hardcore telecommunications engineers with combined 200 + years of experience in designing, optimizing and performance engineering; for several mid large wireless carriers internationally - that saw a need to provide low power, cost efficient sensors to collect data, create alerts, and predict needed actions. We have combined these sensors with low power, wide area (LPWA) networking technologies to provide clients various options to decrease re-occurring costs associated with operating an IoT network of sensors and connected devices. We specialize in design, deployment, optimization, and support of these Networks. Whether an off-the-shelf or custom solution is needed, well create a solution and push the data on the best cloud platform to fit your needs, including your own. Job Description Utilize advanced SQL skills to critically inspect and analyze large, complex, multi-dimensional data sets Define and execute appropriate steps to validate various data feeds to and from the organization Collaborate with business partners to gain in-depth understanding of data requirements and desired business outcomes Create scripts to extract, transfer, transform, load, and analyze data residing in Hadoop and RDBMS including Oracle and Teradata Design, implement, and load table structures in Hadoop and RDBMS including Oracle and Teradata to facilitate detailed data analysis Participate in user acceptance testing in a fast-paced Agile development environment Troubleshoot data issues and work creatively and analytically to solve problems and design solutions Create documentation to clearly articulate designs, use cases, test results, and deliverables to varied audiences Create executive-level presentations and status reports Under general supervision, manage priorities for multiple projects simultaneously while meeting published deadlines Bachelor's degree or Master's degree in Computer Science or equivalent work experience Highly proficient and extensive experience working with relational databases, particularly Oracle and Teradata Experience with Big Data technologies, distributed file systems, Hadoop, HDFS, Hive, Hbase is a plus Excellent working knowledge of UNIX-based systems Excellent Interpersonal, written, and verbal communication skills Very proficient in the use of Microsoft Office or G Suite productivity tools Experience with designing solutions and implementing IT projects Exposure to DevOps, Agile Methodology, CI/CD methods and tools, e.g. JIRA, Jenkins, is a huge plus Prior work experience in a telecommunications environment is a huge plus Experience with BI visualization tools such as Tableau and Qlik is a plus. Background in financial reporting, financial planning, budgeting, ERP (Enterprise Resource Planning) is a plus Exposure to advanced analytics tools and techniques e.g. machine learning, predictive modeling is a plus #J-18808-Ljbffr