Job Details

ID #21809162
State Colorado
City Englewood
Job type Permanent
Salary USD $70,000 - $90,000 70000 - 90000
Source Excelacom
Showed 2021-10-28
Date 2021-10-06
Deadline 2021-12-04
Category Art/media/design
Create resume

Data Analyst

Colorado, Englewood, 80111 Englewood USA

Vacancy expired!

Job Title: Data Analyst

Job Location: Greenwood Village, CO

OVERVIEW:Excelacom is a consulting and technology solutions company with a focus on Communications and Media providers. At our core, we partner with our clients to solve their complex business, technology and operational challenges through a combination of consulting expertise and telecom-focused product solutions.Our consulting teams optimize existing systems and work on an accelerated timeline using innovative approaches and best practices that minimize risk and maximize return to improve business and operational performance without costly technology transformations.Excelacom is a global company and is headquartered in the United States in Reston, VA, outside of Washington, D.C., with offices in North America and Europe as well as a technology center in Chennai, India.

JOB DESCRIPTION:As a Data Analyst with a focus on ad hoc queries and business analysis with our Service team, you will develop a SME attention to detail to answer questions not available in regular business reporting. This position will be a developer in the WiFi product lane at our client. You will collaborate with cross-functional database and product development teams. In your role, you will use different database technologies to support the entire business unit from product managers to software specialists. This role lies within the analyst.

ROLE AND RESPONSIBILITIES:
  • Participate in the collaborative ad hoc / analytical process to address business and technical information needs
  • Audit / analyze new data for duplicates and tie out
  • Be the subject matter expert for pulling data, organizing and analyzing data with client analytic partners
  • Work with others on data feasibility, best practices, and limitations of the data
  • Oversee data transformation, normalization, cleansing, aggregation, workflow management and business rule application in order to apply best practice analytic methods
  • Load, process, and manage manually pulled data feeds in order to analyze data as needed
  • Contribute to the development of business roadmaps to inform client of different aspects of the data or different perspectives in which to present the data to executive leadership
  • Proficiency in effective report/dashboard design and standards in Tableau or others
  • A deep knowledge of Relational Database Management Systems and how to build ad hoc OLAP from OLTP data
  • Familiarity with data preparation, processing, classification, and auditing before presenting analytical results
  • Comprehensive experience with stored procedures and query tools. Strong SQL skills required.
  • Tableau, ETL and data architecture management experience
  • Knowledge and experience using Big Data and related technologies (Phoenix, hive) a plus
  • Experience using analytic functions within different SQL environments
  • Knowledge and experience using AWS Athena, AWS Glue, and other AWS technologies
  • Define and manage critical data using Master Data Management solutions
  • Good collaboration and idea sharing in a team environment

REQUIRED QUALIFICATIONS:
  • Bachelors' Degree in Information Science, Computer Science, Engineering or related field
  • 2+ years hands-on, in-depth experience with PL-SQL, T-SQL, Hive, Presto, or PostgreSQL and stored procedure development
  • 2+ years working experience with Tableau
  • Excellent ETL / ELT understanding
  • Familiar with Gitlab and Jira tools
  • Familiar working in an agile type environment
  • 2+ years hands-on experience within the Data Management and Information Management disciplines
  • 2+ years of development experience

COMPENSATION AND BENEFITS:For individuals assigned to work in Colorado, Excelacom is required to include a reasonable estimated compensation range for this role. However, final salaries will vary based on several factors, such as candidate’s level, qualifications, skills, competencies and proficiency for the role. An individual may be hired at the Analyst, Consultant, or Manager level for this role with each level requiring an increasing set of responsibilities. For regular full-time employees, the estimated salary range is from $70,000 to $90,000/yr. Our competitive salaries are just one component of Excelacom’s total compensation package for our regular full-time employees. Other rewards and benefits include: health, vision, and dental insurance, accident, critical illness, life and AD&D insurance, 401k, paid-time off, paid holidays and floating holidays, to name a few. To view more details of what you can look forward to, visit our careers page: https://www.excelacom.com/careers.html

EEO STATEMENT:Excelacom, Inc. is an equal opportunity employer. Any decision affecting employment, compensation, promotion, or transfer will be based solely on personal qualifications and merit, regardless of sex, race, color, religion, gender identity, sexual orientation, marital status, national origin, disability, age, results of genetic testing, service in the military, pregnancy, childbirth or other related medical conditions or any other factor protected under applicable law.

Vacancy expired!

Subscribe Report job