Data analyst jobs in Downers Grove, IL

Senior Data Analyst on W2 Duration: 3 months (may extend/convert) We are seeking a Senior Data Analyst to ensure the accuracy, consistency, and integrity of master data across SAP and other platforms for our medical device and pharmaceutical business. This role involves data governance, process optimization, and cross-functional collaboration to drive operational efficiencies and implement best practices. Key Responsibilities: Manage day-to-day activities of the Customer Master Data team. Support data governance, ensure data quality, and optimize processes. Assist in pricing, licensing updates, rebates, and regulatory compliance. Serve as SME for new system integrations and enhancements. Participate in process improvement initiatives and special projects. Requirements: Bachelor's degree + 5+ yrs experience (3+ yrs in pharma/medical device). SAP experience, strong analytical and problem-solving skills. Expert in Excel and handling large datasets. Strong communication, collaboration, and leadership skills. Ability to work independently in a fast-paced environment. Interview Process: 1st round: Sr. Manager & Sr. Director (Virtual) 2nd round: Team Lead (Virtual)

The Aspen Group (TAG) is one of the largest and most trusted retail healthcare business support organizations in the U.S. and has supported over 20,000 healthcare professionals and team members with close to 1,500 health and wellness offices across 48 states in four distinct categories: dental care, urgent care, medical aesthetics, and animal health. Working in partnership with independent practice owners and clinicians, the team is united by a single purpose: to prove that healthcare can be better and smarter for everyone. TAG provides a comprehensive suite of centralized business support services that power the impact of five consumer-facing businesses: Aspen Dental, ClearChoice Dental Implant Centers, WellNow Urgent Care, Chapter Aesthetic Studio, and Lovet Pet Health Care. Each brand has access to a deep community of experts, tools and resources to grow their practices, and an unwavering commitment to delivering high-quality consumer healthcare experiences at scale. As a reflection of our current needs and planned growth we are very pleased to offer a new opportunity to join our dedicated team as Data Scientist. Join us as a Data Scientist and play a key role in shaping how patients access care across a growing network of brands including Aspen Dental, ClearChoice, WellNow, Chapter Aesthetic Studio, and Lovet. In this role, you won't just analyze data - you'll lead end-to-end initiatives that shape how we optimize revenue across offices, days, and even hours. From designing strategies, deploying solutions and building performance dashboards to partnering with data science on automation and collaborating with teams across Finance, Marketing, Product, Technology and Operations, you'll have a direct hand in driving measurable results. This role is ideal for someone who excels at turning data into decisions, building repeatable processes, and uncovering insights that drive measurable improvements in revenue performance and patient access. You will lead initiatives across forecasting, scheduling optimization, demand modeling, capacity planning, and revenue strategy, while also shaping how analytics is delivered and scaled across the organization. If you're a builder who loves solving complex problems with data, operational logic, and automation, this opportunity is for you. Essential Responsibilities: Revenue Strategy & Optimization Lead strategy development for optimizing revenue performance at the office, day, and hour level by leveraging forecasting, scheduling, and demand modeling - while balancing access for patients and operational efficiency. Build analytical frameworks to support pricing, demand forecasting, scheduling, and access optimization. Identify revenue opportunities through data-driven analysis of booking trends, cancellations, no-shows, and utilization. Monitor and update demand and schedule availability through the analysis of historical and future booking trends, the pricing environment, industry capacity trends, competitive landscape, and other factors. Analytics, Insights & Experimentation Develop and maintain forecasting, demand models, dashboards, and scenario analyses. Run experiments and structured tests to evaluate new operational and scheduling strategies. Create clear, actionable insights that influence senior leaders and cross-functional partners. Process Building & Automation Map existing manual workflows and identify opportunities to automate recurring analyses or reporting. Cross-Functional Leadership Work closely with Operations, Finance, Product, Marketing, and Clinical teams to align strategies and execution. Help shape and scale the function by building new playbooks, reports, and best practices. Act as a subject matter expert in forecasting, demand modeling, and capacity optimization. Qualifications (Skills-Based): We welcome candidates with diverse academic and career pathways. You may have gained your skills through industry experience, coursework, certificates, or hands-on practice. Experience/Education: 5+ years of experience in Revenue Management, Pricing, Operations Research, Supply/Demand Optimization (Airline, Travel, Healthcare, or multi-location service industries preferred). Bachelor's degree in Business, Finance, Economics, Analytics, or Statistics required; Master's degree a plus. Experience working alongside data science/engineering teams to automate and scale analytics processes. Exceptional analytical, problem-solving, and communication skills - with the ability to influence senior stakeholders. Detail-oriented, self-starter mindset with a passion for driving results. Strong analytical and quantitative skills, with experience in forecasting, modeling, or optimization. Strong technical proficiency in SQL and a modern BI platform (e.g., Tableau, Looker). Familiarity with scripting (e.g., Python or R) or automation tools (e.g., DBT, Airflow) - not required, but helpful. Additional Job Description: Base Pay Range: $115,000 - $130,000, plus 10% annual bonus (Actual pay may vary based on experience, performance, and qualifications.) A generous benefits package that includes paid time off, health, dental, vision, and 401(k) savings plan with match. If you are an applicant residing in California, please view our privacy policy here: *********************************************************************************

