Software Systems Engineer - II

AmNet Services, Inc.; Colorado Springs (CO); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading technology solutions provider in Colorado Springs seeks a skilled data analyst to utilize advanced SQL skills in analyzing complex data sets. The role involves collaborating with business partners, managing data in Oracle and Teradata databases, and troubleshooting data issues creatively. Candidates should have a relevant degree and strong relational database experience. Familiarity with Big Data technologies and Agile methodology is preferred. Competitive compensation and growth opportunities are provided.

Qualifications

• Bachelor’s or Master’s degree in Computer Science or equivalent work experience.
• Highly proficient in relational databases, particularly Oracle and Teradata.
• Experience with Big Data technologies and distributed file systems is a plus.

Responsibilities

• Utilize advanced SQL skills to analyze complex data sets.
• Collaborate with business partners on data requirements.
• Create scripts to extract, transform and load data in Hadoop and RDBMS.

Skills

Advanced SQL skills

Data analysis

Relational databases (Oracle, Teradata)

UNIX-based systems

Microsoft Office or G Suite

Agile methodology

Data visualization tools (Tableau, Qlik)

Education

Bachelor's or Master’s degree in Computer Science

Tools

Hadoop

Teradata

Oracle

JIRA

Jenkins

Job description

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, we’ll create a solution and push the data on the best cloud platform to fit your needs, including your own.

Job Description

Responsibilities

• 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

Qualifications

• 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