Sign upLog in

Senior Systems Analyst - Reports

22nd Century Technologies, Inc.

Baltimore, MD

Apply
JOB DETAILS
SKILLS
Analysis Skills, Automation, Business Analysis, Business Processes, CSS (Cascading Style Sheet), Change Control, Change Requests/Orders, Communication Skills, Cross-Functional, Data Analysis, Data Modeling, Data Processing, Data Quality, Data Visualization, Data Warehousing, Database Administration, Database Analysis, Database Extract Transform and Load (ETL), Department of Health and Human Services, Develop Methodologies, Electronic Data Interchange (EDI), HTML (HyperText Markup Language), Health Insurance, Health Plan, Healthcare, Healthcare Administration, Information Technology & Information Systems, Internet Technology, Java, JavaScript, MPI, Master Data Management (MDM), Medicaid, Multitasking, Operations Management, Policy Development, PostgreSQL, Power BI, Problem Solving Skills, Process Analysis, Programming Languages, Project/Program Management, Python Programming/Scripting Language, Reporting Dashboards, Reporting Skills, Requirements Management, Root Cause Analysis, SQL (Structured Query Language), Stored Procedures, Systems Analysis, Tableau, Team Player, Technical Delivery, Time Management
LOCATION
Baltimore, MD
POSTED
6 days ago
Project Background
The Maryland Health Benefit Exchange (MHBE), an independent unit of state government, provides accessible, affordable health coverage to Marylanders. MHBE administers Maryland Health Connection (MHC), the state's health insurance marketplace. Through MHC, Maryland residents explore health insurance plans, compare rates, and determine their eligibility for advanced premium tax credits (APTC), cost-sharing reductions (CSR), and public assistance programs such as Medicaid and the Maryland Children's Health Insurance Program (MCHP).

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.
  • Note: The candidate must be flexible to work overtime as needed, including weekends, holidays, and off-hours.
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.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

About the Company

2

22nd Century Technologies, Inc.

22nd Century Technologies, Inc., is one of the fastest growing IT Service Integrator and Workforce Solution companies in the United States. Founded in 1997, 22nd Century Technologies is a Certified National Minority Business Enterprise with 6,000+ people including 600+ Cyber SMEs nationwide supporting our customers in all 50 states, Canada, and Mexico. With HQs in Somerset, NJ and Mclean, VA, 22nd Century has 14 offices throughout the United States. As part of our unrelenting focus on quality and compliance, 22nd Century Technologies’ delivery is based on Certified Matured Processes including CMMI L3 Dev & SVC, ISO 20000, ISO 27001, and ISO 9001 quality processes. With a strong focus on the public sector, 22nd Century currently holds government contracts with 14 out of 15 Federal Executive agencies including DoD, 37 other Federal agencies, 50 States, 115+ Local agencies, and 37 School Districts. In the last three years, we have expanded our services to Fortune 500 and other commercial clients and currently support 80+ commercial clients.

Recognized among “Best Company to Work For” by Forbes, 22nd Century Technologies, Inc., consistently exceeds our clients’ expectations by focusing on their absolute satisfaction with jobs while keeping our employees motivated.

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

COMPANY SIZE
100 to 499 employees
INDUSTRY
Computer/IT Services
FOUNDED
1997
WEBSITE
https://www.tscti.com/careers-0

Resume Resources

Free Resume TemplatesFree Resume Builder