- Create and maintain Enterprise Analytics Platform (EAP) data models that integrate multiple source systems into a coherent, cohesive catalog of data. Some of those source systems include Oracle/Peoplesoft HR and Finance and Workday.
- Design, develop and maintain conceptual, logical, and physical data models.
- Work with analyst team to review business requirements and assess the data model needs to best fulfill those requirements. Advise on exercises like gap analyses or cost/benefit/risk analyses.
- Ensure data models adhere to design and security standards.
- Perform data profiling and analysis to ensure the quality of the data models.
- Collaborate with functional and technical team to integrate model metadata with consumer tools (e.g. Collibra, Tableau).
- Collaborate with development team to ensure models are clear and comprehensive. Provide developers with model and/or data definition language (DDL).
- Support EAP customers/consumers with data model walkthroughs and help queue responses.
- Minimum 3 years' experience as a Data Architect, Data Scientist, Data Analyst, Data Engineer, Business Intelligence (BI) Analyst, or similar role.
- In-depth understanding of database structure principles.
- Thorough understanding of data modeling principles and best practices, including expertise in both relational and dimensional modeling, with a specific focus on the AWS Redshift database.
- Strong proficiency in data modeling tools, with expertise in ER Studio.
- In-depth understanding of data warehousing concepts, data lakes, and AWS cloud-based architecture.
- Strong understanding of the software development lifecycle (SDLC).
- Familiarity with metadata management principles.
- Strong understanding of master and reference data management principles.
- Strong understanding of object-oriented design or domain-driven design.
- Experience gathering and analyzing data, report, and business requirements.
- Experience working in a team environment.
- Ability to communicate effectively with users with varying levels of technical vocabulary.
- Analytical skills.
- Problem-solving attitude.
- Experience as a Data Architect, Data Scientist, Data Analyst, Data Engineer, Business Intelligence (BI) Analyst, or similar role.
- Experience gathering and analyzing data, report, and business requirements.
- Understanding of data modeling principles and best practices, including expertise in both relational and dimensional modeling, with a specific focus on the AWS Redshift database.
- Experience with higher education data and reporting, e.g. students, human resources (HR), finance, operations.
- Experience in AWS cloud environment.
- Experience in agile and/or hybrid (agile and waterfall) teams.
- Experience migrating legacy applications and data systems to new environments.
-
Licensed Practical Nurse
1 week ago
Atlantic Rehabilitation Institute Madison, United States Full timeDescription · Atlantic Rehabilitation Institute is a state-of-the-art, 38-bed inpatient acute rehabilitation hospital dedicated to the treatment and recovery of individuals who have experienced the debilitating effects of a severe injury or illness. A career at ARI operated joint ...
-
Assistant Actuary
2 weeks ago
American Family Insurance Madison, United StatesPosition Compensation Range: · $95, $161,000.00 · Pay Rate Type: · Salary · - Compensation may vary based on the job level and your geographic work location._ · **Responsibilities**: · - You will contribute to recommendations and significant revisions to one or more actuarial met ...
-
Associate Laboratory Animal Resources
2 weeks ago
Empirico Inc. Madison, United States**Position Description**: Empirico, a biotechnology company that combines unmatched expertise in human genetics-driven target discovery with world-class capabilities in siRNA drug discovery, is looking for a talented Laboratory Animal Research (LAR) professional to support our vi ...
-
Compensation Consultant
1 week ago
Cottingham & Butler Madison, United StatesView All Jobs · We are looking to add a talented and experienced Compensation & HR Consultant to our team. This role will be client facing and support all client compensation needs. Carlson Dettmann Consulting, a Cottingham & Butler Company, is a management consulting firm with p ...
-
Community Outreach Worker
2 weeks ago
Focused Interruption Madison, United States**Community Outreach Worker** · **Summary**: · The mission of the Focused Interruption is to use a holistic approach to reduce generational trauma by providing evidence-based intervention and prevention services to victims, communities, and families impacted by gun violence. Focu ...
-
Scientist I
1 week ago
University of Wisconsin–Madison Madison, United States**Job Summary**: · The Pegasus research group is seeking a scientist to provide theory and/or diagnostic support for experiments, analyze data and for collaborations with undergraduate and graduate students. · The Pegasus-III Experiment is an ultra-low aspect ratio spherical toka ...
-
Customer Account Specialist
2 weeks ago
C.H. Robinson Madison, United States**Do your friends describe you as a "people person?"** Do you have customer relations experience? Are you looking for a role that will give you an opportunity to learn account management, sales, and operations, and jump start your career with an eye to the next opportunity? Then ...
-
Registered Nurse
1 week ago
SSM Health Madison, United States**It's more than a career, it's a calling** · WI-SSM Health St. Mary's Hospital - Madison · **Worker Type**: · PRN1 · **Job Highlights**: · At SSM Health, we understand that as a nurse, you have a world of opportunities before you. We're not just another option; we're a collabora ...
-
Registered Nurse
6 days ago
SSM Health Madison, United States**It's more than a career, it's a calling** · WI-SSM Health St. Mary's Hospital - Madison · **Worker Type**: · Regular · **Job Highlights**: · **Position Details** · **A one-time sign on bonus is available to qualified individuals for up to $10,000 (less taxes) with a 2 year serv ...
-
Product Manager Associate Director, New Product
2 weeks ago
Exact Sciences Corporation Madison, United States**Help us change lives** · At Exact Sciences, we're helping change how the world prevents, detects and guides treatment for cancer. We give patients and clinicians the clarity needed to make confident decisions when they matter most. Join our team to find a purpose-driven career, ...
-
Registered Nurse
6 days ago
SSM Health Madison, United States**It's more than a career, it's a calling** · WI-SSM Health Outpatient Center · **Worker Type**: · Regular · **Job Highlights**: · **Department: Gastroenterology** · **Patient Population or Ratio: N/A** · **Schedule**: Mon-Fri, Day Shift · **Location**:700 S Brooks St, Madison, W ...
-
Registered Nurse
1 week ago
SSM Health Madison, United States**It's more than a career, it's a calling** · WI-SSM Health Dean Medical Group South Madison Campus · **Worker Type**: · Regular · **Job Highlights**: · **Department**:Ambulatory Infusion Chemotherapy · **Patient Population or Ratio**:3-5 average patients a day · **Schedule**: Da ...
-
Registered Nurse
2 weeks ago
SSM Health Madison, United States**It's more than a career, it's a calling** · WI-SSM Health Outpatient Center · **Worker Type**: · Regular · **Job Highlights**: · - ** Department**: Gastroenterology · - ** Patient Population or Ratio**: GI is comprised of 10 physicians, 5 APs, and a dietician. This clinic-based ...
-
Business Analyst
2 weeks ago
Novalink Solutions LLC Madison, United StatesTop Required Skills & Years of Experience: · • Candidates MUST know SQL for this position · • Serve as a liaison between the business and technical staff to design and implement efficient data integration processes. Creating and maintaining source to target (S2T) documentation – ...
-
Full-time Overnight Residential Monitor
3 days ago
ARC Community Services, Inc. Madison, United States Full timeSeeking a Full Time Overnight Residential Monitor for a 12-bed Women's Residential Treatment Facility located in Madison, WI · **Want to make a difference in someone's life?** · **Our Mission**: Since 1976, ARC Community Services, Inc. has been dedicated to helping women reclaim ...
-
Forensic Lab Technician
2 days ago
City of Madison, WI Madison, United States**General Description**: · This position is responsible for overseeing the timely and accurate duplication and transfer of police evidence and digital multimedia in furtherance of Madison Police Department's commitment to being the national model for policing excellence. · This i ...
-
Registered Nurse
4 days ago
SSM Health Madison, United States**It's more than a career, it's a calling** · WI-SSM Health St. Mary's Hospital - Madison · **Worker Type**: · Regular · **Job Highlights**: · Position Highlights: · - ** Department**:Resource Float Pool · - **Patient Population**:Resource Pool is a service-oriented group of RN's ...
-
Ata Design Technician
6 days ago
Cummins Stoughton, United States**ATA Design Technician 1st Shift** · Our culture believes in _POWERING YOUR POTENTIAL_. We provide global opportunities to develop your career, make your community a better place and work with today's most innovative thinkers to solve the world's toughest problems. · We believe ...
-
RN - Inpatient, Neonatal Icu
1 week ago
UW Health Partners Madison, WI, United States90% FTE, evening/night shift, every other weekend. Hours may vary based on the operational needs of the department. You will be working at American Family Children's Hospital in Madison, WI. · Be part of something remarkable · Join the #1 hospital in Wisconsin · We are seeking a ...
-
rn - inpatient, neonatal icu
1 week ago
UW Health Madison, WI , USA, United StatesJob Description · 90% FTE, evening/night shift, every other weekend. Hours may vary based on the operational needs of the department. You will be working at American Family Children's Hospital in Madison, WI. · Be part of something remarkable · Join the #1 hospital in Wisconsin ...
Business Intel Data Modeler-IV - Madison, United States - Serigor Inc
Description
Job Title: Business Intel Data Modeler-IV (Remote)Location: Madison, WI 53703
Duration: 06+ Months
Job Description:
The client is implementing the Enterprise Analytics
Platform (EAP), including a data lake with data serving the 13 UW universities and campuses.
The EAP team is seeking a data engineer with data modeling skills and expertise. The position will work closely with the analysts, developers, and consumers to design data models that support integration of multiple source systems into cohesive data reporting and visualization solutions.
Major Responsibilities:
Minimum Qualifications:
