Senior Analyst, Data and Insights
Senior data analyst- job in Chicago, IL
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
Senior Data Analyst - PowerBI Dashbords
Senior data analyst- job in Chicago, IL
W2 or c2c
Local preferred - Hybrid role
Need to have creating of PowerBI dashboard experience
A Data Analyst interprets data and turns it into information which can offer ways to improve a business thus affecting business decisions.
Data Analysts gather information from various sources and interpret patterns and trends as such a Data Analyst job description should highlight the analytical nature of the role.
Once data has been gathered and interpreted the Data Analyst will report back what has been found in a comprehensive study to the wider business/relevant colleagues.
Primary Responsibilities:
Collaborate to design and develop schemas and data acquisition transformations and data integration.
Develop and utilize software to interface big data and relational solutions.
Design and implement solutions for metadata data quality privacy management.
Support and consult with the development staff. Collecting and interpreting data Analyzing results
Reporting the results back to the relevant members of the business
Identifying patterns and trends in data sets Working alongside teams within the business or the management team to establish business needs
Defining new data collection and analysis processes
Qualifications:
Technical Degree or related work experience
Ability to analyze existing tools and databases and provide software solution recommendations.
Ability to translate business requirements into non-technical lay terms.
High-level experience in methodologies and processes for managing large scale databases.
Demonstrated experience in handling large data sets and relational databases.
Insurance Business and Exposure Analyst
Senior data analyst- job in Chicago, IL
We are seeking a Business and Exposure Analyst to join our flood insurance analytics team in Miami. In this role, you will leverage your data analysis expertise and business insight to inform catastrophe modelling, manage exposure data, and support flood underwriting decisions. You will work closely with cross-functional stakeholders - including underwriters, risk modelers, and management - to translate complex data into actionable insights. This position offers a hybrid work schedule (at least 3 days per week in-office) and requires 4-6 years of insurance exposure/CAT modelling analysis.
Duties/Responsibilities:
Collect and prepare data: Gather, cleanse, and validate property exposure data (e.g. insured locations, values) to ensure accuracy for catastrophe risk modelling and analysis.
Catastrophe modelling: Run and interpret flood catastrophe models and simulations to estimate potential losses for individual events and entire portfolios. Analyze model outputs to inform portfolio management strategies and reinsurance decisions.
Exposure management: Monitor and manage the company's flood insurance portfolio exposure, identifying concentrations of risk (by geography, construction type, etc.) and providing recommendations to optimize the portfolio's risk profile and reshape appetites.
Event analysis: Provide timely analysis and loss estimates during significant flood events (e.g. hurricanes) to support rapid decision-making and internal/external communications. Gather exposure data to inform key stakeholders of potential risk.
Reporting and visualization: Produce regular reports and dashboards on key flood risk metrics, model results, and portfolio performance for stakeholders such as underwriters, actuaries, and senior management. Continued enhancement of metrics and reporting formats.
Underwriting support: Support the flood underwriting team by providing data-driven insights for individual high-value accounts and policy renewals. This includes analyzing flood zone determinations, historical claims data, submission data and modelled loss estimates to assist in risk selection and pricing both algorithmic and analog. Improve sophistication of digital underwriting capabilities.
Stakeholder collaboration: Work closely with underwriters, catastrophe modelling specialists, actuaries, and product managers to understand business needs and develop analytical solutions. Ensure that analytics align with underwriting guidelines and regulatory requirements.
Communication of insights: Translate complex analytical findings into clear, actionable insights and communicate them to both technical and non-technical stakeholders (e.g. underwriting teams, executives), through presentations, reports, and visualizations.
Process improvement: Contribute to the development and enhancement of internal tools, models, and processes (such as GIS mapping tools or data pipeline automation) to improve efficiency in risk analysis and exposure management.
Continuous learning: Stay up-to-date with industry developments in catastrophe modelling, flood risk assessment, and insurance analytics. Proactively apply new insights, data sources, or techniques to improve our analytic capabilities and decision-making.
Required Skills/Abilities:
Experience: 4-6 years of professional experience in data analytics, catastrophe risk modeling, insurance analytics, or a related field (mid-level role).
Education: Bachelor's degree in Statistics, Data Science, Finance, Environmental Science, Engineering, Business, or a related discipline (Master's degree or relevant industry certifications are a plus).
SQL proficiency: Strong skills in SQL for querying databases and manipulating large datasets.
Programming: Hands-on experience with a programming language for data analysis, such as Python or R, to clean data, perform statistical analysis, and automate tasks.
Excel expertise: Advanced Excel skills for data analysis and reporting (e.g. pivot tables, complex formulas; VBA knowledge is a plus).
GIS and mapping: Familiarity with GIS tools (ArcGIS or QGIS) for spatial data analysis and creating flood risk maps.
Data platforms: Experience working with cloud-based data warehouses or big data platforms (e.g. Snowflake, Databricks) in an AWS environment for data storage and analysis.
Catastrophe modeling knowledge: Understanding of catastrophe modeling and exposure management concepts; experience working with catastrophe risk models or flood hazard data.
Insurance domain expertise: Knowledge of insurance underwriting processes (especially in property or flood insurance) and the ability to support underwriting decisions with analytical insights. Experience in flood insurance or natural catastrophe insurance analytics.
Communication skills: Excellent written and verbal communication skills, with the ability to present complex technical information to non-technical audiences clearly. Strong interpersonal skills for effective collaboration with stakeholders across teams.
Analytical mindset: Strong analytical and problem-solving skills with keen attention to detail, and a naturally curious approach to exploring data for insights and continuous improvement.
Initiative and organization: Self-motivated and proactive, able to manage multiple priorities and projects in a fast-paced environment. Proven ability to work both independently and as part of a team.
About Tokio Marine Highland
Tokio Marine Highland Insurance Services (TMH) is a leading property and casualty underwriting agency. We offer a broad suite of tailored specialty risk management solutions, including private flood, fine art and lender-placed products. At TMH, it's all about our clients. Nationwide, our customers rely on our trusted, industry-leading coverages, supported by compliance expertise, superior claims management and the highest caliber of service.
Founded in 1962, TMH is a wholly owned company of Tokio Marine Kiln, one of the largest carriers in the Lloyd's of London insurance market and a member of the Tokio Marine Group. TMH has operating centers in Chicago, Il, Frisco, Texas, Miami, Fla., and South Pasadena, Calif.
If you're looking to advance your career, TMH is the perfect professional home. At TMH, you'll have a chance to innovate with the world's leading businesses, put your expertise into action on major projects, and work on game-changing initiatives. You'll also make long-lasting professional connections through sharing different perspectives, and you'll be inspired by the best.
Tokio Marine Highland, LLC (TMH) is an Equal Opportunity Employer. TMH's success depends heavily on the effective utilization of qualified people, regardless of their race, ancestry, religion, color, sex, national origin, sexual orientation, gender identity and/or expression, disability, veteran status, or any characteristic protected by law. As a company, we adhere to and promote equal employment opportunities for all.
Consistent with the Americans with Disabilities Act (ADA) and applicable state and local laws, it is TMH's policy to provide reasonable accommodation when requested by qualified individuals with disabilities during the recruitment process, unless such accommodation
would cause an undue hardship. To make an accommodation request, please contact *****************************.
Senior Data Scientist
Senior data analyst- job in Chicago, IL
Be a part of our success story. At Launch, we offer talented and driven professionals the opportunity to deliver high-impact work in a dynamic, fast-growing environment. We invest in our people through competitive compensation, exceptional benefits, internal growth pathways, and meaningful community involvement. For senior professionals ready to shape the future of AI and Data Science, your next big opportunity starts here.
The Role:
As a Senior Data Scientist, you will lead the design and development of advanced machine learning and AI solutions that solve complex business challenges. You'll apply a deep technical foundation in data science, spanning statistics, modeling, software engineering, and domain expertise, while helping set technical direction, mentor team members, and influence decision-making across the organization. You will work closely with stakeholders and cross-functional teams to define use cases, architect scalable solutions, and drive innovation through GenAI, LLMs, NLP, computer vision, and other cutting-edge techniques.
Key Responsibilities:
Lead advanced Data Science initiatives from ideation to deployment, ensuring alignment with business strategy and measurable outcomes.
Develop, implement, and optimize AI/ML models across a range of domains, including predictive analytics, GenAI, LLMs, time series, deep learning, and NLP.
Conduct rigorous exploratory data analysis and feature engineering to uncover insights and support robust model development.
Architect data preprocessing pipelines that ensure clean, high-quality, and well-structured data for training and evaluation.
Apply experimental design best practices (e.g., A/B testing, cross-validation, randomization) to ensure statistical rigor and reduce model bias/overfitting.
Own the deployment and monitoring of ML solutions on modern cloud platforms (Databricks, AWS SageMaker, Azure ML, Snowflake, etc.).
Serve as a technical advisor and thought leader, guiding internal stakeholders on AI capabilities, data strategy, and industry best practices.
Mentor and support the development of junior and mid-level data scientists through code reviews, pair programming, and knowledge sharing.
Communicate effectively across technical and non-technical audiences, including executive leadership, to influence and drive adoption of data-driven solutions.
Required Qualifications:
7+ years of hands-on experience in Data Science, with a strong track record of delivering end-to-end AI/ML solutions in production environments.
Deep expertise in Python, including libraries such as scikit-learn, pandas, NumPy, TensorFlow, PyTorch, spa Cy, and/or Hugging Face.
Strong understanding of statistical modeling, regression, classification, clustering, and deep learning architectures.
Demonstrated experience applying GenAI, LLMs, NLP, or computer vision techniques to solve real-world business problems.
Proven ability to write advanced SQL and work with complex data structures across relational and non-relational databases.
Experience with data pipeline orchestration and preprocessing of structured and unstructured data at scale.
Hands-on experience with cloud data science platforms such as Databricks, AWS SageMaker, Azure ML, Snowflake Snowpark, or Palantir Foundry.
Strong stakeholder management skills and the ability to thrive in a high-paced, constantly evolving environment.
Excellent verbal and written communication skills, including the ability to present complex technical concepts clearly and persuasively.
Preferred Qualifications:
Experience with project delivery frameworks and tools such as Azure DevOps, JIRA, or Agile methodologies.
Experience working with Electronic Medical Record systems and healthcare data file types (e.g., HL7, FHIR, CCD).
Certifications related to Epic, FHIR, or other health IT platforms are a plus.
Familiarity with data architecture tools (e.g., Miro, Visio, LucidChart) for technical design documentation.
Knowledge of modern cloud-based data solutions such as Azure Synapse, Snowflake, Redshift, or BigQuery.
Benefits & Compensation:
As an employee at Launch, you will grow your skills and experience through a variety of exciting project work (across industries and technologies) with some of the top companies in the world! Our employees receive full benefits - medical, dental, vision, short-term disability, long-term disability, life insurance, and matched 401k. We also have an uncapped, take-what-you-need PTO policy. The anticipated wage range for this role is $140,000-180,000. Education and experience will be highly considered, and we are happy to discuss your wage expectations in more detail throughout our internal interview process.
Business Intelligence Analyst
Senior data analyst- job in Chicago, IL
Our client is seeking a Business Intelligence Analyst to join their team! This position is located in Chicago, Illinois.
Support and enhance the account matching and mapping process, ensuring accuracy, consistency, and continuous improvement
Develop, refine, and maintain reports and dashboards that track key performance metrics and enable data-driven decision-making
Analyze large and complex datasets across systems
Collaborate with business partners to understand data requirements and deliver high-quality analytical support
Communicate insights and recommendations clearly and effectively to stakeholders at all levels
Identify and implement process improvements to increase operational efficiency and accuracy across workflows
Investigate and resolve data or operational issues in a timely and thorough manner
Translate complex technical concepts into easy-to-understand explanations for both technical and non-technical audiences
Desired Skills/Experience:
Bachelor's degree in Business Administration, Computer Science, Information Systems, or a related field
4+ years of experience as a Business Analyst (or similar role), with a strong focus on analytics and problem-solving
Demonstrated ability to work with cross-functional teams, gather requirements, and translate business needs into data-driven insights
Strong communication skills with the ability to explain technical concepts to non-technical audiences
Strong data analysis expertise using Google Sheets and Microsoft Excel: advanced formulas, data manipulation, and problem-solving
Proficiency in writing and executing SQL queries for data extraction and analysis
Solid understanding of core IT concepts, including databases, security, networking, and basic programming principles
Understanding of general business processes across Sales, Marketing, Service, and Support
Benefits:
Medical, Dental, & Vision Insurance Plans
Employee-Owned Profit Sharing (ESOP)
401K offered
The approximate pay range for this position is between $42.00 and $60.00. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums.
Senior Data Scientist
Senior data analyst- job in Chicago, IL
Role: Senior Data Scientist
· We are seeking a hands-on Senior Data Scientist to join our Insurance Analytics & AI Vertical. The ideal candidate will bring a blend of insurance domain expertise (preferably P&C), consulting mindset, and strong data science skills. This is a mid-senior level role focused on delivering value through analytics, stakeholder engagement, and logical problem solving, rather than people management.
· The role involves working closely with EXL teams and clients on reporting, data engineering, transformation, and advanced analytics projects. While strong technical skills are important, we are looking for someone who can engage directly with clients, translate business needs into analytical solutions, and drive measurable impact.
Key Responsibilities
· Collaborate with EXL and client stakeholders to design and deliver data-driven solutions across reporting, analytics, and transformation initiatives.
· Apply traditional statistical methods, machine learning, deep learning, and NLP techniques to solve business problems.
· Support insurance-focused analytics use cases (with preference for P&C lines of business).
· Work in a consulting setup: conduct requirement gathering, structure problem statements, and communicate insights effectively to senior stakeholders.
· Ensure data quality, governance, and compliance with Data Privacy and Protection Guidelines.
· Independently research, analyze, and present findings, ensuring client-ready deliverables.
· Contribute to continuous improvement initiatives and support business development activities where required.
Key Skillsets & Experience
· 7-12 years of experience in analytics, reporting, dashboarding, ETL, Python/R, and associated data management.
· Proficiency in machine learning, deep learning algorithms (e.g., neural networks), and text analytics techniques (NLTK, Gensim, LDA, word embeddings like Word2Vec, FastText, GloVe).
· Strong consulting background with structured problem-solving and stakeholder management skills.
· Excellent communication and presentation skills with the ability to influence and engage senior business leaders.
· Hands-on role with ability to independently manage client deliverables and operate in cross-cultural, global environments.
Data Management Skills
· Strong familiarity with advanced analytics tools (Python, R), BI tools (Tableau, Power BI), and related software applications.
· Good knowledge of SQL, Informatica, Hadoop/Spark, ETL tools.
· Ability to translate business/functional requirements into technical specifications.
· Exposure to cloud data management and AWS services (preferred).
Candidate Profile
· Bachelor's/Master's degree in Economics, Mathematics, Computer Science/Engineering, Operations Research, or related analytical fields.
· Prior insurance industry experience (P&C preferred) strongly desired.
· Superior analytical, logical, and problem-solving skills.
· Outstanding written and verbal communication abilities with a consultative orientation.
· Flexible to work in a fast-paced, evolving environment with occasional visits to the client's Chicago office.
Automation Test Analyst
Senior data analyst- job in Oakbrook Terrace, IL
Automation Tester
6 month contract ( extension highly likely )
REMOTE ( with ability to visit the office in Oakbrook terrace )
Interview will be in person- Looking for candidates living within 50 miles radius of Oakbrook
Client is a well known healthcare insurance company
The candidate will design and execute automated test scripts for front end, API and backend testing, perform data validation using SQL, and ensure compliance with healthcare standards.
Responsibilities:
Develop and maintain automated test scripts for web and API applications.
Collaborate with QA leads, developers, and business analysts to define test strategies and create test plans
Write and execute automated tests, analyze results, and report defects using standard tools
Perform data validation and backend testing using complex SQL scripts for data validation of a Data Warehouse / Data Lake containing multiple data sources.
Automate and execute REST, SOAP, XML, JSON based API testing / web services
Integrate automated tests into CI/CD pipelines.
Ensure adherence to HIPAA and healthcare compliance standards.
Required Skills:
Automation Tools: Selenium or similar
Programming Languages: Java, Python, or similar scripting languages.
API Testing: Experience with REST API automation using tools like Postman or other similar tools
Data testing - Solid SQL expertise for data validation, ETL ( using Talend or any other tools) and database testing.
Test Management Tools - Qtest, JIRA, SQL server Management studio or similar test management tools.
CI/CD: Familiarity with Jenkins, Git, or similar tools.
Healthcare Domain: Understanding of healthcare insurance workflows, claims processing, and regulatory compliance.
Testing Methodologies: Agile/Scrum experience, knowledge of SDLC and STLC.
Preferred:
Performance testing experience (JMeter).
Exposure to cloud platforms Azure - Azure synapse
Senior Data Architect
Senior data analyst- job in Oak Brook, IL
We are seeking a highly skilled and strategic Senior Data Solution Architect to join our IT Enterprise Data Warehouse team. This role is responsible for designing and implementing scalable, secure, and high-performing data solutions that bridge business needs with technical execution. Design solutions for provisioning data to our cloud data platform using ingestion, transformation, and semantic layer techniques. Additionally, this position provides technical thought leadership and guidance to ensure that data platforms and pipelines effectively support ODS, analytics, reporting, and AI initiatives across the organization.
Key Responsibilities:
Architecture & Design:
Design end-to-end data architecture solutions including operational data stores, data warehouses, and real-time data pipelines.
Define standards and best practices for data modeling, integration, and governance.
Evaluate and recommend tools, platforms, and frameworks for data management and analytics.
Collaboration & Leadership:
Partner with business stakeholders, data engineers, data analysts, and other IT teams to translate business requirements into technical solutions.
Lead architecture reviews and provide technical guidance to development teams.
Advocate for data quality, security, and compliance across all data initiatives.
Implementation & Optimization
Oversee the implementation of data solutions, ensuring scalability, performance, and reliability.
Optimize data workflows and storage strategies for cost and performance efficiency.
Monitor and troubleshoot data systems, ensuring high availability and integrity.
Required Qualifications:
Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or related field.
7+ years of experience in data architecture, data engineering, or related roles.
Strong expertise in cloud platforms (e.g., Azure, AWS, GCP) and modern data stack tools (e.g., Snowflake, Databricks).
Proficiency in SQL, Python, and data modeling techniques (e.g. Data Vault 2.0)
Experience with ETL/ELT tools, APIs, and real-time streaming technologies (e.g., dbt, Coalesce, SSIS, Datastage, Kafka, Spark).
Familiarity with data governance, security, and compliance frameworks
Preferred Qualifications:
Certifications in cloud architecture or data engineering (e.g., SnowPro Advanced: Architect).
Strong communication and stakeholder management skills.
Why Join Us?
Work on cutting-edge data platforms and technologies.
Collaborate with cross-functional teams to drive data-driven decision-making.
Be part of a culture that values innovation, continuous learning, and impact.
** This is a full-time, W2 position with Hub Group - We are NOT able to provide sponsorship at this time **
Salary: $135,000 - $175,000/year base salary
+ bonus eligibility
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
Benefits
We offer a comprehensive benefits plan including:
Medical
Dental
Vision
Flexible Spending Account (FSA)
Employee Assistance Program (EAP)
Life & AD&D Insurance
Disability
Paid Time Off
Paid Holidays
BEWARE OF FRAUD!
Hub Group has become aware of online recruiting related scams in which individuals who are not affiliated with or authorized by Hub Group are using Hub Group's name in fraudulent emails, job postings, or social media messages. In light of these scams, please bear the following in mind
Hub Group will never solicit money or credit card information in connection with a Hub Group job application.
Hub Group does not communicate with candidates via online chatrooms such as Signal or Discord using email accounts such as Gmail or Hotmail.
Hub Group job postings are posted on our career site: ********************************
About Us
Hub Group is the premier, customer-centric supply chain company offering comprehensive transportation and logistics management solutions. Keeping our customers' needs in focus, Hub Group designs, continually optimizes and applies industry-leading technology to our customers' supply chains for better service, greater efficiency and total visibility. As an award-winning, publicly traded company (NASDAQ: HUBG) with $4 billion in revenue, our 6,000 employees and drivers across the globe are always in pursuit of "The Way Ahead" - a commitment to service, integrity and innovation. We believe the way you do something is just as important as what you do. For more information, visit ****************
Penetration Testing Analyst with Java
Senior data analyst- job in Chicago, IL
Note: Open for Local Candidates and Interview will be onsite
Typical task breakdown:
- Develop test automation code for Continuous Integration (CI), Continuous Delivery (CD), of systems, infrastructure, and test framework.
- Plan, design, develop, and maintain API test automation framework that facilitates automation scripting, execution, and analysis of results
- Provide technical leadership and mentoring for test engineers on multiple applications/projects onshore and offshore; train and mentor project team members to create, execute, analyze, and maintain automated regression suites
- Coordinate with product owner to resolve open issues/enhancements/upgrades and understand the use of a specific functionality as needed
- Develop automated functional scripts using tools such as Java, Karate, JMeter.
- Perform exploratory and manual testing of the product suite as appropriate
- Provide expertise in testing methodologies, best practices, and standards
- Position will be onsite hybrid starting day 1. Interviews may also be onsite
-
Interaction with team:
- Working with team; team consists of 20+ folks
Work environment:
Chicago Office
Education Required:
- Degree requirement: Bachelor's degree
Required Technical Skills
(Required)
Strong design and development skills in two or more of the following - technologies and tools: Java (2+ years) Cucumber(2+ years), JBehave or other BDD testing frameworks
- At least 2-4 years of test automation framework design
- Strong experience in testing Webservices (REST APIs) (2+years)
- Proven experience developing test scripts, test cases, and test data
- The ability to write queries in SQL or other relational databases
- 2+ years of experience in developing scenario based performance testing using JMeter
- Experience testing full stack and integration testing with 3rd parties
- End-to-end system integration testing experience for software platforms
- Experience in Penetration testing (Pen testing)
(Desired)
- Hands on experience with Python
- development experience in AWS Cloud technology
- Experience in TDD, continuous integration, code review practice is strongly desired
- Experience with Apigee or other API gateways is a plus
- Experience with DevOps concepts and tools (e.g., CI/CD, Jenkins, Git)
- At least 2 years working on an Agile team with a solid understanding of Agile/Lean practices.
- Understanding of a micro service Architecture
- Experience load and performance testing
- Strong documentation skills
Soft Skills
(Required)
- Ability to adapt quickly to a complex environment
- Pro-active, flexible and creative
- Very strong communication skills and the ability to collaborate with developers and business users.
IT Business Systems Analyst
Senior data analyst- job in Chicago, IL
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.
Sr. Data Scientist
Senior data analyst- job in Chicago, IL
The Senior Data Scientist, Clinical Data Science (HOS & HRA) plays a key role in advancing analytics that improve Medicare Advantage member outcomes and CMS Star Ratings performance. This position supports the design, implementation, and automation of analytic solutions for the Health Outcomes Survey (HOS) and Health Risk Assessment (HRA) programs-two core domains in Aetna's Medicare clinical strategy.
The ideal candidate combines strong technical depth in data science and statistical modeling with the ability to translate complex findings into actionable insights for non-technical audiences. This individual will automate recurring data science workflows, conduct robust impact and descriptive analyses, and collaborate closely with clinical, quality, and operations teams to identify emerging opportunities that improve member experience and population health outcomes.
Clinical Data Science & Analytics
Lead the development of analytic models and descriptive frameworks supporting HOS and HRA performance improvement across Medicare Advantage.
Conduct impact analyses, trend identification, and segmentation to explain drivers of performance and inform strategy.
Automate recurring analytics and reporting pipelines to increase reliability, efficiency, and reproducibility of insights.
Apply advanced statistical, predictive, and causal inference methods to evaluate intervention effectiveness and identify member-level opportunities.
Develop and refine tools for data visualization and storytelling to communicate results clearly to non-technical stakeholders.
Partner with business leaders to translate analytic results into actionable recommendations for program design, member outreach, and care interventions.
Collaboration & Consultation
Serve as a bridge between technical and non-technical teams, ensuring analytic outputs are interpretable and actionable.
Collaborate cross-functionally with Clinical Operations, Member Experience, and Quality teams to align analytics with enterprise goals.
Support enterprise data modernization and automation initiatives by identifying repeatable use cases for scalable analytics and workflow improvement.
Mentor junior data scientists and analysts on best practices for data integrity, modeling, and automation.
Technical & Operational Excellence
Design and maintain automated analytic processes leveraging Python, SQL, and modern cloud environments (e.g., GCP).
Ensure accuracy, consistency, and explainability of models and metrics through disciplined version control and validation.
Contribute to the team's continuous improvement culture by recommending new methods, tools, or data sources that enhance analytic precision and speed.
Required Skills & Experience
5+ years of hands-on experience in data science, advanced analytics, or statistical modeling in healthcare, life sciences, or managed care.
Strong proficiency in Python, SQL, and data science libraries (e.g., pandas, scikit-learn, statsmodels).
Demonstrated ability to automate data workflows and standardize recurring analyses or reporting.
Experience applying statistical and descriptive analytics to clinical or quality measurement problems (e.g., HOS, HRA, CAHPS, or HEDIS).
Proven success communicating complex findings to non-technical business partners and influencing decision-making.
Ability to work effectively in a fast-paced, cross-functional environment.
Nice to Have Skills & Experience
Master's or PhD in Data Science, Statistics, Epidemiology, Public Health, or a related quantitative field.
Familiarity with Medicare Advantage, CMS Star Ratings methodology, and clinical quality measures.
Experience working within modern cloud environments (e.g., Google Cloud Platform, Databricks) and with workflow orchestration tools (Airflow, dbt).
Background in impact measurement, causal inference, or time-series analysis in healthcare contexts.
Data Architect - Pharma
Senior data analyst- job in Chicago, IL
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
Business Analyst
Senior data analyst- job in Chicago, IL
Hybrid
Chicago, IL
6+ months
Project Overview / Contractor's Role:
IT Infrastructure organization is looking for a Business Analyst to join its ITSM Metrics & Analytics team. As part of an Agile development team, this individual will be responsible for business analysis, requirements, design of custom developed Business Intelligence data products using Microsoft's Power BI product, assuring that all business and technical requirements are being met.
Qualifications (must haves):
> Agile Methodology
>Prior experience performing in a BA role is recommended but not required, preferably involving ITSM processes and/or developing Business Intelligence data products
> Excellent communication, interpersonal and organizational skills are required
> Strong analytical and problem solving skills
> Ability to work both independently and in mixed onshore/offshore teams
> A positive goal orientated attitude with a focus on delivery
Nice to Have:
• Familiarity with ITIL/ITSM processes: Change, Incident, Problem, CMDB, SAM, HAM
• Azure DevOps for work item and backlog management
• Technical skills focusing on ServiceNow, SQL, BI/visualization tools (Power BI, Tableau, etc)
Tasks & Responsibilities:
• Interface with ServiceNow product teams both on-shore and offshore to design solutions to meet their needs
• Serve as a primary liaison between ServiceNow product teams and the Power BI development team
• Translate portions of ServiceNow product roadmaps into Features and User Stories
• Manage Features, User Stories, and Defects in Azure DevOps
• Communicate status (written and verbal) to relevant stakeholders
Charles River Business Analyst
Senior data analyst- job in Chicago, IL
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
Procurement Business Analyst
Senior data analyst- job in Chicago, IL
The Procurement Business Analyst is a critical role that connects procurement operations, data analytics, and strategic business objectives. This individual transforms raw procurement data into actionable insights that drive cost savings, mitigate risk, and optimize the procure-to-pay (P2P) lifecycle. Responsibilities include analyzing complex datasets, identifying spending trends, monitoring supplier performance, and supporting strategic sourcing initiatives. The ideal candidate is highly analytical, detail-oriented, and skilled at communicating complex information to diverse stakeholders.
Key Responsibilities
Data Analysis & Reporting:
Develop and maintain procurement dashboards and reports (e.g., Power BI, Tableau) to track KPIs such as cost savings, supplier performance, contract compliance, and spend under management.
Perform in-depth analysis to identify cost-saving opportunities, sourcing efficiencies, and supplier consolidation.
Strategic Sourcing & Category Support:
Provide analytical support for RFP, RFQ, and RFI processes, including evaluation of supplier bids and total cost of ownership (TCO).
Conduct market research to identify supplier trends, commodity price fluctuations, and potential risks, delivering actionable insights to category managers.
Process Improvement:
Analyze and map procurement processes (e.g., requisitioning, purchasing, invoicing) to identify inefficiencies and opportunities for automation.
Collaborate with IT and business units to gather requirements and implement enhancements to procurement systems (e.g., ERP, P2P platforms).
Supplier & Contract Management:
Develop and monitor supplier performance scorecards to ensure compliance with contractual obligations and performance targets.
Analyze contract compliance, identify off-contract spending, and work with stakeholders to improve adherence to preferred supplier agreements.
Stakeholder Collaboration:
Serve as the primary analytical partner for procurement, finance, and key business departments.
Translate complex data findings into clear, actionable recommendations for non-technical audiences to support decision-making.
Skills and Knowledge
Required:
Education: Bachelor's degree in Business Administration, Finance, Supply Chain Management, Data Science, or related field.
Experience: 3-5+ years in a business analyst, data analyst, or procurement role.
Technical Skills:
Advanced proficiency in Microsoft Excel (pivot tables, complex formulas, data modeling).
Experience with data visualization tools (Power BI, Tableau, Qlik).
Proficiency in SQL for data extraction and manipulation.
Familiarity with ERP or P2P systems (SAP, Oracle, Coupa, Ariba).
Experience managing large datasets and applying data management best practices.
Preferred:
Background in manufacturing, electronics, or technology environments.
Professional certifications (e.g., CPSM, CSCP, IIBA-PBA).
Strong project management skills.
Basic Requirements:
Bachelor's degree in a relevant field.
Minimum 3 years of experience in procurement, supply chain, or data analytics.
Legal authorization to work in the U.S. indefinitely (no sponsorship available).
Travel Requirements:
Under 10%.
Configuration Analyst
Senior data analyst- job in Chicago, IL
New Era Technology is a global technology solutions provider with 4,500+ employees and offices around the world. New Era offers Cloud, Managed, Professional, and Security services, and delivers Collaboration, Data Networking, Digital Transformation, and Physical & Life Safety solutions to more than 14,500 customers worldwide. We are looking for team members to contribute to and deliver our mission: “To deliver and support technology solutions that securely connect people, places, and information.” New Era Technology is a community of like-minded, like-hearted people who share the same vision and values.
Configuration Analyst
Location: Oak Brook IL
Duration: 12 Months
Looking for configuration analyst with any transportation management system that would be interested in the Truckmate role.
Job Summary
The Configuration Analyst is a key part of the Integrated Solutions team. We are looking for a highly talented and motivated Configuration Analyst. You would participate in the full lifecycle of an Truckmate implementation to deliver a highly complex, comprehensive business solution for the enterprise. This position requires an individual capable of operating in a fast-paced environment while working on multiple initiatives. To be successful, this individual must be highly motivated and have a solid understanding of Truckmate, transportation and logistics principles, and supply chain network behavior.
EEO/AA Statement
New Era Technology provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, national origin, religion, pregnancy, marital status, gender identity, age, physical or mental disability, or covered veteran status.
In addition to federal law requirements, New Era Technology complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
Senior Business Analysit - InsurTech
Senior data analyst- job in Chicago, IL
Key Responsibilities
Including but not limited to:
Participate in / lead discussions with business users to understand the business requirements with focus on business consulting as required.
Participate in meetings/workshops with business users in determining the requirements for:
Processes
Products
Third party integrations
Active involvement in hands-on Product configuration in line with Project specific requirements
Identify and highlight potential risks to the business with respect to Functional and Non-Functional requirements
Manage business stakeholders to follow the system instead of heavily customizing the processes, workflow or products.
Analyse data relationships and dependencies, business processes and communication for mapping into future system requirements.
Work closely with technical teams and business stakeholders to prepare clear business objectives and system specifications for the design, development and enhancement of applications.
Liaise with Development and Testing Teams to ensure that all documented specifications are clearly understood.
Assist in the creation and implementation of business and system test plans.
Write/produce high quality documentation and provide progress reports to Lead Consultant and Project Manager as directed.
Prepare PowerPoint presentations for training and system demo purposes and also for pre-sales.
Ability to delegate and steer Product deliverables to completion working with other BAs in the team.
Have good proficiency in Excel, Word, Data visualisation and designing tools.
Perform functional testing from business perspective.
Providing support to customers for UAT and post production.
Professional Characteristic
Driven, with a “can do approach”
Sense of urgency, focus on the outcome, not just the task.
Ownership, pride, and passion with regards work output;
Energetic, learns at a face pace and applies learnings in daily circumstances to deliver real value to clients.
Qualifications
Undergraduate Degree/Diploma
Insurance industry Certifications will be added advantage.
Membership of relevant professional body will be added advantage.
Experience
Mandatory
7+ years relevant experience as a Business Analyst in Insurance domain with focus on non-life/ General/ Personal & Commercial lines
Hands-on Experience in Insurance products configuration
with exposure to modules e.g. Policy Administration, Underwriting, Rules, , Billing/ Finance (Rating), Claims, Reporting, Documentation etc.
Experience in ISO, ACORD standard will be an added advantage.
Ability to manage difficult stakeholders internal as well as external with active participation in the requirement clarifications during implementation, issue resolutions with in-depth Business & System analysis.
Excellent written and verbal communication skills.
Quality orientation and attention to detail.
Strong analytical and problem solving skills.
Self-starter, Quick Learner, able to manage difficult situation and conflict resolution.
Sr Epic Application Analyst
Senior data analyst- job in Chicago, IL
Type : Permanent Role
REMOTE ROLE
MUST BE Citizen or Green Card
Experience working in a hospital or other health care organization.
This position develops, builds, and modifies Epic applications. Writes documentation specifications, fact-finding and analyses.
results and proposes solutions or recommendations. Builds, configures and/or modifying applications using existing application
tools. This role performs complex analysis, design, development, testing and support services for Epic applications. Leads and
monitors midsize to large scale projects within multiple functional departments. Exemplifies the Rush mission, vision and values
and acts in accordance with Rush policies and procedures.
Responsibilities
•Leads and monitors midsize to large scale projects within multiple functional departments.
•Performs complex designs, implements, maintains, and provides ongoing optimization and support for Epic clinical applications.
•Performs workflow assessments, capture business needs, and analyze internal systems to determine functional requirements for
optimal utilization of Epic applications.
•Works within cross-functional team and with end-users to achieve application integration to meet clinical needs.
•Performs builds, upgrades, and system enhancements as needed.
•Supports applications throughout all phases of implementation.
•Delivers post-implementation training, support, troubleshooting, and maintenance.
•Configures vendor applications and products.
•Maintains system documentation and develops system specifications and procedures.
•Defines and documents user requirements.
•Applies project planning and project management methodologies.
•Coordinates and leads short duration projects; monitoring project process, progress and results.
•Develops test plans, prepares test data and performs system testing.
•Provides on-site user support during implementations.
•Takes on-call for system application support at scheduled times.
•Audits data entered by end users.
•Troubleshoots and tracks issues and problems.
•Applies systems development methodology to solve problems.
•Handles multiple assignments simultaneously.
•Other duties as assigned.
Other Information
Required Job Qualifications:
•Bachelor's degree.
•5 years of Epic application experience.
•An Associate degree and seven (7) years of Epic application experience will be accepted in lieu of a Bachelor's.
•Epic certification(s).
•Demonstrated ability to effectively utilize system tools to meet functionality needs of users including proficiency with information
systems technology such as Microsoft Office Products.
•Experienced planning and organizing day-to-day activities, effectively managing more than one task, and meeting established
deadlines.
•Experienced in leading projects, providing expert consultative guidance and direction on change initiatives, effectively dedicating
time across more than one project, and meeting established deadlines.
•Experience leading meetings between business stakeholders, technical resources, and third parties for business requirements and
technical solutions.
•Experienced working with a diverse, multi-disciplinary team, and interacting with all levels of the organization.
•Detail oriented, strong analytical, organizational, and problem-solving skills.
•Excellent oral and written communication skills with technical and clinical audiences.
•Ability to troubleshoot, research, and solve technically challenging problems involving integrated systems.
Preferred Job Qualifications:
•Experience working in a hospital or other health care organization.
Cybersecurity Lead Analyst
Senior data analyst- job in Chicago, IL
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.
Sr. BI Analyst
Senior data analyst- job in Gurnee, IL
Our client is a fast-growing leader recognized by both consumers and industry professionals.
They foster a dynamic, collaborative culture where high performers thrive in a fast-paced, hands-on environment. Although the company has over 60 years of history, they are entering a powerful new chapter of expansion, innovation, and transformation. Their people are their greatest asset-driven, engaged, and motivated by purposeful work.
Our client is seeking a Sr. Business Intelligence Analyst & Data Infrastructure Developer to design, build, and maintain a unified data architecture within Microsoft Fabric to support enterprise-wide reporting and analytics. This role blends advanced data engineering, SQL development, and Power BI expertise to integrate multiple data sources into a single, trusted reporting layer. The ideal candidate will build ETL pipelines, optimize semantic models, and partner closely with finance and business stakeholders to deliver scalable, accurate, decision-driving insights.
What You Will Do:
Lead Data Architecture Initiatives
Design and implement a unified enterprise data model by consolidating seven existing semantic models into a single Microsoft Fabric-based architecture.
Analyze legacy datasets and define optimal integration, migration, and consolidation strategies.
Develop and manage facts, dimensions, measures, and metadata aligned to business needs.
Define partitioning, refresh strategies, and performance optimization approaches.
Maintain data lineage, data dictionaries, and metadata documentation.
ETL/ELT Development & Maintenance
Build, enhance, and troubleshoot ETL/ELT pipelines using SSIS and Microsoft Fabric Dataflows.
Determine when data should be materialized in the warehouse versus exposed through views.
SQL Development
Write, debug, and optimize complex SQL, including stored procedures, CTEs, unions, and dynamic SQL.
Maintain and evolve SQL views supporting downstream reporting, dashboards, and analytics.
Collaboration & Reporting
Partner with finance, operations, and executive teams to scale customized financial and operational reporting solutions.
Translate reporting requirements into scalable technical data models.
Facilitate discussions across business and technology teams to align on long-term data architecture strategy.
Semantic Model Management
Build, maintain, and optimize Power BI semantic models and datasets.
Deploy BI solutions via VS Code, Tabular Editor, and Azure DevOps pipelines.
Support Power BI paginated reports and advanced DAX calculations.
What You Will Bring:
5-7 years of experience in business intelligence, data architecture, and ETL/ELT development.
Strong SQL expertise (CTEs, stored procedures, dynamic SQL, query optimization).
Intermediate to advanced DAX skills for performance tuning and model optimization.
Experience integrating data from major ERP systems (Syspro experience is a plus).
Deep expertise with Power BI (certification preferred).
Familiarity with AI/ML concepts, including agent-based or predictive modeling.
Experience with Microsoft Fabric, Azure Data Services, or similar cloud data platforms.
Education & Qualifications
Bachelor's degree in Data Science, Analytics, IT, or a related field; finance or accounting knowledge is strongly preferred.
Master's or MBA is a plus.
Power BI certification preferred.
Microsoft Fabric certification preferred.
Proven ability to collaborate with senior finance and business leaders.
MMD Services Inc. is an equal opportunity employer. All applicants are considered for all positions without regard to race, religion, color, sex, gender, sexual orientation, pregnancy, age, national origin, ancestry, physical/mental disability, medical condition, military/veteran status, genetic information, marital status, ethnicity, alienage or any other protected classification, in accordance with applicable federal, state, and local laws.