Job Description :
IKCON TECHNOLOGIES INC delivers exceptional IT services and solutions that provide clients with definite edge over competitors and promoting highest standards of quality. We are currently looking for a [Data Warehouse Analyst] with one of our clients in [Madison], [WI]. If you are actively looking for opportunities, please send us your updated resume with your contact details.
JOB TITLE Data Warehouse Analyst
CITY Madison
STATE WI
TAX TERMS C2C/W2
EXPERIENCE 8+ Years
INTERVIEW MODE Telephonic/Skype/In person
JOB DESCRIPTION
The candidate will be a strong technical leader responsible for BI Dashboard Reporting projects using Tableau, gathering, understanding & documenting user requirements, creating specifications, designing solutions, development, testing, and implementing solutions that ensure requirements are achieved through high quality deliverables.
Strong experience in designing visualizations that are efficient and communicate required message.
The candidate will also be responsible for developing and implementing standards, and best practices in the use of Tableau Software. Knowledge and understanding of PeopleSoft Financials and HCM data for reporting purposes.
Seek continuous improvement in performance & tuning and ensure security of data.
Proven experience and demonstrated ability to achieve deliverables on time and on budget.
Experience working with data warehouses and dimensional data models as a data source for dashboard development.
Work with other IT technical teams and Business users to understand requirements, and recommend & implement solutions.
Work 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 7 - 9 years experience or equivalent education.
Ideal candidate will have experience designing BI dashboard solutions, development experience in Tableau Software, strong knowledge of PeopleSoft Financials & HCM, and be familiar with DOT business areas.
DW & BI Knowledge areas:
1. Tableau Software - 2018.1
2. Dashboard design
3. Oracle, DB2 and SQL Server
4. SQL development
5. Data warehouse/data marts using Kimball & Inmon methodologies
6. Dimensional Data Modeling - Star Schemas
7. Slowly Changing Dimensions
8. PeopleSoft Financials & HCM data for Reporting/Visualization purposes
9. Requirements gathering
10. Creating specifications
11. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support
12. Excellent written and oral communications
13. Independent worker
Tableau Software (8+ years’ experience)
PeopleSoft Financials and HMC (6+ years’ experience)
Database Knowledge (8+ years’ experience):
ORACLE
SQL Server
DB2
Complex SQL statements
MINIMUM QUALIFICATIONS
Bachelor’s Degree or master’s degree in the field of Computer Science or Information Systems or a related field.