Enterprise Data Architect

Responsibilities

• Design and implement effective database solutions and models to store and retrieve company data.
• Develop, optimize and oversee our company’s conceptual and logical data Systems.
• Examine and identify database structural necessities by evaluating client operations, applications and programming.
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Prepare accurate database design for Management and Executive teams.
• Responsibilities will include setting the vision, gathering requirements, gaining business consensus, performing vendor and product evaluations, mentoring business and development resources, deliver.
• Monitor the system performance by performing regular tests, troubleshooting and integrating new features.
• Recommend solutions to improve new and existing database systems.
• Enterprise data warehouse (EDW) schema and define extract-translate-load (ETL) and/or extract-load-translate (ELT) processes for EDW.

Required Skills

• Extensive expertise in Oracle and SQL Server database, as well as data modeling, both logical and physical.
• Knowledge of relational SQL databases and SQL in Oracle and Microsoft SQL Server.
• Strong math and analytical skills are essential to complete job requirements successfully.
• Able to compile and organize statistical information retrieved and present findings to management.
• Extremely strong analytical and problem-solving skills.
• Outstanding verbal, written and visual presentation skills.
• Proven strong negotiating and consensus building abilities.
• Proven skills to work effectively across internal functional areas in ambiguous situations.
• Structured thinker and effective communicator, comfortable with interacting with customers.
• Ability to work independently, establishing strategic objectives, project plans and milestone goals.
• A solid understanding of key BI trends.

Required Experience

• A minimum of 10 years of progressively responsible experience in a directly related area, during which both professional and management capabilities have been clearly demonstrated.
• Experience in and understanding of a wide variety of analytical processes (governance, measurement, information security, etc).
• Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, normalized and de-normalized models, handling “slow-changing” dimensions/attributes.
• Extensive experience providing practical direction on information and analytics platforms in conjunction with EDW tools and technologies.
• Experience using with project management, ITIL and SDLC methodologies.
• Solid experience with Data Warehouse and BI systems; extensive experience for collecting business requirements from customers, and transform the requirements into DB data processes and data schema.
• Experience working with sensitive personal information.

Education Requirements

• Bachelor’s Degree in Computer Science, Computer Engineering or a closely related field.