Analytics Data Modeler

Job Title: Analytics Data Modeler

Position Type: Fulltime or Contract

Location: Pleasant Prairie, WI 53158 (2 days onsite per week, 3 days remote)

Learn more about the general tasks related to this opportunity below, as well as required skills.

Job Summary:

We are seeking an experienced Analytics Data Modeler to join our team in Pleasant Prairie, WI. The ideal candidate will be responsible for designing, developing, and deploying database models that support our business applications. This role requires a strong understanding of data modeling best practices, experience with SQL databases, and proficiency with the Erwin data modeling tool. The position offers a hybrid work environment with a mix of onsite and remote work.

Core Skills:

Data Modeling

SQL Database

Dimensional Data Modeling

Erwin Data Modeling Tool

Waterfall and Agile Development Methodologies

Responsibilities:

Database Modeling: Design, develop, and deploy database models to support business applications, ensuring system scalability, security, performance, and reliability.

Data Analysis: Perform data analysis and data modeling for both operational applications and analytical databases.

Data Classification and Naming: Responsible for data classification, naming conventions, database design, and creation of Data Definition Language (DDL).

Technical Consulting: Provide technical consulting to application teams on data naming, classification, design, and handling, serving as the first line of defense for data controls.

Architectural Improvements: Suggest and implement improvements in architecture, team processes, and functions.

Client Interaction: Meet with clients as required to provide delivery expertise and drive results.

Accountability: Take accountability to complete work on time and proactively address blockers and issues to ensure timelines are met.

Deliverable Quality: Ensure all deliverables are completed with high satisfaction and build relationships with clients and peers to foster trust and confidence.

Innovative Solutions: Lead the development of new solutions and accelerators based on past and current client execution, aiming to drive results and innovation.

Leadership and Guidance: Provide leadership and guidance in building out innovative solutions that will accelerate implementation and time to market for our clients.

Required Skills:

12+ years of experience in IT, Data Analysis, Data Manipulation, or a related field

Hands-on experience with Erwin data modeling tool

Proficiency with databases and SQL

Experience with dimensional modeling

Deep understanding of data modeling best practices

Full lifecycle experience in both waterfall and agile development methodologies

Practical and results-oriented approach to work

Required Qualifications:

BA/BS in Mathematics, Computer Science, Business Administration, or a related field in Analytics