Immediate need for a talented Data Analyst This is an 36+ Months contract opportunity with long-term potential and is located in Scottsdale, AZ ( 100% Remote ) . Please review the job description below and contact me ASAP if you are interested. Job ID: 23-04369 Pay Range: $55 – $60/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location). Key Responsibilities: Manager Notes: Candidates must be sharp and will be tested during the interview: SQL, Mapping, Profiling, Modeling, Conceptual data design experience. Job Description: Candidate must have strong skills in data profiling, mapping , data modeling and data governance. Includes ability to query data repositories to determine Source to target mappings, data quality, completeness and transformation rules necessary for merging into target repositories Strong skills in Informatica, Informatica Data Quality, Information Analyzer, and IBM data architect, Erwin is big plus. Strong SQL skills are a must. Hands-on experience in creating/updating conceptual, logical, and physical data models most appropriately needed to satisfy the business requirements. Should be able to understand and explain complex data integration and extraction/transformation/load processes (ETL). Should be able to work with the business to define scope of Data-centric or supportive projects. Should be competent in reviewing Project Initiation Document, Reference/Domain value mapping. Should be able to work with Business and Architects to identify Pain points impacting data capabilities. Should be able to establish program/project specific Data Analysis approach. Should be competent at Source-Target Data mapping, S/T Record building/ Join conditions, writing transformations building data lineage. Should be able to conduct Peer Reviews. Should be able to support ETL/Test questions, output file validation, defect analysis. Should ensure data analysts (and other data leads, as necessary) are following standard work and best practices. Key Requirements and Technology Experience: Minimum Experience required : 10 Years. 8+ years of progressive experience in the data and analytics, including large customer data bases and work with product, geographic, demographic, customer, prospect, producer, social, machine and unstructured data to identify trends and opportunities), business consulting, or data governance field and/or manipulation of complex high-volume data from a variety of sources. Experience successfully developing and implementing complex data and analytic solutions which meet business needs within tight time frames. Experience in AWS Programming in Python a plus Insurance Domain knowledge Experience with Complex Source to Target Data Mappings Mappings involving different source and target data structure Sound understanding of Data modeling and Database concepts Strong SQL skills Should be able to drive analysis independently with minimal SME support Ability to investigate all aspects pertaining to analysis Our client is a leading Insurance organization and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration. Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. #tel
Informatica Data Analyst erwin SQL Python code-profiling ETL database-theory modeling