2026-2027 yearlong quality inspections intern

senior financial analyst Jobs in House Video Content Creator Jobs In Person Jobs In Person Jobs In Person Jobs In Chicago

senior financial analyst

accounting + finance intern Jobs in House Video Content Creator Jobs In Person Jobs In Person Jobs In Person Jobs In Chicago

accounting + finance intern

analyst 2, finance Jobs in House Video Content Creator Jobs In Person Jobs In Person Jobs In Person Jobs In Chicago

analyst 2, finance

analytics & reporting consultant Jobs in House Video Content Creator Jobs In Person Jobs In Person Jobs In Person Jobs In Chicago

analytics & reporting consultant

analytics support analyst Jobs in House Video Content Creator Jobs In Person Jobs In Person Jobs In Person Jobs In Chicago

analytics support analyst

data analyst intern advanced sql python data engineering focus

Machinery Marketing Inter

<p>Data Analyst Intern (Advanced SQL / Python / Data Engineering Focus)</p><p><b>Location:</b> On site (Chicago preferred)<br/><b>Duration:</b> 6 months<br/><b>Type:</b> Internship (High-Impact Technical Track)</p><p>Role Overview</p><p>We are seeking a highly technical <b>Data Analyst Intern</b> who can operate at the intersection of analytics and data engineering. This role involves working directly with production databases, optimizing queries at scale, contributing to data modeling decisions, and building automated analytical pipelines.</p><p>This is not a dashboard-only role &mdash; we are looking for someone who understands how data flows from source systems to analytical layers and can reason about performance, schema design, and statistical validity.</p><p>Core Responsibilities</p><p>1. Advanced SQL &amp; Query Optimization</p><ul><li>Write complex analytical queries using:</li><li>CTE chains</li><li>Window functions (ROW_NUMBER, RANK, LAG, LEAD)</li><li>Recursive queries</li><li>Complex aggregations</li><li>Correlated subqueries</li><li>Analyze and optimize slow-running queries using:</li><li>Execution plans</li><li>Indexing strategies</li><li>Partitioning logic</li><li>Query refactoring</li><li>Design and maintain:</li><li>Materialized views</li><li>Incremental aggregation tables</li><li>Work with large datasets (multi-million row tables)</li><li>Contribute to schema design discussions</li></ul><p>Expected databases:</p><ul><li>PostgreSQL / MySQL / SQL Server</li><li>Familiarity with columnar systems (Redshift / BigQuery / Snowflake) is a plus</li></ul><p>2. Data Modeling &amp; Warehousing</p><ul><li>Understand and apply:</li><li>Star schema</li><li>Snowflake schema</li><li>Fact vs Dimension tables</li><li>Slowly Changing Dimensions (SCD)</li><li>Help design data marts optimized for analytics use cases</li><li>Define and document KPI logic and metric definitions</li><li>Ensure data consistency across reporting layers</li></ul><p>3. Python &amp; Data Pipelines</p><ul><li>Build scalable data processing scripts using:</li><li>Pandas</li><li>NumPy</li><li>SQLAlchemy</li><li>PyArrow (optional)</li><li>Design automated reporting pipelines</li><li>Implement ETL/ELT workflows</li><li>Perform data validation checks and anomaly detection</li><li>Work with:</li><li>JSON APIs</li><li>Web scraping (if applicable)</li><li>Streaming or batch ingestion processes</li><li>Use logging and exception handling for production-ready scripts</li></ul><p>4. Statistical &amp; Experimental Analysis</p><ul><li>Design and analyze A/B tests:</li><li>Power analysis</li><li>Statistical significance testing</li><li>Confidence intervals</li><li>Apply regression models for:</li><li>Trend forecasting</li><li>Cohort analysis</li><li>Retention modeling</li><li>Evaluate metric bias and confounding variables</li><li>Clearly communicate limitations of statistical conclusions</li></ul><p>5. Dev &amp; Infrastructure Exposure</p><ul><li>Use Git for version control</li><li>Write modular, reusable code</li><li>Document pipelines and data logic</li><li>(Preferred) Exposure to:</li><li>Docker</li><li>Airflow</li><li>dbt</li><li>Cloud environments (AWS/GCP/Azure)</li><li>CI/CD concepts</li></ul><p>Required Qualifications</p><ul><li>Strong SQL proficiency (must understand query execution and optimization)</li><li>Advanced Python for data analysis</li><li>Deep understanding of relational database design</li><li>Strong grasp of statistics and hypothesis testing</li><li>Ability to reason about data integrity and system-level data flow</li><li>Comfortable working with messy, incomplete, real-world data</li></ul><p>Preferred Qualifications</p><ul><li>Experience building ETL pipelines</li><li>Knowledge of indexing strategies and database internals</li><li>Experience with analytics engineering tools (dbt)</li><li>Exposure to distributed systems or big data frameworks</li><li>Experience handling datasets &gt;10M rows</li></ul><p>Compensation</p><ul><li>Paid internship (competitive hourly rate)</li><li>High ownership and impact</li><li>Mentorship from senior analytics / engineering leadership</li><li>Potential conversion to full-time role</li></ul><p>Pay: From $20.00 per hour</p><p>Work Location: In person</p>

