Senior Data Scientist (Senior Consultant)
Senior data analyst- job in Chicago, IL
Job Family:
Data Science Consulting
Travel Required:
Up to 10%
Clearance Required:
Ability to Obtain Public Trust
About our AI and Data Capability Team
Our consultants on the AI and Data Analytics Capability team help clients maximize the value of their data and automate business processes. This high performing team works with clients to implement the full spectrum of data analytics and data science services, from data architecture and storage to data engineering and querying, to data visualization and dashboarding, to predictive analytics, machine learning, and artificial intelligence as well as intelligent automation. Our services enable our clients to define their information strategy, enable mission critical insights and data-driven decision making, reduce cost and complexity, increase trust, and improve operational effectiveness.
What You Will Do:
Data Collection & Management: Identify, gather, and manage data from primary and secondary sources, ensuring its accuracy and integrity.
Data Cleaning & Preprocessing: Clean raw data by identifying and addressing inconsistencies, missing values, and errors to prepare it for analysis.
Data Analysis & Interpretation: Apply statistical techniques and analytical methods to explore datasets, discover trends, find patterns, and derive insights.
Data Visualization & Reporting: Develop reports, dashboards, and visualizations using tools like Tableau or Power BI to present complex findings clearly to stakeholders.
Collaboration & Communication: Work with cross-functional teams, understand business requirements, and effectively communicate insights to support data-driven decision-making.
Problem Solving: Address specific business challenges by using data to identify underperforming processes, pinpoint areas for growth, and determine optimal strategies.
What You Will Need:
US Citizenship is required
Bachelor's degree is required
Minimum THREE (3) Years Experience using Power BI, Tableau and other visualization tools to develop intuitive and user friendly dashboards and visualizations.
Skilled in SQL, R, and other languages to assist in database querying and statistical programming.
Strong foundational knowledge and experience in statistics, probability, and experimental design.
Familiarity with cloud platforms (e.g., Amazon Web Services, Azure, or Google Cloud) and containerization (e.g., Docker).
Experience applying data governance concepts and techniques to assure greater data quality and reliability.
he curiosity and creativity to uncover hidden patterns and opportunities.
Strong communication skills to bridge technical and business worlds.
What Would Be Nice To Have:
Hands-on experience with Python, SQL, and modern ML frameworks.
Experience in data and AI system development, with a proven ability to design scalable architectures and implement reliable models.
Expertise in Python or Java for data processing.
Demonstrated work experience within the public sector.
Ability to support business development including RFP/RFQ/RFI responses involving data science / analytics.
The annual salary range for this position is $113,000.00-$188,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.
What We Offer:
Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
Benefits include:
Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time & Company Paid Holidays
Position may be eligible for a discretionary variable incentive bonus
Parental Leave and Adoption Assistance
401(k) Retirement Plan
Basic Life & Supplemental Life
Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
Short-Term & Long-Term Disability
Student Loan PayDown
Tuition Reimbursement, Personal Development & Learning Opportunities
Skills Development & Certifications
Employee Referral Program
Corporate Sponsored Events & Community Outreach
Emergency Back-Up Childcare Program
Mobility Stipend
About Guidehouse
Guidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.
Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.
If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at ************** or via email at RecruitingAccommodation@guidehouse.com. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.
All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or ************************. Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.
If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse's Ethics Hotline. If you want to check the validity of correspondence you have received, please contact *************************. Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant's dealings with unauthorized third parties.
Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.
Auto-ApplySenior Data Analyst
Senior data analyst- job in Chicago, IL
Senior Data Analyst
Department: Office of Market Supervision (“OMS”)
Reports to: Manager, OMS
Status: Full-Time, Exempt
Under the supervision of the Manager, OMS, the Sr. Data Analyst will support the Office of Market Supervision (OMS) and Regulation's Market Regulation Center (“MRC”) management, with a focus on the Trading Floor team in particular, related to technical aspects of regulatory-related tools and processes; front-end / application development; report development; data and statistical analysis and reporting; and procedural documentation efforts.
Position Duties:
Develop a subject matter expert (“SME”) level of BOX facilities' data models, including Consolidated Audit Trail (“CAT”), as sources of Regulation's report generation and query activities.
Assist with database creation, performance, and maintenance of SQL Server related to regulatory dashboard application.
Develop a detailed level of knowledge of operational functionality and processes related to VIGIL, CAT and other regulatory-related applications.
Assist in development of Regulation's Request for Change (“RFC”) and Business Requirements Documentation (“BRD”).
Participate in various meetings related to development of Business Requirement Documents (“BRD”) for OMS technology providers and other relevant vendors in coordination with other stakeholders. Perform user acceptance testing of OMS-related system or reporting changes, problem solving of issues with stakeholders and reporting to OMS management.
Assist with resolution of CAT reporting issues and data reconciliation issues with BOX Exchange Participant firms.
Assist with development and maintenance of accurate and current procedures for assigned functions; create and report updates to OMS management to ensure accurate reflection of processes and controls.
Leverage technology to streamline current regulatory operation processes and decrease repetitive tasks in coordination with Regulation staff.
Communicate status, issues, and resolutions with interested parties including, but not limited to, Regulation staff, OMS / MRC management, OMS technology providers and BOX Exchange Participants as appropriate.
Perform technical-related surveillance reviews including related investigations of identified exceptions as well as support of Trading Floor-related activity investigations.
Other responsibilities include compiling, analyzing, or validating data and statistics, and/or assisting with risk assessment and/or audit documentation production, as otherwise assigned by OMS management.
Cross-train on floor trade analyst duties for backup coverage purposes.
Education:
Bachelor's degree in Computer Science, Information Systems, or Data Analytics required.
Experience:
At least two years of data analytics or similar experience in a regulated environment.
Experience designing and developing Power BI reports and dashboards preferred.
Job Knowledge and Skills:
Experience with Python, SQL, Excel, Microsoft SQL Server Management Studio, Transact-SQL, and Power BI.
An aptitude for analytical and problem resolution.
Ability to analyze and summarize findings in a clear and concise format.
Self-starter, proactive and objective oriented.
High level of accuracy and attention to detail.
Ability to handle multiple assignments and deadlines.
Interpersonal skills to work effectively and collaboratively with persons from diverse backgrounds and at various organizational levels within and outside of BOX Exchange.
Target Salary Range:
$120,000 - $150,000 if located in Illinois
Salaries vary by location and are based on numerous factors, including, but not limited to, the relevant market, skills, experience, and education of the selected candidate. If an estimated salary range for this role is available, it will be provided in our Target Salary Range section.
Our compensation package also includes bonus eligibility and a comprehensive benefits program.
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
Data Architect
Senior data analyst- job in Oak Brook, IL
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.
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.
Cloud Data Architect
Senior data analyst- job in Chicago, IL
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.
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
Data Architect
Senior data analyst- job in Chicago, IL
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.
Business System Analyst
Senior data analyst- job in Chicago, IL
Hybrid
Direct Hire
W2 only
About the Role
We are seeking a specialized Business Analyst / Business Systems Analyst (BA/BSA) to support our Infrastructure and Engineering teams. This role is ideal for someone with a strong technical foundation and an interest in backend systems, networking, and data center operations. You will work closely with technical teams to gather requirements, document processes, and ensure successful delivery of infrastructure projects.
Key Responsibilities
Collaborate with Infrastructure and Engineering teams to define and document requirements for:
Data centers, backend servers, and networking solutions.
Hardware setups, including racks and system configurations.
Support backend server administration and connectivity planning.
Assist in setting up directory permissions and managing file transfer protocols.
Understand and document how network traffic flows and how proxies are leveraged.
Translate technical needs into clear business requirements and functional specifications.
Participate in testing and validation of solutions; basic scripting for automation and troubleshooting.
Serve as a liaison between technical teams and business stakeholders to ensure alignment.
Maintain documentation for infrastructure processes and standards.
Required Skills & Experience
Strong understanding of network fundamentals, traffic flow, and proxy usage.
Familiarity with data center operations, hardware requirements, and system connections.
Basic knowledge of shell scripting (e.g., Bash) and ability to work with CLI tools (command line interface).
Experience with file transfer protocols and directory permission management.
Exposure to backend server administration.
Ability to gather and translate technical requirements into actionable deliverables.
Excellent communication and documentation skills.
Interest in learning and growing within infrastructure and engineering domains.
Preferred Qualifications
Hands-on experience with bash scripting and automation.
Some development or testing experience.
Knowledge of hardware configuration and rack setup.
Familiarity with networking tools and troubleshooting techniques.
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
Technical Solutions Analyst
Senior data analyst- job in Rosemont, IL
IDR is seeking a Technical Solutions Analyst to join one of our top clients for an opportunity in a remote capacity. This role is integral to the Data Engineering team within a leading organization in the technology and data solutions industry. The position involves translating business requirements into technical specifications and collaborating across multiple teams to deliver innovative data-driven solutions.
Position Overview for the Technical Solutions Analyst:
Collaborate closely with Product, Engineering, and Business stakeholders to understand and analyze business needs.
Lead the process of eliciting, analyzing, and validating business requirements, translating them into detailed technical specifications and user stories.
Create User Stories, Acceptance Criteria, Data/Process Flow Diagrams, and other detailed technical documentation for development teams.
Analyze existing and third-party software solutions to determine integration needs or capture new system deployment requirements.
Participate actively in Agile ceremonies, including stand-ups, refinement, release planning, demos, and retrospectives.
Requirements for the Technical Solutions Analyst:
Bachelor's degree in computer science or 7+ years of equivalent hands-on software development experience.
Minimum of 5 years of recent experience as the primary author of User Stories, Acceptance Criteria, and related technical details in an Agile environment.
Expertise in relational databases and API design and architecture.
Experience designing or developing healthcare interoperability solutions utilizing either EDI or HL7 standards.
Advanced T-SQL skills for querying database objects.
What's in it for you?
Competitive compensation package
Full Benefits; Medical, Vision, Dental, and more!
Opportunity to get in with an industry leading organization.
Why IDR?
25+ Years of Proven Industry Experience in 4 major markets
Employee Stock Ownership Program
Dedicated Engagement Manager who is committed to you and your success.
Medical, Dental, Vision, and Life Insurance
ClearlyRated's Best of Staffing Client and Talent Award winner 12 years in a row.
ERP Business Analyst
Senior data analyst- job in Kenosha, WI
We are seeking an experienced IT/ERP Project Manager to lead and drive critical technology initiatives, including our upcoming ERP system upgrade and key IT process improvement projects. This role will play a pivotal part in enhancing operational efficiency, optimizing business processes, and supporting digital transformation across the organization.
The ideal candidate will have a proven track record managing ERP implementations or upgrades-preferably with experience in QAD ERP-and leading cross-functional teams through complex IT projects. This is a hybrid role based in Wisconsin, with some on-site requirements to effectively collaborate with internal stakeholders and project teams.
Lead ERP Upgrade Initiatives
: Manage the successful execution of ERP system upgrades, ensuring projects are completed on time, within scope, and within budget.
Optimize Business Processes
: Evaluate existing workflows across departments and implement process improvements to increase efficiency, reduce manual effort, and minimize errors.
Drive Digital Transformation
: Lead company-wide digital initiatives, leveraging technology to streamline operations and enhance business performance.
Design and Deliver ERP Reporting Solutions
: Collaborate with stakeholders to develop custom ERP reports that provide actionable insights and support business decision-making.
Collaborate Across Teams
: Partner with business leaders and cross-functional teams to gather requirements, ensure alignment, and deliver solutions that meet operational needs.
Manage Risk and Change
: Identify project risks and implement mitigation strategies while leading effective change management to support smooth adoption of new systems and processes.
Project Planning and Execution
: Develop detailed project plans, manage resources, track progress, and ensure accountability to meet project milestones and deliverables.
Promote Continuous Improvement
: Research and recommend new technologies, tools, and best practices to advance the company's digitalization and process optimization goals.
Communicate Project Progress
: Provide clear and consistent updates to leadership and stakeholders on project status, risks, and achievements to maintain alignment and transparency.
Skills & Qualifications:
3+ years of IT experience in a networked environment
Bachelor's degree in Computer Science, Information Systems, or equivalent combination of education and experience
Strong knowledge of IT infrastructure, systems, and troubleshooting best practices
Proven experience managing complex IT projects, including ERP upgrades or implementations
Hands-on experience with ERP systems (preferably QAD), with an understanding of integrations, customization, and upgrade processes
Skilled in business process analysis and workflow automation
Demonstrated ability to lead digital transformation initiatives and drive technology adoption
Strong change management skills with a focus on smooth implementation and user adoption
Excellent leadership, communication, and collaboration skills with the ability to work across all levels of the organization
Strong analytical and problem-solving abilities, with a proactive approach to resolving issues
Experience working in a manufacturing or industrial environment preferred
Preferred Qualifications:
Direct experience with QAD ERP
Experience managing full-cycle ERP implementations or upgrades
Proficiency in developing custom reports within ERP systems
Sr Epic Application Analyst - Willow Certified
Senior data analyst- job in Chicago, IL
Job Title: Sr. Epic Application Analyst - Willow
Primary Location: Remote (with occasional on-site for go-live events)
Position Type: Full-Time
TalentFish is casting a line for a Sr. Epic Application Analyst. This is a Full-Time role, working remotely with occasional on-site requirements for go-lives. The reason this position exists is to develop, build, and modify Epic applications, perform complex analysis, design, development, testing, and provide support services for Epic applications.
What You Bring to the Role (Ideal Experience):
Bachelor's degree (or Associate's degree with 7 years of Epic application experience).
5 years of Epic application experience (Willow required, Bridges preferred).
Epic certification(s)- Willow required
Proficiency with information systems technology such as Microsoft Office Products.
Experience planning and organizing day-to-day activities, managing multiple tasks, and meeting deadlines.
Experience leading projects and meetings between business stakeholders, technical resources, and third parties.
Ability to work with diverse, multi-disciplinary teams and interact with all organizational levels.
Strong analytical, organizational, and problem-solving skills.
Excellent oral and written communication skills with technical and clinical audiences.
Ability to troubleshoot and solve technically challenging problems involving integrated systems.
Experience from working within a hospital environment
What You'll Do (Skills Used in this Position):
Lead and monitor midsize to large-scale projects across multiple departments.
Perform complex designs. Implement, maintain, and optimize Epic clinical applications.
Conduct workflow assessments, capture business needs, and analyze internal systems for functional requirements.
Collaborate with cross-functional teams and end-users for application integration.
Perform builds, upgrades, and system enhancements.
Support applications throughout all phases of implementation.
Deliver post-implementation training, support, troubleshooting, and maintenance.
Configure vendor applications and products.
Maintain system documentation and develop specifications and procedures.
Define and document user requirements.
Apply project planning and management methodologies.
Develop test plans, prepare test data, and perform system testing.
Provide on-site user support during implementations.
Take on-call for system application support as scheduled.
Audit data entered by end users and troubleshoot issues.
Apply systems development methodology to solve problems.
Handle multiple assignments simultaneously.
Additional Skills:
Pyxis - Client (ADS, CII Safe, Logistics) or Omnicell (ADS, CSM, CPM)
Epic Willow
Epic Bridges
Interface/HL7
Pump integration (alaris, cadd solis)
CPR+
CAPS
Camera hardware (Hovercam etc)
Printer Networking (Zebra, lexmark)
Server Maintenance
Remote access
SQL
The expected salary range for this position is $110,000 - $129,000 per year, depending on experience and qualifications. This role also qualifies for comprehensive benefits such as health insurance, 401(k), and paid time off. TalentFish is committed to pay transparency and equal opportunity. The salary range provided is in compliance with applicable state and federal regulations.
This role requires authorization to work in the U.S. without current or future visa sponsorship.
All offers are contingent upon the completion of a background check, which may include but is not limited to reference checks, education verification, employment verification, drug testing, criminal records checks, and any required certifications or compliance requirements based on the end client's background check policies and applicable laws.
TalentFish is an employee-owned company pioneering a new realm in talent acquisition. We are redefining IT staffing by evolving AI, video screening, and our unique platform. TalentFish focuses on providing the best employee, consultant, and client experience possible. At TalentFish we are an Equal Opport unity Employer; we embrace and encourage diversity!
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. Workday HRIS Analyst
Senior data analyst- job in Skokie, IL
The Planet Group is assisting our client in hiring a Sr. Workday HRIS Analyst, Direct Hire/Perm role, Hybrid-onsite 1 day/week, Skokie, IL, 60077. Local resources only (the client is not considering candidates who are open to relocation at this time)! Client will only consider US Citizens or GC Holders (client will not sponsor any visa's).
NO THIRD PARTIES!
The Senior Workday HRIS Analyst will be hands-on that spans multiple HRIS applications-with emphasis on Workday. You will lead collaboration and business discussions and configuration excellence across HR workstreams including Core HCM, Recruiting, Time, Absence, Benefits, Compensation, Advanced Compensation, Talent Management, and Payroll. Additionally, there will be focus on Advanced Reporting / People Analytics. Provide generalized support for Shared Services user tickets in support of Workday technology issues, as well as all other HRIS technologies and general HR needs.
As the Sr. Workday HRIS Analyst, you will provide project management, reporting and analytics, collaborate with enterprise Workday partners for system maintenance and improvement, user enablement and support, and data integrity and system readiness capabilities.
Requirements:
Bachelor's degree in related field.
Certificate(s): Workday Pro certificate in HCM is strongly preferred but can be obtained within the first 6 months.
Additional Workday training or certifications in Advanced Reporting, Payroll, Absence, Time Tracking (PATT) are highly preferred.
5+ years' Workday administration experience; 4+ years configuration in HCM, Payroll, Absence, Time Tracking (PATT) and Advanced Reporting configuration expected.
Experience with developing and writing advanced Workday reports is required, including matrix and composite reports.
Experience consulting as a business partner with subject matter experts and gathering design requirements is required.
Previous experience as an HR practitioner/ HR knowledge or education is preferred.
Experience in Health Care, Senior Living or related field is preferred.
Experience with project management highly preferred.
The Planet Group Company Description
At The Planet Group, we connect Enterprise Systems experts with opportunities that match their skills, goals, and ambition. From fast-moving startups to global enterprises, we partner with top organizations across industries-giving you access to roles where your contributions make a difference. Explore flexible options including contract, direct hire, and contract-to-hire, all supported by a team that puts people first.
Additional Information
If you are interested, please respond to this ad with an updated resume and a summary of your skills. We look forward to hearing from you soon.
All your information will be kept confidential according to EEO guidelines.
Application Analyst
Senior data analyst- job in Munster, IN
In this role, you will look for opportunities using information technology to enhance business processes, automate manufacturing and develop supporting solutions. Through partnerships with production-related departments and cross-functional teams, you will identify needs for automation, assess potential solution sets, then design and implement the appropriate technologies. This role will be an integral part of the overall Information Technology team at Land O'Frost and will be part of a sub-team focused on enterprise application solutions and the integration of information between these systems. This position reports to the Manager of Enterprise Applications and Integration. This position can be located on site in Munster, IN, Searcy, AR, or Madisonville, KY.
Company
At Land O'Frost, our brands of lunchmeat, hot dogs and specialty sausage products are recognized as one of the nation's best-selling and trusted brands. We have accomplished this through our incredible team of employees who are customer focused, motivated, achievers, developers, and purpose driven.
How YOU Will Contribute
Understand and analyze existing business systems that include IFS and Novacura development, customizations, application patches, and database health.
Development and Testing: Assist in the design, development, testing, implementation, and documentation of new software and enhancements of Radley and Novacura applications.
Oversee IFS development, customizations, application patches, and database health.
Responsible for leading the IFS system solutions and support services within the Operations function.
Lead the definition and implementation of business process improvements projects within the ERP system (IFS).
IFS Applications - Maintain processes and tools needed to install and configure IFS Applications and to setup development environments of IFS Applications.
Maintain IFS Databases - Monitor Database activities and workload to prevent issues and failures.
Maintain technical knowledge for SQL Developer, SQL Plus, MS Office (Word, Excel, Access, PowerPoint), Oracle, IFS, Novacura Flow Studio, Teams, Notepad++, Bartender Designer, Filezilla FTP.
About YOU
Bachelor's degree or equivalent work experience in Information Technology in a process-driven environment.
Knowledge of software development tools.
Experience in using relational databases as sources of data for application software.
Excellent oral and written communication skills.
Deep understanding of PCs and network connectivity.
Senior Business Analyst - Card Loss Forecast and Allowance
Senior data analyst- job in Chicago, IL
About the organization:
The Loss Forecasting and Allowance team resides within our Consumer Card Risk Management Organization and is focused on delivering quality forecasts to our Consumer Card businesses (US Card, Canada and UK). This ultimately impacts LOB-wide budgets and planning, and directly impacts company wide earnings. The broader team also works on Stress Testing initiatives as well as quarterly updates on the state of credit which is shared directly with Rich Fairbank, CEO and the Executive Committee. The team environment is collaborative, engaging, and offers ample opportunities for meaningful contributions to the highly visible work we do.
The Role:
As a Senior Business Analyst at Capital One, you will apply your strategic and analytical skills to major company challenges. You will team with world-class professionals to develop and test strategies that ultimately impact the bottom line. And you will do it all in a collaborative environment that values your insight, encourages you to take on new responsibility, promotes continuous learning, and rewards innovation.
This role sits on the Card Allowance team which produces a quarterly forecast for expected lifetime credit losses (i.e. the reserve for loans we expect not to collect on under GAAP standards). This has direct impacts on the consolidated P&L impacts of the business and is frequently discussed in the context of company wide earnings. This work entails analytical rigor, technical savvy, and sound judgement to create forecasts that are ultimately shared by our team with a wide range of senior stakeholders across the company. In doing so, you will work alongside driven teammates and a variety of cross-functional teams (Accounting/Finance, Capital Risk, firstline business teams, among others) to build out a robust and well-informed product.
Additional aspects of this role include gaining familiarity with the underlying models and data, engaging with firstline teams to stay apprised of business strategy changes, assessing internal and external trends to derive insights into credit performance, and identifying areas to improve our processes and forecasts.
General Responsibilities Include, But Are Not Limited To:
Analysis: Identify business challenges and opportunities for improvement and solve for them using analysis to make strategic or tactical recommendations
Product: Perform modeling/analytics to assist new product and pricing strategies for various lending products
Credit Risk: Support step-change improvements in credit performance by connecting drivers of future consumer credit trends to historical behavior, creating risk models, and testing hypotheses using rigorous monitoring and analysis
Execution: Involve problem frame-works, develop hypotheses, test and analysis, solution development, scope operational feasibility, lead implementation efforts and develop a monitoring plan
Partnership: Work closely with colleagues across Capital One including: IT, Sales, Operations, Finance and others to drive improvement in quality, volume, service, and profitability
Strategic & analytic orientation: A proven track record of decision making and problem solving based on analytics. Conceptual thinking skills must be complemented by a strong quantitative orientation, given that a large part of the business is based on rigorous analytic marketing & credit risk management
Strong business judgment, leadership and integrity: He/she should be a tenacious decision maker, able to bring a healthy, aggressive, yet responsible approach to business
Strong communication skills: Impeccable written and oral communication credentials, coupled with strategic influencing skills and the ability to drive agreement through intellect, interpersonal and negotiation skills
Clear results orientation: display an intense focus on achieving both short and long term goals. He/she should be able to drive and execute an agenda in an uncertain and fluid environment
Successful track record of thriving in a fast paced, entrepreneurial and dynamic environment. Previous consulting experience is a plus
Basic Qualifications:
Bachelor's Degree in any quantitative field (Business, Math, Economics, Finance, Statistics, Science, Engineering)
At least 1 year of experience in analysis
Preferred Qualifications:
Master's Degree in Business or quantitative field such as Finance, Economics, Physical Sciences, Math, Statistics, Engineering
1+ years of experience in Statistical model building
1+ years of experience in market research
1+ years of experience in SQL querying
2+ years of experience in business analysis
1+ years of experience in consulting
Capital One will consider sponsoring a new qualified applicant for employment authorization for this position.
The minimum and maximum full-time annual salaries for this role are listed below, by location. Please note that this salary information is solely for candidates hired to perform work within one of these locations, and refers to the amount Capital One is willing to pay at the time of this posting. Salaries for part-time roles will be prorated based upon the agreed upon number of hours to be regularly worked.
Chicago, IL: $99,100 - $113,100 for Sr. Business Analyst
McLean, VA: $109,000 - $124,400 for Sr. Business Analyst
Riverwoods, IL: $99,100 - $113,100 for Sr. Business Analyst
Candidates hired to work in other locations will be subject to the pay range associated with that location, and the actual annualized salary amount offered to any candidate at the time of hire will be reflected solely in the candidate's offer letter.
This role is also eligible to earn performance based incentive compensation, which may include cash bonus(es) and/or long term incentives (LTI). Incentives could be discretionary or non discretionary depending on the plan.
Capital One offers a comprehensive, competitive, and inclusive set of health, financial and other benefits that support your total well-being. Learn more at the Capital One Careers website . Eligibility varies based on full or part-time status, exempt or non-exempt status, and management level.
This role is expected to accept applications for a minimum of 5 business days.No agencies please. Capital One is an equal opportunity employer (EOE, including disability/vet) committed to non-discrimination in compliance with applicable federal, state, and local laws. Capital One promotes a drug-free workplace. Capital One will consider for employment qualified applicants with a criminal history in a manner consistent with the requirements of applicable laws regarding criminal background inquiries, including, to the extent applicable, Article 23-A of the New York Correction Law; San Francisco, California Police Code Article 49, Sections ; New York City's Fair Chance Act; Philadelphia's Fair Criminal Records Screening Act; and other applicable federal, state, and local laws and regulations regarding criminal background inquiries.
If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation, please contact Capital One Recruiting at 1- or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.
For technical support or questions about Capital One's recruiting process, please send an email to
Capital One does not provide, endorse nor guarantee and is not liable for third-party products, services, educational tools or other information available through this site.
Capital One Financial is made up of several different entities. Please note that any position posted in Canada is for Capital One Canada, any position posted in the United Kingdom is for Capital One Europe and any position posted in the Philippines is for Capital One Philippines Service Corp. (COPSSC).
Lead ETL Architect (No H1B)
Senior data analyst- job in Deerfield, IL
Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
As background, this client has been working with us and internal recruiting to fill this role for a LONG time. Previously, the client was looking for someone who could both technically lead the team specific to SAG technologies and also work with the business.
Two things have changed: 1) the span of control of the team increased from SAG to include the other technologies listed in the job description, and 2) he has been unsuccessful in finding someone who was both the best technical architect on the team and also had manager qualities. He is now open to lesser capabilities on the technical, as long as they have the manager.
I WOULD TARGET CURRENT/ FORMER SR. MANAGERS/ DIRECTORS OF INTEGRATION/ SOA. PREFERABLY, WERE TECHNICAL AT SOME POINT IN THEIR CAREER, BUT MOVED INTO MANAGEMENT. WITH THIS TARGET, YOU SHOULD BE ABLE TO ACCESS THE APPROPRIATE TALENT AT THIS PAY RATE.
Lead ETL Architect
Client's is seeking a Lead ETL Architect as a key member of their Center of Expertise for Integration Technologies. This consultant will be primarily responsible for leading the demand intake/ management process with the business leaders and other IT groups related to managing the demand for the design, build and ongoing support of new ETL architectures. They also will interact extensively with the team of architects supporting these technologies. Expertise in one of more of the following integration technology areas is required:
-- ETL - Datastage, AnInito, Talend (client is moving from AbInitio to Talend as their primary ETL tool)
The overall team is responsible for addressing any architecture impacts and defining technology solution architectures focusing on infrastructure, logical and physical layout of the systems and technologies not limited to hardware, distributed and virtual systems, software, security, data management, storage, backup/recovery, appliances, messaging, networking, work flow, interoperability, flexibility, scalability, monitoring and reliability including fault tolerance and disaster recovery in collaboration with Enterprise Architect(s). Additionally, responsible for the build-out and ongoing run support of these integration platforms.
Skills Set
· Possession of fundamental skills of a solution architect with ability to inquire and resolve vague requirements
· Ability to analyze existing systems through an interview process with technology SMEs. Does not need to be the SME.
· Takes a holistic view and communicate to others to be able to understand the enterprise view to ensure coherence of all aspects of the project as an integrated system
· Perform gap analysis between current state and the future state architecture to identify single points of failure, capabilities, capacity, fault tolerance, hours of operation (SLA), change windows,
· Strong verbal and written communication with proven skills in facilitating the design sessions.
· Able to influence, conceptualize, visualize and communicate the target architecture.
· Able to communicate complex technical or architecture concepts in a simple manner and can adapt to different audiences
· Ability to work independently and market architecture best practices, guidelines, standards, principles, and patterns while working with infrastructure and technology project teams.
· Ability to document end-to-end application transaction flows through the enterprise
· Ability to document the technology architecture decision process, and if required develop relevant templates
· Resolve conflicts within infrastructure and application teams, business units and other architects
· Identify opportunities to cut cost without sacrificing the overall business goals.
· Ability to estimate the financial impact of solution architecture alternatives / options
· Knowledge of all components of an enterprise technical architecture.
Additional Information
** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
Note:-
This is a
Contract job opportunity
for you.
Only
US Citizen
,
Green Card Holder
,
GC-EAD
,
H4-EAD, L2-EAD, OPT-EAD & TN-Visa
can apply.
No
H1B candidates,
please.
Please mention your
Visa Status
in your
email
or
resume
.
** All your information will be kept confidential according to EEO guidelines.
ETL Conversion Architect
Senior data analyst- job in Park Ridge, IL
Who We Are
PCMI (Policy Claim Management International) is a fast-growing, leading provider of integrated software for Extended Warranty Management and Finance and Insurance (F&I) administration. We are a SaaS company that operates in a fast paced, entrepreneurial environment. Our 3 teams located in the US, Poland, and Thailand work collaboratively around the clock to build our PCRS platform that automates the full administration lifecycle of all extended warranties, F&I products, and service contracts for our customers.
What You'll Do
The ETL Conversion Architect will play a critical leadership role in shaping the data conversion strategy for enterprise-scale implementations of PCMI's PCRS platform. Rather than focusing solely on individual project delivery, this role is also responsible for establishing scalable frameworks, validation models, and governance structures that enable the broader Professional Services team to execute conversions with consistency, accuracy, and minimal rework.
Acting as the subject matter expert in ETL methodology, this individual will define how legacy data is transformed, validated, and migrated into PCRS-prioritizing transparency, client alignment, and time-to-value. From developing SQL-based source-to-target comparison models to enabling trust-but-verify conversion tracking, this role is essential to building a repeatable, high-confidence conversion process that accelerates client onboarding and elevates delivery quality across the organization.
In this role, you will own:
Practice-Level Framework Design:
Architect and maintain source-to-target field-level validation frameworks that ensure field-level integrity across legacy and PCRS systems.
Design standardized SQL Server validation pipelines (leveraging SSIS) to log and store pre/post conversion data, enabling clear traceability and trust-but-verify validation with clients.
Establish conversion hypothesis protocols-defining expected outcomes from each extract-transformation-load (ETL) step before execution begins.
Define and govern control total expectations (e.g., contract count, rate bucket totals, claim payments) across major business objects like Contracts, Claims, and Payments.
Automation & Quality Enablement:
Build automated validation assets and exception monitoring templates that the broader team can leverage in Excel, SQL Server, or other tooling.
Partner with DevOps/Engineering to maintain a centralized SQL repository of validation rules, transformation logic, and data anomaly flags.
Provide field-level transformation and mapping patterns for common edge cases (e.g., address concatenation, rate truncation, legacy formatting inconsistencies).
Client Alignment & Delivery Readiness:
Define standardized conversion preview formats (e.g., before/after field-level reports) to be used in pre-conversion workshops with clients-helping them visualize how legacy data will translate into PCRS before any transformation begins.
Serve as a client-facing SME during data onboarding and conversion planning sessions-guiding clients through expected outcomes, resolving mapping discrepancies, and confirming mutual alignment prior to data transformation.
Act as a Trusted Advisor for clients throughout the full conversion lifecycle, from pre-conversion planning through post-load validation - ensuring transparency, accuracy, and accountability are maintained across all data migration milestones.
Ensure ongoing data quality assurance by defining scalable approaches for post-load reconciliation, control totals, and referential integrity validations - enabling early detection of discrepancies and reducing reliance on UAT as the primary validation checkpoint.
Governance & Oversight:
Own the conversion data quality strategy for PCRS implementations - including release-specific adjustments based on schema evolution.
Govern the process for tracking, storing, and surfacing control totals (financial and transactional) across conversions-ensuring full auditability.
Define procedures for flagging scope changes or deviations from standard conversions and providing inputs into project change control discussions.
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
Supervisory Responsibilities
None.
What You'll Need to Join Our Team
10+ years of progressive experience in ETL development, data conversion, and SaaS implementation, with a proven track record of designing and delivering scalable, SQL-based data frameworks in complex client environments.
Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent hands-on experience with high-volume data conversion projects.
Deep expertise in Microsoft SQL Server, including schema design, scripting, data transformation, validation logic, stored procedures, and performance tuning.
Proficiency in ETL frameworks and tools (e.g., SSIS, custom SQL-based ETL engines), with strong ability to architect reusable pipelines and enforce field-level mapping logic.
Solid understanding of SaaS platforms, especially in highly configurable systems within the following industries: Insurance, F&I, Accounting, Risk Management, or warranty admin platforms.
Experience working in Professional Services organizations with a focus on implementation quality, timeline predictability, and cost control.
Strong communication skills with demonstrated ability to translate complex technical designs into digestible summary insights for non-technical audiences, including PMs and clients.
Background in mentoring technical consultants and conversion engineers, and establishing standards for scalable data practices across client projects.
Familiarity with Agile or Waterfall delivery methodologies, as well as Change Management, Data Governance, and Test Validation frameworks.
Experience collaborating with Product and Engineering to identify platform gaps, inform roadmap priorities, and drive customer outcomes through technical innovation.
Required Skills/Abilities
Expert-level proficiency in ETL processes, frameworks, and source-to-target data mapping.
Strong SQL skills and experience working with SQL Server for complex data transformations.
Proficient in managing and querying large datasets across staging and production layers.
Familiarity with REST APIs, JSON, XML, and Batch processing for system integrations.
Competent in scripting with PowerShell and Python for ETL automation and validation.
Strong analytical mindset with a focus on quality, traceability, and reusability of conversions.
Excellent communication skills, capable of translating technical insights for non-technical audiences.
Highly organized with the ability to manage multiple priorities under tight deadlines.
Comfortable in a high-paced, client-facing environment with evolving business needs.
Physical Requirements
Prolonged periods of sitting at a desk and working on a computer.
Must be able to lift up to 15 pounds at times.
Travel Requirements
Must be able to travel to client meetings or PCMI office; up to 10%
Why Work For Us
Competitive Compensation from $150,000-$170,000 Annually*
Comprehensive Benefit Package**
Health, Dental & Vision Insurance
Health Savings Account (HSA)
Flexible Spending Account (FSA)
Short- & Long-Term Disability Insurance
Company-paid Long-Term Disability
Company-paid Life Insurance
Voluntary Life Insurance
Voluntary Accident Insurance
Employee Assistance Program
401k with generous Company Match
Commuter Benefits
Paid Time Off accrued per pay period.
10 Paid Holidays
Paid Parental Leave
Annual Bonus Program
Professional Development Opportunities
Employee Events
Wellness Programs
Employee Discount Programs
Office in Park Ridge, IL - Convenient location to Blue Line
*Individual compensation packages are based on various factors unique to each candidate, including skill set, experience, qualifications, and other job-related aspects.
**Eligible to enroll in the first day of employment for immediate coverage.
Although the role is remote, PCMI can only hire employees in the following states:
AL
CT
FL
GA
IL
KY
MO
NH
NC
OH
PA
TX
Note: It is required for this role to be in the Park Ridge, IL office, 2 days per week if candidate is located in the Chicagoland area.
Auto-Apply