Data Warehouse Analyst II

AtriaGroupLLC

Charlotte, NC, United States contract

Posted: January 12, 2015

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.

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

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.