Humana Hiring for Data Architect – Louisville, KY or Remote at Glen Allen, Virginia Full Time

Description

The Provider Insights & Claims Analytics (PICA) team is a blend of technology, data, and consulting professionals leveraging the latest tools and methods to solve complex business problems. In this role the Data Architect works in multiple data environments with responsibilities for data design, database architecture, metadata and repository creation. These assignments are varied and frequently require interpretation and independent determination of the appropriate courses of action.

Responsibilities

The Data Architect is responsible for collaboratively developing scalable, efficient, and comprehensive data structures to enable analytics and insight generation for internal customers and partner teams. Primary duties include:

• Translating business needs into long-term data architecture solutions

• Defining, designing, building, and maintaining dimensional database schemas, such as star or snowflake schemas

• Evaluating reusability of current data for separate analyses

• Conducting data sheering to rid the system of old, unused or duplicate data

• Reviewing object and data models and the metadata repository to structure the data for better management and quicker access

• Understanding department, segment, and organizational strategy and operating objectives, including their linkages to related areas

• Making decisions regarding own work methods mostly within established guidelines/procedures, occasionally in ambiguous situations

• Translating reporting and analysis needs into database design

• Migrating and optimizing the current on-premises environment to a MS Azure cloud environment

In addition to being a great place to work, Humana also offers industry leading benefits for all employees, starting your FIRST day of employment. Benefits include:

• Medical Benefits

• Dental Benefits

• Vision Benefits

• Health Savings Accounts

• Flex Spending Accounts

• Life Insurance

• 401(k)

• PTO including 7 paid holidays, one personal holiday, one day of volunteer time off, 23 days of annual PTO, parental leave, caregiving leave, and weekly well-being time

• And more

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology or related field

• Strong SQL knowledge, including writing complex, performant queries to pull data from multiple platforms such as SQL Server, Microsoft Azure, Netezza, Oracle, or DB2

• Experience working on the design and implementation of large data technologies and solutions related to data warehouses, data lakes and data marts within a cloud data environment including tasks such as data architecture design, automation, security, storage and configurations.

• Experience creating and maintaining automated extract-transform-load (ETL) processes using tools such as Azure Data Factory, SnapLogic, and/or Python

• Must be passionate about contributing to an organization focused on continuously improving consumer experiences

Preferred Qualifications

• Knowledge of Python or similar programming language

• Understanding of how to define, design and build dimensional database schemas, including star and snowflake schemas

• Working knowledge of DevOps methods and CI/CD automation practices

• Proficiency in understanding Healthcare related data

• Proficiency in verbal and written communication

• Knowledge of Power BI as reporting tool and its data access architecture is a plus.

• Proficiency in design of various database objects such as Views, Stored Procedures, Functions etc.

• Experience migrating on-premises data to MS Azure

Additional Information

• We will require full COVID vaccination (https://www.cdc.gov/coronavirus/2019-ncov/vaccines/fully-vaccinated.html#vaccinated) for this job as we are a healthcare company committed to putting health and safety first for our members, patients, associates and the communities we serve.

• If progressed to offer, you will be required to provide proof of full vaccination or documentation for a medical or religious exemption consideration where allowed by law. Requests for these exemptions should be submitted at least 2 week prior to your scheduled first day of work.

Work at Home/Remote Requirements Must ensure designated work area is free from distractions during work hours and virtual meetings Must provide a high-speed DSL or cable modem for a workspace (Satellite and Hotspots are prohibited). A minimum standard speed of 10×1 (10mbs download x 1mbs upload) for optimal performance is required.

Our Hiring Process

As part of our hiring process for this opportunity, we may contact you via text message and email to gather more information using a software platform called Modern Hire. Modern Hire Text, Scheduling and Video technologies allow you to interact with us at the time and location most convenient for you.

If you are selected to move forward from your application prescreen, you may receive correspondence inviting you to participate in a pre-recorded Voice, Text Messaging and/or Video interview. Your recorded interview will be reviewed and you will subsequently be informed if you will be moving forward to next round of interviews

If you have additional questions regarding this role posting and are an Internal Candidate, please send them to the Ask A Recruiter persona by visiting go/Buzz and searching Ask A Recruiter! Please be sure to provide the requisition number so we may be able to research your request quicker.

In order to support the CDC recommendations on social distancing and reduce health risks for associates, members and public health, Humana is deploying virtual and video technologies for all hiring activities. This position may be subject to temporary work at home requirements for an indefinite period of time. These requirements include access to a personal computing device with a camera, a minimum internet connection speed of 10m x 1m (satellite and/or wireless internet connections are NOT permitted for Work at Home roles) and a dedicated secure home workspace for interview or work purposes. Humana continues to monitor the situation, and will adjust service levels as the coronavirus situation evolves. The following changes are temporary and will be evaluated frequently with the goal of returning to normal operations as soon as possible. Your Talent Acquisition representative will advise on the latest recommendations to protect your health and wellbeing during the hiring process. #ThriveTogether #WorkAtHome

Alert: Humana values personal identity protection. Please be aware that applicants selected for leader review may be asked to provide a social security number, if it is not already on file. When required, an email will be sent from [email protected] with instructions to add the information into the application at Humana’s secure website.

Humana is more than an equal opportunity employer, Humana’s dedication to promoting diversity, multiculturalism, and inclusion is at the heart of what we do in all of our Humana roles. Diversity is more than a commitment to us, it is the foundation of what we do. We are fully focused on diversity of race, gender, sexual orientation, religion, ethnicity, national origin and all of the other fascinating characteristics that make us each uniquely wonderful.

Scheduled Weekly Hours

40