PS-Application Developer IIIEngagement Description - A brief description of the project or initiative. Includes:1. Applies project management skills to ensure timely delivery of assigned projects of own work2.
Collaborates with Business Analytics Services, Strategic Informatics, and Business Analytics Operations in the development of analytic plans, identification of data sources and specifications, execution of programming, and review of resultsPossesses a working knowledge of administrative medical claims, relational databases, and primary data marts, defining code lists for diagnoses/procedures, and deriving variables required for analyses3. Applies a continuous improvement mindset of quality and optimization in all project workWrites efficient and well-documented queries for data extracts and programmed analysesIdentifies opportunities for improvement in departmental processes that ensure high-quality deliverablesAdheres to departmental and enterprise data standardsIdentifies opportunities for automation and executes them in individual project work4. Partners with various areas of HCV and IT to author comprehensive business requirements for data feeds/transfers, funded corporate projects for HCV, vended software solutions, and enhancements to internal foundational data sources, in accordance with IT delivery processesOnce established, works with IT and vendors to execute data exchange to the established requirementsExecutes UAT of IT or vendor-provided solutions, ensuring compliance with business requirements5.
Serves as a subject matter expert in at least one of the following areas: stakeholder area portfolio, observational data methods, statistical modeling, departmental data sources, software, IT, lines of business, or health research specialty.Top 3 Required Skills/Experience:3-5 years of progressive work experience working in SQL Server environmentsHas a broad level of understanding surrounding information systems and application architecture standardsDemonstrated ability to analyze and interpret complex problems or processes that span multiple business areas, identify and understand requirements, and develop alternate solutionsRequired Skills/Experience:Experience designing, developing and testing applications using proven or emerging technologiesAdvance SSIS, SSMS, and T-SQL working knowledgeKnowledge of data warehousing and data mining concepts including but not limited to ETL, datamart design, fact tables, dimension tables, data views within data marts/data warehouses, olap, rolap and data models such as star schemas and snowflake schemasPreferred Skills/Experience:Knowledge of healthcare terminology, plan/benefit design and fundamental operational principles and administrative claims data including standard coding schemes such as ICD-9/10 and HCPCSAbility to communicate effectively with IT and business team membersAbility to recognize data patterns, quantify potential issues and identify solutionsAbility to standardize, harmonize, clean, prepare and use data for developing datasets, reporting, and analysisAbility to effectively document STM and ERDEducation/Certifications:Bachelor degree required in a related field such as Computer Science, Engineering, or FinanceMaster degree preferred in a related field such as Computer Science, Engineering, or FinanceFounded in 2007, InterSources Inc is a Small Business Enterprise (SBE), Minority Business Enterprise (MBE) & Women-Owned Small Business (WOSB) Certified Company specializing in providing IT Consulting, IT Staffing Solutions, and Software solutions. We have been recipients of Various Awards under "Fastest Growing IT Consulting and Software Company " and "Excellence in Technology Services "