Data Modeler Columbus, OH Duration – 1 year + JOB DESCRIPTION:
Top Three Skills: 1. Data profiling 2. Source to target Mappings 3. Data Modeling Hybrid-Dimensional and Relational 4. Data visualization 5. SQL experience is also very important- We will be trying to use a tool called Informatica Data Quality to conduct data profiling. If for some reason we run into issues using this tool, we fall back to SQL. Job Description: Position likely to be contract to perm. A Lead data analyst performs a variety of tasks related to collecting, organizing and interpreting data. A data analyst will be responsible for inspecting, cleansing, transforming and modeling data. A data analyst wll have to deal with uncertainty about data information completeness and quality. A data analyst will play a dominant role in business intelligence, advanced analytics, data integration and master data management efforts and will be involved with traditional application development projects where necessary. Role accountabilities A data analyst will have a natural inclination and passion toward problem solving in a disciplined process oriented fashion. A data analyst will – Critically evaluates information gathered from multiple sources, reconciles conflicts, classifies the information in logical categories – Uses different visualization techniques and present the results of data exploration exercises – Understands the flow of data, business processes/technical interfaces that would be created or impacted – Documents the source to target mappings for both data integration as well as web services (consumer/provider mappings) that can be easily understood by the project team members with data quality and transformation rules – Identifies and documents sources of existing data as well as the new data. Understands use of master and reference data including sources and contributors. – Collaborates with data scientists and business partners and conducts data profiling and predictive analysis using a variety of standard tools – Creates conceptual, logical and physical data models and determines the most appropriate method to represent the data for business consumption. This includes all forms of physical representation of data, such as relational, dimensional, object, key-value (such as column families), and graph. Please note this list is not all inclusive. – Have joint accountability with data stewards and data architects on the projects to ensure conformance to enterprise data governance policies around information risk and data protection guidelines. Data analysts should be familiar with common policies around data masking and protection schemes. Recommended experiences Data source identification, data profiling, interpretation of patterns and trends, assessment of and improvement of data quality, versatility with visualization tools and techniques to share analysis findings. It is beneficial for individuals to have worked as a data analyst in any of the following types of projects: Analytically Intensive – Intended to draw/develop insights from data that is collected Operationally Data Intensive – Intended to create authoritative data sources that are essential to core transactional processing Data Integration Intensive – Requires the merging of many data types to satisfy business requirements The Requirements Analyst translates business and system needs into Solution Requirements for Designers, Developers and Testers to consume and uses Requirements elicitation, analysis, specification, verification and management techniques for the purpose. Requirements Analysts are engaged in work efforts at all scales ranging from minor defect fixes and enhancements to development of new applications. They are also involved in all types of solution approaches (custom development, package implementation etc.) and solution domains (business applications, data warehouses, web services, infrastructure etc.) Contributes overall strategic vision of the organization and integrates a broad range of ideas and initiatives regarding IT Analysis. Serves as the top level technical contributor and lead for the most complex IT analysis initiatives. Recognized across the organization for IT analysis expertise. Undertakes the most complex IT analysis issues on projects involving high risk to the organization or that have an impact to multiple business units. Formulates and defines systems scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements. With expert knowledge, develops or modifies the most complex information systems. Includes analysis of business and user needs, documenting requirements, and revising existing system log difficulties as necessary. Guides and advises less-experienced analysts . Consults on the development and implementation of IT analysis initiatives to ensure that information systems products and services meet organization standards. Thanks & Regards Shyam Rachakatla Technical Strategies Inc., (A Certified Small Minority Owned Business) 4229, Lafayette Center Dr, Suite 1650 | Chantilly, VA – 20151 Office: 703-773-6218 | Fax: 703-621-6864 Email: [email protected] OR [email protected] | URL: www.techstratinc.com -- You received this message because you are subscribed to the Google Groups "as400placements1" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send an email to [email protected]. Visit this group at https://groups.google.com/group/hrccpl. For more options, visit https://groups.google.com/d/optout.