The Business Systems Analyst (BSA) is responsible for managing the WMS, ERP, OMS, including the oversight and resolution of EDI issues. The BSA will lead the coordination and resolution of break/fix issues, maintain project lists, gather detailed business requirements from internal stakeholders, and ensure systems alignment with business objectives. This is a 100% onsite position with no exceptions. Key Responsibilities: Provide training and guidance to internal staff and end-users on system functionalities and processes. Act as primary point of contact for all ERP, WMS, OMS, PIM, and EDI-related issues. Manage and prioritize break/fix incidents, enhancements, system upgrades, and collaborate closely with internal staff and external vendors. Develop and maintain detailed documentation, including project lists, functional requirements, process flows, and training materials. Regularly meet with internal stakeholders to identify and document project requirements and enhancement opportunities. Translate business requirements into technical specifications to facilitate clear communication with technical teams or vendors. Perform system testing and validation, and provide guidance to end-users for UAT (User Acceptance Testing). Proactively monitor system performance and provide recommendations for improvements and upgrades. Work with internal business and IT staff to plan and execute system upgrades and new implementations. Provide support during business hours and after hours (weekends included) and act as the primary point of contact for urgent issues. Required Skills & Qualifications: Bachelor's degree in Information Systems, Business Administration, or related field. Minimum 3-5 years of experience in a Business Systems Analyst or similar role. Experience supporting ERP and WMS systems, ERP and/or AS preferred. Strong analytical skills with the ability to translate complex business requirements into technical specifications. Excellent verbal and written communication, interpersonal skills, and stakeholder management. Proven ability to manage multiple priorities and effectively troubleshoot issues. Experience managing relationships with external vendors and service providers. Familiarity with integration tools (middleware platforms like MuleSoft, Boomi, or Informatica). Understanding of EDI (Electronic Data Interchange) processes, integrations, and troubleshooting. Knowledge of reporting and analytics tools such as Power BI. Preferred Qualifications: Familiarity with warehouse and logistics operations, particularly in the manufacturing or automotive industry. Experience with SQL and Python required. Familiarity with on-premises (Veeam) and cloud infrastructure (AWS or Azure). Project management certifications (such as PMP or Agile certifications). Experience with Microsoft Project, Microsoft Visio, or other similar tools. ERP/WMS systems management certifications. ITIL Foundation Certification. Exposure to Lean, Six Sigma, or continuous improvement methodologies. Compensation: The salary range for this position is $85,000 to $120,000 annually, reflecting the anticipated compensation at the time of posting. Final placement within this range will be determined by several factors, including-but not limited to-education, certifications, relevant experience, skills, and overall business needs. In addition to salary, eligible employees will receive a comprehensive benefits package, which includes paid time off, medical, dental, and vision insurance, life insurance, short- and long-term disability coverage, paid parental leave, and a 401(k) match retirement plan. Company Overview: PowerStop is the leading innovator and market leader in aftermarket automotive brake kits, holding the top share across all major online retail platforms and distinguished by its best-in-class omni-channel operational excellence. The company's core product portfolio includes complete brake kits-sold through leading eCommerce retailers such as Amazon, RockAuto, and AutoZone-as well as brake components and accessories distributed primarily through traditional warehouse channels. Unlike traditional brake suppliers, PowerStop was born in the digital era, pioneering a category-defining product specifically engineered for the online marketplace: the all-in-one brake kit. Each kit contains every component required for a full brake replacement or performance upgrade, offering consumers unmatched convenience and value. Today, more than 70% of PowerStop's revenue is generated through online channels. Its leadership position is underpinned by a strong consumer brand, differentiated product offering, and world-class fulfillment capabilities. PowerStop has also built enduring partnerships with warehouse distributors, recognized for its exceptional service, product quality, and industry-leading logistics. With a proven track record of consistent double-digit organic growth over the past decade, PowerStop's success is driven by its consumer-centric approach, deep market coverage (serving approximately 98% of the vehicle parc), and operational excellence across every segment of the value spectrum. The company continues to build on this foundation through multiple growth levers, including expansion into new product categories, further penetration of the DIFM (“Do It For Me”) and IIFM (“Install It For Me”) markets, and targeted strategic acquisitions. Headquartered in Burr Ridge, Illinois, PowerStop employs more than 550 team members across its corporate and operational facilities. The company operates two major distribution centers: a 230,000-square-foot eCommerce facility in Bedford Park, Illinois, and a 500,000-square-foot facility in Hodgkins, Illinois, designed to serve larger stocking and replenishment orders. Work Environment: This position operates in a professional office environment with occasional time spent in warehouse operations for system-related tasks. Travel: Travel is required between all company locations and vendor sites based on project needs or issue resolution.