Data Analyst Intern (Advanced SQL / Python / Data Engineering Focus)

Realign

<div>Chicago, Illinois 60018 Posted March 3rd, 2026
 <div></div><p>Looking for more job opportunities? Click here!</p></div>
<br><div><p>Job Type: Contract</p>
<p>Job Category: IT</p>
<p>Job Description</p>
<p></p><div><b>Role: Trading Support Analyst - Banking Markets</b></div><div><b>
Location: Chicago, IL (trading floor a minimum of four days per week)</b></div><div><b>
Contract</b></div><div><b>
F2F Interview</b></div><div></div><div><br>
We are seeking a Trading Support Analyst to support brokerage trading applications in a fast-paced Banking Markets environment.</div><div>
Core responsibilities include back end system analysis on top of front office trading support and analysis.</div><div>
This role partners with a global production support team to provide day-to-day operational support for mission-critical trading platforms.</div><div>
Role also includes some development work following DevOps model.</div><div></div><div><b><br>
Key Responsibilities:</b></div><div></div><div><br>
Provide production support for brokerage trading applications in a high-pressure trading environment</div><div>
Analyze, troubleshoot, and resolve production incidents, escalating as required</div><div>
Partner with business users to resolve issues in compliance with IT and business control standards</div><div>
Drive root-cause analysis and continuous improvement initiatives</div><div>
Produce operational metrics, audit support, and application status reporting</div><div>
Maintain disaster recovery documentation and participate in DR exercises</div><div>
Collaborate with technology, business, compliance, audit, and vendor teams</div><div>
Participate in on-call rotations, including evenings and weekends, to manage high-severity incidents end to end</div><div></div><div><b><br>
Required Qualifications:</b></div><div></div><div><br>
5+ years of experience in financial services or capital markets</div><div>
2-3 years of experience with Azure Platform, CI/CD pipelines, GitHub/Jenkins etc.</div><div>
Advanced SQL expertise (Oracle, MS SQL, or Sybase)</div><div>
Strong scripting and automation skills (Python, Perl, PowerShell)</div><div>
Working knowledge of infrastructure components.</div><p>
Strong communication skills and ability to operate independently in a trading environment</p><p></p>
<p>Required Skills</p>
<p>DATA ANALYST</p></div>

Trading Support Analyst / Banking Markets-2

CapTech Consulting

