Software Systems Engineer - II

• 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 Vik Salvatore vivek.salvatore(@)americanetworks.com (973) 582-3458