Data Architect - Data Warehouse
InfoStaff - Atlanta, GA

This job posting is no longer available on InfoStaff. Find similar jobs: Data Architect jobs - InfoStaff jobs

The Database Architect – Data Warehouse Architect position will be responsible for providing oversight of the technical design of all data warehouse projects to insure consistency and adherence to corporate standards and development best practices. You will review warehouse project proposals and scope documents to validate technical viability and uniformity to existing projects and architectures. You will write technical design documents for developers in a geographically distributed environment. You will obtain buy in from project stakeholders for your technical design. You will collaborate with developers to insure that your technical design is being followed. You will provide expertise to developers through code reviews and act as a 3rd tier escalation for ETL support.
Key Targets:
Non-Financial
• Demonstrated technical leadership and a “take-charge” attitude
• Attention to detail/accuracy
• Professional maturity and excellent business acumen
• Demonstrate appropriate level of confidence and urgency in taking action
• Ability to provide timely and accurate information to external and internal requestors
• Excellent communication skills (verbal & written)
• Organization and planning skills
• Conflict management & resolution skills
• Multi-tasking capable (individual will be assigned multiple projects simultaneously), and highly flexible.
• Travel industry experience is a plus.
Job Specific Essential Duties & Responsibilities:
Core Responsibilities:
Development
• Define best practices and standards for ETL and Data Warehouse design
• Collaborate with developers to insure that technical design is being followed.
• Provide expertise to developers through code reviews and act as a 3rd tier escalation for ETL support.
Requirements
• Write technical design documents for developers in a geographically distributed environment
• Obtain buy in from project stakeholders for technical design
• Review warehouse project proposals and scope documents to validate technical viability and uniformity to existing projects and architectures
Support
• Availability for 3rd tier support, problem determination and problem resolution of production systems
Essential Job Functions:
• Must be able to come to work promptly and regularly
• Must be able to take direction and work well with others
• Must be able to work under the stress of and meet deadlines
• Must be able to concentrate and perform accurately while meeting applicable productivity measures
• Must be able to change productively and to handle other tasks as assigned
Qualifications / Knowledge / Experience:
Essential
• 7+ Years or SQL Server Development
• 7+ Years ETL development with at least 2 of those years using SQL Server Integration Services (SSIS)
• 7+ Years T-SQL experience
• 7+ Years data warehousing experience
• 5+ Years enterprise software development experience
• 5+ Years Data Modeling, including
• 2+ Years “Big Data” or Enterprise Data experience
Required Skills
• Dimensional modeling experience
• Analytical design and processing
• ETL Development using SQL Server Integration Services (SSIS), 2005, 2008, or 2008R2
• Ability to read, write, complex T-SQL
• ETL / T-SQL Performance Tuning
• Experience with Data Modeling tools
Preferred
• Data Quality Tools
• C# / VB.net development
• TaskFactory
• Sybase PowerDesigner for Data Architecture
• MicroStrategy experience

InfoStaff - 30+ days ago - save job - block
Recommended Jobs
Data Architect - Media Traffic Systems
Cox Media Group - Atlanta, GA
Cox Media Group - 3 days ago

Data Architect
Nasco - Atlanta, GA
Nasco - 6 days ago

ETL Architect
Accenture - Atlanta, GA
Accenture - 5 days ago