GeoWealth is a Chicago-based fintech firm that offers an award-winning digital advisory platform, including Turnkey Asset Management Platform (“TAMP”) capabilities. We deliver a comprehensive and fully integrated wealth management technology platform to professionals in the financial services industry. OPPORTUNITY: We're looking for a Data Architect to join our Engineering Team. In this role, you will oversee the overall data architecture, helping us deliver our best-in-class solutions to our customers. This role will be key in organizing, designing, and leading our team through well-designed data architecture. If you love architecting complex systems, delivering customer focused software, designing best-in-class systems and leading data architecture design this role is for you. RESPONSIBILITIES: Own data architecture and oversee data implementation Set coding/implementation standards Lead our data warehouse design Deliver performant, maintainable, and quality software in collaboration with our teams. Improve our database design to reduce replication and increase performance Partner with other architects and engineers to produce better designed systems SKILLS, KNOWLEDGE, AND EXPERIENCE: 5+ years of experience as Data Architect or equivalent role Bachelor's degree in computer science or equivalent degree Hands-on experience with Oracle Designed and implemented data warehouse Experience with the following is preferred but not required: designing and building monolithic and distributed systems, Postgres, Logi Symphony, PowerBI, Java and JIRA/Confluence COMPANY CULTURE & PERKS - HIGHLIGHTS: Investing in Your Growth 🌱 Casual work environment with fun, hard-working, and open-minded coworkers Competitive salary with opportunity for performance-based annual bonus Opportunities to up-skill, explore new responsibilities, and network across departments Defined and undefined career pathways allowing you to grow your own way Work/Life Balance 🗓️ Flexible PTO and work schedule to ensure our team balances work and life Hybrid work schedule Maternity and paternity leave Taking Care of Your Future ♥️ Medical, Dental, and Vision, Disability insurance Free access to Spring Health, a comprehensive mental health solution 401(k) with company match and a broad selection of investments Voluntary insurance: short-term disability, long-term disability, and life insurance FSA and transit benefits for employees that contribute pre-tax dollars Other Fun Stuff ⭐ Free on-site gym and parking Weekly catered lunches in the office, plus monthly happy hours Stocked kitchen with snacks and drinks GeoWealth was recognized as “Best Place to Work” by Purpose Job's 2025, 2024 and 2022 GeoWealth was recognized as “Best Place to Work” by Built In in 2024, 2023 and 2022 SALARY RANGE: Starting at $170,000-$220,000 + Benefits + Opportunity for Performance Bonus This is an estimated range based on the circumstances at the time of posting, however, may change based on a combination of factors, including but not limited to skills, experience, education, market factors, geographical location, budget, and demand.

Chicago Based, no relocation support; We are looking to fill this role ASAP *This role is intended to be converted to a full-time position for the right candidate. *No ChatGPT during interview The AI Data Strategy Intern will play a key role in advancing data-driven decision-making processes while contributing to the development of AI models and supporting and enhancing the organization's AI environment. Reporting to the Director of Data Strategy, the intern will work with diverse datasets, explore their sources, and utilize the Datawarehouse for data extraction, transformation, and analysis. This role offers an excellent opportunity to gain hands-on experience in AI and data analytics while supporting the mission to strengthen faith communities and make a meaningful impact. Essential Functions & Job Performance Criteria Analyze donor data to uncover insights and patterns. Utilize SQL to cleanse, transform, and extract donor information. Assist in developing and maintaining fundraising performance reports using Power BI. Contribute to the development, maintenance, and optimization of AI models to support predictive fundraising outcomes and other organizational initiatives. Support and enhance the organization's AI environment, ensuring its effective use in analytics and decision-making. Perform data management tasks such as deduplication, migration, and addressing data integrity issues. Adhere to security standards and protocols in handling donor information. Troubleshoot and resolve data-related challenges effectively. Identify opportunities for process enhancement and efficiency within fundraising operations. Assist with other duties as needed to support fundraising and AI-related initiatives. Qualifications Pursuing or holding a bachelor's degree in Data Science, Computer Science, or Engineering Proficiency in data structures and SQL, with strong data manipulation skills. Familiarity with data analytics concepts and AI/ML fundamentals. Interest in AI development and its applications. Strong problem-solving skills with a technical mindset. Ability to communicate analysis results to both technical and non-technical audiences. Demonstrates a growth mindset and a positive attitude. Interest in working with data for performance measurement, decision-making, and AI applications. Ability to collaborate effectively in a team-oriented, fast-paced environment at our downtown Chicago location. Strong organizational and prioritization skills. Capacity to work independently while maintaining open communication. Self-motivated with excellent organizational abilities. Demonstrates personal integrity, credibility, and a dedication to the organization's mission. Appreciation for and understanding of the teachings and traditions of the Roman Catholic Church. A passion for your field and a sense of humor. Full time position but part time optional if need be (students only)

Minimum Qualifications: ● 5+ years of experience leading data science projects that have a direct impact on a company's objectives or PhD degree in quantitative fields such as Statistics, Data Science, Computer Science with 3+ years of experience ● 5+ years of experience utilizing data mining techniques, ML models to assist business decision making. Hands-on experience with deep learning frameworks , LLMs, GenAI tools, and NLP techniques. ● Deep expertise in statistical methods and machine learning concepts, with the ability to mentor team members on methodologies, model tuning, and evaluation techniques. ● 2+ years hands-on experience with deep learning frameworks, LLMs, GenAI tools, and NLP techniques. ● 5+ years of experience using Python to process large, diverse datasets, and develop and deploy predictive models in cloud-based environments and other computing platforms. ● 5+ years of experience in SQL and cloud-hosted data platforms (Google Cloud Platform, AWS, etc.). ● Demonstrated ability to assist business decision-making through data mining and machine learning. ● Strong communication skills to collaborate effectively with business stakeholders. Must be able to interact cross-functionally and drive both business and technical discussions. ● Ability to translate complex business problems into actionable project plans and solve

The Aspen Group (TAG) is one of the largest and most trusted retail healthcare business support organizations in the U.S., supporting 15,000 healthcare professionals and team members at more than 1,000 health and wellness offices across 47 states in three distinct categories: Dental care, urgent care, and medical aesthetics. Working in partnership with independent practice owners and clinicians, the team is united by a single purpose: to prove that healthcare can be better and smarter for everyone. TAG provides a comprehensive suite of centralized business support services that power the impact of five consumer-facing businesses: Aspen Dental, ClearChoice Dental Implant Centers, WellNow Urgent Care, Lovet Animal Hospitals and Chapter Aesthetic Studios. Each brand has access to a deep community of experts, tools and resources to grow their practices, and an unwavering commitment to delivering high-quality consumer healthcare experiences at scale. As a reflection of our current needs and planned growth we are very pleased to offer a new opportunity to join our dedicated team as a Senior Analyst, Data & Insights supporting our WellNow Urgent Care brand. This role is responsible for leveraging data and transforming it into insights and reporting that can be utilized across all levels of the organization. This role will be engaged in driving the business both through support of our business partners in both the offices and field teams along with informing strategy for our Executive Leadership Team. Responsibilities As a Senior Analyst, Data & Insights you will be responsible for: Supporting the WellNow brand through the development of a common approach and infrastructure to data sources built to support enterprise-wide reporting Capture and translate business requirements for reporting from executive leadership Developing key data sources in BigQuery through use of SQL, Power BI, or other reporting languages & tools Synthesizing insights from various data sources and presenting data in an easy-to-read manner Become organizational expert on data sources and how to extract data from all systems. Ability to combine multiple data sources; strong attention to detail and data integrity. Work across departments to understand how their work impacts the performance of the business deriving metrics to measure results Identify key opportunities to drive transparency and turn data into insights and action. Leading organization in implementing a standardized, consistent approach to reporting, with a strong focus on user experience to drive usage. Utilizing data to uncover trends and insights, connecting changes in operational metrics to broader business performance, and craft compelling narratives that inform stakeholders and drive strategic decision-making. Ad-hoc analytical projects as needed. Minimum Education and Experience BA or BS in Data Analytics, Finance, Business or other degree with equivalent work experience in analysis or insights-based roles. 3+ years of experience in data analytics or similar analysis-driven roles required. Required experience partnering with both key business stakeholders and IT departments. Experience writing in SQL or BigQuery is required. Experience using data visualization software like Tableau or PowerBI is required. Ability to find and query appropriate data from databases, along with validating and reviewing data and reports for accuracy and completion Excellent communication and interpersonal skills are required. Experience managing cross-functional projects with multiple stakeholders is desirable. Advanced skills with Microsoft Excel and PowerPoint are required. Ability to excel in fast paced environment, take direction, and handle multiple priorities Annual Salary Range: $87,500-105k, with a generous benefits package that includes paid time off, health, dental, vision, and 401(k) savings plan with match If you are an applicant residing in California, please view our privacy policy here: ********************************************************************************* View CA Privacy Policy

Are you a master translator who can bridge the gap between investment operations and technology? Do you thrive on solving complex problems and designing elegant solutions? We're looking for a talented Business Analyst to join our client's team, working with cutting-edge investment systems and collaborating with top-notch professionals. Key Responsibilities: Configure and enhance Charles River systems to meet evolving business needs Analyze trading lifecycle workflows and design technical solutions Lead requirements gathering and documentation using Agile/Scrum methodologies Design and execute comprehensive test plans Serve as a technical consultant for various teams, solving problems and optimizing workflows Monitor production platforms and resolve issues Leverage SQL expertise to conduct data analysis and validate system behavior Collaborate on projects, staying current with Charles River capabilities and best practices What You'll Need: Bachelor's degree in a relevant field (business, finance, computer science) 3+ years of Charles River configuration experience 1+ year of Charles River Compliance experience 6-8 years of experience in investment management systems and business analysis Strong SQL skills and understanding of trading lifecycle and settlement workflows Agile/Scrum expertise and excellent analytical and problem-solving abilities What We Offer: Permanent opportunity with a generous salary, bonus up to 30K, and amazing benefits World-class working environment Opportunities for growth and professional development

Jenner & Block LLP is a law firm with a fearless reputation and global reach, high-level problem solvers in litigation, government controversies, investigations, regulatory challenges, and complex corporate transactions. With offices in Century City, Chicago, London, Los Angeles, New York, San Francisco, and Washington, DC, the firm represents a wide range of clients, counseling Fortune 100 companies, large privately held corporations, major nonprofits, top universities, private equity investors, and Native American tribes. Consistently recognized as a firm that stands up for its values with its commitment to justice and community service, Jenner has been named the No. 1 pro bono firm 13 times in the United States by The American Lawyer. POSITION SUMMARY We are seeking a dynamic AI Analyst to serve as a critical bridge between technology and legal practice. This role combines technical expertise with exceptional communication skills to drive AI adoption, provide hands-on user support, and assist in evaluating AI solutions across the firm. Reporting to the AI Portfolio Manager, the AI Analyst will be the frontline resource for lawyers and staff, helping them responsibly maximize the value of AI platforms through training, prompt engineering guidance, and troubleshooting. The successful candidate will partner with cross-functional teams to enhance system functionality, support vendor evaluations, and contribute to the firm's AI governance framework. ESSENTIAL JOB FUNCTIONS AI Adoption and User Support Guide users on effective use of AI tools and prompting techniques, ensuring adherence to the firm's AI policy and other AI best practices Provide hands-on user support and issue resolution for AI systems; troubleshoot data and application issues with end users, fully analyze impact, determine resolution strategies, fully test and reconcile resolutions, and assist in implementation Develop and maintain documentation, training materials, knowledge-sharing resources, and prompt templates for AI system usage on the firm's intranet Technical Administration and Configuration Perform administrative and configuration support for the firm's custom-built AI tools Work with the AI Portfolio Manager, end users, consultants, and project managers to understand business processes and requirements; identify gaps; communicate and define requirements for enhancements to technical solutions Assist in development of process changes or new technical solutions to satisfy business needs for projects and daily operations Recommend, implement, and test enhancements or process changes to optimize system performance and user experience Vendor Evaluation and Implementation Support Assist in evaluating use cases for custom builds versus commercial solutions and participate in vendor demonstrations Coordinate with Information Security for Vendor Risk Assessments and partner with Procurement during Master Service Agreement negotiations to ensure appropriate AI safety and governance provisions AI Governance and Strategy Support Partner with stakeholders to identify opportunities for AI adoption and provide guidance on best practices for system use Contribute to developing the firm's AI governance framework, creating evaluation criteria for vendors, and monitoring compliance with AI policies Stay current with industry trends in generative AI, prompt engineering, and enterprise AI administration QUALIFICATIONS AND REQUIREMENTS 2-4 years of experience in technical support, business analysis, or technology consulting Exceptional communication skills with ability to bridge technical and non-technical audiences Experience providing user training, creating documentation, or delivering technical presentations Strong writing skills for creating clear, user-friendly materials Understanding of prompt engineering principles and generative AI best practices Familiarity with help desk operations and troubleshooting methodologies Strong analytical and problem-solving capabilities with attention to detail Patient, service-oriented approach with ability to support users under pressure Bachelor's degree in Computer Science, Information Technology, Business, Communications, or related field PREFERRED QUALIFICATIONS Experience in the legal industry or professional services environment Familiarity with AI/ML technologies, large language models, or enterprise AI platforms Background in change management or technology adoption initiatives Experience with vendor evaluation processes and understanding of information security practices Knowledge of SDLC methodologies and experience with enterprise software administration Disclaimer Additional Duties This job description is intended to provide a general overview of the primary duties and responsibilities for the position. It is not an exhaustive list of all tasks or responsibilities that may be assigned. The role may include additional duties, specialized projects, and other tasks as required. The firm reserves the right to modify or adjust the responsibilities to meet business needs. Physical Requirements Candidates must be able to meet the physical demands of the position, including the ability to commute to the office as required on designated in-office days based on the position. The firm is committed to providing reasonable accommodations in accordance with the Americans with Disabilities Act (ADA) for qualified individuals with disabilities. EEO Statement Jenner & Block LLP is an equal opportunity employer. Recruitment and employment decisions are not made on the basis of an individual's race, color, creed, religion, national origin, ancestry, citizenship status, age, non-disqualifying physical or mental disability or medical condition, genetic information, sexual orientation, sex, gender identity and/or expression, pregnancy, childbirth, breastfeeding or related medical conditions, arrest record, matriculation, personal appearance, political affiliation, marital, parental, veteran, military, or order of protection status, or any other protected status or that of their relatives, friends, or associates. Jenner & Block is proud to offer a competitive total rewards package, including comprehensive health & well-being benefits and 401k profit sharing. The anticipated pay range for this role is $100,000-$123,000. The actual offered rate for this position will be determined based on several factors, including qualifications and experience, geographic location, education, external market data, and consideration of internal equity.

Job Title: Architect / Senior Data Engineer We are seeking a highly skilled Architect / Senior Data Engineer to design, build, and optimize our modern data ecosystem. The ideal candidate will have deep experience with AWS cloud services, Snowflake, and dbt, along with a strong understanding of scalable data architecture, ETL/ELT development, and data modeling best practices. Key Responsibilities Architect, design, and implement scalable, reliable, and secure data solutions using AWS, Snowflake, and dbt. Develop end-to-end data pipelines (batch and streaming) to support analytics, machine learning, and business intelligence needs. Lead the modernization and migration of legacy data systems to cloud-native architectures. Define and enforce data engineering best practices including coding standards, CI/CD, testing, and monitoring. Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and translate them into technical solutions. Optimize Snowflake performance through query tuning, warehouse sizing, and cost management. Establish and maintain data governance, security, and compliance standards across the data platform. Mentor and guide junior data engineers, providing technical leadership and direction. Required Skills & Qualifications 8+ years of experience in Data Engineering, with at least 3+ years in a cloud-native data environment. Hands-on expertise in AWS services such as S3, Glue, Lambda, Step Functions, Redshift, and IAM. Strong experience with Snowflake - data modeling, warehouse design, performance optimization, and cost governance. Proven experience with dbt (data build tool) - model development, documentation, and deployment automation. Proficient in SQL, Python, and ETL/ELT pipeline development. Experience with CI/CD pipelines, version control (Git), and workflow orchestration tools (Airflow, Dagster, Prefect, etc.). Familiarity with data governance and security best practices, including role-based access control and data masking. Strong understanding of data modeling techniques (Kimball, Data Vault, etc.) and data architecture principles. Preferred Qualifications AWS Certification (e.g., AWS Certified Data Analytics - Specialty, Solutions Architect). Strong communication and collaboration skills, with a track record of working in agile environments.

MathCo Role - Data/AI Engineering Manager Onsite - Chicago - 4 days in office (Mandatory) Industry - Pharma (Mandatory) As platform architect/owner, you will: Lead the end-to-end architecture, lifecycle, and governance of the AI/Analytics platform, defining standards, reusable components, and integration patterns. Partner with AI/Data architects to enable scalable model deployment and enhance agentic orchestration. Translate business needs into platform features, manage onboarding, documentation, and cross-functional collaboration for platform adoption. Oversee infrastructure-as-code, CI/CD, observability, and containerized environments to ensure reliability and scalability. Evaluate complex technical proposals and develop actionable platform roadmaps and architecture recommendations Stay current on key AI platform developments and assess their impact on architecture and client strategy Coach others, recognize their strengths, and encourage them to take ownership of their personal development Skills Required Experience in designing, architecting, or managing distributed data and AI platforms in cloud environments (AWS, Azure, or GCP) Proven ability to carry out complex Proof of Concept (POC), pilot projects, and limited production rollouts for AI use-cases, focusing on developing new or improved techniques and procedures. Strong skills in pipeline/workflow optimization and data processing frameworks to evaluate architectural choices Years of Experience Minimum of 8 years in relevant experience, preferably with a consulting background and experience with Pharma clients

Must Have Technical/Functional Skills · Cloud Data Architect in Data & Analytics will play a key role in driving solution architecture design, evaluation, and selection, buy vs. · build decisions, and early-phase project estimates which contribute to the business case. · Partner with Key Roles (Business and Technology) to shape the Cloud Data & Analytics strategy, provide hands on guidance to convert the strategy to architecture/Solutions that are aligned to architecture standards and principles, leverage common solutions and services, and meet the financial targets (costs and benefits) and actionable plan. · Furthermore, shape large Data and Analytics opportunities for TCS. Prior experience in Banking Financial and Insurance combined with strong articulation skills, strategic Thinking exposure, Leadership traits, Strong business acumen, Customer focus, Social are essential. · Must Have skills : Cloud Data Architect, Snowflake, demonstrate hands-On on Databricks (Delta Lake, Unity Catalogue), Snowflake, Cortex AI, Five Tran, DBT. · On Data front Hands on in Data Quality, Data Governance, MDM and Data Modeling (Data Products, Data Mesh, Data vault) Roles & Responsibilities · Strong experience in Cloud Data Architecture and Roadmap and effectively engaging various client Stakeholders on the architecture proposition. · Strong experience in Solution Architecture (Data & Analytics) · Must have prior experience building large scale enterprise data architectures using commercial and/or open source Data Analytics technologies. Must demonstrate knowledge of data architecture patterns · Strong cloud architecture expertise (Azure, AWS, GCP) across large project with minimum 2-3 years experience in doing cloud projects · Strong solution implementation experience (platform engineering, developer experience) · Data modelling and architecting skills including strong foundation in data warehousing concepts, data normalization, dimensional data modelling and a variety of data models including data vault · Demonstrated experience across different data platform such as Databricks (Delta Lake, Unity Catalogue), Snowflake and Cortex AI, FiveTran, dbt, Data Virtualization tools · Demonstrated experience in Big Data, data warehouse, data analytics projects, and/or any Information Management related projects · Lead transformation effort for Large opportunities i.e. build strategy and multi-year Transformation roadmap for our customers · Strong ability and experience in engaging with both technical and non-technical stakeholders · Strong teaming, communications and analytical skills · Dedicated, resourceful and able to work under pressure · As part of Presales support, should be able to shape large multi-million value Deals both proactive and reactive by driving TCS positioning with customers and build business for TCS · Develop Point of views, solution approaches & pitches for new opportunities · Define Data and Technology Architecture and patterns on-prem/hybrid/Cloud using native and other partners/tools with recommendations that suits customer's context and objectives · On Data front strong in Data Governance, MDM and Data Modeling · Drive and Participate in Architecture reviews both internal and client teams · Oversee data management, warehousing, integration, data movement, and delivery across assigned data initiatives. · Examine data, processes, and technologies to determine the current state and critical problems of Customer's data and analytics journey · Research and make recommendations for training, equipment, and technology to improve data use · Build connect with Client's Senior Leadership CXOs/D&A Heads and work with them to develop clear Data and Analytics Strategy and Architecture that supports their business goals and objectives.

Are you an experienced IT Business Analyst with a desire to excel? If so, then Talent Software Services may have the job for you! Our client is seeking an experienced IT Business Analyst to work at their company in Chicago, IL. We are seeking a highly skilled professional with hands-on experience in end-to-end development of data modelling and expertise in leveraging Power Query and DAX. This role requires more than just experience working alongside a data modelling team; the ideal candidate will have direct, hands-on involvement in data modelling processes. Join our dynamic team in Chicago, a vibrant city known for its rich history, diverse culture, and thriving business environment. Experience the best of both worlds with our hybrid working model, offering flexibility and the chance to collaborate in person with our talented team. Primary Responsibilities/Accountabilities: Understand business requirements from various stakeholders and plan a solution to address data requirements. Candidate should have hands-on experience with end-to-end development of data modelling, and leveraging Power Query and DAX. Simply working on a team adjacent to data modelling, or managing a data modelling team is not sufficient. Collect, refine, and prepare data for analytics and visualisation. Develop, design, and maintain Power BI dashboards, SQL Queries, and analytics. Define new KPIs and analyze them to form actionable recommendations. Present to business leaders in both ad-hoc forums and routine business reviews to drive strategic decision-making. Identify new data functionalities or enhancements needed to support better decision-making and business growth. Solve any data or performance issues related to workbooks and data sources. Qualifications: Hands-on experience with end-to-end development of data modeling, and leveraging Power Query and DAX. Degree in a quantitative field with 5 years of relevant experience. Strong proficiency in SQL, Excel, and building dashboards using BI Tools such as Power BI. Ability to read an ETL pipeline and collaborate with Data and Software Engineers. Capability to design new metrics and collaborate with Data Scientists. Experience in leading projects independently and collaborating with Operations and Finance. Proven ability to successfully influence without authority. Strong verbal and written communication skills; adept at working with individual contributors and senior leaders.

Scaylor helps mid-market and enterprise companies make sense of their data. Most teams past $20M ARR are stuck with fragmented systems, old databases, and hundreds of spreadsheets that never quite line up. We build the pipelines that clean, normalize, and connect that data so it can actually be used. Our platform handles everything from parsing financial models and reports to mapping tables across legacy databases and modern APIs. The goal is simple: give companies a single source of truth they can trust. We're a small team of four - one backend engineer, one frontend engineer, and 2 founders. We're looking for our fifth teammate to help us scale the engine behind it all. ⸻ The Role You'll work across data engineering and full-stack development, helping us build reliable data infrastructure that powers real workflows. You'll touch everything from ingestion and transformation pipelines to the APIs and dashboards that surface insights to clients. You'll work directly with the founding team and help make technical decisions that define the next version of Scaylor's core platform. ⸻ What You'll Work On • Build data pipelines that extract, clean, and standardize information from Excel files, PDFs, APIs, and legacy databases • Design schemas and transformation logic for structured and semi-structured data • Develop and maintain backend APIs (Python/FastAPI or Node/Express) for data access and analytics • Help connect backend services to our frontend dashboards (React, Node.js, or similar) • Set up and maintain AWS infrastructure (Lambda, S3, ECS, CloudFormation) • Collaborate with clients to understand their data problems and design workflows that fix them ⸻ You'd Be Great Here If You • Have 3-6 years of experience in data engineering, backend, or full-stack roles • Write clean, maintainable code in Python + JS • Understand ETL, data normalization, and schema mapping • Have experience with SQL and working with legacy databases or systems • Are comfortable managing cloud services and debugging data pipelines • Enjoy solving messy data problems and care about building things that last ⸻ Nice to Have • Familiarity with GCP or SQL databases • Understanding of enterprise data flows (ERP, CRM, or financial systems) • Experience building and deploying containers (Docker, GitHub Actions, CI/CD) • Interest in lightweight ML or LLM-assisted data transformation ⸻ Why Join Scaylor • Be one of the first five team members shaping the product and the company • Work directly with the founder and help define Scaylor's technical direction • Build infrastructure that solves real problems for real companies • Earn meaningful equity and have a say in how the company grows ⸻ Compensation • $130k - $150k with a raise based on set revenue triggers • .4% equity • Relocation to Chicago, IL required

Resource 1 is in need of a Sr. Data Engineer for a full-time/ permanent position with our client in Naperville, IL. Candidate must be local to Illinois because of future hybrid onsite in Naperville expected. Our client is an employee-owned company with excellent benefits, growth opportunities and profit-sharing bonus. This position is focused on building modern data pipelines, integrations and back-end data solutions. Selected individual will work within cross-functional Agile teams, collaborating with product owners, business analysts and other engineers to design and deliver data solutions that power business insights and AI products. Responsibilities: Design and develop scalable data pipelines for ingestion, transformation and integration using AWS services. Pull data from PostgreSQL and SQL Server to migrate to AWS. Create and modify jobs in AWS and modify logic in SQL Server. Create SQL queries, stored procedures and functions in PostgreSQL and RedShift. Provide input on data modeling and schema design as needed. Manage infrastructure through infrastructure-as-code templates (Serverless Framework), supporting new data products and services in AWS. Support inbound/ outbound data flows, including APIs, S3 replication and secured data. Assist with data visualization/ reporting as needed. Follow an Agile development methodology, with regular workshops and standup meetings, working in two-week sprints. Qualifications: 5+ years of data engineering experience. Experience with AWS and its associated array of offerings (Glue, Redshift, Athena, S3, Lambda, Spectrum). Strong experience with SQL, Python and PySpark. A background in supply chain, logistics or distribution would be a plus. Experience with Power BI is a plus.

requires visa independent candidates. Note: (OPT, CPT, H1B holders will not work at this time) Design, develop, and maintain scalable ETL pipelines using AWSGlue Collaborate with data engineers and analysts to understand data requirements Build and manage data extraction, transformation, and loading processes Optimize and troubleshoot existing Glue jobs and workflows Ensure data quality, integrity, and security throughout the ETL process Integrate AWS Glue with other AWS services like S3, Lambda, Redshift, and Step Functions Maintain documentation of data workflows and processes Stay updated with the latest AWS tools and best practices Required Skills Strong hands-on experience with AWS Glue, PySpark, and Python Proficiency in SQL and working with structured/unstructured data (JSON, CSV, Parquet) Experience with data warehousing concepts and tools Familiarity with CI/CD pipelines, Terraform, and scripting (PowerShell, Bash) Solid understanding of data modeling, data integration, and data management Exposure to AWS Batch, Step Functions, and Data Catalogs

The Data Engineer will design, build, and optimize the data pipelines and models that support the firm's evolving research, analytics, and systematic portfolio construction environment. This role is central to enabling data-driven investment processes, including quantitative research, AI/ML capabilities, and front-office automation. Candidates must have deep expertise with Snowflake, strong SQL skills, and experience integrating diverse datasets used across investment organizations. The role is highly collaborative and requires comfort working in an iterative, fast-moving environment where data needs evolve rapidly based on stakeholder input. Responsibilities Design, build, and enhance ETL/ELT pipelines in Snowflake, ensuring high performance, reliability, and scalability. Integrate internal and external datasets, including pricing, research content, economic releases, market data, and security reference data. Support real-time or near-real-time data flows where needed (e.g., pricing, indicative quotes, market-sensitive inputs). Collaborate closely with Product Leads, Quant Developers, and UI/UX teams to ensure data structures meet the requirements of research workflows, analytical models, and user-facing applications. Partner with front-office stakeholders to rapidly iterate on evolving analytical and data needs. Implement data validation, monitoring, and quality frameworks to ensure accuracy and reliability across critical datasets. Translate prototype pipelines into production-ready workflows with appropriate documentation, standards, and controls. Contribute to data modeling standards, metadata frameworks, and data governance practices across the platform. Requirements 10+ years of data engineering experience within investment management, financial technology, or similar data-intensive environments. Expert-level SQL, including complex queries, schema design, and performance optimization. Deep hands-on experience with Snowflake, including advanced features such as tasks, streams, performance tuning, and secure data sharing. Strong Python capabilities for ETL/ELT development, data processing, and workflow automation. Experience integrating APIs and working with structured, semi-structured, and unstructured datasets. Familiarity with NLP or AI/ML-oriented datasets (e.g., textual research content, PDFs) is a plus. Experience with Domino or willingness to work within a Domino-based model environment. Working knowledge of investment data structures (holdings, benchmarks, pricing, exposures) is highly preferred. Ability to thrive in a rapid prototyping environment with evolving requirements and close partnership with front-office teams.

Design, develop, and maintain robust ETL/ELT data pipelines Write and optimize complex SQL queries for analytics use cases Work with GCP services such as BigQuery, GCS, and Dataflow Build and manage scalable data solutions using Databricks and Apache Spark Ensure data quality, reliability, and performance Collaborate with data analysts, data scientists, and business stakeholders Troubleshoot and resolve data pipeline and performance issues Required Skills Strong expertise in SQL Hands-on experience with Google Cloud Platform (GCP) Experience with Databricks / Apache Spark Proficiency in Python Experience with data warehousing and data modeling concepts Nice to Have Experience with Airflow or other orchestration tools Exposure to streaming technologies (Kafka, Pub/Sub) Knowledge of CI/CD, Git, and DevOps practices

Immediate need for a talented Cybersecurity Lead Analyst . This is a 12 months contract opportunity with long-term potential and is located in Chicago, IL(Remote). Please review the job description below and contact me ASAP if you are interested. Job ID:25-89141 Pay Range: $46 - $47/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location). Key Responsibilities: Ensures implementation of secure operating systems, networks and databases for the organization. Performs complex risk assessments and executes tests of data processing system to ensure functioning of data processing activities and security measures. Drafts plans to safeguard computer files against accidental or unauthorized modification, destruction, or disclosure and to meet emergency data processing needs. Encrypts data transmissions and erect firewalls to conceal confidential information as it is being transmitted and to keep out tainted digital transfers. Facilitates risk audits and assessments and provides recommendations for application design to ensure operating effectiveness. Monitors analysis of system access logs, ensuring only permitted individuals have access to company information. Reviews violations of computer security procedures and discusses procedures with violators to ensure violations are not repeated. Trains users and promotes security awareness to ensure system security and to improve server and network efficiency. Key Requirements and Technology Experience: Key Skills; Microsoft Security Tools, Active Directory, Cybersecurity Operations, Investment management. University (Degree) Preferred 3 Years Required; 5 Years Preferred. Physical Requirements: Sedentary Work. Lead the cybersecurity team, providing mentorship, guidance, and performance management. Develop and execute the organization's cybersecurity strategy aligned with business goals. Collaborate with IT leadership and stakeholders to assess risk and define security priorities. Microsoft Security Operations Administer and optimize Microsoft Defender for Endpoint, Identity, Cloud Apps, and Office 365. Manage and monitor Microsoft Sentinel for threat detection, incident response, and log analytics. Implement and maintain Microsoft Purview for data governance, compliance, and information protection. Oversee Entra ID (Azure AD) identity and access management, including Conditional Access and Privileged Identity Management (PIM). Conduct regular reviews of security configurations and policies across Microsoft 365 and Azure environments. Conduct monthly Attack Simulations. Lead threat hunting and incident response activities using Microsoft XDR and SIEM tools. Develop and maintain playbooks for automated response in Sentinel and Defender. Coordinate with internal teams and external partners during security incidents and investigations. Governance, Risk & Compliance Ensure compliance with industry standards (e.g., NIST, GDPR, LGPD, DORA, other local data privacy laws). Conduct risk assessments and vulnerability scans; manage remediation efforts. Maintain documentation for security policies, procedures, and audit readiness. Promote security awareness across the organization through training and communication. Stay current with emerging threats, vulnerabilities, and Microsoft security innovations. Our client is a leading Financial Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration. Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, 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. By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here.