*Dear Candidate,* *We have an urgent opening for and I have sent you a job description please go through it and let me know if you are comfortable with it and also send me your consultant's updated. *
*Title:- ETL developer* *Location : Long Beach CA * *Mode:- Skype* *Duration:- 4month +* *Rate $-47 /hrc2c* *Job Desc. ( I would not worry about the ETL Piece ) * *I would prefer them local but if they are not I would say make sure they have healthcare. * *Working hours: Monday To Friday (8 AM -5 PM) • Length of assignment? 6 Months (With possible extensions) • Interview process: In Person Have SQL programming (biggest must have for the manager) must have good soft skills, running with meetings and work with stakeholders to resolve problems and give real time expectations Healthcare (ACA) and Medicare background is best Job Summary The Business Ops/Data Analyst provides expertise in the process of screening, framing and modeling business requirements and ideas for process enhancements, process improvements, and/ or cost savings. Determines best practices and makes recommendations on improving current practices and processes. Responsible for organizing and documenting requirements into Business Requirements Documents (BRDs) and Report Requirements Designs (RRDs). Develops recommendations to solve problems and issues related to business operations. Generally works on large scale projects of significant complexity. Accountable for delivering work products that meet business needs. Business Ops team is seeking an experienced Data analyst to join our team of qualified, diverse individuals. This is an excellent opportunity for an experienced professional to work with cross functional teams of business domain experts, software developers, data architects, solution analysts, testers, and trainers. Responsibilities/Essential Functions • Minimum 3 to 5 yrs of current and hands-on experience with ETL design, development & performance tuning. • Participate in JAD sessions for gathering and defining data conversion and ETL rules requirements. • Review designs with data conversion team members. • Provide accurate and efficient ETL transformations from mainframe and distributed systems to new web-based applications. • Ability to work during peak data conversion periods. • ACA and health insurance exchanges knowledge and experience preferred • Minimum 3 to 5 yrs of current and hands-on experience with SQL and Relational DB and SQL Query performance tuning. • Create analytical tools necessary to support Operational analysis and ad hoc reports as required. • Experience with building web based systems with real time capabilities. • Demonstrate ownership, innovation, and focus on delivering results. • Conducts and facilitates JAD sessions to develop and coordinate the requirements, specifications, design, and testing efforts for medium to large projects. • Analyzes and updates existing BRD’s/FRD’s annually or as requested. • Analyzes business workflows/system needs for new features and enhancements; assists in data mapping. • Reviews, analyzes, and evaluates business processes for improvement or enhancement as needed. • Recommends promotion of software to production based on satisfactory test result. • Supports or leads the process of screening, framing and modeling ideas that capture business requirements. • Defines and documents business and IT system processes and workflows. Models AS-IS and TO-BE processes. • Develops and executes test strategies, plans, scenarios, and tracks resolution to identified defects. • Prepares documentation and training materials for various audiences. • May lead and/or mentors other business analysts and data analysts Conducts gap analysis and uses analytical skills to identify root cause and assist with problem management. JOB DESCRIPTION JOB TITLE – Business Ops/ Data Analyst continued Knowledge/Skills/Abilities • Demonstrated understanding of Software Development Life Cycles (SDLC). • Intermediate level of knowledge in Microsoft applications (Word, Excel, MS Project, PowerPoint, Visio) and SharePoint. • Good level knowledge: SQL/VB, Crystal Reports, Access, and Relational Database tables and tools. • Ability to articulate an appropriate course of action based on reading standard project documentation (charter, work plan). • Understanding of government healthcare programs such as Medicare and Medicaid is helpful. • Ability to document business analysis deliverables such as requirements, workflow diagrams, and testing documentation. • Ability to work independently, as a team member, or a team leader. • Ability to multi-task skills and prioritize workload. • Excellent verbal and written communication skills. • Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA). • Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers. • Background in compliance reporting with experience in gathering requirements and building specifications for compliance reporting (e.g., State Departments of Health, MMP and/or CMS). Required Education: Bachelor’s Degree or equivalent experience Required Experience: • Minimum 3 yrs of current and hands-on experience with ETL design, development & performance tuning. • Minimum 3 yrs of Operational analysis, Reporting, SQL. • 6+ years’ experience with increasing responsibilities as a business analyst with experience leading teams a plus • 4+ years’ experience with health care payer organizations and particularly business operations Preferred Experience: • 4+ years of managed care experience • 2+ years Medicaid/Medicare/Exchanges experience • 2+ years exposure to health plan operations including member enrollment, billing, reconciliation, and issues resolution a plus • 2+ years compliance reporting – gathering requirements and building specifications for compliance reporting (e.g., State Departments of Health, MMP and/or CMS).* [image: logo] *Rohit Bhasin |* lead Recruiter | Apetan Consulting LLC Tel: 201-620-9700* |121| Fax:2015266869 | *Mail *: 72 van reipen ave pmb#255, Jersey City, NJ 07306| *Corp. Office:* 15 Union Avenue, office # 6, Rutherford, New Jersey 07070| ro...@apetan.com| www.apetan.com | *“Forget all the reasons why it won’t work and believe the one reason it will work**"* [image: https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png] <http://www.facebook.com/Apetanconsulting> [image: https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png] <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> [image: https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png] <http://twitter.com/ApetanLLC> [image: e verify] *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@apetan.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at https://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.