The Analyst II will provide data analytics support with advanced knowledge and techniques in Microsoft Excel and working knowledge of Visual Basic for Applications, Power BI, and Data Analysis Expressions. The Analyst II will query and extract data from multiple databases and management information systems, and apply complex formulas to clean data and perform extensive validation. Use advanced formulas and code to automate procedures and to construct, manage, and enhance visualization dashboards, reports, and related products.
Essential Functions and Job Responsibilities Perform maintenance and troubleshooting for existing MS Excel and Power BI analysis and dashboard productsProvide analytical and data visualization support to develop content and functions for both current and new dashboard and reporting products including but not limited to:Building, organizing, and maintaining interconnected pivot tables, formula-based summary tables, as well as charts, graphs, and other graphical featuresWith instruction and support from WTCHP staff, building, testing, and maintaining complex formulas, as well as VBA code in MS Excel and DAX in Power BI.Provide consultation, guidance, and technical assistance to users of dashboard and reporting products
Organizational Context: This work is for the WTC Health Program only and work will be related to the support the Program’s ability to meet documentation requirements and improve work efficiencies.
Minimum RequirementsMinimum Requirements:
Special Considerations or Requirements: The knowledge, skills and abilities are specific in this task area and shall include:
Advanced knowledge of MS Excel with the ability to construct interactive dashboards using a variety of visual elements and functions including charts, graphs, summary tables, linked shapes and pictures, filters, slicers, and customized buttons.Microsoft Excel formulas used in a standalone context and/or in combined/nested constructions (including but not limited to):INDEX MATCH, VLOOKUP, HLOOKUPSUMIFS, AVERAGEIFS, COUNTIFSAVERAGE, STDEV, MEDIAN, MODETRIMCONCATENATELEN, LEFT, MID, RIGHT, SEARCH, FINDIF AND/ORSUMPRODUCTFORECAST, FORECAST.LINEAR, FORECAST.ETSMicrosoft Excel functions (including but not limited to):PIVOT TABLESCHARTS, PIVOT CHARTSSLICERSCONDITIONAL FORMATTINGDATA VALIDATIONSORT, FILTERSPARKLINESSHEET PROTECTION, WORKBOOK PROTECTIONNAMED RANGESFORM CONTROLSPARSINGMACROSWorking knowledge of Visual Basic for Applications (VBA) with the ability research, develop, and troubleshoot customized automation procedures for a variety of functions including, but not limited to:message boxesfiltering, finding, and replacing cell valuescopying and pasting cell valueshiding/unhiding rows, columns, and worksheetsprotecting worksheets and workbooksopening, closing, and managing interactions between workbooks Working knowledge of Power BI with the ability to research, develop, and troubleshoot interactive dashboards using, but not limited to, the following:Connecting to data from multiple sourcesCleaning and transforming data by trimming, cleaning, splitting columns, removing rows, replacing values, and creating custom columnsBuilding data models bycreating relationships manually and automaticallyresearching, creating, and troubleshooting calculated columnsresearching, creating, and troubleshooting measuresCreating reports using a variety of visualizations, slicers, filters, and visual interactions Working knowledge of Data Analysis Expressions (DAX) with the ability to research, develop, and troubleshoot calculated columns and measures for use in Power BI reports and dashboards Company BenefitsPSI offers full-time, benefits eligible employees a competitive total compensation package that includes paid leave, and options for employer sponsored group medical, dental, vision, short-term and long-term disability, life insurance, AD&D coverage, legal services, identity theft, and accident insurance. Flexible spending account and health saving account options offer pre-tax savings for qualified medical, dental, and vision expenses. The company sponsored 401(k) retirement plan has an employer contribution match that is immediately vested. We invest in the professional growth of our employees through professional courses, certifications, and tuition reimbursement programs.
EEO CommitmentIt is company policy to promote equal employment opportunities. All personnel decisions, including, but not limited to, recruiting, hiring, training, promotion, compensation, benefits, and termination, are made without regard to race, color, religion, age, sex, sexual orientation, pregnancy, gender identity, genetic information, national origin, citizenship status, veteran status, protected veteran status, disability, or any other characteristic protected by applicable federal, state, or local law.
Reasonable accommodations for applicants and employees with disabilities will be provided. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Human Resources by emailing HRDepartment@plan-sys.com, or by dialing 703-575-8400.
Software Powered by iCIMS
www.icims.com