Systems Analyst - Reporting

Role Overview

The Systems Analyst - Reporting will design, develop, and manage complex reports and dashboards using SQL, Tableau, and other tools. The role requires a minimum of 5 years of experience in data extractions, analysis, and report generation. The analyst will work with multi-disciplinary teams to deliver data to internal and external stakeholders.

What You Will Do

Design, develop, and build complex reports and dashboards. Identify opportunities for securely sharing data internally and externally. Interpret data and perform analysis for management decision-making. Utilize database applications and analytical tools to evaluate data quality.

Why It Might Be a Fit

The ideal candidate will have a minimum of 5 years of experience in data extractions, analysis, and report generation. They will have strong communication and collaboration skills, as well as analytical and problem-solving skills. Experience with data visualization, data analysis, and report automation is also required.

Requirements

• A minimum of 5 years of experience performing complex data extractions, analysis, report generation, and dashboard creation.
• A minimum of 5 years of experience working in a complex IT organization developing a variety of queries and custom reports utilizing SQL, stored procedures, and complex queries.
• A minimum of 2 years of experience translating business requirements into effective data visualizations and dashboards.
• Experience in establishing and maintaining reporting databases and data warehouses.
• Knowledge of data modeling, data warehousing, and ETL processes.
• Effective communication and collaboration skills to work with stakeholders and technical teams.
• Demonstrated ability to manage multiple critical priorities and tight deadlines.
• Demonstrated analytical and problem-solving skills.
• A minimum of 8 years of hands-on experience designing complex queries and reports using SQL and Stored Procedures.
• A minimum of 4 years of experience developing queries and reports in the PostgreSQL database environment.
• A minimum of 4 years of experience developing complex reports and dashboards utilizing Tableau, or equivalent.
• Extensive knowledge of data sources, data flow, data/system interactions, and advanced reports design techniques to develop complex analytical reporting solutions.
• Experience with developing reports and dashboards for the health insurance marketplaces, healthcare, or Health and Human Services domains.
• Hands-on experience with data visualization, data analysis, and report automation.
• Experience with web technologies, such as HTML, CSS, and JavaScript.
• Familiarity with programming languages such as Python, Java, or equivalent.
• Knowledge of EDI transaction sets such as 834, 820, and 999.
• Knowledge of Medicaid and Qualified Health Plan (QHP) eligibility rules.
• Knowledge of EDI 834 enrollment transactions, including Adds, Terminations, Cancellations, and life events.

Benefits

• Health insurance
• Paid time off
• Training & development