<div><b>Company Description</b><p><br>
CapTech is an award-winning consulting firm that collaborates with clients to achieve what&rsquo;s possible through the power of technology. At CapTech, we&rsquo;re passionate about the work we do and the results we achieve for our clients. From the outset, our founders shared a collective passion to create a consultancy centered on strong relationships that would stand the test of time. Today we work alongside clients that include Fortune 100 companies, mid-sized enterprises, and government agencies, a list that spans across the country.</p><br>
<div></div>
<b>
Job Description</b><p><br>
CapTech Machine Learning Engineers are responsible for designing and implementing data-driven solutions for our clients, with a specific focus on building and deploying scalable machine learning systems in enterprise environments. CapTech employees enjoy a collaborative environment and have many opportunities to learn from and share knowledge with other CapTech analysts, architects, and our clients.</p><p><b><i>
Specific responsibilities for the Lead Machine Learning Engineer position include:
</i></b></p><ul><li>Strategizing with clients, data scientists, engineers, and other members of cross-functional teams to implement end-to-end machine learning solutions and identify new machine learning and data science approaches to meet business needs</li><li>
Provide technical leadership and collaborate within and across teams to ensure that the overall technical solution is aligned with the customer needs.</li><li>
Deconstructing client needs into data-driven processes/models and analytical measures.</li><li>
Analyzing and transforming large datasets hosted on a variety of enterprise-level data platforms (e.g., AWS, Azure, GCP).</li><li>
Designing, developing, and deploying advanced analytical solutions leveraging client data (e.g., recommender systems, natural language processing, risk scoring).</li><li>
Productionizing ML systems with a focus on optimization and scalability to satisfy clients&rsquo; requirements.</li><li>
Growing CapTech&rsquo;s Machine Learning and Data Science practices through delivering client presentations, writing proposals, attending various business development events, and leading teams of junior data scientists and engineers.</li></ul><br>
<div></div>
<b>
Qualifications</b><br>
<ul><li>
7+ years of experience delivering data engineering and machine learning solutions on cloud platforms</li><li>
Bachelor's degree or equivalent combination of education and experience.</li><li>
Experience providing technical leadership and mentoring other engineers in data engineering space</li><li>
Hands-on experience manipulating and analyzing large (multi-billion record) data sets.</li><li>
Hands-on experience developing data-driven solutions using Python, Scala, or similar languages.</li><li>
Proficiency leveraging SQL, Spark, NoSQL, and/or cloud data processing frameworks in a production setting.</li><li>
Proficiency with containerization (e.g., Docker) and microservices.</li><li>
Proficiency with data warehousing tools/environments such as Snowflake, Databricks, Azure SQL, Amazon RDS</li><li>
Comfort and proficiency in framing data-driven problems from cross-industry business requirements.</li><li>
Experience applying analytical methods across multiple business domains (e.g., customer analytics, marketing, finance, digital channels)</li><li>
Hands-on experience implementing production-scale machine learning systems in one or more domains (i.e., personalization, natural language processing, computer vision).</li><li>
Knowledge of DevOps and automation best practices.</li><li>
Knowledge of statistics and statistical modeling methods.</li><li>
Knowledge of model management and model versioning best practices.</li><li>
Experience working with LLMs (e.g., GPT, Claude, Mistral, etc.) in production setting</li><li>
Experience with prompt engineering, MCP and RAG, and agentic AI architectures</li><li>
Strong understanding of conversational UX and prompt evaluation metrics</li><li>
Experience with agentic frameworks in practice (langchain, n8n, pydantic, etc.)</li><li>
Experience with multi-agent orchestration</li></ul><br>
<div></div>
<b>
Additional Information</b><p><br>
We want everyone at CapTech to be able to envision a lasting and rewarding career here, which is why we offer a variety of career paths based on your skills and passions. You decide where and how you want to develop, and we help get you there with customizable career progression and a comprehensive benefits package to support you along the way. Alongside our suite of traditional benefits encompassing generous PTO, health coverage, disability insurance, paid family leave and more, we&rsquo;ve launched extended benefits to help meet our employees&rsquo; needs.</p><ul><li>
Learning &amp; Development &ndash; Programs offering certification and tuition support, digital on-demand learning courses, mentorship, and skill development paths</li><li>
Modern Health &ndash;A mental health and well-being platform that provides 1:1 care, group support sessions, and self-serve resources to support employees and their families through life&rsquo;s ups and downs</li><li>
Carrot Fertility &ndash;Inclusive fertility and family-forming coverage for all paths to parenthood &ndash; including adoption, surrogacy, fertility treatments, pregnancy, and more &ndash; and opportunities for employer-sponsored funds to help pay for care</li><li>
Fringe &ndash;A company paid stipend program for personalized lifestyle benefits, allowing employees to choose benefits that matter most to them &ndash; ranging from vendors like Netflix, Spotify, and GrubHub to services like student loan repayment, travel, fitness, and more</li><li>
Employee Resource Groups &ndash; Employee-led committees that embrace and incorporate diversity and inclusion into our day-to-day operations</li><li>
Philanthropic Partnerships &ndash; Opportunities to engage in partnerships and pro-bono projects that support our communities.</li><li>
401(k) Matching &ndash; Generous matching and no vesting period to help you continue to build financial wellness</li></ul><p>
CapTech is an equal opportunity employer committed to fostering a culture of equality, inclusion and fairness &mdash; each foundational to our core values. We strive to create a diverse environment where each employee is encouraged to bring their unique ideas, backgrounds and experiences to the workplace. For more information about our Diversity, Inclusion and Belonging efforts, click HERE. As part of this commitment, CapTech will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Laura Massa directly via email lmassa@captechconsulting.com.</p><p>
CapTech supports Equal Pay for all. In addition, in the State of Illinois we are committed to Equal Pay for ALL in accordance with the Illinois Equal Pay Act. The base pay range for this role is: $150,000 - $200,000.</p><p>
At this time, CapTech cannot transfer nor sponsor a work visa for this position. Applicants must be authorized to work directly for any employer in the United States without visa sponsorship.</p></div><p></p>

