Data & AI jobs

Data Warehouse Analyst II

Atria Group LLC (agency)Charlotte, NCContractOn-site5+ years experience

Pay not listed

2 things to check before you apply.

On Atria Group LLC’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 11 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 60 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Gather and document business and user requirements, then design data warehouse and BI solutions.
  • Develop, test, implement, and maintain ETL mappings, data warehouse solutions, universes, reports, and dashboards.
  • Analyze relational databases and investigate data-load failures and data-retrieval issues.
  • Improve data warehouse performance and tuning, and ensure data security and reliability.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 5+ years of Informatica PowerCenter experience
  • 5+ years of Business Objects experience
  • 5+ years of database experience
  • Data warehouse design and development
  • 7 years of experience designing Data Warehouse and BI solutions and developing with Informatica PowerCenter and Business Objects (preferred)

Skills

  • SAP Business Objects universe design and development
  • SAP Business Objects report design and development
  • Complex SQL statements
  • Oracle, SQL Server, and DB2

Other requirements

  • Independent worker

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Atria Group LLC’s careers site

Company Description

Job Description

We are looking for a candidate that can help us build our Data Warehouse & BI practice.

The candidate will be working on Data Warehouse & BI projects, gathering & documenting requirements, designing solutions, developing ETL using Informatica PowerCenter, developing universes and reports using Business Objects, testing, and implementing solutions. They will be responsible for both ETL and business intelligence report design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables.

Show full descriptionShow less

Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure security of data. Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Works with other IT technical teams and Business users to understand requirements, and recommend & implement solutions.

Works with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 5 Ideal candidate will have experience designing Data Warehouse and BI solutions, and development experience - 7 years experience with both Informatica PowerCenter and Business Objects.

Data warehouse/data marts using Kimball & Inmon methodologies

DW & BI Knowledge areas:

  • Informatica PowerCenter ETL
  • SAP Business Objects universe and report design/development
  • Xcelcius Dashboard design and development
  • Crystal reports
  • Oracle, DB2 and SQL Server
  • Dimensional Data Modeling
  • Slowly Changing Dimensions
  • Requirements gathering
  • Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation,
  • Excellent written and oral communications

Informatica PowerCenter - ETL (5+years experience):

  • Infoburst support
  • Independent worker
  • Data warehouse design
  • Data warehouse development

Business Objects (5+ years experience):

  • SAP Business Objects Universe design and development
  • SAP Business Objects report design and development

Database Knowledge (5+years experience):

  • Complex SQL statements
  • Xcelsius dashboards
  • ORACLE
  • SQL Server
  • DB2

Additional Information

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

Data Analyst

RVO Health · Charlotte, NC +2 places

$70k–$95k/yrHybrid

StrongChecked open todayPosted 26 days ago

Data Scientist II

Honeywell · Charlotte, NC

Full-timeHybrid

StrongPay not listedChecked open todayPosted 1 month ago

Medicaid Data Lead

Abt Global · Rockville, MD +3 places

$110k–$155k/yr

StrongChecked open todayPosted 9 days ago

See more like this