SSRS Reports Developer
venkat recruiter
SSRS Reports Developer
Primary Location – Baltimore, MD
V-Soft Consulting is an end-to-end recruiting and staffing solution provider known for our ability to provide highly qualified consultants for any project at any scale.
What makes us different? Our expertise is derived from over 20 years of delivering world-class IT staffing, consulting, engineering and managed services to Fortune 1000 and mid-market companies in the U.S., Canada, and Asia. V-Soft is a trusted partner with experience across diverse technology stacks to help business get IT done.
Like what you hear? Apply with V-Soft today!
V-Soft Consulting is currently hiring for an SSRS Reports Developer for our premier client in Baltimore, MD. This is a multi-year contract position in the health insurance industry.
WHAT YOU’LL NEED:
Education and Experience »
- Requires a Bachelor’s Degree from an accredited college or university in Engineering, Computer Science, Information Systems, Business or another related Discipline
- A Master’s Degree is preferred
- A minimum of 8 years of hands-on experience designing complex queries and reports using SQL is preferred
- A minimum of 8 years of experience in Information Technology systems analysis
- A minimum of 5 years of experience working in a complex IT organization developing a variety of queries and reports utilizing SQL/SSRS
- A minimum of 4 years of experience in creating/maintaining EDI X12 files for transactions sets such as 834, 999 and TA1
- A minimum of 2 years of experience developing queries and reports in the PostgreSQL database environments is preferred
- Experience with the State Based Marketplace solutions and Healthcare IT or Health and Human Services domains is preferred
- Experience in quality assurance, quality control and compliance processes of large scale Healthcare IT Systems is preferred
- Experience working with the Project Management Office (PMO) processes, policies and procedures is preferred
- Experience with transactions sets such as 834, 999 and TA1, SOA, EDI and EAI Applications is preferred
- Experience establishing and maintaining reporting databases and data warehouses
Knowledge, Skills and Abilities »
- In-depth understanding of 834 enrollment transactions, including Adds, Terminations, Cancellations and Life events is preferred
- Extensive knowledge of data sources, data flow, data/system interactions and advanced reports design techniques to develop complex analytical reporting solutions is preferred
- Strong knowledge in the Affordable Care Act (ACA) eligibility rules is preferred
- Knowledge of Medicaid 8001/Interim Database (IDB) file processing is preferred
- Knowledge of Medicaid coverage types, coverage span and eligibility rules is preferred
- Demonstrated ability to develop complex reports utilizing SQL/SSRS is preferred
- Demonstrated ability to manage multiple critical priorities and tight deadlines
- Demonstrated analytical and problem solving skills
WHAT YOU’LL DO:
Job Responsibilities »
- Develop, build and manage complex, operational and federally mandated reports
- Conduct feasibility studies from design, implementation and post-implementation evaluation from a number of possible approaches
- Write a variety of queries in SQL and develop reports in SSRS and/or PostgreSQL
- Identify opportunities for sharing commonly used data internally and externally
- Interpret data analysis to support decision-making by management and strategic planning
- Utilize database applications and analytical tools to evaluate data quality, functions and maintain operations
- Analyze business processes to develop data solutions/reports to meet business, application requirements
- Work in multi-disciplinary teams in a fast paced, technically challenging environment
- Perform Medicaid 8001 Flat File validation and analysis; review multiple MPIs for SSN matching
- Perform HBX System Error analysis, validate 1095-A/1095-B files, and reconcile Medicaid 8001 transactions
- Assist the development team, business operations team and the testing team to analyze, fix, test and transmit 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 HBX database and application to perform root cause analysis for transaction rejections
Thanks,
Venkata Krishna Pondugula | Manager- Recruitments
■ direct 502.792.8436
■ toll free 844.425.8425 ext. 8436
■ vpond...@vsoftconsulting.com