Lead Machine Learning / Data Science Engineer

University of Illinois

<div><div><div><div><p><b>Undergraduate Affairs Data Analyst - ORSS</b></p><p></p><p><b><br>
Hiring Department</b>: Office for Research on Student Success</p>
<p><b>
Location</b>: Chicago, IL USA</p>
<p><b>
Requisition ID</b>: 1039326</p><p><b>
Posting Close Date</b>: March 27, 2026</p><p><b>
Salary: </b>The budgeted salary range for the position is $60,000-$75,000. Salary is competitive and commensurate with qualifications and experience, while also considering internal equity.</p><p></p><p><b><br>
About the University of Illinois Chicago</b></p><p>
UIC is among the nation&rsquo;s preeminent urban public research universities, a Carnegie RU/VH research institution, and the largest university in Chicago. UIC serves over 34,000 students, comprising one of the most diverse student bodies in the nation and is designated as a Minority Serving Institution (MSI), an Asian American and Native American Pacific Islander Serving Institution (AANAPSI) and a Hispanic Serving Institution (HSI). Through its 16 colleges, UIC produces nationally and internationally recognized multidisciplinary academic programs in concert with civic, corporate and community partners worldwide, including a full complement of health sciences colleges. By emphasizing cutting-edge and transformational research along with a commitment to the success of all students, UIC embodies the dynamic, vibrant and engaged urban university. Recent &ldquo;Best Colleges&rdquo; rankings published by U.S. News &amp; World Report, found UIC climbed up in its rankings among top public schools in the nation and among all national universities. UIC has over 300,000 alumni, and is one of the largest employers in the city of Chicago.</p><p>
This position is intended to be eligible for benefits. This includes Health, Dental, Vision, Life Insurance, a Retirement Plan, Paid time Off, and Tuition waivers for employees and dependents.</p><p><b>
Position Summary</b><br>
The Undergraduate Affairs Data Analyst performs research and creates data visualizations in the areas of undergraduate student success, program assessment and effectiveness, and strategic planning. This position develops and conducts research, and analyzes data for decision making and policy implementation in areas including (but not limited to) undergraduate student retention and graduation, student goal attainment, program assessment and evaluation, access and equity, and functional benchmarking specific to higher education.<br>
<br>
<b>Duties &amp; Responsibilities</b></p><br>
<ul><li>
Data Visualization
</li></ul><ul><li>Make complex datasets more accessible, understandable and usable by creating visual data models.
</li><li>Develop and maintain integrated data dashboards to display student data in support of institutional goals.
</li><li>Integrate multiple relational data sets to create data visualizations.</li></ul><ul><li>
</li></ul>
<ul><li>Research Design
</li></ul><ul><li>Conduct evidence-based best practice research and perform studies for strategic planning, program and policy assessment and student support services.
</li><li>Design effective research strategies and gather relevant information using primary and secondary sources and techniques (e.g., institutional data, course data, surveys, print sources, government agencies, external research organizations, etc.).
</li><li>Organize and execute research projects, identifying ways to improve research design and data validity.
</li><li>Develop and carryout research with sound methodologies to investigate undergraduate success and institutional effectiveness.
</li><li>Select and adapt quantitative methods, practices, and theories to perform analysis, interpret results, and document findings.
</li><li>Manage IRB protocols for VPUA projects.</li></ul>
<ul><li>
Data Analysis and Reporting
</li></ul><ul><li>Identify and analyze patterns in institutional data, make critical observations of policy impact, and recommend strategies and actions.
</li><li>Develop analytical models, identify trends and fluctuations, evaluate limitations of data, and specify the range of results needed for management planning, programming, and resource decisions. Generate ad-hoc reports as needed.
</li><li>Communicate with non-technical end-users to deliver reports.</li></ul>
<ul><li>Perform other related duties and participate in special projects as assigned.</li></ul><br>
<p></p>
<p><b>
Minimum Qualifications</b></p><br>
<ul>
<li>Bachelor&rsquo;s degree required.</li>
<li>Minimum two years of experience conducting education, social science, student success related research or data analytics/visualizations.</li>
<li>Demonstrated ability to interact with multiple constituents and articulate complex, multifaceted issues related to institutional effectiveness.</li>
<li>Ability to collect and analyze qualitative data from a variety of stakeholders.</li>
<li>Experience in a higher education setting using data analytics, research methods, and statistics including demonstrated experience using statistical software (SPSS, R, SAS, etc).</li>
<li>Proven ability to work in distributed systems.</li></ul><br>
<b>
Preferred Qualifications</b><br>
<ul>
<li>A Bachelor&rsquo;s degree in statistics, psychology, education, data analytics, computer engineering, computer science, or related field.</li>
<li>Master&rsquo;s or doctoral degree in these fields or other related disciplines.</li>
<li>Experience in developing, maintaining, and managing data dashboards.</li>
<li>Experience with software such as Python, SQL, and other database query reporting tools.</li></ul><p></p><p>
For fullest consideration, please submit your resume and cover letter by<b> Friday, March 20, 2026</b>.</p><p><i>
The University of Illinois System is an equal opportunity employer, including but not limited to disability and/or veteran status, and complies with all applicable state and federal employment mandates. Please visit </i><i>Required Employment Notices and Posters</i><i> to view our non-discrimination statement and find additional information about required background checks, sexual harassment/misconduct disclosures, and employment eligibility review through E-Verify.</i></p><p><i>
The university provides accommodations to applicants and employees. </i><i>Request an Accommodation</i></p><p><i>
Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position, however, all employment decisions will be made by a person.</i></p></div></div></div></div><div></div>

