BI Sr. Developer Cognos, OptumInsight - Telecommuter
January 10, 2018
Eden Prairie, Minnesota
No industry is moving faster than health care. And no organization is better positioned to lead health care forward. We need attention to every detail with an eye for the points no one has considered. The rewards for performance are significant. You'll help improve the health of millions. And you'll do your life's best work.(sm) The primary role of the senior developer / lead is to translate the business requirements into scalable design and technical specifications and develop effective and high quality technical solutions that meet the business requirements. The technical domain of the BI Senior Developer includes understanding Business Intelligence (BI) best practices, tools and technologies, security in the environment, understanding of different data warehousing and dimensional modelling concepts, BI development, performance tuning and support system testing. Primary Responsibilities:Ability to work closely with Business Analysts and SMEs to understand business needs and help define requirements for reporting solutions Experienced in delegating and coordinating development and testing in an onsite - offshore delivery model Experience in leading a geographically dispersed team of 5 - 10 resourcesAbility to design and build reporting semantic layer using Cognos cubes, Business Object Universe and / or other similar BI tool capabilitiesProficient in designing and creating reports primarily using Cognos and Microsoft SSRS Expertise in other BI Tools like Microstrategy and Business Objects preferredFamiliarity with ETL tools like SSIS, Informatica and Data StageFamiliarity with Data Visualization tools like TableauAbility to design, develop and deploy custom applications using Visual Basic .Net / C# Participate in development and configuration projects for a broad set of solutions including transactional and repository reporting applicationsDevelop technical design documents to describe and support justification of the chosen reporting architecture and proposed implementationDevelop detail design documents, data structure diagrams and code assets supporting the Reporting implementationProficient in creating Process Flows using Visio Create / maintain report design related artifactsValidate the BI design and ensure that technical specifications are complete, consistent, concise, and achievableEnsure quality assurance by unit test activities including the development of test cases and publication of unit test resultsPerformance tuning of BI processes Well versed with Automation tools like Tivoli Maestro Ability to work in a matrixed team environment with distributed responsibility across different teams Ability to work and deliver in a very high paced environment with limited information at times to support business needs Experienced in working with sensitive / de - identified data environments Experience in working with encrypted and secure data transfersProactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutionsParticipate in BI / Reporting architecture design reviewsConduct BI / Reporting unit testing and code reviewsParticipate in system and integration test; identifies and remedies solution defectsCreate other technical artifacts needed for project implementation
Required Qualifications: The person performing this role would require having at least:Completion of Bachelors degree or higher 8+ years of Cognos Suite, including Reporting and Cube design and development using Framework Manager 4+ years of SQL Server Integration Services, (SSIS 2008 and above for ETL)6+ years of SQL Server Database Skills (SQL 2008 and above)Proficient in Unix shell scriptingExcellent SQL skills and ability to create T - SQL / stored procedures Configuration Management using Microsoft Team Foundation Server and / or other version control toolsUnderstanding of Enterprise Data warehouse data models and dimensional modeling concepts, source to target mapping and Data Integration architectureDemonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with the clientExcellent oral and written communication skills Travel required **(see note)**Typical travel scenario – Travel is based on project size, scope and location. Projects may require up to 80% travel. If travel is required , typical travel schedule is out early Monday, back late Thursday with telecommute from home on Friday. Preferred Qualifications:Knowledge of a Data Modeling Tool like Erwin Knowledge of other databases like Teradata, Oracle, SQL Server Knowledge of Cisco Data Virtualization platformProficiency in SQL Server Reporting Services (SSRS 2008 and above)Proficiency in C# / VB.NET (Using Visual Studio 2012 and above)Proficient in setting up IIS server website / Setting up Virtual directories / Knowledge of installing IIS certificates etc.Knowledge of MS SQL Server Suite (SSIS, SSRS, SSAS) and other BI tools like Business Objects, Microstrategy Knowledge of Testing and Defect tracking tools like HP ALM / QC MS Office Suite, MS Visio Knowledge of end to end SDLC from project inception to deployment Experience in different project management methodologies i.e. Agile and Waterfall Healthcare Payer / PBM domain knowledge in a data warehouse environmentCareers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health - related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm) Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity / Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment. Job Keywords: OptumInsight, Cognos, SSIS, Business Intelligence, BI, Developer, Travel, Telecommuter, telecommuting, work from home, work at home, mobile
Our mission is to help people live healthier lives and to help make the health system work better for everyone.- We seek to enhance the performance of the health system and improve the overall health and well-being of the people we serve and their communities. - We work with health care professionals and other key partners to expand access to quality health care so people get the care they need... at an affordable price. - We support the physician/patient relationship and empower people with the information, guidance and tools they need to make personal health choices and decisions.