Government Informatics Consultant - Qlik BI Developer

Company: Mercer Description: Mercer Health & Benefits, LLC is seeking candidates for the following full-time position based in the Raleigh, NC office (A hybrid work schedule may be permitted within a commutable distance from the worksite, in accordance with company policies.): Government Informatics Consultant - Qlik BI Developer We will count on you to: Create, test, and debug QlikView/Sense analytics dashboards and Nprinting Reports. Create custom extensions in Qlik Sense, including JavaScript and D3, maintain data loads and QlikView/Sense dashboards and reports for efficient performance and timely data updates. Work closely with Business Intelligence (BI) architects to gather and document required BI system requirements. Document BI report requirements and technical specifications with input/output technical design. Translate business requirements into specifications that will be used for consistent reporting and metadata enhancements. Extract, transform and load data into QlikView/Sense tools (requires data modeling across multiple data sources). Utilize Qlik's in-memory data discovery architecture and advocate and communicate adherence to Qlik's best practices and standards. Provide technical 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: Must have a Bachelor's degree or foreign equivalent in Engineering (any) or a related field plus three (3) years of experience in the position offered or a related position. Must have three (3) years of experience with all of the following: Developing BI solutions using QlikView and Qlik Sense; Working in Data Warehouse environments, reporting on dimensions/hierarchies with experience in Star Schema/Snowflake modeling and Fact & Dimensions tables; Developing complex Qlik data models; 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; Utilizing QlikView Publisher capabilities; Using SQL RDBMS (Oracle and SQL Server), data warehouse, and Hadoop/big data systems and performance tuning; Using ETL tools including SSIS, Informatica, and Snaplogic. #LI-DNI Mercer is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information about Mercer, visit mercer.com, or follow us on LinkedIn and X. Marsh is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, veteran status (including protected veterans), or any other characteristic protected by applicable law. If you have a need that requires accommodation, please let us know by contacting [email protected]. Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one "anchor day" per week on which their full team will be together in person.