Undergraduate Affairs Data Analyst - ORSS

Excel Sports Management

<div><div><p><b>Excel Sports Management</b> is an industry-leading sports agency representing top-tier talent, blue-chip brands and marquee properties. Our success is rooted in our people, our high character reputation and our commitment to creating a diverse and welcoming workplace. We focus on team chemistry, collaboration, strong relationships, valuable networks, and ambitious ideas to deliver innovative solutions that keep our clients and agency ahead of the curve.</p><br>
<p></p>
<p><b><i>
Excel Sports Management is an Equal Opportunity Employer (EOE).</i></b></p></div><p><b>
Position Summary: </b>Our team is seeking a highly analytical, detail-oriented Senior Coordinator to serve as a foundational member of our Analytics and Data Operations function within Excel Analytics. This individual will sit at the intersection of data quality assurance, data governance, and applied analysis - acting as a critical connective layer between our Engineering team &amp; Analytics Ops who depend on accurate, well-structured data to do their best work. The Senior Coordinator will be responsible for establishing and maintaining data governance practices, enforcing data quality standards, documenting data definitions and lineage across our internal and syndicated data ecosystem, and supporting the broader analytics infrastructure that powers our sponsorship valuation and measurement capabilities. This role will be based in the Excel Chicago office.</p>
<p>
This is a role for someone who is operationally minded and technically curious - someone who takes ownership of data integrity, builds process where there is none, and holds a high standard for what &quot;trustworthy data&quot; means in a fast-paced client services environment. Candidates with prior experience in data operations, analytics, consulting, or a data governance-adjacent function are strongly preferred.</p>
<p>
Within Excel Sports Management, the Excel Analytics team serves as the center of gravity for all commercial marketing insights and analytics including sponsorship measurement, consumer insights, talent analytics and industry/category analysis. Excel Analytics is comprised of a vertically-integrated team of specialists supporting brand, property and talent clients, from back-end engineering, through to modeling and analytics and finally to our client-facing consultants who interpret and visualize our results.</p><br>
<p></p>
<p>
 <b>Role &amp; Responsibilities:</b></p>
