IT Business Systems Analyst
Senior data analyst- job in Elgin, IL
About us Rural King is America's Farm and Home Store, providing essentials to the communities we serve. With a wide array of necessities ranging from food and feed to farm and home products, Rural King serves over 130 locations across 13 states and is constantly expanding. Our annual sales exceed $2.5 Billion, and our heart beats in Mattoon, IL, home to our corporate office, distribution center, and flagship store.
One thing our customers appreciate is our unique shopping experience, complete with complimentary popcorn and coffee. It's just one way we show our appreciation for their support.
At Rural King, we value our associates and strive to create a positive, rewarding workplace. We offer growth opportunities, competitive benefits, and a people-first environment where dedicated individuals come together to serve rural communities passionately. Join us, and you'll find not just a job but a chance to grow professionally, contribute meaningfully, and make a difference in the lives of those we serve.
How we reward you
401(k) plan that provides a 100% match on the first 3% of your contributions and 50% of the next 2%
Healthcare plans to support your needs
Virtual doctor visits
Access to Centers of Excellence with Barnes Jewish Hospital and Mayo Clinic's Complex Care Program
15% Associate Discount
Dave Ramsey's SmartDollar Program
Associate Assistance Program
RK Cares Associate Hardship Program
24/7 Chaplaincy Services
Company paid YMCA Family Membership
What You'll do
The IT Business Systems Analyst supports Rural King's enterprise applications ecosystem-focusing on Oracle ERP and Merchandising platforms-to ensure seamless business operations across buying, inventory, finance, and store execution functions. This role acts as a key liaison between business stakeholders, IT, and external partners to translate operational needs into system solutions, improve business processes, and drive adoption of new functionality within Rural King's Oracle Retail suite.
Essential Duties and Responsibilities
Partner with Merchandising, Inventory, Finance, and Store Operations teams to understand business requirements and translate them into scalable system solutions within Oracle ERP and Merchandising modules (e.g., MFCS, SIOCS, ReSA, ReIM, CFIN).
Lead discussions on business process improvements, data flow optimization, and functional design to ensure alignment between business needs and Oracle capabilities.
Create and maintain clear documentation-functional designs, process flows, user guides, and training materials-for both technical and non-technical audiences.
Participate in and support all phases of the Software Development Life Cycle (SDLC), including requirements gathering, solution design, testing, deployment, and post-go-live support.
Conduct and coordinate User Acceptance Testing (UAT) and Quality Assurance (QA) to validate business processes and ensure successful implementation of new features or patches.
Troubleshoot, analyze, and resolve application issues across Oracle Retail integrations, working closely with AMS, Oracle Support, and internal development teams.
Support and enhance reporting needs by compiling and interpreting data for senior leadership, ensuring business insights are accurate and actionable.
Stay current on Oracle Retail updates, release notes, and emerging technologies to recommend new functionality and process improvements.
Collaborate with internal and external partners to ensure adherence to IT standards, governance, and change control procedures.
Provide training and end-user support to drive adoption and self-sufficiency across business groups.
Use discretion and independent judgment in daily decisions while maintaining confidentiality and professionalism.
Supervisory Responsibilities
No
Essential Qualiities for Success
Education & Experience:
Bachelor's degree in information technology, Business Administration, or related field, or equivalent combination of education and experience.
Minimum 5 years of experience supporting business applications within a retail or enterprise environment.
3+ years of hands-on experience with Oracle Retail or Oracle ERP Cloud applications (MFCS, SIOCS, ReSA, ReIM, CFIN, or related systems) strongly preferred.
Technical & Functional Skills:
Strong understanding of retail business processes-merchandising, inventory management, purchasing, pricing, and financial reconciliation.
Experience in application configuration, testing, and end-to-end process validation.
Proficient with Microsoft Excel (advanced formulas, pivot tables, data analysis) and Microsoft Office Suite.
Familiarity with SQL, XML, and data integration tools (AIF/BDI) a plus.
Soft Skills:
Excellent analytical and problem-solving abilities with keen attention to detail.
Strong interpersonal and communication skills for engaging cross-functional teams and external vendors.
Proven ability to manage competing priorities in a fast-paced environment.
Demonstrated integrity, professionalism, and confidentiality in all interactions.
PHYSICAL REQUIREMENTS
Must be able to sit or stand for prolonged periods of time.
Must be able to lift up to 15 pounds at times.
Must be able to access and navigate each department across facilities.
Must be able to verbally communicate effectively with others (in-person and via electronic devices).
Must have close visual acuity.
Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions.
The pay range for this position is $74,000 - $93,000 annualized and is bonus eligible. Exact compensation is determined by factors such as relevant geographic location, education, certifications, experience, job level, shift, and organizational needs. To learn more about our benefits, review here
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin or ancestry, sex, age, physical or mental disability, veteran or military status, genetic information, sexual orientation, marital status, or any other characteristic protected by law.
We use E-Verify to confirm the employment eligibility of all newly hired associates. To learn more about E-Verify, including your rights and responsibilities, please visit *********************
Senior 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.
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.
Salesforce Business Analyst
Senior data analyst- job in Deerfield, IL
About the Role
We are looking for a Salesforce Business Analyst who will partner closely with sales, service, and technical teams to design and implement scalable reporting, dashboards, and data models in Salesforce. You will translate business needs into actionable insights, ensure high‑quality data structures, and enhance operational visibility across the organization.
Responsibilities
Translate business requirements into scalable Salesforce reporting solutions, dashboards, and KPIs for Sales and Service teams.
Gather requirements from stakeholders, define user stories, and produce detailed functional specifications for reports, dashboards, and analytics.
Design, build, and maintain Salesforce reports, dashboards, and advanced analytics to track pipeline performance, opportunity trends, case volumes, SLAs, and customer satisfaction.
Configure and optimize Sales and Service Cloud objects, fields, validation rules, flows, and permission models to improve data quality for reporting.
Develop data models, implement data quality controls, and perform data cleansing initiatives.
Train and onboard end users on new or updated reports, dashboards, and data processes.
Collaborate with IT and analytics teams to integrate Salesforce data with external systems (e.g., Snowflake) to support enterprise‑wide reporting.
Create and maintain documentation, including data dictionaries, report catalogs, and governance standards.
Stay current with Salesforce releases and best practices; evaluate enhancements and drive continuous improvement in reporting capabilities.
Communicate complex technical concepts clearly to non‑technical stakeholders and support decision‑making through data insights.
Minimum Qualifications
3-5 years of experience as a Salesforce Business Analyst or similar role.
Hands‑on experience with Salesforce Sales Cloud and Service Cloud.
Proficiency in Salesforce reporting, dashboards, data modeling, and analytics.
Strong understanding of core Salesforce configuration (fields, objects, validation rules, flows, permissions).
Experience with data cleansing, data quality management, and documentation.
Strong communication, problem‑solving, and facilitation skills.
Preferred Qualifications
Experience with Snowflake, Tableau, and advanced Excel.
Familiarity with Apex, Lightning Web Components (LWC), and Salesforce integrations.
Experience working with managed and unmanaged packages.
Background in supporting cross‑functional data initiatives with IT or analytics teams.
Pay: ~ $55-$60/hr W2
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.
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
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.
Sr Epic Application Analyst
Senior data analyst- job in Chicago, IL
Type : Permanent Role
REMOTE ROLE
MUST BE Citizen or Green Card
Experience working in a hospital or other health care organization.
This position develops, builds, and modifies Epic applications. Writes documentation specifications, fact-finding and analyses.
results and proposes solutions or recommendations. Builds, configures and/or modifying applications using existing application
tools. This role performs complex analysis, design, development, testing and support services for Epic applications. Leads and
monitors midsize to large scale projects within multiple functional departments. Exemplifies the Rush mission, vision and values
and acts in accordance with Rush policies and procedures.
Responsibilities
•Leads and monitors midsize to large scale projects within multiple functional departments.
•Performs complex designs, implements, maintains, and provides ongoing optimization and support for Epic clinical applications.
•Performs workflow assessments, capture business needs, and analyze internal systems to determine functional requirements for
optimal utilization of Epic applications.
•Works within cross-functional team and with end-users to achieve application integration to meet clinical needs.
•Performs builds, upgrades, and system enhancements as needed.
•Supports applications throughout all phases of implementation.
•Delivers post-implementation training, support, troubleshooting, and maintenance.
•Configures vendor applications and products.
•Maintains system documentation and develops system specifications and procedures.
•Defines and documents user requirements.
•Applies project planning and project management methodologies.
•Coordinates and leads short duration projects; monitoring project process, progress and results.
•Develops test plans, prepares test data and performs system testing.
•Provides on-site user support during implementations.
•Takes on-call for system application support at scheduled times.
•Audits data entered by end users.
•Troubleshoots and tracks issues and problems.
•Applies systems development methodology to solve problems.
•Handles multiple assignments simultaneously.
•Other duties as assigned.
Other Information
Required Job Qualifications:
•Bachelor's degree.
•5 years of Epic application experience.
•An Associate degree and seven (7) years of Epic application experience will be accepted in lieu of a Bachelor's.
•Epic certification(s).
•Demonstrated ability to effectively utilize system tools to meet functionality needs of users including proficiency with information
systems technology such as Microsoft Office Products.
•Experienced planning and organizing day-to-day activities, effectively managing more than one task, and meeting established
deadlines.
•Experienced in leading projects, providing expert consultative guidance and direction on change initiatives, effectively dedicating
time across more than one project, and meeting established deadlines.
•Experience leading meetings between business stakeholders, technical resources, and third parties for business requirements and
technical solutions.
•Experienced working with a diverse, multi-disciplinary team, and interacting with all levels of the organization.
•Detail oriented, strong analytical, organizational, and problem-solving skills.
•Excellent oral and written communication skills with technical and clinical audiences.
•Ability to troubleshoot, research, and solve technically challenging problems involving integrated systems.
Preferred Job Qualifications:
•Experience working in a hospital or other health care organization.
Cybersecurity Lead Analyst
Senior data analyst- job in Chicago, IL
Immediate need for a talented Cybersecurity Lead Analyst . This is a 12 months contract opportunity with long-term potential and is located in Chicago, IL(Remote). Please review the job description below and contact me ASAP if you are interested.
Job ID:25-89141
Pay Range: $46 - $47/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key Responsibilities:
Ensures implementation of secure operating systems, networks and databases for the organization.
Performs complex risk assessments and executes tests of data processing system to ensure functioning of data processing activities and security measures.
Drafts plans to safeguard computer files against accidental or unauthorized modification, destruction, or disclosure and to meet emergency data processing needs.
Encrypts data transmissions and erect firewalls to conceal confidential information as it is being transmitted and to keep out tainted digital transfers.
Facilitates risk audits and assessments and provides recommendations for application design to ensure operating effectiveness.
Monitors analysis of system access logs, ensuring only permitted individuals have access to company information.
Reviews violations of computer security procedures and discusses procedures with violators to ensure violations are not repeated.
Trains users and promotes security awareness to ensure system security and to improve server and network efficiency.
Key Requirements and Technology Experience:
Key Skills; Microsoft Security Tools, Active Directory, Cybersecurity Operations, Investment management.
University (Degree) Preferred
3 Years Required; 5 Years Preferred.
Physical Requirements: Sedentary Work.
Lead the cybersecurity team, providing mentorship, guidance, and performance management.
Develop and execute the organization's cybersecurity strategy aligned with business goals.
Collaborate with IT leadership and stakeholders to assess risk and define security priorities.
Microsoft Security Operations
Administer and optimize Microsoft Defender for Endpoint, Identity, Cloud Apps, and Office 365.
Manage and monitor Microsoft Sentinel for threat detection, incident response, and log analytics.
Implement and maintain Microsoft Purview for data governance, compliance, and information protection.
Oversee Entra ID (Azure AD) identity and access management, including Conditional Access and Privileged Identity Management (PIM).
Conduct regular reviews of security configurations and policies across Microsoft 365 and Azure environments.
Conduct monthly Attack Simulations.
Lead threat hunting and incident response activities using Microsoft XDR and SIEM tools.
Develop and maintain playbooks for automated response in Sentinel and Defender.
Coordinate with internal teams and external partners during security incidents and investigations.
Governance, Risk & Compliance
Ensure compliance with industry standards (e.g., NIST, GDPR, LGPD, DORA, other local data privacy laws).
Conduct risk assessments and vulnerability scans; manage remediation efforts.
Maintain documentation for security policies, procedures, and audit readiness.
Promote security awareness across the organization through training and communication.
Stay current with emerging threats, vulnerabilities, and Microsoft security innovations.
Our client is a leading Financial Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here.
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.
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.
Sr. BI Analyst
Senior data analyst- job in Gurnee, IL
Our client is a fast-growing leader recognized by both consumers and industry professionals.
They foster a dynamic, collaborative culture where high performers thrive in a fast-paced, hands-on environment. Although the company has over 60 years of history, they are entering a powerful new chapter of expansion, innovation, and transformation. Their people are their greatest asset-driven, engaged, and motivated by purposeful work.
Our client is seeking a Sr. Business Intelligence Analyst & Data Infrastructure Developer to design, build, and maintain a unified data architecture within Microsoft Fabric to support enterprise-wide reporting and analytics. This role blends advanced data engineering, SQL development, and Power BI expertise to integrate multiple data sources into a single, trusted reporting layer. The ideal candidate will build ETL pipelines, optimize semantic models, and partner closely with finance and business stakeholders to deliver scalable, accurate, decision-driving insights.
What You Will Do:
Lead Data Architecture Initiatives
Design and implement a unified enterprise data model by consolidating seven existing semantic models into a single Microsoft Fabric-based architecture.
Analyze legacy datasets and define optimal integration, migration, and consolidation strategies.
Develop and manage facts, dimensions, measures, and metadata aligned to business needs.
Define partitioning, refresh strategies, and performance optimization approaches.
Maintain data lineage, data dictionaries, and metadata documentation.
ETL/ELT Development & Maintenance
Build, enhance, and troubleshoot ETL/ELT pipelines using SSIS and Microsoft Fabric Dataflows.
Determine when data should be materialized in the warehouse versus exposed through views.
SQL Development
Write, debug, and optimize complex SQL, including stored procedures, CTEs, unions, and dynamic SQL.
Maintain and evolve SQL views supporting downstream reporting, dashboards, and analytics.
Collaboration & Reporting
Partner with finance, operations, and executive teams to scale customized financial and operational reporting solutions.
Translate reporting requirements into scalable technical data models.
Facilitate discussions across business and technology teams to align on long-term data architecture strategy.
Semantic Model Management
Build, maintain, and optimize Power BI semantic models and datasets.
Deploy BI solutions via VS Code, Tabular Editor, and Azure DevOps pipelines.
Support Power BI paginated reports and advanced DAX calculations.
What You Will Bring:
5-7 years of experience in business intelligence, data architecture, and ETL/ELT development.
Strong SQL expertise (CTEs, stored procedures, dynamic SQL, query optimization).
Intermediate to advanced DAX skills for performance tuning and model optimization.
Experience integrating data from major ERP systems (Syspro experience is a plus).
Deep expertise with Power BI (certification preferred).
Familiarity with AI/ML concepts, including agent-based or predictive modeling.
Experience with Microsoft Fabric, Azure Data Services, or similar cloud data platforms.
Education & Qualifications
Bachelor's degree in Data Science, Analytics, IT, or a related field; finance or accounting knowledge is strongly preferred.
Master's or MBA is a plus.
Power BI certification preferred.
Microsoft Fabric certification preferred.
Proven ability to collaborate with senior finance and business leaders.
MMD Services Inc. is an equal opportunity employer. All applicants are considered for all positions without regard to race, religion, color, sex, gender, sexual orientation, pregnancy, age, national origin, ancestry, physical/mental disability, medical condition, military/veteran status, genetic information, marital status, ethnicity, alienage or any other protected classification, in accordance with applicable federal, state, and local laws.
Senior ABAP Development Lead
Senior data analyst- job in Chicago, IL
Relocation support is available for qualified candidates, with packages tailored to individual circumstances, including household status, number of vehicles, pets, and whether you rent or own your home.
About the Role
Our client is seeking an experienced SAP Development Lead to drive the design, ABAP development of a global SAP S/4HANA Private Cloud environment. This is a senior, hands-on technical leadership role at a growing U.S. organization. Ideal for someone who thrives on building scalable SAP solutions, driving secure system architecture, and collaborating cross-functionally with business and IT teams.
You'll lead development strategy and play a pivotal role in ensuring the stability and performance of mission-critical SAP applications.
Key Responsibilities
SAP Development
Lead end-to-end development of custom SAP solutions in S/4HANA Private Cloud.
Build applications using ABAP, ABAP RAP, OO ABAP, Smart Forms, and Adobe Forms.
Develop modern UI experiences with Fiori/UI5.
Create CDS Views, OData services, and RESTful APIs using ADT, BOPF, and BRF+.
Deliver WRICEF objects and performance tuning using Workbench, SAT, ST05, ST12.
Manage complex integrations via SAP CPI, IDOCs, BAPIs, RFCs, and flat files.
Collaborate across FI/CO, SD, MM, PP, PM, and QM functional areas for end-to-end solutions.
Oversee DevOps and transport management to ensure traceable, compliant deployments.
Manage 1 onshore ABAP developer and 1 offshore ABAP developer
Collaborate with offshore SAP Security team to support secure solution delivery
Required Qualifications
Bachelor's in Computer Science, Engineering, or related field.
8+ years SAP development experience (S/4HANA or ECC).
3+ years in a senior technical or team leadership capacity.
Expertise in ABAP, Fiori/UI5, ABAP RAP; CPI experience preferred.
Strong WRICEF development and CDS/OData expertise.
Hands-on in multiple SAP full lifecycle implementations.
Familiarity with Basis, infrastructure, and performance management.
Experience partnering with Security teams, and basic security knowledge, is a strong plus.
Strong communication and leadership skills.
Junior Data Analyst - Direct Lending
Senior data analyst- job in Chicago, IL
Information
Hiring Manager:
Associate Manager
Department:
DL - Data & Technology
Golub Capital is looking for a skilled Junior Data Analyst to assist in the review and maintenance of key client information for the Firm and provide support to end users with data quality initiatives.
Execute action plans to remediate data quality issues; this will include but is not limited to actions such as:
creating and editing / updating records
documenting business process and data flows
using reporting and data analytics tools to confirm root causes of data issues and potential prevention methods
working with multiple internal teams to troubleshoot and resolve data issues
Assist with entering and maintaining relevant information in applicable applications
Review and update information in multiple systems
Generate various reports from multiple systems
Actively participate in innovative projects to improve the data quality or master data management within the Firm's data ecosystem
Candidate Requirements
Qualifications & Experience:
Sophomore, Junior, Senior attending local university with a focus in Finance, Business or other related fields
Ability to work part-time with set hours between 9 AM to 5 PM
Strong working knowledge of Excel
Familiarity with Microsoft Office desktop and Office365 tools (e.g., Word, SharePoint)
Extreme attention to detail
Ability to take initiative and work independently, while demonstrating strong teamwork
Must be able to work in a fast paced environment, manage time and priorities under pressure and meet deadlines
COVID vaccinations required, subject to applicable local, state and federal law
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 great culture.
Achieving Results: Role models in this area are high achievers who develop careful plans and execute consistently and effectively. They hold themselves and others accountable for delivering high quality results.
Thinking Critically: Role models in this area understand our business, rely on analytical reasoning to define and solve problems and make decisions effectively. They are forward thinking, anticipating issues and addressing them in advance.
Personal Effectiveness: Role models in this area build strong relationships and communicate effectively. They are driven to exceed expectations and adaptable to changing circumstances.
The department-specific competencies define the knowledge, skills and abilities that are needed to successfully perform the functional or technical work of this role.
Deal Execution: Evaluates, structures and executes investment opportunities and transactions.
Relationship Management: Establishes, develops and manages internal and external relationships.
Portfolio Management: Actively monitors portfolio companies to identify risks and opportunities that may impact overall performance.
Risk Management: Demonstrates credit acumen by leveraging tools and analyses and interpreting due diligence findings to guide decisions while balancing risks and rewards.
Financial Analysis: Uses financial analyses to generate insights and support fact-based decision making.
Competitive Positioning: Demonstrates knowledge of the Firm's capabilities, the Firm's position in the industry, competitors' capabilities and end markets. Recognizes implications of knowledge on Firm's positioning.
Legal Documentation: Demonstrates knowledge of legal documentation, processes and procedures.
Compensation & Benefits
Compensation will be commensurate with experience. Golub Capital offers a full range of benefits which includes medical, dental, vision and 401(k).
Golub Capital is an Equal Opportunity Employer.
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-ApplyAb 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