Data Warehouse Solutions Architect-Boston, MA
Desired Skills and Experience:
- Experience leading Business Intelligence / Data Warehousing projects
- 5-8 years of relational and/or multi-dimensional database experience
- Experience with Oracle, SQL Server, T-SQL, PL/SQL; proficiency with advanced SQL concepts such as complex joins, triggers, cursors, correlated sub queries, analytic functions
- Ability to implement ETL concepts using native database utilities and third-party tools (ODI, Talend, SSIS, Informatica, SQL*Loader, Custom PL SQL packages)
- Experience extracting data from a variety of data storage media including relational databases, web services, LDAP querying and a variety of flat file structures
- Strong problem solving skills; strong multi-tasking skills
- Understanding of the best-practices in concepts such as change data capture and master data management
- Understanding of transactional system architectures
- Ability to communicate effectively with various user groups - excellent written and oral communication skills
- Ability to translate technical solution designs into tangible benefits for the business
- Proven ability to apply industry best practices around data warehousing standards
- Experience in leading data integration and enterprise performance management projects are preferred
- Minimum BA or BS in a relevant field
- Able and willing to travel
- Must be eligible to legally work in the United States
Ideal Candidate Sketch:
- Excellent interpersonal skills and business etiquette
- Ability to quickly learn complex concepts & methodologies
- Excellent communication via email, phone, or in-person
- Ability to work independently in a fast-paced environment and have excellent relationship management skills
- Accepts responsibility, proactively problem-solves and goes the extra mile to ensure deadlines are met
- Open-minded, self-motivated and feels comfortable in a strong team-oriented environment