*Position:** Lead Data Analyst / Data Modeler 10+ years exp*** *Work Location: Charlotte, NC*
*12-month contract* * * *REQUIRED SKILLS:* * * - *Education: Bachelor's Degree in Technical discipline * - *10+ years experience in the field or a related area preferred * - *End user reporting project: Lead Data Analyst 50% data modeling, 50% lead work * - *Strong database knowledge (table structures, relationships, keys, alternate keys, indexes, etc) * - *Able to rapidly learn about many and varied applications at the data structure level * - *Must be able to successfully work with data analyst and data architect * - *Strong knowledge of any reporting system (MS reporting service preferred) * - *Familiar with hardware setup and configuration * - *Erwin, Oracle, Sql * - *Desired skills: RDBMS tools, Metadata tools, SQL, MSRS, Power Delivery or Gas Operations functional understanding from data standpoint, Outage Management, GIS, MapFrame, Gas Transportation mgmt * - *Able to assume a leadership role on the project * - *Understand company's data hub architecture, must learn and follow company's IMA data hub architecture process * - *ETL tool experience, such as Informatica * - *Familiarity with an established SDLC methodology etc. * - *Understand ODBC connectivity. * __________________________________________________________________________________________________________ - *Analyze and Design Database: Adapt conceptual and logical data models to enterprise model. Create, refine and distribute conceptual and logical data models * - *Identify backup and recovery requirements and create recovery plan * - *Backup and recovery requirements are consistent with corporate policy, business needs and legal requirements * - *Requirements are specific to database and are documented completely * - *Identify high-level business rules for data model * - *Data constraints are identified and documented * - *Data definitions are fully developed and agreed upon * - *Detailed business data rules are documented * - *High-level business rules are integrated within the data model * - *Perform research and analyze requirements * - *Integrate high-level business rules with code * - *Data constraints required by the organization are implemented * - *Database triggers, objects, and procedures are documented * - *Provide Data Assurance: Gather and document security requirements * - *Security requirements are documented * - *Potential security risks are identified and resolved * - *Coordinate and Review: Coordinate all modeling activities in workgroup * - *Plan resource needs for upcoming projects * - *Data Management: Data cleaning, updating, editing and validation techniques * - *Data privacy rules, laws, and implementation techniques * - *Data storage and access within government regulation, and corporate policies * - *Developing database triggers, foreign key constraints, and validation (code) tables * - *User access rights to individual tables, rows, and columns (e.g., DDL SQL) * - *Databases: Creation of forms and reports * - *Data flow and data structure modeling * -- -- Skybell Astoline.Inc [email protected] Cont.No:732-734-0940. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Mainframe1952" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/mainframe1952?hl=en -~----------~----~----~----~------~----~------~--~---
