Data Architect, PL/SQL

Data Architect, PL/SQL
Denver, CO
Who We Are:
Excelacom has a global presence in the consulting and technology solutions industry with a focus on Communications and Media providers. We collaborate with our clients to solve their complex business, technology and operational challenges through a combination of consulting expertise and telecom-focused solutions and products. Excelacom provides extensive experience in product development, IT consulting, telecom-focused software and managed services, as well as strategic management and thought leadership to steer our clients towards a successful business and technology transformation.

At Excelacom, we recognize that our most valuable asset is our people. We strive to create an environment where our employees can contribute their unique perspectives and grow individually and collectively. Our diverse and inclusive culture empowers our people to embrace their ideas and transform them into innovative solutions.

Who You Are:
As a Data Architect, you will develop complex strategies and data organization architectures that address industry requirements through collaboration with IT teams and leadership. You will develop data models and analytics that meet existing and future clients' needs.

At the Analyst-Level, you will be expected to contribute to the development of recommendations, business knowledge and technology awareness, provide meaningful input into client deliverables/proposals, and take ownership of assigned tasks. You will conduct research, collect data, and perform quantitative and qualitative analyses to support business solutions. Most importantly, you will embrace our firm's brand and core values.

Role and Responsibilities:

• You may work on various projects throughout your career with Excelacom. The roles and responsibilities noted below pertain to the specific role listed above.
• Responsible for design and development of data architecture and ETL dataflows in support of enterprise risk management, analytics and reporting.
• Analyze business requirements, propose, design and implement technical solutions
• Work effectively with the DBA teams to ensure that all approved development and deployment procedures are followed.
• Provide production support from development teams for existing systems, troubleshoot data and/or system issues
• Identify root causes and resolve data related issues
• Review and optimize query performance
• Perform Database Analysis and Data Modeling, PLSQL.
• Create Volumetric for capacity planning.
• Automate the Extraction, Transformation and Load (ETL) of data from the Production system to the Reporting Database
• In addition to delivering at the client site, you will occasionally be tasked in productizing Excelacom's work, contributing to our Center of Excellence and intermittently working on Excelacom proposals to the client.

Required Qualifications:

Bachelor's degree required, preferably in Computer Science or related field

Proficiency in Microsoft Office (Word, Excel, PowerPoint, Visio)

Strong math, written and verbal communication skills with an analytical approach

Ability to interact cross-functionally with various levels management and peers

Demonstrated ability to work independently and in a team-based environment

6 years' of information technology experience in Data modeling database development (Oracle/MSSSQL/MYSQL/Postgres), Data architecture, Data Science, Data warehousing, NOSQL and or Bigdata.

Hands-on experience with oracle database administration, database and sql performance tuning.

Experience writing complex SQL statements

Experience in application architecture, network management, and performance management work experience

Experience in data management, data-oriented programming, and development work experience

Experience in developing large scale systems, developing interfaces to Oracle or other SQL-based databases and Sound understanding of RDBMS

Experience in working controlled development, testing and production environments

Experience in Monitor application related jobs and data replication activities

Experience in optimized database design and modeling of OLTP systems and hands on experience with tuning of SQL queries of OLAP and OLTP systems.

Proficient in PENTAHO, SSIS, Informatica tool for loading data from different source systems.

Must have expereince working with offshore teams

Preferred Qualifications:

Prior experience in Telecommunications, Media, or Cable is highly preferred

Oracle Database and Cloud certification

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 $90,000 - $110,000

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, ancillary benefits, Life and AD&D insurance, 401k, and generous paid time off policies.

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.

#ZR

Salary : $90,000 - $110,000