Data Modeler Consultant
Job Description Position/Program Title: Data Modeler Senior Consultant The opening is for a large consulting firm. Our Data and Analytics consultants help clients maximize the value of their data. This high performing team helps clients define their information strategy, architecture and governance, get the most value from business intelligence and analytics, and implement enterprise content and data management solutions to enable business insights, reduce cost and complexity, increase trust and integrity, and improve operational effectiveness. Minimum Years of Experience: 4 Minimum Degree Required: Bachelor's degree in Computer Science or any MIS related field Knowledge Preferred: Demonstrates thorough knowledge of contributing on client engagement teams that design and develop business intelligence (BI) and predictive models for data warehouse (DW) information management architecture, including: Evaluating enterprise DW architecture feasibility, risk, and technologies related to business change (ie assessing, identifying and recommending BI and related business stakeholders' data requirements; BI solution prototyping and development; processes and performance from business and technical standpoints; and the impact of data changes on business and/or IT processes); Advising CXO's on emerging BI/DW technologies and strategies consistent with clients' business strategies; Prioritizing, preparing and implementing BI and/or DW architectural improvements (ie developing and recommending alternative DW technical and data management solutions, methodologies, strategies and architectural improvement plans); Developing and validating business stakeholders' conceptual data models, including socializing and implementing logical and physical DW/data mart data models; identifying data sources and metadata (including business rules, definitions, attributes, etc.) to deliver analytic requirements. Skills Preferred: Demonstrates thorough abilities to interact with end-users to understand and document business and functional requirements for complex projects, including full software development life cycle, DW/BI/ETL tools and other related technologies, including: Enterprise data management, data warehousing and/or business intelligence; data modeling, integration and/or synchronization, quality, security, conversion, and analysis; database administration; and/or enterprise data management policies, procedures, compliance & risk management. This includes a minimum of having participated in two full life cycle implementations. Architecture, design, and development of enterprise business intelligence and data warehousing solutions, including utilizing leading ETL/BI tools and the ability to architect a solution. Design and development of data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching that leverage knowledge within data, master data, metadata and technology management. Develop the architecture of a data warehouse, data modeling, and fluency in Oracle PL/SQL SQL. They should have experience in Oracle 11g and Oracle Designer, and with Erwin Data Modeler. The successful candidate will have an extensive background in data modeling (supporting either application development and/or data warehouse development) and will demonstrate a clear understanding of dimensional models, indexing, aggregate tables, dimension tables, constraints, keys, and fact tables. Demonstrates proven thorough skills and success participating in consulting-related projects within a professional services environment that utilize creative thinking skills and individual initiative, including the following: Collaborating and contributing as a team member: understanding personal and team roles; contributing to a positive working environment by building solid relationships with team members; proactively seeking guidance, clarification, and feedback Identifying and addressing client needs: building solid relationships with clients; developing an awareness of Firm services; approaching client in an organized manner; delivering clear requests for information; demonstrating flexibility in prioritizing and completing tasks; communicating potential conflicts to a supervisor. Prioritizing and handling multiple tasks; researching and analyzing pertinent client, industry, and technical matters; utilizing problem-solving skills; and, communicating effectively in written and verbal formats to various audiences (including various levels of management and external clients) in a professional business environment. Coaching and collaborating with associates who assist with this work, including providing coaching, feedback, and guidance on work performance. Position Type: Full Time State & City: VA-McLean Travel Requirements: 0-20% Company Description Market Timing Solution is recruiting for a large consulting firm.