<ul>
<li>Own the ongoing monitoring of data quality across key internal, syndicated, and third-party vendors/data sources.</li>
<li>Serve as the primary point of contact for day-to-day operational management between vendors and Excel Analytics.</li>
<li>Oversee Analytics' core data assets &amp; maintain a working knowledge of data sources, their structure, lineage, refresh cadence, and known limitations.</li>
<li>Establish and enforce data quality standards while documenting the logical and physical data models for our core analytics data ecosystem - including entity relationships, field mappings, and schema documentation</li>
<li>Develop and execute recurring data validation routines and automated quality checks to detect anomalies, missing records, schema drift, and inconsistencies before they reach production reporting.</li>
<li>Perform root cause analysis on data quality issues; document findings and coordinate with Engineering/DevOps to ensure timely resolution</li>
<li>Build and maintain a data dictionary and metadata repository - defining field-level definitions, acceptable value ranges, business rules, and data ownership for all key datasets</li>
<li>Partner with Engineering to support data pipeline design, ETL process documentation, and the integration of new data sources into the analytics environment</li>
<li>Evaluate and document structural changes to data sources (schema updates, field deprecations, new API versions) and assess their downstream impact on dashboards, models, and reporting outputs</li>
<li>Assist in the evaluation of new data tools, platforms, and syndicated data vendors - contributing to requirements definition and fit assessments</li>
<li>Support the Analytics Operations and Partnership Insights teams with ad hoc data requests, query writing, and data extraction across internal databases and syndicated data platforms</li>
<li>Contribute to the development of internal reporting templates and standardized analytical frameworks to drive consistency and efficiency across client deliverables</li>
<li>Establish a deep understanding of the sponsorship landscape in sports &amp; entertainment</li></ul><br>
<p></p>
<p><b>
Education &amp; Experience:</b></p>
<ul>
<li>Bachelor's degree required, preferably in Business Analytics, Statistics, Mathematics, Information Systems, Computer Science, or a related field</li>
<li>2-4 years of experience in a Data Consulting, Data Analyst, Data Architect, Data Quality, or governance-adjacent role</li>
<li>Prior experience in consulting, agency, or professional services environment strongly preferred.</li>
<li>Exposure to or interest in sports/sports marketing, entertainment/media, or marketing analytics a plus but not required.</li></ul><br>
<p></p>
<p><b>
Knowledge, Skills &amp; Abilities:</b></p>
<ul>
<li>Familiarity with data modeling concepts (entity-relationship diagrams, dimensional modeling, schema design) and the ability to read and interpret technical documentation</li>
<li>Proficiency in SQL; ability to write queries to extract, join, and validate data across relational databases</li>
<li>Working knowledge of Python or R for data manipulation and automation tasks; comfort with scripting to support validation workflows</li>
<li>Experience with data quality tools, data cataloging platforms, or metadata management systems</li>
<li>Strong documentation skills - able to write clear process guides, data dictionaries, and technical specifications for both technical and non-technical audiences</li>
<li>Detail-oriented with a high degree of accuracy; a natural ownership mentality around data integrity</li>
<li>Strong communicator - comfortable surfacing issues, presenting findings, and collaborating with stakeholders at multiple levels of the organization</li>
<li>Proactive self-starter who can manage multiple workstreams, prioritize effectively, and operate with minimal supervision</li>
<li>Intellectually curious and proactive, recognizing opportunity and implementing procedures to enhance efficiencies across the team</li>
<li>Uncompromised ethics and integrity, always focused on doing what is right for our clients</li>
<li>Knowledge of the sports and sponsorship landscapes in the US and globally</li>
<li>Ability to work both independently, and within a team, and establish effective interdepartmental relationships</li>
<li>Ability to prioritize and manage workflow in an environment of managing multiple projects simultaneously</li></ul><br>
<p></p>
<p><b>
The pay range for this position is: $70,000</b><b> per year - $80,000</b><b> per year. This position is also eligible for benefits and discretionary </b><b>bonus</b><b>.</b></p>
<p><b>
Ultimately, the salary may vary based upon, but not limited to, relevant experience, time in role, business sector, and geographic location, among other criteria.</b></p><div><p><b>
This position is not eligible for sponsorship.</b></p><br>
<p></p>
<p><i>
Excel Sports Management provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, leaves of absence, compensation and training.</i></p></div></div>

Senior Coordinator, Analytics- Data Quality and Operations

