Matrix Systems and Technologies, Inc

Systems Analyst - Reporting

Matrix Systems and Technologies, Inc  •  $70k - $105k/yr  •  Baltimore, MD (Onsite)  •  4 hours ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Benefits:
  • Health insurance
  • Paid time off
  • Training & development
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.
  •  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.
Duties/ Responsibilities:
  • Design, develop, build, and manage complex, operational, and federally mandated reports.  
  • Identify from design, implementation, and post-implementation evaluation a variety of possible approaches for generating reports, dashboards, and data extraction requirements.  
  • Write a variety of complex queries in SQL for data extractions and develop reports in Tableau, and other tools using PostgreSQL and other databases as data sources.  
  • Identify opportunities for securely sharing commonly used data internally and externally.  
  • Interpret data, and perform data analysis for management decision-making, policy formulations, and review.  
  • Utilize database applications and analytical tools to evaluate data quality, and functions and maintain operations. 
  •  Analyze the business processes to develop data solutions, reports, and dashboards to meet reporting requirements.  
  • Work with multi-disciplinary teams in a fast-paced, technically challenging environment delivering data to various internal and external stakeholders.  
  • Perform Medicaid 8001 Flat File validation and analysis, review multiple Member Person Index(MPI) for SSN matching and Master Data Management (MDM) matching.  
  • Perform HBX System Error analysis, validate 1095-A/1095-B files, and reconcile Medicaid 8001 transactions.  
  • Assist the development team, EDI operations team, and testing team in analyzing, fixing, testing, and transmitting EDI files on a daily basis.  
  • Create data change requests to fix consumer or system-reported errors, coordinate with technical and business teams to analyze error reports, and access the HBX database and application to perform root cause analysis for transaction rejections.  
  • Adhere to all security, change control, and MHBE Project Management Office (PMO) policies, processes, and methodologies.  

Compensation: $70,000.00 - $105,000.00 per year


 
Matrix Systems and Technologies Inc., is a leading information technology solutions provider based in the Washington, DC metro area. 

We have provided services in full life-cycle engineering analysis, strategic planning, testing and process management for clients across the North-eastern corridor since 1996. Our client base includes; The State of Maryland, Maryland State Department of Education, Prince George’s County Maryland, IRS, Northrop Grumman, Computer Sciences Corporation, SAIC, Lockheed Martin, American University, and the Department of Health and Human Services. 


Matrix Systems and Technologies, Inc

About Matrix Systems and Technologies, Inc

Matrix Systems and Technologies Inc., is an information technology solutions provider based in the Washington, DC metro area, where we have provided full life-cycle services since 1996.

In our mission to strive for excellence, we invest in cultivating our talented workforce to ensure we provide industry best practices and excellent customer service. We are committed to understanding your organizational and business needs to offer innovative solutions that will optimize your performance levels, increase Return on Investment and maintain a competitive advantage. Our relentless drive to integrate talent and innovation to meet your needs makes Matrix Systems and Technologies a great partner you can count on to solve your most complex technology needs.

As an innovative leader, Matrix Systems and Technologies has developed a Center of Excellence program to brand our key services in the areas of: Total Quality Testing (TQT), Best Practice Integration and Targeted Staff Augmentation.

Total Quality Testing

Under our Center of Excellence testing program, we have supported the implementation of over $6.5 billion dollars of systems to production and branded a comprehensive TQT process that supports the full test life-cycle on mainframe to mobile applications for both independent and in-line testing.

Best Practice Integration

It is our goal to implement Best Practice Integration that continuously drive improvement so your organization function at an optimal performance level.

Targeted Staff Augmentation

Because of Matrix Systems and Technologies’ commitment and understanding of your technical, organizational and business needs, we hand pick and retain the industry’s most seasoned, certified experts to solve for and handle your most complex IT needs. With our Targeted Staff Augmentation brand we guarantee that your organization will be quickly equipped with the best staff in the industry, primed to help you achieve your project goals.

Industry
Unknown
Company Size
1-10 employees
Headquarters
Upper Marlboro, MD
Year Founded
1996
Website
msandtinc.com
Social Media