*Hi,*
*Hope you are doing good* *Please let me know if you have anyone available for below position* *Data Warehouse Expert* *Richmond, VA 23219* *12+ Months* *F2F Interview * This is a unique role where you will be assisting with the implementation and development of data warehouse-based solutions as part of the Data Warehouse Team. The team is comprised of both State and contracted workers and includes project managers and State subject matter experts as well as Teradata and web developers, data modelers, DBAs, business analysts, report developers, and help desk analysts. You will support the development and management of the agency data warehouse, including, but not limited to, public and secured data applications, ETL tools, and relational databases. Additionally, you will be responsible for designing and developing SQL which will be used by analysts to interact with agency data in a Teradata environment. Primary Responsibilities: • Gather and analyze business requirements • Complete inventory of all Agency data sources and business processes from an IT perspective • Review the data warehouse infrastructure design and offer solutions • Review the MMIS infrastructure design and offer suggestions and insight to vendor • Review the infrastructure designs of MES components and analyze the impact of each on the data warehouse solution • Assist with the review of all technical specifications and design documents associated the data warehouse solution • Review and test the integration of data in the data warehouse/data marts and Business Intelligence solutions • Communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector. • Able to work independently • Excellent communication, time/project management, problem solving, organizational, and analytical skills required. Required Qualifications: • Bachelor’s degree or equivalent work experience • 5+ years experience with Medicaid, Medicare or other health systems • 5+ years technical business analyst experience in a data warehouse project environment • 5+ years working with end users/customers to understand and develop requirements for technical solutions to meet business needs • 5+ years analyzing project requirements and developing detailed technical specifications • 5+ years working with technical developers to strategize solutions to align with business requirements • 5+ years recent Teradata experience • 5+ years administering SAS in a Unix/Linux environment • 3+ years facilitating customer requirements gathering meetings/sessions/JAD Sessions • 3+ years working knowledge of relational databases/database structures • 3+ years experience with Requirements Traceability • 3+ years experience with BI reporting tools • 3+ years developing test data and test scenarios • Experience with SAS In-Database processing with Teradata Preferred Qualifications: • Knowledge of MMIS architecture • Ability to design applications taking into consideration data reconciliation, query/reporting performance, and analytical business value. • Business Analyst experience in a state government environment • Experience with Teradata SQL Assistant • Experience using Teradata Utilities • Experience with implementing SAS/Teradata interfaces • Experience using ERWin for data modeling • Open Text BI Query experience *Required / Desired Skills* Skill Required / Desired Amount of Experience Bachelor’s degree or equivalent work experience Required experience with Medicaid, Medicare or other health systems Required 5 Years years technical business analyst experience in a data warehouse project environment Required 5 Years working with end users/customers to understand and develop requirements for technical solutions to meet business needs Required 5 Years years analyzing project requirements and developing detailed technical specifications Required 5 Years years working with technical developers to strategize solutions to align with business requirements Required 5 Years recent Teradata experience Required 5 Years administering SAS in a Unix/Linux environment Required 5 Years facilitating customer requirements gathering meetings/sessions/JAD Sessions Required 5 Years working knowledge of relational databases/database structures Required 5 Years Requirements Traceability Required 5 Years BI reporting tools Required 5 Years developing test data and test scenarios Required 5 Years SAS In-Database processing with Teradata Required 5 Years Knowledge of MMIS architecture Highly desired Ability to design applications taking into consideration data reconciliation, query/reporting performance, and analytical business value. Highly desired Business Analyst experience in a state government environment Highly desired Experience with Teradata SQL Assistant Highly desired Experience using Teradata Utilities Highly desired Experience with implementing SAS/Teradata interfaces Highly desired Experience using ERWin for data modeling Highly desired Open Text BI Query experience Highly desired Thank you. *______________________________________________________________________* *Praveen kumar* Senior Technical Recruiter, *AuroPro Systems Inc* 609 897-1024 X 205 609 964 0577 609 897-1025 666, Plainsboro Road, Suite 220, Plainsboro, NJ 08536 www.auropro.com prav...@auropro.com <prad...@auropro.com> We at AuroPro Systems firmly oppose to e-mail "spamming". We apologize to those who do not wish to receive this e-mail and also to those who have accidentally received it again. Our database is updated online and all removals will be handled immediately. Please reply with REMOVE in the subject listing, with all aliases email addresses that you would want removed and any inconvenience caused is highly regretted. We appreciate your patience and cooperation *Please do not print this email unless it is absolutely necessary* *(Reduce || Reuse || Recycle)* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
