About Moser

For more than 25 years we have formed partnerships and grown through open and honest collaboration with our clients, partners, and employees. We are best known for taking great care of our clients, our dedication to creating a work environment where employees do their best work, and our deep commitment to continuous improvement. Our consultants work in a collaborative and fast-paced environment, are self-motivated, and are passionate about evolving technology. It is no accident that we are recognized as one of the Best Places to Work in Indiana for 10 consecutive years.

Internally, we believe in building strong teams from the top down with a focus on values in our Model-Coach-Care philosophy. Our leadership are encouraged and trained to model good practices, mentor other employees and each other, and show empathy and caring in all interactions. This is the base of our core values: Accountability, Balance, Collaboration, Focus, Integrity, Social Responsibility, Support and Transparency.

Moser Consulting believes in equal opportunity for all people and is committed to enabling a diverse, equitable, and inclusive culture. We foster a spirit of unity that respects the remarkable individuality of everyone's culture, history, and service.

Description

• 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 QlikSense, 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.
• The candidate must be flexible to work overtime as needed, including weekends, holidays, and off-hours.

Requirements

• 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, QlikSense, 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.
• The candidate must be flexible to work overtime as needed in the Baltimore, MD office, including weekends, holidays, and off-hours.

Preferred

• 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, QlikSense, 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.

Where You'll Work

The candidate will be expected to work onsite in the Baltimore, MD area, at least 3 days a week.

Benefits

For more than 25 years, Moser Consulting has been the go-to source for exceptional IT talent with the ability to self-manage. At Moser Consulting, our people are our #1 asset. We hire the best people, welcome them like family, connect them with opportunities, and let them do what they do best: produce innovative solutions to technology problems.

Our culture gives us a competitive advantage by keeping our employees happy, healthy, and by lowering stress levels in a very demanding industry. It is no accident that we are recognized as one of the Best Places to Work in Indiana. We focus on giving employees: an incredible work space; a fun, collaborative, and creative atmosphere; an extremely generous compensation package; and dozens of outstanding and unique perks usually not found at one company.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.