Government Informatics Consultant - Qlik Developer

Company: Mercer Description: Mercer is currently recruiting for a Government Healthcare Informatics Consultant – Qlik Developer to work in one of the following offices: Phoenix, Atlanta, Washington DC or Minneapolis. Government Healthcare Actuarial Consultant – Qlik Developer What can you expect? Be a part of the team that leverages our knowledge and expertise to help states manage the challenges and complexities of the health care world What is in it for you? Be on the cutting edge of health care reform. Mercer GHSC partners with states and the Federal government on implementing a wide variety of health care and human services issues, including actuarial, data/systems analysis, clinical, policy, pharmacy, operations, and procurement On day one you'll be eligible for medical, dental, and vision care benefits in addition to a generous PTO package, as well as time off for community service We will count on you to: Work closely with Business Intelligence (BI) architects to gather and document required BI system requirements Translate business requirements into specifications that will be used to develop data objects and/or framework ensuring business smart resource allocation Extract, transform and load data into QlikView/Sense applications (requires data modeling across multiple data sources) Develop, test, debug QlikView/Sense applications & Nprinting Reports Develop extensions in Qlik Sense, including JavaScript and D3, tune data loads and QlikView/Sense application for efficient performance Work on mashups & deploy Qlik applications on custom portals (.Net applications preferred) Utilize Qlik's in-memory data discovery architecture and advocate and communicate adherence to Qlik's best practices and standards Provide support as required to ensure the data availability and performance of enterprise data and BI environments for both external and internal users Provide technical assistance and cross training to other team members as needed What you need to have: Bachelor’s degree in Science, Math, or Engineering Developing BI solutions in the QlikView/Sense or similar technologies Experience working in Data Warehouse environments reporting on dimensions/hierarchies with experience in Star Schema/Snowflake modeling, Fact & Dimensions tables; Solid experience developing complex Qlik data models Strong knowledge using set analysis and set expressions and creating data load scripts in data load editor to develop in Qlik Sense, HTML, JavaScript, CSS, VB, and JSON Utilizing scripting language to meet complex business requirements Require strong analytical, conceptual, and problem-solving abilities What makes you stand out: Utilizing QlikView Publisher capabilities Extensive use of SQL RDBMS (Oracle, SQL Server, etc.), Data warehouse & Hadoop/Big data systems & performance tuning experience required Extensive use of ETL tools like SSIS/Informatica/Snaplogic etc Excellent planning and organizational skills with good communication and interpersonal skills are desired Ability to perform and contribute in a strong team environment & to manage multiple priorities Mercer believes in building brighter futures by redefining the world of work, reshaping retirement and investment outcomes, and unlocking real health and well-being. Mercer’s more than 25,000 employees are based in 44 countries and the firm operates in over 130 countries. Mercer is a business of Marsh & McLennan (NYSE: MMC), the world’s leading professional services firm in the areas of risk, strategy and people, with 76,000 colleagues and annual revenue of $17 billion. Through its market-leading businesses including Marsh, Guy Carpenter and Oliver Wyman, Marsh & McLennan helps clients navigate an increasingly dynamic and complex environment. For more information, visit https://www.me.mercer.com/. Follow Mercer on Twitter @Mercer. Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers. The applicable base salary range for this role is $62,600 to $125,300. The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives. We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs. Click here to return to the MMC Careers Site Marsh McLennan (NYSE: MMC) is the world's leading professional services firm in the areas of risk, strategy and people. The Company's 76,000 colleagues advise clients in over 130 countries. With annualized revenue approaching $17 billion, Marsh & McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. Marsh advises individual and commercial clients of all sizes on insurance broking and innovative risk management solutions. Guy Carpenter develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. Mercer delivers advice and technology-driven solutions that help organizations meet the health, wealth and career needs of a changing workforce. Oliver Wyman serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit mmc.com, follow us on LinkedIn and Twitter @mmc_global or subscribe to BRINK.