What are the responsibilities and job description for the Senior System Analyst position at Elegant Enterprise-Wide Solutions, Inc.?
Minimum Qualifications
- A minimum of five (5) years of experience performing complex data extractions, analysis, report generation, and dashboard creation.
- A minimum of five (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 five (5) years of experience developing various reports and dashboards utilizing reporting tools such as Tableau, or PowerBI.
- A minimum of two (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.
Preferred Qualifications
- A minimum of eight (8) years of hands-on experience designing complex queries and reports using SQL and Stored Procedures.
- A minimum of four (4) years of experience developing queries and reports in the PostgreSQL database environment.
- A minimum of four (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.