CW Data Modeler Intern

Louisiana Blue

Posted about 21 hours ago

Internship

Baton Rouge, Louisiana

In Person

Smart Summary

Responsibilities

The intern will assist in creating and maintaining data definitions, models, and blueprints for the Enterprise Data Warehouse. They will also collaborate with team members to gather business requirements and support the design of enterprise reporting dashboards.

Qualifications

You are pursuing a degree in a related field such as Computer Science or Data Analytics and possess basic SQL scripting knowledge. You also have a foundational understanding of database concepts and a strong interest in data warehousing and enterprise reporting.

Must Have Skills for ATS

SQL

Erwin

data modeling

data warehousing

Microsoft Office

Excel

Job Description

We take great strides to ensure our employees have the resources to live well, be healthy, continue learning, develop skills, grow professionally and serve our local communities. We invite you to apply for a career with us.

Residency in or relocation to Louisiana is preferred for all positions.

The Enterprise Information Management team supports Louisiana Blue’s strategic direction to be data and analytics driven by developing and maintaining data definitions, data models, and model blueprints for the Enterprise Data Warehouse (EDW). The Data Modeler Intern will support team objectives through hands-on project work, mentoring, and exposure to data modeling practices used across the organization.

ACCOUNTABILITIES & ESSENTIAL FUNCTIONS:

Assist with creating and maintaining data definitions for EDW tables and views in Erwin under team guidance. 

Support updates to logical and physical data models, model diagrams, and DDL documentation for tables and views. 

Help gather, document, and analyze data requirements, data flows, and business needs for reporting or feature-development work. 

Participate in the creation of solution blueprints for features that require changes or additions to the EDW model. 

Assist with basic review of deployment scripts, plans, and documentation to support data model implementation. 

Support teams and business areas by researching basic questions related to an EDW subject area. 

Contribute to data model design and solutioning for enterprise reporting dashboards. 

Collaborate with Business Data Architects, Product Management, DI Architects, and other team members to understand how tables and views are designed to meet business needs. 

Participate in training or knowledge-sharing activities related to EDW-specific dimensional modeling and data usage. 

Required Qualifications:

Current undergraduate, graduate student, or recent graduate, pursuing Business, Finance, Computer Science, Mathematics, Data Analytics, Information Systems, or a related field. 

Basic knowledge of SQL scripting through coursework, project work, internships, or related experience. 

Basic understanding of database concepts, including tables, views, data relationships, and data modeling principles. 

Strong interest in data, analytics, enterprise reporting, information management, or data warehousing. 

Cumulative GPA: 3.0 preferred; 2.5 minimum cumulative GPA. 

Other Qualifications:

Ability to adapt quickly to change and coordinate activities with others in a team environment. 

Working knowledge of Microsoft Office suite, especially Word, Excel, PowerPoint, Teams, and Outlook. 

Knowledge of SQL, database design, data visualization, or reporting tools is preferred. 

Self-motivated, professional, coachable, adaptable to a changing work environment, and team-oriented. 

Must be able to work a minimum of 25 hours per week during Spring and Fall semesters and 25–30 hours per week during Summer. 

#LI-DNI

An Equal Opportunity Employer

All internal employees please apply through Workday Careers.

PLEASE USE A WEB BROWSER OTHER THAN INTERNET EXPLORER IF YOU ENCOUNTER ISSUES (CHROME, FIREFOX, SAFARI)

Additional Information

Please be sure to monitor your email frequently for communications you may receive during the recruiting process. Due to the high volume of applications we receive, only those most qualified will be contacted. To monitor the status of your application, please visit the "My Applications" section in the Candidate Home section of your Workday account. 

If you are an individual with a disability and require a reasonable accommodation to complete an application, please contact recruiting@bcbsla.com for assistance.

In support of our mission to improve the health and lives of Louisianians, we encourage the good health of its employees and visitors. We want to ensure that our employees have a work environment that will optimize personal health and well-being. Due to the acknowledged hazards from exposure to environmental tobacco smoke, and in order to promote good health, our company properties are smoke and tobacco free. 

We perform background and pre-employment drug screening after an offer has been extended and prior to hire for all positions. As part of this process records may be verified and information checked with agencies including but not limited to the Social Security Administration, criminal courts, federal, state, and county repositories of criminal records, Department of Motor Vehicles and credit bureaus. Pursuant with sec 1033 of the Violent Crime Control and Law Enforcement Act of 1994, individuals who have been convicted of a felony crime involving dishonesty or breach of trust are prohibited from working in the insurance industry unless they obtain written consent from their state insurance commissioner.

Additionally, we are a Drug Free Workplace. A pre-employment drug screen will be required and any offer is contingent upon satisfactory drug testing results.

Louisiana Blue

Louisiana Blue is a company on a mission: to improve the health and lives of Louisianians. We take that mission very seriously and apply it to everything we do. But, we also like to have fun! After all, we live and work in a state known for its joie de vivre, its great food and its friendly people. That joy for life also affects everything we do as we strive to give our members the best possible experience and the best possible outcomes. Our company was founded here in 1934 and has remained Louisiana-owned and operated. Our vision is to be the statewide leader in healthcare, improving quality, value and experience through transformation of the delivery system in partnership with providers committed to positive change, and by serving Louisianians across all major market segments by 2020. That means it’s an exciting time to be part of our family. Every day, we are seeking innovative ways (and people) to achieve our vision and stay true to our Louisiana roots. Of course, we are aware of the urgent national issues regarding healthcare affordability, the numbers of uninsured and the quality of health services rendered. Louisiana Blue is providing education and guidance to help shape healthcare reform legislation, but it’s also important to us to reassure our members that we are going to be here through every change, making sure they continue to have access to quality care. Louisiana Blue collaborates with other business and community leaders to move Louisiana to a quality-driven model of healthcare using data, patient engagement, provider professionalism and financial incentives to improve health outcomes and promote patient-centered care. Blue Cross and Blue Shield of Louisiana is an independent licensee of the Blue Cross and Blue Shield Association and incorporated as Louisiana Health Service & Indemnity Company. Blue Cross and Blue Shield of Louisiana is licensed to sell products only in the state of Louisiana.
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria