data analyst intern (advanced sql / python / data engineering focus)

electrical engineer technical lead, data centers - remote (u.s.)

lead machine learning / data science engineer

2026-2027 yearlong quality inspections intern

21st floor spinal cord unit patient care technician full time nights 7p-7:30am

data analyst intern (advanced sql / python / data engineering focus) Jobs in Chicago

data engineer

electrical engineer technical lead, data centers - remote (u.s.) Jobs in Chicago

hr data & automation analyst Jobs in Chicago

hr data & automation analyst

lead machine learning / data science engineer Jobs in Chicago

senior backend engineer dps core data engine squad

CCC Intelligent Solutions

<div>Salary range is:
$106,277.25 - $140,000.00
This position is bonus and/or commission eligible.
CCC Intelligent Solutions Inc. (CCC) is a leading cloud platform for the multi-trillion-dollar insurance economy , creating intelligent experiences for insurers, repairers, automakers, part suppliers, and more. At CCC, we&rsquo;re making life just work by empowering more than 35,000 businesses with industry-leading technology to get drivers back on the road and to health quickly and seamlessly. We&rsquo;re pushing boundaries with innovative AI solutions that simplify and enhance the claims and repair journey. Through purposeful innovation and the strength of its connections, CCC technologies empower the people and industry relied upon to keep lives moving forward when it matters most. Learn more about CCC at www.cccis.com . 
 
<h1 class="jobSectionHeader">The Role
</h1>We are seeking a Senior Backend Engineer who is passionate about database modernization, performance optimization, and strategic refactoring of mission-critical systems. You will be a key member of the DPS Core &amp; Data Engine Squad, working on the system-of-record platform that powers both internal (DPS) and external (IES) claims management experiences supporting millions of transactions and billions of dollars in claims.
 
 
This is a modernization engineering role for someone who gets excited about:
 
<ul><li>Refactoring complex stored procedures and carving out domain logic into maintainable services
</li><li>Optimizing SQL performance and improving system efficiency
</li><li>Creating safe migration patterns that enable continuous modernization while maintaining business continuity
</li><li>Working in .NET codebases and evolving them into clean, testable, domain-aligned modules
</li></ul> 
If you love the challenge of strategic system evolution and want to participate in evolving the technical architecture of a multi-year transformation from monolithic database logic to service-oriented architecture&mdash;this role is for you. 
 
