| Senior Data Warehouse Analyst [message #93235] |
Tue, 20 January 2004 18:26  |
Anna Karotusos
Messages: 15
Registered: October 2000
|
Junior Member |
|
|
<B style="mso-bidi-font-weight: normal">Excellent Opportunity in the Columbus Ohio area[/b]
<B style="mso-bidi-font-weight: normal">[/b]<B style="mso-bidi-font-weight: normal">Salary 65-85 [/b]<B style="mso-bidi-font-weight: normal">
[/b]
New opportunity for a Senior Data Warehouse Analyst
This individual will be a key player for our client’s Business Intelligence team. Duties will include: developing and maintaining enterprise Customer Relationship Management and Business Intelligence systems. Involved in the design and development of an enterprise data warehouse repository that will support numerous operational and reporting & analytic applications; Provide leadership to the architecture design and development of the ECTL (Extract, Cleansing, Transformation and Load) processes required to support the enterprise data warehouse and corresponding data marts; A hands‑on person with responsibilities that include data design, database architecture and creation the actual source to target mappings to be used in the environment. this individual will be responsible for all data quality and standardization processes and all metadata & ETL documentation.<B style="mso-bidi-font-weight: normal">
[/b]
Develop logical and physical database designs and participate in the detailed design, development, testing, and deployment of the architectures. Database designs will support 3NF atomic level EDW repository and dimensional/star/snowflake schema designs for Decision Support and CRM systems.
Design and Code complex ECTL (Extract, Cleanse, Transformation, Loading) logic and specifications. Heavy emphasis should be placed on architecting and developing 'best‑practice' ETL frameworks that support ODS, Staging, atomic level EDW and multidimensional decision support structures for both MOLAP or ROLAP analysis. ETL and data cleansing packages to be used will be Informatica 7.0 and Trillium v7.
Create and maintain metadata and ETL documentation that support business roles and detailed source to target data mappings. Creates and maintains data governance strategies that reduce data redundancy wherever possible.
Develop and execute test plans and play an active role in project rollouts.<B style="mso-bidi-font-weight: normal"> [/b]<B style="mso-bidi-font-weight: normal">
[/b]
<UL style="mso-margin-top-alt: 0in" type=disc>
<LI class=MsoNormal style="tab-stops: list .5in right 476.6pt; mso-list: l0 level1 lfo1">High level PC skills and expert in MS Office applications (Access, Word, Excel and PowerPoint) Microsoft Project, Visio.
<LI class=MsoNormal style="tab-stops: list .5in right 476.6pt; mso-list: l0 level1 lfo1">Must have understanding of prevailing data warehouse architectures including, at a minimum, Bill Inmon's Corporate Information.<B style="mso-bidi-font-weight: normal">
[/b] [/list]
BA BS in Computer Science, MIS or Business Administration (Masters degree a plus)<B style="mso-bidi-font-weight: normal">
[/b]
· Must have 5‑8 years technical experience as a systems, technical or data analyst.
· Must have 4+ years performing data analysis and full life‑cycle development or support experience within a data warehousing
· Environment.
· Demonstrated proficiency using SQL (4+ years). Should have experience with stored procedures.
· Experience with Design and development of Conceptual, Logical and Physical data models for a data warehouse (normalized and
· dimensional).
· Expertise in designing complex ETL processes (3+ years). Background should include development of ETL(Extract Transformation
<SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: 'Book Antiqua'; mso-bidi-font-size: 12.0pt">
<SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: 'Book Antiqua'; mso-bidi-font-size: 12.0pt">
Anna Karoutsos
www.zoe-tech.com
614-766-2087
annak@zoe-tech.com
<SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: 'Book Antiqua'; mso-bidi-font-size: 12.0pt">
<SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: 'Book Antiqua'; mso-bidi-font-size: 12.0pt">
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
