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
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 Analyst
Senior data analyst- job in Frankfort, IL
AMSCO Medical is a full line distributor of medical, surgical, and laboratory equipment & supplies. Founded in 1985, AMSCO Medical has been serving various clients for more than 35 years. AMSCO is looking to add another member to our growing team. The Business Analyst position is a full-time on-site role located in Frankfort, IL. The candidate will be responsible for day-to-day tasks including analyzing business operations and identifying areas for improvement, spear-heading customer, and vendor compliance requirements, ensuring all product information is accurate, and more. The Business Analyst will also collaborate with the executive teams to implement new customer and vendor solutions.
Responsibilities -
Manage vendor contract information.
Develop new customer/vendor solutions to increase workflow.
Assist with product pricing information internally and externally.
Manage vendor/customer compliance requirements. Communicate and validate requirements with relevant parties.
Strategize ideas to improve day-to-day operations.
Coordinate with different departmental teams to improve productivity.
Qualifications -
Analytical Skills and Business Analysis skills.
Excellent communication skills, both written and verbal.
Experience with Business Process and Business Requirements.
Strong problem-solving skills.
Ability to work with cross-functional teams.
Bachelor's degree in business administration or related field.
Experience in the healthcare industry is a plus.
MUST LIVE IN ILLINOIS & ABLE TO BE IN OFFICE 5 DAYS A WEEK.
Benefits -
Health insurance after 90-day probation period.
401k match after 90-day probation period.
Senior Business Analyst, ServiceNow GRC/IRM
Senior data analyst- job in Chicago, IL
Our client is seeking a Senior Business Analyst, ServiceNow GRC/IRM to join their team! This position is located in Chicago, Illinois.
Lead workshops and conduct interviews with business stakeholders to define, analyze, and validate GRC/IRM requirements
Translate business needs into user stories, functional requirements, and process flow diagrams for implementation in ServiceNow IRM
Develop risk-related artifacts such as risk registers, risk assessment methodologies, and control frameworks
Conduct business process analysis to identify inefficiencies and make recommendations for improvement
Collaborate with the technical team to ensure the configured solution aligns with the documented functional requirements
Create and configure dashboards and reports to provide stakeholders with clear visibility into the organization's risk and compliance posture
Develop test plans, assist with user acceptance testing (UAT), and ensure the solution meets acceptance criteria
Provide ongoing support and clarification for implemented IRM solutions, acting as the subject matter expert
Stay up-to-date with ServiceNow IRM product releases and evolving GRC industry trends
Desired Skills/Experience:
Bachelor's degree in a relevant field, or equivalent professional experience
10+ years of professional experience in risk management, GRC, or a related field, demonstrating an in-depth understanding of enterprise risk, and controls processes
5+ years of experience working with ServiceNow IRM, with a deep focus on GRC processes and modules
Proven track record of success in gathering and translating complex business requirements into clear, functional specifications for large-scale ServiceNow IRM implementations
Expertise in core IRM capabilities such as Risk Identification, Risk and Control Self-Assessments (RCSA), Issue Management, Incident Management, Loss Events, and Controls Testing
Deep functional understanding of the ServiceNow IRM suite and its capabilities, including Policy and Compliance, Risk Management, and Audit Management
In-depth knowledge of GRC and risk management frameworks and best practices
Strong communication, presentation, and facilitation skills, with the ability to effectively bridge the gap between technical and non-technical stakeholders
Proven ability to lead workshops, gather requirements, and present complex information to all levels of the organization
Benefits:
Medical, Dental, & Vision Insurance Plans
Employee-Owned Profit Sharing (ESOP)
401K offered
The approximate pay range for this position is between $74.00 and $94.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.
Analyst, Renewables Project Development
Senior data analyst- job in Chicago, IL
We're partnered with a high-growth platform focused on building one of the largest portfolios of distributed solar and storage assets in the U.S. They partner with Fortune 500s and large energy users to deliver cost-effective and impactful clean energy solutions.
They're an experienced team offering a direct path to shaping the future of distributed energy. They're seeking a motivated and analytically sharp early-career professional to join their development team.
Why This Role Is Compelling:
High-Impact & High-Visibility: Serving as the operational and analytical go-to for thousands of projects nationwide, sitting at the intersection of data, markets, and project execution, you will have a hand in building a platform from the ground up, with immediate exposure to executives, clients, and cross-functional teams.
Accelerated Career Growth: As the company scales, they are building multiple business units around this program. High performers have a clear and rapid path to leadership roles in market intelligence, strategy, development, and operations.
"Doer" Culture, Not A Bureaucracy: They are a flat-structured team that rewards initiative and curiosity. This is a place for those who want ownership and responsibility, not just a task list.
Deepen Your Expertise: Gain hands-on, practical knowledge in utility rate design, energy policy, solar & storage economics, and contractor management that is highly sought after in the renewable energy sector.
What You'll Do:
Perform utility rate analysis and support energy modeling to evaluate the economics of distributed solar and storage projects throughout the U.S.
Conduct market research on energy policies, incentives, and utility programs that impact project viability and development strategy.
Oversee contractor progress on applications, permitting, and interconnection across multiple markets.
Build and maintain dashboards, project trackers, and reports to communicate portfolio performance and key insights to leadership.
Transform raw project and utility data into actionable intelligence to drive decision-making and optimize development workflows.
Jump in operationally where needed, embodying a team-first mentality to ensure project success.
What You'll Bring:
A Bachelor's degree in a relevant field (e.g., Engineering, Economics, Data Analytics, Environmental Science) and 1-3 years of professional experience
Strong proficiency in Excel or Google Sheets (pivot tables, charting, dashboards)
Analytical mindset with comfort managing, interpreting, and drawing insights from large datasets
Exceptional organizational skills and the ability to prioritize competing projects in a fast-paced environment
Clear and professional written communication skills for both technical and non-technical audiences.
A genuine curiosity about renewable energy, utility markets, and a desire to build a career in the industry
Nice-to-Haves:
Exposure to solar modeling software (e.g., Aurora, Toolbase), Power BI, or SQL.
Experience interacting with contractors or managing project trackers.
Familiarity with utility rate structures and/or energy policy.
Senior Business Analyst
Senior data analyst- job in Chicago, IL
Job Title
Senior Business Analyst
About OX
The Office of Experience (OX) is a full-service digital agency helping companies excel at every moment of interface they have with their customers. OX's human-centered philosophy and multidisciplinary approach integrate strategy, design and technology to help organizations reinvent their business and rapidly bring new experiences, products and messages to market. In an era of unprecedented disruption, OX is built to transform.
Position Description
As a member of OX's Business Analysis team, the Senior Business Analyst will be a highly self-motivated team member with the ability to work in a constantly changing environment. In this role, you will have a proven analytical background that is logical and efficient with keen attention to detail. You will have an exceptional ability to recommend solutions that are reasonable, actionable, and cost-effective, including the ability to properly gauge requirements. This role reports directly to the Executive Director, Experience Strategy.
Responsibilities & Duties
Drive cross-functional discussions with OX clients and internal teams-including IT, design, UX, and business leaders-to gather insights and develop business requirements that support the product vision
Understand high level technical architecture and help identify gaps between existing systems and what will be needed for a successful product
Translate business requirements into user stories
Work closely with UX, UI and development teams to ensure designs and builds are aligned to user stories and that all functional teams have the information they need to build and design in a timely fashion
Work closely with QA teams to ensure proper testing
Manage user acceptance testing and business related training with the client
Maintain all feature planning and backlog documentation
Maintain all action logs between client and agency teams
Required Experience
5-8 years of BA or Product Management experience in an agency or consulting environment
Experience working in B2B and B2C Commerce and CMS platforms
Experience working with UX, Product Design and Development teams
Experience working closely with various business teams to define requirements
Understanding of different tools and ways to tease out the right information needed for requirements definition through process flows for users, systems and client workflows
Ability to be process-oriented and also have the ability to be flexible and change process as needed
Ability to work within a collaborative and agile environment
Experience leading hybrid and remote teams
Experience with working with enterprise level and smaller technologies
Mobile and/or web app project experience
Experience leading feature discovery and roadmap discussions
Location
Chicago / Hybrid
Lead Data Architect
Senior data analyst- job in Chicago, IL
Role: Lead Data Architect
Skills: Data Mesh, Snowflake, Azure, and Python
Experience: 14+ years
The Data Technical Lead is responsible for architecture, Data migration to Data Mesh, they need someone who can Lead, architecture and make it a simplified, scalable, and work closely with teams to manage schedules and deliverables.
The skills needed are-
At least 12-14 years of experience working in Data
Strong in Data Mesh and Data products
Strong exp in Snowflake, Azure.
Strong in either Python or Java who can assess and work on the framework
Hands-on leadership to assess and rectify the issues
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.
Analyst/Senior Analyst
Senior data analyst- job in Chicago, IL
Background:
The role will require an entrepreneurial approach and willingness to use initiative but also a strong grounding in M&A, with solid understanding of representations, indemnities and the associated limitations in transaction documents.
Insurance knowledge is not required and will be provided, but experience of using RWI on transactions will be helpful.
The successful candidate will:
Learn about the M&A insurance market and the risks assumed by the insurance market;
Understand and learn the unique approach to broking which has underpinned growth across North America;
Engage with clients and in time run transaction processes from an insurance perspective;
Join business development meetings and pitches with investors and legal advisors, and in time run these meetings and develop own client base;
Help train and develop future more junior hires.
Business Support Analyst / Data Analyst
Senior data analyst- job in Naperville, IL
Job Title: Business Support Analyst (Data Analyst)
Job Type: Contract with possible extension
Pay Rate: $35-$45 hourly
Key Duties & Responsibilities:
Reporting: Prepares monthly financial reports, variance analyses, and clear explanations of key drivers.
Planning: Maintains the 10-year capital plan and develops procedures for capital budgeting, prioritization, and reporting.
Analysis: Delivers ad-hoc financial reports; researches expenditures; identifies trends and variances; and prepares comparisons and forecasts.
Visualization: Creates clear, visually effective presentations of financial data for stakeholders.
Compliance: Supports regulatory filings, commitments, and reporting requirements.
Systems: Assists with financial system upgrades and enhancements.
Collaboration: Provides backup support to the Sr. Analyst on project and financial control initiatives.
Qualifications Required:
Education: BA/BS/BBA in Finance, Accounting, Business Management, Engineering, or related field.
Certification: AACE, CPA, CMA, CISA, CFE, or similar recognized credential.
Experience: 3+ years in finance, accounting, audit, or project controls; energy sector experience preferred (natural gas/pipelines, storage, or plant development).
Technical Skills: Proficient in Oracle ERP, Power BI, PowerPlan or UI Planner; advanced Microsoft Office 365 skills, especially Excel.
Financial Expertise: Strong knowledge of reporting, modeling, forecasting, and accounting fundamentals.
Organizational Skills: Effective planning, prioritization, and attention to detail; ability to manage multiple tasks and shifting priorities.
Communication: Strong verbal and written communication across all organizational levels.
Flexibility: Able to maintain accuracy under tight deadlines; willing to work extended hours during critical periods.
Business Analyst with Knowledge in Financial Data Exchange - FDX /DDA API .
Senior data analyst- job in Chicago, IL
CapB is a global leader on IT Solutions on Financial Technology. Our R&D is focused on providing cutting edge products and solutions across Digital Transformations from Cloud, AI/ML, IOT, Blockchain, MDM/PIM, to Integration solutions. For one of our going on project we are looking for a Business Analyst with Knowledge in Financial Data Exchange - FDX /DDA API . Positions can be remote for deserving candidates.
Skills Needed
- Understanding of Financial products e.g. Banking products, investment products, brokerages etc.
- Knowledge on FDX / DDA API. Understanding of API data models as exposed by FI's and to create data mappings to the FDX standard.
- Understanding of oAuth 2.0, OIDC frameworks
- Ability to write test plans for end to end integration
- Good presentation and communication skills
If interested rush your resume with full contact details
Junior Analyst, Investor Communications - Data Management
Senior data analyst- job in Chicago, IL
Information
Hiring Manager:
Assistant Vice President
Department:
Investor Communications
The Investor Communications Group supports the Firm's capital raising efforts across various products, strengthening its relationship with investors and contributing to the overall growth of the Firm. The group is responsible for investor services and acts as the liaison between clients and senior management. The department is also responsible for investor onboarding and is the primary point of contact for investor reporting and ongoing account maintenance. The group collaborates closely with department leadership, business unit heads and the Business Development and Marketing Groups to develop and execute plans in line with business objectives.
Position Responsibilities
The Junior Analyst will join the Firm's growing Investor Communications (“IC”) Department which serves as a key point of contact to the Firm's investor base. This role requires a motivated individual with a proactive approach to working with other team members and departments, who has the ability to manage tight deadlines and brings impeccable attention to detail.
Responsibilities included, but not limited to:
Execution of the Data Management Team specific Service Level Agreements
Onboarding and maintenance of investor accounts, including collecting and analyzing banking and investor contact information
Contributing to process improvements and automation with respect to how data is managed in the CRM database
Contributing to critical Investor Communications projects
Corresponding with other back-office teams on daily and ad-hoc activity
Consistently meeting team metrics and shifting priorities as needed
Ensuring timely execution on team deliverables and ad-hoc requests
Maintaining a positive culture during times of high volumes
Participating in calls with internal and external stakeholders
Candidate Requirements
Qualifications & Experience:
Bachelor's degree required
Strong financial services internship experience preferred
Meticulous attention to detail and accuracy
Excellent organizational and prioritization skills
Ability to work in a fast-paced environment
Ability to build strong relationships with internal and external groups
Demonstrated ability to work well both independently and as part of a team
Proficient in MS Office products, specifically Word and Excel
Knowledge of Microsoft Dynamics is a strong plus
Enthusiastic about working in office and creating a Gold Standard hybrid work culture
Critical Competencies for Success
Our Gold Standards Model defines key behaviors and competencies across 4 dimensions: Leadership, Achieving Results, Personal Effectiveness and Thinking Critically. These behaviors and competencies drive our ability to win together.
Leadership: Role models in this area consistently focus on the right goals and priorities and continually develop themselves and others. Always team players, they influence and engage with others to contribute to a supportive and inclusive culture where all feel welcome.
Achieving Results: Role models in this area are high achievers who develop careful plans and deliver consistently and effectively. They hold themselves and others accountable for delivering high quality results, and they remove barriers to ensure others can contribute and grow.
Personal Effectiveness: Role models in this area build strong relationships, treat others with respect and communicate effectively. They are driven to exceed expectations and are adaptable to changing circumstances.
Thinking Critically: Role models in this area understand our business, rely on analytical reasoning and seek diverse perspectives to solve problems. They are forward thinking, anticipating issues and addressing them in advance.
The department-specific competencies define the knowledge, skills and abilities that are needed to successfully perform the functional or technical work of this role.
Industry Knowledge: Demonstrates an understanding of the Firm's position in the industry, including its complex structure and competitive advantage in the marketplace. Monitors industry trends and changes and recognizes their relevancy and implications.
Technical Communication and Documentation: Documents and communicates technical processes and procedures in area of specialty to stakeholders. Adapts the level of detail and specificity based on the needs of the intended audience.
Investor Data Governance: Follows appropriate policies and procedures to enter and manage investor data, including evaluating issues with investor data and taking appropriate steps to address them and communicating with others regarding investor data governance to ensure accuracy and integrity.
Investor Management: Handles or manages investor onboarding, reporting and inquiries. Understands how to prepare and check reports, gather subscription-related data from investors (e.g., legal documentation) and answer investor inquiries regarding onboarding, subscriptions and reports.
Tax and AML Regulatory Compliance: Complies with tax and AML laws and regulations related to due diligence, withholding and reporting. Stays informed of changes to tax law, regulations and legal cases to communicate impact to relevant internal and external stakeholders.
Innovative Mindset: Leverages a detailed, agile and creative mindset to master processes and responsibilities, as well as drive value-added enhancements, continuous process improvement and proactive learning through new technology, processes and people.
Compensation & Benefits
For Illinois Only: It is expected that the base salary range for this position will be $55,000 to $70,000. Actual salaries may vary based on factors such as skills, experiences and qualifications for the role. The total compensation package for this position may also include other elements and discretionary awards in addition to a full range of medical, financial and / or other benefits (including 401(k) eligibility and various paid time off benefits such as vacation, sick time and parental leave) dependent on the position offered. Details of participation in these benefit plans will be provided if an employee receives an offer of employment. If hired, the employee will be in an ‘at-will position' and the Firm reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time including for reasons related to individual performance, Firm or individual department / team performance and market factors.
Golub Capital is an Equal Opportunity Employer.
Due to the highly regulated nature of Golub Capital's business and because of the sensitivity of the information that all personnel have access to, Golub Capital performs extensive and thorough pre-hire screens to ensure that its personnel act with expected levels of integrity, professionalism and personal responsibility.
Data Integrity (SR AS)
Senior data analyst- job in Chicago, IL
Guggenheim Investments is seeking an organized and detail-oriented candidate to join its Data Integrity team. The Senior Associate will be part of a team which is responsible for the creation and stewardship of security data and analytics calculations for all of Guggenheim Investments. The role provides a unique opportunity to join a dynamic, evolving, and fast paced team and will involve being a subject matter expert working directly with Trading Desks, Portfolio Management, Compliance, Client Service and other Operations groups to ensure securities are set up timely and accurately in the trading systems and their data is maintained accurately.
As part of a team of experts on security level data for Guggenheim, the Senior Associate will respond to a range of inquiries from stakeholders across the firm while getting exposure to equities, Corporate Bonds, Munis, Gov't & Agency Bonds, ABS, RMBS, CMBS, Private Placements, and derivatives such as Swaps, Options and FX.
The Data Integrity Senior Associate position is within the Operations department based in the Chicago and New York office.
Responsibilities
Key Responsibilities
* Primary contact for security and issuer set-up and review.
* Manage security master data across the risk management system, the portfolio accounting system, the order management system, the option trading system, and the data warehouse.
* Daily review and clean-up of the data integrity suite of reports, including but not limited to: factor and coupon validation, new bonds, missing issuers, security ticker check, SEDOL check.
* Daily updates and recalculations of principal and income projections.
* Monthly Security Master reconciliation between the risk management system and the portfolio accounting system.
* Timely response to queries affecting both the risk management system and the accounting system.
* Provide support for portfolio managers and sector specialists ensuring accurate data, including fixed income analytics, sectoring, and analyst assignments.
* Update and review fixed income cash flows, ensuring that the resulting bond analytics are within reasonable expectations of the portfolio desk and trading group.
* Produce monthly external reporting .
Qualifications
Basic Qualifications
* Undergraduate degree, preferably in Finance or Business-related fields
* 5+ years of relevant work experience (asset management and/or middle office experience)
* Strong analytical skills and experience with data analysis
* Strong understanding of fixed income securities
* High attention to detail, organizational skills, and ability to manage multiple inquiries under tight deadlines
* Ability to lead projects to completion and troubleshoot/resolve complex issues
* High proficiency in Excel, and knowledge/use of the Microsoft Office suite
Preferred Qualifications
* Completion of the CFA Level 1 exam is a plus, but not required
* Experience using Blackrock Aladdin, Wall Street Office
* Thorough deep knowledge and understanding of fixed income securities, with emphasis on Bank Loans
* Ability to work in a team to create processes and influence change
* Demonstrated commitment to teamwork and client service
* Effective project management and communication skills
* Organized, detail oriented and extremely thorough with strong problem-solving skills and demonstrated ability to take initiative
Salary Range
Annual base salary between
$105,000.00-$115,000.00
The base salary range represents the low and high end of the anticipated base salary range for this position. Actual base salaries may vary depending on factors such as location and experience. The range listed reflects base salary only, and the total compensation package may include other components such as incentive compensation.
Auto-ApplyData Integrity Gift Analyst
Senior data analyst- job in Chicago, IL
Details Job Title DATA INTEGRITY ANALYST Position Number 8101645 Job Category University Staff Job Type Full-Time FLSA Status Exempt Campus Chicago-Water Tower Campus Department Name DEVELOPMENT & DONOR SERVICES Location Code DEVELOPMENT & DONOR SERVICES (03635A) Is this split and/or fully grant funded? No Duties and Responsibilities
Loyola University Chicago's Advancement division is seeking a detail-oriented team member committed to the highest quality of gift maintenance, management, and standards to join its team. In partnership with the Associate Director of Data Integrity: Gift Processing, and other members of the Advancement Operations and Campaign Planning team, the Gift Analyst is responsible for managing incoming donations, including the proper recording to the donor's record, storing gift documentation, and depositing and reconciling per University policies and procedures. They also confirm that any bio-demographic record updates received are recorded. This position is hybrid, with an expected regular presence in Loyola's Water Tower campus. Typical high-volume seasons are the weeks leading up to and following June 30 and December 31.
As part of a collaborative Data Integrity team and under the direction of the Associate Director of Data Integrity, the Gift Analyst will ensure that all gift data is up to date and accurate, that foundational structures are in place for fundraising appeals and events and serve as experts in the best practices of their field. This includes but is not limited to:
Essential duties and responsibilities include the following:
* Review, stage, and enter all donations to the University, including HSC (Health Sciences Campus). This includes processing checks (scanning checks to the University's bank), managing the payment lockbox, reviewing and scanning all documentation, processing payroll deductions, electronic fund transfers, wire transfers, gifts-in-kind, including gifts of securities, gift transactions from collection applications like iModules, Kindsight Portal/Connect, Graduway, and CVENT, gift revenue from events, and posting donations to the donor's record ensuring that proper credit is given to the donor(s) and entered in Loyola's CRM. May serve as a liaison between University Advancement, University Finance, and the University's broker.
* Ensure that daily reconciliation reports are completed for University Finance and prepare information for entry into Loyola's CRM. Work with University Accounting to facilitate intercompany transfer of funds as necessary.
* Evaluate all outright gifts, matching gifts, pledges, and pledge payments to determine appropriate donor credits, funds, appeals, and required documentation for completion and accuracy.
* Based on the agreed-upon schedule, run Gift Audit Reports to ensure that all gift entry standards have been maintained and reconciled. May perform regular audits of open pledges.
* Maintain donor pledge files, reviewing documentation to ensure that the correct donor, fund designation, pledge payment schedule, and other critical information has been accurately recorded and stored in an electronic location. Partner with Donor Relations to review pledge reminders.
* Assist in researching gift and pledge relation information.
* Monitor Pledge and Gift Processing Controls to ensure accuracy of input, review, and reconciliation of all donations following University policy and procedures.
* Provide customer service through shared Data Integrity email accounts and the Smartsheet task request system, including fulfilling the ad hoc gift and data requests. Reach out and return calls to donors as needed.
* Process Matching Gift Forms from donors as required.
* Prepare and deliver cash deposits to the Bursar's Office.
* Charge manual credit card transactions.
* Aid with producing accurate donor receipt correspondence according to policies and procedures as a collaborative member of the Data Integrity team.
* Utilize Loyola's CRM for data pertinent to fundraising on donors, prospects, volunteers, and staff, including demographic, biographical, financial, and philanthropic information.
* As needed, establish and maintain designation records and new appeal codes.
* Develop and maintain gift processing policies and procedures.
* Review/research all records that cannot be automatically created/updated by data upload sources; create/update records as appropriate.
* Assist with overseeing the maintenance of all constituent and organizational records in Loyola's CRM, including (but not limited to):
* Creating new records.
* Updating and maintaining biographical, demographic, and contact information.
* Updating and maintaining employment and employment-related information (e.g., matching gift relationships, business addresses, positions, and titles).
* Updating and maintaining personal relationship information (e.g., marital status and parent-child relationships).
* Researching unverified obituary notifications and updating constituent records with verified information.
* Proactively acquiring, updating, and maintaining constituents' engagement information (e.g., event attendance, participation in volunteer activities, membership on a Loyola advisory board, etc.).
* Assisting with high-volume periods and bulk updates.
* Run and review data audit reports, correcting/updating constituent data as necessary. Use publicly available and proprietary data tools to obtain the data needed to make the appropriate adjustments. These tools include AlumniFinder, Loyola's PeopleSoft student system, online publications, social media, and the internet.
* Perform database analysis, financial corrections, and adjustments.
* Review mail returned by the USPS - inactivating incorrect addresses and performing research to identify new/correct address information.
* Maintain existing and contribute to new procedural documentation.
* Use subject matter expertise to recommend and execute new data integrity audits.
* Create and maintain documentation about data updates (e.g., coding two people as married) and data audits (e.g., merging duplicate records).
* Assist the Associate Director, Gift Processing with project management, tracking progress, and estimating timelines and completion dates. Assist with making recommendations about Data Integrity's portfolio of data projects.
* Perform other duties as assigned.
Reasoning Ability
* Ability to interpret instructions in written and oral form and use logical thinking to solve practical problems.
* Demonstrated client service skills to understand how each action and decision impacts the team, the division, and the organization.
* Ability to work under pressure due to time and frequent requests from multiple sources with their own timelines and constraints and with all levels of administrative staff.
* Demonstrated project management skills with excellent organization skills and attention to detail.
Minimum Education and/or Work Experience
Bachelor's Degree with 3-5 years of related experience in database/records management, gift processing, accounting, finance, and/or advancement. Familiarity with non-profit advancement/fundraising or higher education preferred.
Qualifications
Minimum Education and/or Work Experience
* Bachelor's Degree with 3-5 years of related experience in database/records management, gift processing, accounting, finance, and/or advancement. Familiarity with non-profit advancement/fundraising or higher education preferred.
* At least 3 years of experience with data management or entry in a non-profit environment.
* Experience and references demonstrating scrupulous accuracy and attention to detail in data entry and information processing.
* Proven ability to prioritize, work independently, and meet expectations for goals and timelines.
* Ability to read, analyze, interpret, and follow departmental policies and procedures.
* Knowledge of gift receipt requirements and other regulatory requirements.
* Proven ability to work as a collaborative team member.
Language/Communication Skills
* Excellent spoken and written English language skills.
* Excellent interpersonal relationship-building and maintenance skills.
* Demonstrated ability to communicate detailed information clearly in written and oral form.
* Demonstrated ability to effectively present information and respond to questions from internal and external stakeholders.
Reasoning Ability
* Ability to interpret instructions in written and oral form and use logical thinking to solve practical problems.
* Demonstrated client service skills to understand how each action and decision impacts the team, the division, and the organization.
* Ability to work under pressure due to time and frequent requests from multiple sources with their own timelines and constraints and with all levels of administrative staff.
* Demonstrated project management skills with excellent organization skills and attention to detail.
* Ability to identify scenarios for data entry, choose the best path forward based on data request volume and type, source of information, and other competing factors, while still delivering a clean and accurate finished product regardless of path chosen.
Certificates/Credentials/Licenses
n/a
Computer Skills
* Experience utilizing fundraising databases; Kindsight ascend and Salesforce application experience strongly preferred.
* Experience importing, exporting, and integrating data from multiple systems (Salesforce Interims). Experience with iModules, TouchNet, Graduway, Portal, Cvent, DemandTools, or comparable tools preferred.
* Intermediate proficiency with Microsoft Office applications such as Excel and Word required. Advanced proficiency in Excel preferred.
* The person in this role will be trained to advanced proficiency in University systems (Loyola's Database, Data Loader, LOCUS, etc.).
Supervisory Responsibilities No Required operation of university owned vehicles No Does this position require direct animal or patient contact? No Physical Demands Repetitive Motions Working Conditions None Open Date 11/05/2025 Close Date Position Maximum Salary or Hourly Rate $70,000/ann Position Minimum Salary or Hourly Rate $65,000/ann Special Instructions to Applicants
As a Jesuit, Catholic institution of higher education, we seek candidates who will contribute to our strategic plan to deliver a Transformative Education in the Jesuit tradition. To learn more about Loyola University Chicago's mission, candidates should consult our website at ********************* For information about the university's focus on transformative education, they should consult our website at *****************************
About Loyola University Chicago
Founded in 1870, Loyola University Chicago is one of the nation's largest Jesuit, Catholic universities, recognized for its academic excellence, commitment to community engagement, and leadership in sustainability. A Carnegie R1 research institution, Loyola leverages its status as one of an elite group of universities with the highest level of research activity to advance knowledge that serves communities and creates global impact. With 15 schools, colleges, and institutes-including Business, Law, Medicine, Nursing, and Health Sciences-Loyola operates three primary campuses in the greater Chicago area and one in Rome, Italy, that provide students a transformative, globally connected learning experience. Consistently ranked among the nation's top universities by U.S. News & World Report, Loyola is a STARS Gold-rated institution that is ranked as one of the country's most sustainable campuses by The Princeton Review and has earned distinctions from AmeriCorps and the Carnegie Foundation for its longstanding record of service and community engagement. Guided by its Jesuit mission and commitment to caring for the whole person, Loyola educates ethical leaders who think critically, act with purpose, and strive to create a more just and sustainable world.
Loyola University Chicago strives to be an employer of choice by offering its staff and faculty a wide array of affordable, comprehensive, and competitive benefits. To view our benefits in detail, click here.
Loyola adheres to all applicable federal, state, and/or local civil rights laws and regulations prohibiting discrimination in private institutions of higher education. Please see the University's Nondiscrimination Policy.
Ab Initio ETL Architect
Senior data analyst- job in Chicago, IL
Ventures Unlimited is a service centric organization. Our success begins with our ability to apply our relationships, leverage technologies, and identify talent - often in combination - to an endless array of real-world customer needs
Role : Ab Initio ETL Architect
Location: Chicago, IL
Duration: Full Time Permanent
Job Description
:
Total Experience Required :
12+ years
Mandatory Technical Skills :
Strong knowledge in Ab Initio suite (GDE, BRE, EME, Express->IT etc)
Must have implementation knowledge of Ab Initio Metadata and BRE
Should be able to Define the strategy, roadmap, process, governance etc for Metadata driven development
Should have knowledge on integrating Metadata in the SDLC phases
Should have knowledge on Data Modeling, data lineage, Data quality best practices
Requirement analysis, estimation, scoping, Design, Review, performance tuning.
Define the strategy, roadmap, process, governance for Metadata driven development
POC's using Ab Initio EME, BRE
Provide architecture solutions for the large programs
Desirable Technical Skills :
Experience in Requirements Engineering, Solution Architecture, Design, Development and Deployment
A broad set of technical skills and knowledge across hardware, software, systems and solutions development and a across more than one technical domain.
Demonstrated experience in real world IT or other solutions environments including creating (on your own or with a team) a product or IT solution
Strong communication skills including representing your company in industry standards organizations or industry technical forums.
Strong technical team leadership, mentorship and collaboration.
Desirable Functional Skills :
Functional experience of retail healthcare industry
Qualifications
Ab Initio suite (GDE, BRE, EME)
Additional Information
Contact
"Rahul Kumar
" for more details at
************ Ext :157
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-ApplyCharles River Techno Functional Business Analyst
Senior data analyst- job in Chicago, IL
3MK Software Solutions is the leading software service soltions provider and IT Staffing Supplier company, outsourcing and complex implementation services for the business across different functional areas and technologies with a core focus on software development and web designing development and GIS Software solutions and services. Our team is our core strength, we have selected the most skilled and talented specialists from the IT industry, and we continuously invest in developing their capabilities. The core management has many years of experience and has successfully leaded complex projects for major corporate in the field of healthcare, communication, retail and finance. During the term of these projects, the team had needed to develop an advanced implementation methodology.
We need Charles River Techno Functional Business Analyst for Northern Trust client at Chicago location.
Only FTE employees for this position. No contractors are preferred. Need strong Charles river experienced person
No of positions -15
Type - FTE
Location - Chicago , IL
Job Description:
Charles River Business Analyst:
•Has extensive working experience on of Charles River Invest Management System especially in manager workbench, trading blotter, compliance, System admin and configuration.
•Has working experience in asset management and is aware of various lines of business involved, portfolio management, order execution and back office transactions.
•Managed user groups, profiles and access to different modules.
•Has worked with setup of batch components - batch import and export
•Aware of Installation and configuration of Charles River server and client software.
•Aware of CRD exposed Web Services and invoking them for configuration, execute orders or run compliance.
•Aware of customization of blotter buttons
•Create and manage CRD workflows for each business group.
•Support end user CRD client software and have working knowledge of Citrix. Support blotter customizations.
•Manage / configure FIX setup including adding/deleting brokers.
•Aware of UNIX navigation and shell scripting.
•Domain Requirements: asset management , portfolio and order management across all asset classes - Equities, FI, Derivatives , FX, settlement, program trading.
•Experience working, integrating with Liquidnet, FXAll, Bloomberg/ Reuters.
Preferred: Charles River Certification.
Years of Expr.: Charles River Development: 2 years
Desired Skills:
•Understanding business requirements and mapping them to system requirements specifications.
•Project status tracking, resource allocation and management,
•Conducting process and system studies and coordinating with team members for System Design & Integration, Application Maintenance, etc.
•Delivering and implementing project as scheduled and ensuring compliance to quality standards. Liaising with the onsite and offshore development and support teams
•Designing the entities and performing coding, data verification etc.
•Preparing TSD and assisting UAT, SFR resolution & Production Release
Additional Information
All your information will be kept confidential according to EEO guidelines.
Lead Analyst Corporate Strategy and Business Development
Senior data analyst- job in Chicago, IL
The Corporate Strategy and Business Development department works cross-functionally to analyze, contextualize, and recommend strategic choices for the enterprise. The team is responsible for developing strategies and driving execution of key partnership opportunities.
The team works with key business leaders to allocate the firm's resources and to identify new opportunities for inorganic or organic growth based on internal needs, the external environment, and the firm's strategic positioning.
The department facilitates meetings of the Executive Committee of CME's Board of Directors multiple times per year and guides discussion of key strategic topics with CME Group's Management Team.
Finally, the team is responsible for facilitating internal stakeholder understanding of enterprise strategy, and for promoting deeper strategic understanding and alignment throughout the organization.
The Lead Analyst Corporate Strategy will be a core member of the Corporate Strategy and Business Development team and will support major initiatives focused on (1) enterprise direction and communication, (2) market structure, innovation and commercialization of new products or services, (3) business unit strategies and key business development efforts, and (4) broader ecosystem research and strategy. They will be expected to take initiative, work independently, support cross-functional teams, and produce high-quality work. They will need to be poised and confident in their ability to work with a broad cross-section of the organization, including with senior leaders.
Principal Accountabilities:
* Support Corporate Strategy and Business Development teams with core analytics, written presentations, and creation and maintenance of key business documents, financial databases and materials.
* Participate in discrete cross-functional strategy initiatives to develop and advance business unit strategies, plans and performance.
* Take ownership of processes and develop project scopes, plans, communications, and presentations in concurrence with business unit leaders.
* Support the business unit leaders and teams in understanding competitive dynamics and strengthening business logic through research and analysis.
* Proactively develop relationships across the organization, from product heads to research analysts, in pursuit of advancing the business.
* Identify gaps in business and customer knowledge and work across the team and organization to address those gaps; Identify and propose options to act on opportunities (mergers & acquisition, joint ventures, commercial partnerships, etc.) through data gathering, financial modeling, and advancing commercial partnership discussions.
* Contribute to development of Corporate Strategy agenda for the company. Ensure alignment with key corporate strategic initiatives.
* Develop materials that enable broad discussion and contribute to understanding key opportunities and challenges for CME and advance key business cases for the enterprise.
* Support development of peers by sharing knowledge, best practices, and helping to grow their analytical and strategic skills.
Experiences and Skills:
* 6+ years experience in corporate strategy, management consulting, investment banking, product management, business development, or other similar positions is preferred
* Proven ability to conduct deep analysis and proactively identify key trends and patterns; financial modeling experience a plus
* Experience in financial services a plus
* Outstanding written and oral communication and presentation skills to executive audiences
* Experience building strong internal and external relationships and leveraging network and third-party resources to successfully deliver projects
* Strong experience with Microsoft Office (Word, PowerPoint, Excel), Google Workspace, Bloomberg, Gen AI, Capital IQ and business intelligence tools is preferred
* Self-starter with the ability to work/collaborate effectively within a team
Education:
* Bachelor's degree required
* Postgraduate degree in an analytical field or MBA from top business school a plus
#JR1 #hybrid
CME Group is committed to offering a competitive total rewards package for our employees that recognizes their contributions to the business and reflects our long-term investment in their future. The pay range for this role is $95,800-$159,600. Actual salary offered will be dependent on a wide array of factors including but not limited to: relevant experience, skills, education and comparison to internal employees (where relevant). Our compensation program also includes an annual target bonus opportunity for all employees, as well as the opportunity to become an owner in the company through our broad-based equity program. Through our benefits program, we strive to offer flexibility, value and choice. From comprehensive health coverage, to a retirement package that includes both a 401(k) and an active pension plan, to highly competitive education reimbursement provisions, paid time off and a mental health benefit, CME Group offers a holistic benefits package for our team and their dependents.
CME Group: Where Futures are Made
CME Group is the world's leading derivatives marketplace. But who we are goes deeper than that. Here, you can impact markets worldwide. Transform industries. And build a career by shaping tomorrow. We invest in your success and you own it - all while working alongside a team of leading experts who inspire you in ways big and small. Problem solvers, difference makers, trailblazers. Those are our people. And we're looking for more.
At CME Group, we embrace our employees' unique experiences and skills to ensure that everyone's perspectives are acknowledged and valued. As an equal-opportunity employer, we consider all potential employees without regard to any protected characteristic.
Important Notice: Recruitment fraud is on the rise, with scammers using misleading promises of job offers and interviews to solicit money and personal information from job seekers. CME Group adheres to established procedures designed to maintain trust, confidence and security throughout our recruitment process. Learn more here.