<h1 class="jobSectionHeader">Key Responsibilities:
</h1>Database Engineering &amp; Modernization (60%)
<ul><li>Stored procedure refactoring: Analyze, optimize, and decompose complex stored procedures into smaller, testable, well-documented units
</li><li>Performance engineering: Query tuning, indexing strategy, execution plan analysis, optimizing data access patterns
</li><li>Schema evolution: Design backward-compatible schema changes with safe rollout/rollback patterns
</li><li>Migration seams: Create facades, wrappers, and anti-corruption layers around stored procedures to enable gradual extraction of business logic into services
</li></ul>Legacy .NET Modernization (30%)
<ul><li>Refactor .NET Framework code supporting DPS workflows into maintainable, testable modules
</li>Implement strangler fig patterns to incrementally move logic from database<li> service layer while maintaining production stability
</li><li>Build domain-aligned modules/services with clear contracts that enable the Domain &amp; Services Squad to extract capabilities
</li><li>Establish patterns for dependency injection, observability, and error handling in established .NET codebases
</li></ul>Operational Excellence (10%)
<ul><li>Implement performance baselines, regression detection, and alerting for data-intensive workflows
</li><li>Participate in incident response for data/performance-related production issues
</li><li>Create diagnostic tooling and runbooks to reduce time-to-resolution
</li>Collaborate with SRE/DevOps on deployment safety (blue/green, feature flags, canary releases for schema changes) 
<li>
</li></ul> 
<h1 class="jobSectionHeader">Requirements:
</h1>Technical Skills
Must-Have:
<ul><li>8+ years of professional software development experience in object-oriented languages (C#/.NET required)
</li><li>Expert-level SQL Server knowledge (SQL Server 2019):
</li><li>Advanced query optimization (execution plans, index tuning, query hints)
</li><li>Stored procedure, function, and trigger development/refactoring
</li><li>Database design and normalization
</li><li>Performance tuning at scale (multi-million row tables, complex joins, aggregations)
</li><li>Understanding of indexing strategies (clustered, non-clustered, filtered, columnstore)
</li><li>SQL Agent jobs and automated workflow patterns
</li><li>Transaction isolation levels, locking, and concurrency management
</li><li>C# and .NET Framework/.NET Core (legacy and modern)
</li><li>Experience refactoring established systems while maintaining production stability
</li><li>SQL source control (migrations, version control for schema/stored procedures)
</li></ul>Highly Desired:
<ul><li>Experience with strangler fig, anti-corruption layer, and facade patterns in practice
</li>Hands-on experience migrating logic from stored procedures<li> service layer in production systems
</li><li>Familiarity with domain-driven design (DDD) concepts (bounded contexts, aggregates, repositories)
</li><li>Azure SQL Database, Azure DevOps experience
</li><li>Observability tools (Application Insights, SQL Profiler)
</li><li>API design and versioning (REST, OpenAPI/Swagger)
</li><li>Unit testing frameworks (xUnit, NUnit) and test data builder patterns
</li><li>PowerShell for database scripting/automation
</li><li>Experience with microservices architecture and event-driven patterns
</li><li>Familiarity with Entity Framework Core, Dapper, or other ORMs (and knowing when to use native SQL)
</li></ul>Non-Technical Skills
Required:
<ul><li>Ownership mindset: You see complex stored procedures as opportunities for meaningful improvement
</li><li>Pragmatic modernization philosophy: Balance architectural excellence with incremental, safe delivery
</li><li>Strong communication: Explain complex technical decisions to non-engineers; write clear documentation and migration runbooks
</li><li>Collaboration over hero-coding: You enable your team and adjacent squads; you're a force multiplier
</li><li>Comfort with ambiguity: System modernization requires creating the roadmap as you execute&mdash;you'll help define the path
</li>Detail-oriented with systems thinking: See both the specific query and the broader data flow/architectural impact 
<li>
</li></ul> 
<div><div><div><div><div><div><div><h1 class="jobSectionHeader">About CCC's Commitment to Employees:
</h1></div></div></div></div></div></div></div>CCC Intelligent Solutions understands that our employees play an integral role in our vision to shape a world where life just works. Our team is defined by our values of Integrity, Customer-Focus, Innovation, Inclusion &amp; Diversity, Tenacity, and Connection. Through diverse perspectives, purposeful innovation, and the strength of connections, our technologies empower the people and industry relied upon to keep lives moving forward when it matters most.
At CCC, together everyone can thrive as we innovate and collaborate, creating employee experiences that just work. We are committed to providing opportunities for our people to make real-life impacts, advance in their careers, and contribute to CCC&rsquo;s success.
CCC offers competitive compensation and benefits to support you and your families, including:
<ul><li>401K Match
</li><li>Paid time off
</li><li>Annual Incentive Plan Performance Bonus
</li><li>Comprehensive health insurance
</li><li>Adoption Assistance
</li><li>Tuition Reimbursement
</li><li>Wellness Programs
</li><li>Stock Purchase Plan options
</li><li>Employee Resource Groups
</li></ul>For more information about our benefits, please check out our careers site .
Here, you belong. You are seen, valued, and respected. We celebrate you for who you are and all you bring. Every voice is heard and is important to our success. You can hear what employees have to say about our culture here
If you require reasonable accommodation to complete a job application, please contact (800) 621-8070.</div>

Senior Backend Engineer – DPS Core & Data Engine Squad

Sands Investment Group

<div>Sands Investment Group (SIG) is hiring a high-performing Senior Commercial Real Estate Advisor to join our team. Whether you have a few years of experience, or a track record of 8 figure deal volume, we offer the tools, deal flow, and support to help you scale a multimillion dollar brokerage business 
 
This is a 100% commission based role designed for entrepreneurial professionals who are hungry to grow. Top performers are earning 300K-1M+ annually. 
 
Why Join SIG? 
<ul><li>National Platform with $10.1 billion in closed transactions</li><li>Industry leading lead generation tools, proprietary systems, and full time marketing engine built by brokers</li><li>One-on-one mentorship with Managing Directors and senior producers</li><li>Access to $1.5 billion in inventory 
</li></ul> 
 
What You'll Do 
<ul><li>Drive lead generation and nurture relationships with investors and property owners</li><li>Oversee full deal pipeline: listings, marketing, negotiations, LOIs, PSAs, due diligence, and closings</li><li>Collaborate with your team and marketing staff to bring deals to market</li><li>Produce Broker Opinion of Values (BOVs), pull comps, and pitch opportunities</li><li>Own key accounts and client relationships within your product specialization</li></ul> 
Who Are You 
<ul><li>5+ Years in commercial real estate, or investment sales</li><li>Proven closer or producer looking for a stronger platform</li><li>Licensed Real Estate Agent or actively pursuing licensing</li><li>Comfortable with CRM systems, data tools, and financial analysis</li><li>A culture fit: Collaborative, Coachable, Communicative, and Consistent</li></ul> 
Compensation 
<ul><li>100% commission-based role, no cap on earnings</li><li>Senior Advisors earn 150K-300K with top performers exceeding 500K+</li><li>Includes access to SIG's national inventory, CRM, marketing systems, and training</li></ul> 
Office Location 
Offices In: Atlanta, Austin, Charleston, Charlotte, Chicago, Fort Lauderdale, Los Angeles, Nashville, and Philadelphia</div>

Senior Commercial Real Estate Advisor

Roblox

<div>Chicago, Illinois, United StatesEngineeringID: 5793</div>
 <div><div><div>Every day, tens of millions of people come to Roblox to explore, create, play, learn, and connect with friends in 3D immersive digital experiences&ndash; all created by our global community of developers and creators.
At Roblox, we&rsquo;re building the tools and platform that empower our community to bring any experience that they can imagine to life. Our vision is to reimagine the way people come together, from anywhere in the world, and on any device. We&rsquo;re on a mission to connect a billion people with optimism and civility, and looking for amazing talent to help us get there.
A career at Roblox means you&rsquo;ll be working to shape the future of human interaction, solving unique technical challenges at scale, and helping to create safer, more civil shared experiences for everyone.</div>
As a Senior Data Center Engineer, you'll help us scale our Core/Edge Data Centers and hardware infrastructure at a time of incredible growth for our business. At Roblox, you'll have boundless opportunities to shape the future of the Imagination Platform&trade; and demonstrate your passion for delivering thoughtful solutions in front of a global audience. If you know what it takes to build and operate hardware infrastructure that can sustain millions of concurrent players year-round and you take play as seriously as we do, you'll fit right into our highly experienced and ever-expanding engineering team. You will report to the Technical Lead Data Center Engineer.

You will:
<ul>
<li>Develop and maintain the Core/Edge Data Center and hardware infrastructure to meet the large scale and real-time requirements of our Imagination Platform&trade; to ensure our community has an awesome experience anywhere in the world. This includes all aspects of the server, network infrastructure, power, and environmental life cycles.</li>
<li>Own efforts to track and mitigate systemic issues preventing hosts from returning to service.</li>
<li>Identify and solve critical problems and prevent them from re-occurring via root cause analysis and giving recommendations to improve automation.</li>
<li>Coordinate with peers to establish and uphold best practices related to breakfix, install, decom and all other aspects of datacenter operations.</li>
<li>Create, influence, and improve the development platform, infrastructure, standards (Runbooks, SOPs, MOPs), and methods to ensure the goal of scalability and high availability can be achieved.</li>
<li>Leverage partnerships across teams to automate maintenance actions which do not require physical intervention.</li>
<li>Encourage an environment of continuous improvement and learning among engineering staff.</li>
<li>Assist in coordinating vendors and ensuring quality of outsourced projects</li>
<li>Participate in the on-call rotation for our critical infrastructure.</li>
<li>Travel: International and Domestic travel may be required 25% of the time and up to 50% of time depending on needs of the business.</li>
</ul>
You have:
<ul>
<li>At minimum 6+ years of experience working in large-scale Data Center Infrastructure environments and experience planning, executing, and documenting repairs in the server and networking domains.</li>
<li>Extensive experience installing, monitoring, and maintaining server and network equipment. This includes brand new server and network provisioning.</li>
<li>In-depth knowledge of data center environments, servers, and network equipment.</li>
<li>Proven experience executing on multiple tasks simultaneously.</li>
<li>You have installed various equipment that commonly resides in the data center environment and are able to lift 75 pounds occasionally.</li>
</ul>
You are:
<ul>
<li>Someone who is ready for action wielding a wealth of server and network hardware troubleshooting knowledge to support Roblox&rsquo;s systems.</li>
<li>Excited about getting in front of complex problems, and can effectively organize your work to overcome emergent high-impact issues.</li>
<li>Someone who enjoys building processes and procedures for the day to execute our workload and for developing new capabilities as a team.</li>
<li>Someone who asks the right questions to solve issues within your expertise and you use data to test your theories. You are able to formulate and identify problems, generate and evaluate a variety of solutions (some of which are novel), and implement the best one(s).</li>
<li>Someone who is committed to demonstrating professionalism in all interactions with partners both inside and outside Roblox to ensure continued success in cross-functional initiatives. You are able to foster trust and uphold the reputation of the team and company.</li>
</ul><div><div><div>
For roles that are based at our data center in Elk Grove Village, IL: The starting base pay for this position is as shown below. The actual base pay is dependent upon a variety of job-related factors such as professional background, training, work experience, location, business needs and market demand. Therefore, in some circumstances, the actual salary could fall outside of this expected range. This pay range is subject to change and may be modified in the future. All full-time employees are also eligible for equity compensation and for benefits as described on this page.</div><div>
Annual Salary Range</div><div>
$143,870&mdash;$174,540 USD</div></div></div><div>
Roles that are based in an office are onsite Tuesday, Wednesday, and Thursday, with optional presence on Monday and Friday (unless otherwise noted).

Roblox provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Roblox also provides reasonable accommodations to candidates with qualifying disabilities or religious beliefs during the recruiting process.</div></div></div>

Senior Data Center Engineer

Ascot Group

<div>This is an opportunity to join Ascot Group - one of the world&rsquo;s preeminent specialty risk underwriting organizations. 
Designed as a modern-era company operating through an ecosystem of interconnected global operating platforms, we&rsquo;re bound by a common mission and purpose: One Ascot. Our greatest strength is a talented team who flourishes in a collaborative, inclusive, and entrepreneurial culture, steeped in underwriting excellence, integrity, and a passion to find a better way, The Ascot Way. 
The Ascot Way guides our people and our organization. Our underwriting platforms collaborate to find creative ways to deploy our capital in a true cross-product and cross-platform approach. These platforms work as one, deploying our capital creatively through our unique Fusion Model: Client Centric, Risk Centric, Technology Centric. 
Built to be resilient, Ascot maximizes client financial security while delivering bespoke products and world class service &mdash; both pre- and post-claims. Ascot exists to solve our clients&rsquo; brightest tomorrow, through agility, collaboration, resilience, and discipline. 
Position Overview: 
Reporting to the Business Intelligence Lead, the Business Intelligence Engineer supports the development and maintenance of Power BI reports and dashboards used across Ascot&rsquo;s business, operations, and finance teams. This role works closely with senior BI engineers, data engineers, and business partners to deliver accurate, well-structured reporting solutions. The ideal candidate has a foundational understanding of Power BI and SQL, strong attention to detail, and a desire to continue developing technical and analytical skills in an enterprise data environment. This role will be in the office with a hybrid work schedule. 
Responsibilities: 
<ul><li>Assist in the development and maintenance of Power BI reports, dashboards, and datasets.
</li><li>Support Power BI semantic models by creating and maintaining basic measures, calculated columns, and relationships.
</li><li>Write and modify SQL queries to retrieve and validate data from enterprise data sources.
</li><li>Perform data validation and reconciliation to ensure reports are accurate and align with source systems.
</li><li>Work with senior developers and data engineers to understand data structures, definitions, and reporting standards.
</li><li>Help address report defects, enhancements, and routine maintenance requests.
</li><li>Participate in requirements discussions to understand reporting needs and assist in translating them into Power BI solutions.
</li><li>Follow established development standards, naming conventions, and documentation practices.
</li><li>Learn and apply best practices related to data modeling, report performance, and usability.
</li><li>Commitment to The Ascot Way: Embody The Ascot Way in their daily interaction with colleagues, fostering colleague engagement and development, collaboration, inclusivity, and individual accountability 
</li></ul>Requirements: 
<ul><li>Bachelor&rsquo;s degree in information systems, Data Analytics, Computer Science, or a related field (or equivalent experience).
</li><li>2&ndash;3 years of experience working with Power BI in a professional or business setting.
</li><li>Some experience working with relational databases and structured datasets.
</li><li>Strong attention to detail and commitment to data accuracy.
</li><li>Ability to work effectively in a collaborative, team-based environment.
</li><li>Willingness to learn new tools, techniques, and business concepts.
</li><li>Power BI fundamentals, including:
<ul><li><div>Report and dashboard creation
</div></li><li><div>Basic data modeling concepts
</div></li><li><div>Introductory DAX measures and calculations
</div></li></ul></li><li>Working knowledge of SQL for querying and validating data.
</li><li>Familiarity with relational databases (e.g., SQL Server or similar platforms).
</li><li>Basic understanding of data warehousing and ETL concepts.
</li><li>Ability to read and follow existing data models and report designs.
</li><li>Analytical mindset with strong problem-solving skills.
</li><li>High attention to detail and data quality.
</li><li>Clear written and verbal communication skills.
</li><li>Positive attitude and eagerness to grow technical capabilities. 
</li></ul>***This position may be filled at a different level, depending on experience*** 
Compensation: 
Actual base pay could vary and may be above or below the listed range based on factors including but not limited to experience, subject matter expertise, and skills. The base pay is just one component of Ascot&rsquo;s total compensation package for employees. Other rewards may include an annual cash bonus and other forms of discretionary compensation awarded by the Company. 
The annualized base pay range for this role is: $95,000 - $110,000 
Company Benefits: 
The Company provides a competitive benefits package that includes the following (eligibility requirements apply):
<ul><li>Health and Welfare Benefits: Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Life Insurance, AD&amp;D, Work/Life Resources (including Employee Assistance Program), and more
</li><li>Leave Benefits: Paid holidays, annual Paid Time Off (includes paid state /local paid leave where required), Short-term Disability, Long-term Disability, Other leaves (e.g., Bereavement, FMLA, Adoption, Maternity, Military, Primary &amp; Non-Primary Caregiver)
</li>Retirement Benefits: Contributory Savings Plan (401k) 
<li>
</li></ul>#LI-Hybrid</div>

Business Intelligence Engineer

Excel Sports Management

<div><div>Excel Sports Management 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. 


Excel Sports Management is an Equal Opportunity Employer (EOE).</div>
Position Summary: 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.

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.

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. 


 Role &amp; Responsibilities:
<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> 


Education &amp; Experience:
<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> 


Knowledge, Skills &amp; Abilities:
<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> 


The pay range for this position is: $70,000 per year - $80,000 per year. This position is also eligible for benefits and discretionary bonus.

Ultimately, the salary may vary based upon, but not limited to, relevant experience, time in role, business sector, and geographic location, among other criteria.<div>
This position is not eligible for sponsorship. 


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.</div></div>

Senior Coordinator, Analytics- Data Quality and Operations

Per Scholas

ABOUT PER SCHOLAS: For 30 years, Per Scholas has been on a mission to drive mobility and opportunity in the ever-advancing technology landscape by unlocking the untapped potential of individuals, uplifting communities, and meeting the needs of employers through rigorous tech training. By teaming up with dynamic employer partners, ranging from Fortune 500 companies to innovative startups, we're forging inclusive tech talent pipelines, fulfilling an ever-increasing need for skilled talent. With national remote training and campuses in 20+ cities and counting, Per Scholas offers no-cost training programs in the most sought-after tech skills, spanning Cloud, Cybersecurity, Data Engineering, IT Support, Software Engineering, and more. To date, 30,000+ individuals have been trained through Per Scholas, propelling their professional trajectories into high-growth tech careers with salaries three times higher than their pre-training earnings. Learn more by visiting PerScholas.org and follow us on LinkedIn, X, Facebook, Instagram, and YouTube. Per Scholas preferred hires reside within the following states: AZ, CA, CO, FL, GA, IL, IN, KS, MD, MA, MI, MO, NC, NJ, NY, OH, PA, TX, WA REPORTS TO: Site Director LOCATION: Chicago, Illinois Who We Are Looking For Per Scholas is seeking a multi-talented Technical Instructor to deliver high-end training in both Cybersecurity and Software Engineering. You will play a critical role in our mission to unlock untapped potential and create inclusive tech talent pipelines for entry-to-mid-level roles. Per Scholas is seeking a Technical Instructor to deliver high-end technical training to underemployed and unemployed community residents for purposes of higher economic development and improvement of quality of life at the Per Scholas Chicago Campus in the Loop, and at our satellite campus on the South Side. The Technical Instructor must be self-directed and self-motivated, and comfortable with making intermediate-level decisions to adapt processes and curriculum delivery based on current conditions. The Technical Instructor works in collaboration with peers with learner support and works with the Managing Director to change policies, procedures, and strategic planning. WHAT YOU'LL DO Instruction &amp; Facilitation Using a structured and approved curriculum, conduct a full-time, 15-week cycle of technical training to prepare students for entry to mid-level jobs in the field of Cyber Security and/or Software Engineering. Technical training competencies include but are not limited to: hardware, software, networking, security, server, mobility, virtualization, and project management. Deliver technology skills training and assessments to prepare students for entry-level to mid-level careers in the field of software development and Cybersecurity Daily instruction, assessment administration, attendance, one-on-one tutoring, evaluation, and monitoring of individual student progress. Facilitate a highly interactive, hands-on instructional style leveraging a flipped classroom model and simulating workplace environments. Comfortable facilitating project-based learning that simulates real-world engineering workflows, including teamwork, deadlines, and iterative improvement. Utilize in-house Learning Management System for assignments, tests, and real-time performance monitoring Manage and appropriately utilize a teaching assistant Maintain regular office hours WHAT YOU'LL BRING TO US Professional Requirements The &quot;Full-Stack&quot;: Strong proficiency in modern JavaScript and frontend development, including HTML5, CSS3, and React (or comparable frameworks). Experience building backend services using Node.js, RESTful APIs, and server-side application architecture. Working knowledge of relational databases (SQL); familiarity with NoSQL databases is a plus. Engineering Fundamentals: Solid understanding of core software engineering practices, including version control (Git/GitHub), debugging techniques, API integration, and collaborative development workflows. Security Credentials: Expert-level knowledge in networking, virtualization, and server management. CompTIA Security+ 701 is required. Teaching Experience: Proven ability to teach adults in a hands-on environment. Experience with lesson planning and student assessment is required. Physical Requirement: Must be able to comfortably and frequently lift 50lbs. Personal Characteristics Mission-Driven: You believe talent is universal but opportunity is not; you are a catalyst for social change. Adaptable: You can pivot from debugging a React component to analyzing a packet capture in Wireshark. Collaborative: You thrive in a fast-paced environment and enjoy working cross-functionally with Career Coaches and Program Managers. COMPENSATION For this dual-competency role, we are targeting a salary of $75,000/year, determined by geography and the specific depth of experience in both disciplines. #LI-Onsite QUESTIONS? If you have any questions about this role, please feel free to email our Talent team at jobs@perscholas.org. We look forward to viewing your application! Equal Employment Opportunity We're proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or national origin. PII Policies Non-Discrimination Policy

Technical Instructor - Cybersecurity/Software Engineering

Machinery Marketing Inter

Data Analyst Intern (Advanced SQL / Python / Data Engineering Focus)Location: On site (Chicago preferred) Duration: 6 months Type: Internship (High-Impact Technical Track)Role OverviewWe are seeking a highly technical Data Analyst Intern 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.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.Core Responsibilities1. Advanced SQL &amp; Query Optimization<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>Expected databases:<ul><li>PostgreSQL / MySQL / SQL Server</li><li>Familiarity with columnar systems (Redshift / BigQuery / Snowflake) is a plus</li></ul>2. Data Modeling &amp; Warehousing<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>3. Python &amp; Data Pipelines<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>4. Statistical &amp; Experimental Analysis<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>5. Dev &amp; Infrastructure Exposure<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>Required Qualifications<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>Preferred Qualifications<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>Compensation<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>Pay: From $20.00 per hourWork Location: In person

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

Explore 181+ Senior backend engineer dps core data engine squad in Chicago this March. Find roles across top companies and apply now to boost your career.