Software Developer II, Business Intelligence - Medical Management
About The Position
PacificSource is seeking a Software Developer II to provide information system solutions to internal departments and external customers and partners. The role analyzes requirements and business processes, recommends solutions, and implements or integrates purchased applications while developing applications and integrations when appropriate. Work is performed with cross-functional teams of IT peers and business partners, with an emphasis on managing time and expectations and maintaining stakeholder and user satisfaction. The position develops and supports business intelligence reporting and data solutions, including standardized parameterized reports, multidimensional models, and reporting tools. It also analyzes, develops, configures, tests, and maintains mission-critical applications, web portals, and databases; troubleshoots system and reporting issues; and advises on improvements to system efficiency, security, functionality, data quality, and business processes. The role prepares specifications and project documentation, communicates status and milestones, trains users, and contributes to vendor selection and relationship management. The work takes place inside a general office setting with ergonomically configured equipment. Travel is required approximately 10% of the time. PacificSource describes itself as an equal opportunity employer and emphasizes diversity, customer service, teamwork, improvement, social justice, equity, diversity and inclusion, creativity, and excellence.
Requirements
- Minimum of 3 years of software development and analysis experience in a business environment.
- Bachelor’s degree in Computer Science or an equivalent combination of upper-level education and experience.
- Programming experience in VB.NET, ASP.NET, and C#.
- Advanced experience with databases, SSIS, and SQL stored procedures.
- Technical experience may include debugging, software installation, programming development tools, Transact-SQL, flowcharting, and documentation.
- Basic knowledge and use of the MS Office suite.
- Experience with MS Visual Studio and MS SQL Server Management Studio.
- Ability to read and comprehend written and spoken English and communicate clearly and effectively.
- Ability to meet the physical requirements of the role, including stooping and bending, extended sitting or standing, repetitive typing, sorting and filing, and light lifting and carrying.
Nice To Haves
- Commercial, Medicaid, and/or Medicare healthcare insurance industry systems experience.
- Experience with Epic Payer Platform/Tapestry.
- Experience with Databricks.
- Experience with TriZetto Facets.
- Technical integration and implementation experience.
- Database administration experience.
- EDI experience, including ANSI X12 formats.
- Project management experience.
- Experience integrating enterprise-wide applications.
- Knowledge of Microsoft SQL Reporting Services/BI DS and Microsoft SQL Analysis Services/BI DS.
- Knowledge of Microsoft Power Suite, including Power BI, Power View, and Power Pivot.
- Knowledge of Microsoft Master Data Services and Data Quality Services.
- Knowledge of Microsoft SQL Server Integration Services, Tableau, and MDX (Multidimensional Expression).
Responsibilities
- Develop standardized parameterized reports using commercial off-the-shelf reporting tools and multiple data sources.
- Support end users in using reports and reporting tools.
- Participate in data quality improvement by recommending simpler data structures and improved information quality.
- Identify operational improvement and waste-reduction opportunities using LEAN methodology.
- Troubleshoot and resolve reporting issues, data inconsistencies, scheduling issues, and query-performance problems.
- Keep current with business intelligence trends, best practices, and technologies, and make recommendations to the technology planning team.
- Design and implement multidimensional models or cubes to meet business requirements.
- Analyze and evaluate existing or proposed systems, develop and configure applications and web portals, and assess user requirements.
- Work with other IT staff to improve system efficiency, security, and functionality.
- Identify, diagnose, and resolve system problems and provide troubleshooting support to other staff.
- Design and apply methods and procedures; develop and test systems, programs, and database structures for efficiency and effectiveness.
- Prepare system specifications, project plans, and other internal documents.
- Communicate the nature of work, timeframes, and milestones to users and partners, and provide regular status updates to supervisors and stakeholders.
- Train users in technical aspects of systems.
- Participate in supplier and vendor selection and recommendations, and assist in managing those relationships.
- Balance high-priority project work with lower-priority maintenance to support project delivery and ongoing operations.
- Proactively identify system and process improvement opportunities and work with management and stakeholders to prioritize and implement solutions.
- Meet department and company performance and attendance expectations.
- Follow PacificSource privacy policy and HIPAA requirements for confidentiality and security of protected health information.
- Perform other duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
