Business Intelligence Developer - SQL

Company: Optum

Location: Everett - Washington - USA

Posted on: September 23

JOB SUMMARY:As a BI Developer (SQL) you will be responsible for designing - developing - maintaining and supporting data analytics platforms using SQL Server and other business intelligence applications...ESSENTIAL DUTIES & RESPONSIBILITIES:50% Database development using SQL-Transact30% SQL Server Integration Services (SSIS) - Extract Transform Load (ETL)20% Power BI developmentDUTIES: Use T-SQL programming skills to write complex stored procedures - views - queries - user defined functions and common table expressions. Create normalized Fact and Dimension Tables from multiple disparate data sources. Use SSIS to acquire data from multiple sources (text files - databases - etc) - process SQL queries and normalize data (ETL). Work with data modelers - business analysts and other developers to design and build physical and logical data layers in regional data warehouse. Create visually appealing Power BI interactive dashboards and reports that incorporate charts - graphs - tables - filters - matrices and custom calculations. Work in normal sprint cycles while coordinating with other developers to ensure all pieces of a project are released on time. Use TFS source control to manage iterations of code. Complete ad hoc projects to support operations and end user analysis. Stay updated with advancements and best practices in design and development. Will be a part of an On-Call rotation with some after hours and weekend work required.KNOWLEDGE and SKILLS: T-SQL programming experience required Microsoft Power BI experience required SSIS and ETL experience desired Team Foundation Server (TFS) and Visual Studio experience desired SSIS - SSAS and Active Batch experience is helpful SSRS experience is helpful Previous experience working within the healthcare or insurance industries is helpfulABILITIES: Can communicate clearly both verbally and in writing Ability to think critically and logically Able to understand business requirements in a BI context Able to follow written requirements and work independently Ability to perform design and analysis of a project based on a given specification Ability to work well with other team members Must be able to handle multiple tasks at one time Have an analytical mind with a problem-solving attitude Ability to take initiative and be innovative Customer service focusedEDUCATION & EXPERIENCE: Bachelors degree in Computer Science or relevant field Minimum of seven years experience developing in a time-critical environmentFull COVID-19 vaccination is an essential requirement of this role. UnitedHealth Group will adhere to all federal - state and local regulations as well as all client requirements and will obtain necessary proof of vaccination prior to employment to ensure compliance.If you need to enter a work site for any reason - you will be required to screen for symptoms using the ProtectWell mobile app - Interactive Voice Response (i.e. - entering your symptoms via phone system) or a similar UnitedHealth Group-approved symptom screener. Employees must comply with any state and local masking orders. In addition - when in a UnitedHealth Group building - employees are expected to wear a mask in areas where physical distancing cannot be attained.Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. 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. Here youll find incredible ideas in one incredible company and a singular opportunity to do your life's best work. (SM)Diversity creates a healthier atmosphere: Optum and its affiliated medical practices are Equal Employment Opportunity/Affirmative Action employers 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. Optum and its affiliated medical practices is a drug-free workplace. Candidates are required to pass a drug test before beginning employment