W2 Only - Business Intelligence Developer

Job Title: Senior Health Intelligence Programmer - Cognos Location: Remote Position Type: Contract position Working Hours: As per EST timings Responsibilities: Manager Notes: The key is - technical skills with Cognos, SSRS and Power BI, the manager is looking for someone with great communication and soft skills. This person will interact with Ops directors & VP’s to understand their needs and accordingly plan deliverable and comply with the need. Responsibilities: • Responsible for designing, developing reports, analyzing raw data and identifying data and report discrepancies and deploying Enterprise and External Client grade critical Reports. • Responsible for administering, configuring, managing and monitoring reporting platforms, security, processes, identifying and troubleshooting issues, managing upgrades. • Responsible for managing report security, access, archival, retention, assistance in audits. • Collaborate with various function teams such as operations, marketing, research, and IT to achieve business results. • Prepare accurate and relevant reports that provide insight regarding key points for leadership and clients. • Able to independently profile data and test output and, produce support documentation. • Research data discrepancies, performance and troubleshoots SQL Code, underlying transformations, SSIS Packages, views, stored procedures. • Utilize reporting methodology to communicate needs to Data Analysts for report programming • Communicate the results of data analysis in written and verbal form to managers and changes in financial and business trends for leadership decision making. • Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules. • Mentor Juniors, Train peers and, adopt and share Best Practices with the team. • Able to communicate with stakeholders, manage expectations and prioritize deliverables. Required Qualifications: • Requires a bachelor’s degree and 4-5 years of relative experience, or an equivalent combination of education and experience. • Requires High proficiency in SQL, well-developed analytical skills especially in Database. • Requires High proficiency in Cognos Reporting Tool, Framework Manager and Cognos Server Administration. Additional tools preferred - SSRS, Power BI, Tableau • Requires experience in data architecture, data modeling and performance tuning • Requires High Proficiency with tools – Toad, DBeaver, Workbench, SSMS, SSAS, SSIS • Requires Proficiency in Story Telling via Data Visualization and User Experience Design. • Requires strong organizational and multitasking skills, and the ability to meet time-sensitive deadlines. • Experience in working on Data Warehouse or similar data repository environments. • Intermediate to advanced knowledge of Excel is required. Preferred Qualifications: • Master's degree preferred • General knowledge of business operations, programs, outcomes, system inputs and outputs to support accurate reports to clients. • Prior experience working with healthcare claims, utilization / case management data • Knowledge or Experience in Healthcare domain or industry • Familiarity with Visual Studio and TFS/Azure DevOps source control. • Familiarity with agile methodology. • Experience supporting ETL development. • Experience in scripting languages - Unix/Shell, Python, etc. • Experience with development methodology – Agile, SDLC in regulated industry