<div>
 Aon is looking for a Data Scientist Analyst to join the Health Commercial Analytics team.
 <br/>
 <br/>
 As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions as part of the Commercial Analytics team within Aon.
 <br/>
 <br/>
 This is a hybrid role with the flexibility to work both virtually and from our Atlanta, GA or Chicago, IL offices
 <br/>
 <br/>
 <strong>
  Aon is in the business of better decisions
  <br/>
  <br/>
 </strong>
 At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.
 <br/>
 <br/>
 As an organization, we are united through trust as one inclusive team and we are passionate about helping our colleagues and clients succeed.
 <br/>
 <br/>
 <strong>
  What The Day Will Look Like
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Work with large health claims and risk datasets such as eligibility data, medical claims, and prescription drug claims data.
  </li>
  <li>
   Build statistical models on large health claims and risk datasets such as eligibility data, medical claims, and prescription drug claims data.
  </li>
  <li>
   Evaluate healthcare costs, outcomes, utilization and major drivers.
  </li>
  <li>
   Collaborate with data engineering and innovation teams
  </li>
  <li>
   Translate and simplify results for presentation to clients
  </li>
  <li>
   Work in collaboration with external healthcare carriers, data vendors and startups
  </li>
  <li>
   Be up to date on upcoming vendors and startups in the healthcare space in areas such as healthcare navigation, digital health and care delivery
  </li>
  <li>
   Support client teams and actuaries with data related requests
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  How This Opportunity Is Different
  <br/>
  <br/>
 </strong>
 A competitive total rewards package, continuing education &amp; training, and tremendous potential with a growing worldwide organization.
 <br/>
 <br/>
 <strong>
  Skills And Experience That Will Lead To Success
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   2+ years&rsquo; experience in health data analytics, statistics or related area
  </li>
  <li>
   Experience in data cleaning, exploratory analysis, predictive analytics
  </li>
  <li>
   Have familiarity with medical claims reporting and billing
  </li>
  <li>
   Experience working with large datasets
  </li>
  <li>
   Strong applied statistics skills such as model training and validation, statistical testing
  </li>
  <li>
   Knowledge of Python, SQL, R or other coding languages
  </li>
  <li>
   Experience with data visualisation tools: Power BI/plotly/ Rshiny
  </li>
  <li>
   Good communication skills, both oral and in writing
  </li>
  <li>
   Good organization and time management skills; ability to work independently
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Education
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Bachelor&rsquo;s degree in actuarial science, data science, economics, mathematics, statistics or other related fields
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Pay Transparency
  <br/>
  <br/>
 </strong>
 The salary range for this position (intended for U.S. applicants) is $90,000 - $109,000 annually. The actual salary will vary based on applicant&rsquo;s education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant&rsquo;s geographic location.
 <br/>
 <br/>
 This position is eligible to participate in one of Aon&rsquo;s annual incentive plans to receive an annual discretionary bonus in addition to base salary. The amount of any bonus varies and is subject to the terms and conditions of the applicable incentive plan.
 <br/>
 <br/>
 <strong>
  How We Support Our Colleagues
  <br/>
  <br/>
 </strong>
 Aon offers a comprehensive package of benefits for full-time and regular part-time colleagues, including, but not limited to: a 401(k) savings plan with employer contributions; an employee stock purchase plan; consideration for long-term incentive awards at Aon&rsquo;s discretion; medical, dental and vision insurance, various types of leaves of absence, paid time off, including 12 paid holidays throughout the calendar year, 15 days of paid vacation per year, paid sick leave as provided under state and local paid sick leave laws, short-term disability and optional long-term disability, health savings account, health care and dependent care reimbursement accounts, employee and dependent life insurance and supplemental life and AD&amp;D insurance; optional personal insurance policies, adoption assistance, tuition assistance, commuter benefits, and an employee assistance program that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies.
 <br/>
 <br/>
 In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two &ldquo;Global Wellbeing Days&rdquo; each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions for our colleagues as well.
 <br/>
 <br/>
 Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.
 <br/>
 <br/>
 Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.
 <br/>
 <br/>
 Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status. People with criminal histories are encouraged to apply.
 <br/>
 <br/>
 We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email ReasonableAccommodations@Aon.com
 <br/>
 <br/>
 For positions in San Francisco and Los Angeles, we will consider for employment qualified applicants with arrest and conviction record in accordance with local Fair Chance ordinances.
 <br/>
 <br/>
 <strong>
  Aon is not accepting unsolicited resumes from search firms for this position. If you are a search firm, you will not be compensated in any way for your submission of a candidate, even if Aon hires that candidate.
  <br/>
  <br/>
 </strong>
 Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.
 <br/>
 <br/>
 2575501
 <br/>
 <br/>
</div>


Health Analytics - Data Science Analyst

Union Tank Car Company (UTLX)

