Software Systems Engineer - II

About the role

• 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

Additional Information: Vik Salvatore vivek.salvatore(@)americanetworks.com