What are the responsibilities and job description for the Senior Systems Analyst (Reporting & Data Analytics) position at Metalight Solutions Inc?
Job Title: Senior Systems Analyst (Reporting & Data Analytics)
Location: Baltimore, MD (Hybrid)
Duration: Long-Term Contract
Job Summary
We are seeking an experienced Senior Systems Analyst (Reports & Data Analytics) to support the Client. The ideal candidate will have strong expertise in SQL, PostgreSQL, Tableau/Power BI, reporting, dashboard development, data analysis, and healthcare-related EDI transactions.
The selected consultant will work closely with business, development, testing, and operations teams to develop complex reports, analyze data, troubleshoot system issues, and support healthcare enrollment and Medicaid-related data exchanges.
Required Skills
- 5 years of experience in:
- Complex SQL development
- Data extraction and analysis
- Report generation and dashboard development
- Tableau and/or Power BI
- Strong experience with:
- SQL Queries
- Stored Procedures
- PostgreSQL
- Data Warehousing
- ETL Processes
- Data Modeling
- Experience translating business requirements into dashboards and visualizations
- Strong analytical and problem-solving skills
- Experience working with stakeholders and cross-functional teams
Preferred Skills
- 8 years of advanced SQL reporting experience
- 4 years of PostgreSQL experience
- 4 years of Tableau development
- Healthcare, Medicaid, Health Insurance Exchange, or Health & Human Services experience
- EDI transaction experience (834, 820, 999)
- Enrollment processing knowledge
- Medicaid eligibility rules
- QHP (Qualified Health Plans)
- Master Data Management (MDM)
- Member Person Index (MPI)
- Report automation
- Python or Java
- HTML, CSS, JavaScript
Day-to-Day Responsibilities
- Develop complex reports and dashboards
- Create SQL queries and data extracts
- Perform healthcare data analysis
- Validate Medicaid 8001 flat files
- Analyze EDI transactions
- Investigate enrollment issues
- Support production data reconciliation
- Conduct root cause analysis of data errors
- Work with development, testing, and operations teams
- Maintain reporting databases and reporting solutions
Salary : $50 - $60