Interface Architect DBA - US Telecommute
Seattle, WA

Job Description

The primary role of the developer is to take the design and technical specifications and develop effective and high quality technical solutions that meet the business requirements. The technical domain of the Interface Architect/DBA includes understanding Data Integration (DI) and Reporting best practices, tools and technologies, security in the environment, understanding of different data warehousing and dimensional modelling concepts, DI development, performance tuning and support system testing.

You'll enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges.

Primary Responsibilities:

* Ability to work closely with DBAs, Engineers, Business Analysts and SMEs to understand business requirements and follow standard operating procedures


* Perform Data profiling and analysis of structured and unstructured data
* Define new interface layouts (custom or healthcare industry standards) for integrating into database
* Create source to target mappings and ETL design for integration of new/modified data streams into the database/data warehouse/data marts
* Validate the ETL design and ensure that technical specifications are complete, consistent, concise, and achievable
* Create ETL Processes and reports using Microsoft SQL Server Suite (SSIS, SSRS, SSAS) and other data integration tools like Data Stage, Informatica, Ab initio
* Develop ETL code as per the technical specifications and business requirements according to the established designs
* Familiarity with reporting tools like Cognos, Business Objects , Microstrategy
* Familiarity with Data Visualization tools like Tableau, Qlikview , Power BI
* Proficient in leading and managing the development resources
* Create Process Flows using Visio
* Create Dimensional models using ERWIN or other data modeling tools
* Create/maintain design related artifacts i.e. data models , Mapping documents, architecture diagrams, data flow diagrams
* Performance tuning of ETL processes
* 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 delegating and coordinating development and testing in an onsite-offshore delivery model
* Experienced in working with sensitive/de-identified data environments
* Experience in working with encrypted and secure data transfers
* Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions
* Participate in ETL/Reporting architecture design reviews
* Conduct ETL/Reporting unit testing and code reviews
* Participate in system and integration test; identifies and remedies solution defects
* Create other technical artifacts needed for project implementation

Required Qualifications:

* Bachelor's in Computer Science, Information Technology or related area
* 5 years of Data Integration/ETL development experience in healthcare domain
* 5 years of Reporting/Visualization development experience, preferably in healthcare domain
* 3 years of ETL design using Microsoft SSIS
* 5 years of SQL Server Experience with versions 2008 and/or 2012
* Excellent SQL skills and ability to create and troubleshoot T-SQL/stored procedures, functions
* Understanding and use of performance and tuning functions, Profiler, DVM, showplan info
* Configuration Management using Microsoft Team Foundation Server and/or other version control tools
* Understanding of Enterprise Data warehouse data models and dimensional modelling concepts, source to target mapping and Data Integration architecture
* Demonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with the client

Preferred Qualifications:

* Experience in developing reports using SQL Server Reporting Services (SSRS)
* Experience in developing dashboards using Tableau/MS Power BI
* Experience in creating Source to Target Mappings
* Experience in Data Profiling & data analysis in a DW environment on Teradata/Oracle/MS SQL Server
* Performance Tuning of ETL processes in large scale data warehouse environment
* Knowledge of a Data Modeling Tool like Erwin
* Knowledge of other databases like Teradata, Oracle, SQL Server
* Knowledge of MS SQL Server Suite (SSIS, SSRS, SSAS) and other ETL tools like Informatica, Data Stage
* 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 environment
* Excellent oral and written communication skills

Careers with UnitedHealthcare. Let's talk about opportunity. Start with a Fortune 6 organization that's serving more than 85 million people already and building the industry's singular reputation for bold ideas and impeccable execution. Now, add your energy, your passion for excellence, your near-obsession with driving change for the better. Get the picture? UnitedHealthcare is serving employers and individuals, states and communities, military families and veterans where ever they're found across the globe. We bring them the resources of an industry leader and a commitment to improve their lives that's second to none. This is no small opportunity. It's where you can do your life's best work.SM

* All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy.

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: sql, tableau, teredata, oracle, sql server, telecommute, telecommuter, Seattle,WA, Washington, Minneapolis, MN, Minnesota, Chicago, IL. Illinois, Hartford, CT, Connecticut