<div>Union Tank Car Company<p></p><p>
As a part of the global industrial organization Marmon Holdings&mdash;which is backed by Berkshire Hathaway&mdash;you&rsquo;ll be doing things that matter, leading at every level, and winning a better way. We&rsquo;re committed to making a positive impact on the world, providing you with diverse learning and working opportunities, and fostering a culture where everyone&rsquo;s empowered to be their best.</p><p></p><p>
Marmon Holdings, Inc., a Berkshire Hathaway company, is significantly investing in attracting, retaining, and developing the deep and diverse talent pool needed to support our more than 100 operating companies across the globe.</p><p>
Marmon Rail &amp; Leasing helps keep the global economy moving. Marmon Rail has approximately $1.8B in revenue across the 18 total Marmon Rail business units. Our products and services enable the safe and efficient delivery of essential commodities &ndash; from crude oil to corn syrup &ndash; across continents and oceans. In Marmon&rsquo;s Rail &amp; Leasing Group, we design, build, repair and lease. With more than 125 years in the tank car business, we have established our place as the industry leader. Our integrated business model, which combines railcar manufacturing, leasing and repair, drives our success. From our industry-leading railroad tank cars and intermodal containers to a wide range of components and services, we innovate to serve our customers.</p><p></p><p>
This Summer internship is a full-time position in our Chicago office with a requirement to be in-office 5 days/week for the duration of the Summer program (approximately late May &ndash; mid-August).</p><p></p><p><b>
Business/Data Analyst Intern</b></p><p>
Our businesses are embarking on a significant process and information technology transformation. It is an exciting time, as we are in a period of rapid change. We require business analysis and project management talent to lead us through these challenges.</p><p>
Summary:</p><p>
The Business Process Analysis Team is seeking a Summer Intern (Business Analytics / Data Analytics) with strong interest in translating business problems into data-driven solutions and visual storytelling. The individual in this role should be a detail-oriented critical thinker with strong communication skills and a willingness to learn and take on challenges. The ideal candidate would possess the following skills:</p><ul><li>
Technical capability: Proficient in SQL (writing/optimizing queries across multiple tables for extraction, transformation, validation, and analysis) and DAX for modeling and measures in Power BI.</li><li>
Power BI delivery: Able to design, build, and maintain dashboards and automated reporting that supports KPI monitoring, operational visibility, and stakeholder decision-making.</li><li>
Data analysis &amp; quality mindset: Comfortable working with multiple data sources, performing data analysis, identifying gaps/inconsistencies, and supporting data quality checks/standardization (e.g., profiling, cleanse rules, documentation of findings).</li><li>
Capstone project leadership: Will lead a capstone effort to build a master data table, coordinating requirements and definitions with business process owners, subject matter experts, and IT, and translating those requirements into a usable, governed dataset.</li><li>
Project management &amp; process improvement: Brings structured execution skills&mdash;planning work, tracking progress, documenting decisions, and identifying opportunities to improve processes through analytics and standard work.</li><li>
Collaboration &amp; communication: A proactive team player who works well with others, communicates clearly with technical and non-technical stakeholders, and can turn business questions into actionable analytical outputs.</li></ul><p>
REQUIRED EDUCATION and EXPERIENCE:</p><ul><li>
Currently pursuing a bachelor&rsquo;s degree in business, economics, finance or accounting.</li><li>
Excellent analytical, problem-solving, organizational, verbal, written, and interpersonal skills</li><li>
Proficient in Microsoft Products including Word, Excel, PowerPoint, and SharePoint.</li><li>
Ability to work in a team environment.</li></ul><p>
Pay Range: $20-$24</p><p></p><p>
DISCLAIMER:</p><p>
The duties listed are not intended to be all-inclusive and may change at any time with or without notice. This job description does not constitute a contract of employment.</p><p></p><p>
Pay Range:</p>
18.00 - 22.00<p></p><p>
We offer a comprehensive benefits package that may include medical, dental, vision, 401k matching, and more!</p><p></p><p>
Following receipt of a conditional offer of employment, candidates will be required to complete additional job-related screening processes as permitted or required by applicable law.</p><p></p><p>
We are an equal opportunity employer, and all applicants will be considered for employment without attention to their membership in any protected class. If you require any reasonable accommodation to complete your application or any part of the recruiting process, please email your request to careers@marmon.com, and please be sure to include the title and the location of the position for which you are applying.</p></div>

Business/Data Analyst Intern

Explore 295+ Data analyst intern advanced sql python data engineering focus in House Video Content Creator Jobs In Person Jobs In Person Jobs In Person Jobs In Chicago this March. Find roles across top companies and apply now to boost your career.