Data Analyst
Data analyst job in Deerfield, IL
Our client is currently seeking a Data Analyst
Hybrid to the northern suburbs of Chicago
W2 Only
In this role, you'll evaluate usage, adoption, and performance of IIN systems, identify data mining opportunities, and integrate findings with key performance indicators. You'll collaborate with cross-functional teams to deliver dashboards, reports, and scorecards that inform strategy.
What You'll Do
Analyze usage, adoption, and efficacy of IIN systems.
Identify and execute data mining opportunities.
Integrate insights with traditional KPIs.
Provide analytical support for projects and stakeholders.
Develop and share dashboards, reports, and scorecards.
Ensure data accuracy, format, and availability.
What We're Looking For
Bachelor's degree in Statistics, Data Science, Mathematics, or related field.
Strong analytical skills and ability to interpret complex datasets.
Advanced Excel skills (pivot tables, VLOOKUP, Power Query, visualization).
Expertise in Tableau for dashboard design and optimization.
Hands-on experience with Snowflake and SQL for data warehousing and analysis.
Strong business acumen and ability to align data strategies with goals.
Excellent communication and collaboration skills.
Nice to Have
Experience with KPI reporting and BI tools.
Familiarity with advanced data visualization techniques.
Rate: $65-90/HR
IT Business Systems Analyst
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.
Data Scientist
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. and has supported over 20,000 healthcare professionals and team members with close to 1,500 health and wellness offices across 48 states in four distinct categories: dental care, urgent care, medical aesthetics, and animal health. Working in partnership with independent practice owners and clinicians, the team is united by a single purpose: to prove that healthcare can be better and smarter for everyone. TAG provides a comprehensive suite of centralized business support services that power the impact of five consumer-facing businesses: Aspen Dental, ClearChoice Dental Implant Centers, WellNow Urgent Care, Chapter Aesthetic Studio, and Lovet Pet Health Care. Each brand has access to a deep community of experts, tools and resources to grow their practices, and an unwavering commitment to delivering high-quality consumer healthcare experiences at scale.
As a reflection of our current needs and planned growth we are very pleased to offer a new opportunity to join our dedicated team as Data Scientist.
Join us as a Data Scientist and play a key role in shaping how patients access care across a growing network of brands including Aspen Dental, ClearChoice, WellNow, Chapter Aesthetic Studio, and Lovet. In this role, you won't just analyze data - you'll lead end-to-end initiatives that shape how we optimize revenue across offices, days, and even hours. From designing strategies, deploying solutions and building performance dashboards to partnering with data science on automation and collaborating with teams across Finance, Marketing, Product, Technology and Operations, you'll have a direct hand in driving measurable results.
This role is ideal for someone who excels at turning data into decisions, building repeatable processes, and uncovering insights that drive measurable improvements in revenue performance and patient access. You will lead initiatives across forecasting, scheduling optimization, demand modeling, capacity planning, and revenue strategy, while also shaping how analytics is delivered and scaled across the organization. If you're a builder who loves solving complex problems with data, operational logic, and automation, this opportunity is for you.
Essential Responsibilities:
Revenue Strategy & Optimization
Lead strategy development for optimizing revenue performance at the office, day, and hour level by leveraging forecasting, scheduling, and demand modeling - while balancing access for patients and operational efficiency.
Build analytical frameworks to support pricing, demand forecasting, scheduling, and access optimization.
Identify revenue opportunities through data-driven analysis of booking trends, cancellations, no-shows, and utilization.
Monitor and update demand and schedule availability through the analysis of historical and future booking trends, the pricing environment, industry capacity trends, competitive landscape, and other factors.
Analytics, Insights & Experimentation
Develop and maintain forecasting, demand models, dashboards, and scenario analyses.
Run experiments and structured tests to evaluate new operational and scheduling strategies.
Create clear, actionable insights that influence senior leaders and cross-functional partners.
Process Building & Automation
Map existing manual workflows and identify opportunities to automate recurring analyses or reporting.
Cross-Functional Leadership
Work closely with Operations, Finance, Product, Marketing, and Clinical teams to align strategies and execution.
Help shape and scale the function by building new playbooks, reports, and best practices.
Act as a subject matter expert in forecasting, demand modeling, and capacity optimization.
Qualifications (Skills-Based):
We welcome candidates with diverse academic and career pathways. You may have gained your skills through industry experience, coursework, certificates, or hands-on practice.
Experience/Education:
5+ years of experience in Revenue Management, Pricing, Operations Research, Supply/Demand Optimization (Airline, Travel, Healthcare, or multi-location service industries preferred).
Bachelor's degree in Business, Finance, Economics, Analytics, or Statistics required; Master's degree a plus.
Experience working alongside data science/engineering teams to automate and scale analytics processes.
Exceptional analytical, problem-solving, and communication skills - with the ability to influence senior stakeholders.
Detail-oriented, self-starter mindset with a passion for driving results.
Strong analytical and quantitative skills, with experience in forecasting, modeling, or optimization.
Strong technical proficiency in SQL and a modern BI platform (e.g., Tableau, Looker).
Familiarity with scripting (e.g., Python or R) or automation tools (e.g., DBT, Airflow) - not required, but helpful.
Additional Job Description:
Base Pay Range: $115,000 - $130,000, plus 10% annual bonus (Actual pay may vary based on experience, performance, and qualifications.)
A generous benefits package that includes paid time off, health, dental, vision, and 401(k) savings plan with match.
If you are an applicant residing in California, please view our privacy policy here: *********************************************************************************
Data Architect
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.
AI Data Strategy Internship
Data analyst job in Chicago, IL
Chicago Based, no relocation support; We are looking to fill this role ASAP
*This role is intended to be converted to a full-time position for the right candidate.
*No ChatGPT during interview
The AI Data Strategy Intern will play a key role in advancing data-driven decision-making processes while contributing to the development of AI models and supporting and enhancing the organization's AI environment. Reporting to the Director of Data Strategy, the intern will work with diverse datasets, explore their sources, and utilize the Datawarehouse for data extraction, transformation, and analysis. This role offers an excellent opportunity to gain hands-on experience in AI and data analytics while supporting the mission to strengthen faith communities and make a meaningful impact.
Essential Functions & Job Performance Criteria
Analyze donor data to uncover insights and patterns.
Utilize SQL to cleanse, transform, and extract donor information.
Assist in developing and maintaining fundraising performance reports using Power BI.
Contribute to the development, maintenance, and optimization of AI models to support predictive fundraising outcomes and other organizational initiatives.
Support and enhance the organization's AI environment, ensuring its effective use in analytics and decision-making.
Perform data management tasks such as deduplication, migration, and addressing data integrity issues.
Adhere to security standards and protocols in handling donor information.
Troubleshoot and resolve data-related challenges effectively.
Identify opportunities for process enhancement and efficiency within fundraising operations.
Assist with other duties as needed to support fundraising and AI-related initiatives.
Qualifications
Pursuing or holding a bachelor's degree in Data Science, Computer Science, or Engineering
Proficiency in data structures and SQL, with strong data manipulation skills.
Familiarity with data analytics concepts and AI/ML fundamentals.
Interest in AI development and its applications.
Strong problem-solving skills with a technical mindset.
Ability to communicate analysis results to both technical and non-technical audiences.
Demonstrates a growth mindset and a positive attitude.
Interest in working with data for performance measurement, decision-making, and AI applications.
Ability to collaborate effectively in a team-oriented, fast-paced environment at our downtown Chicago location.
Strong organizational and prioritization skills.
Capacity to work independently while maintaining open communication.
Self-motivated with excellent organizational abilities.
Demonstrates personal integrity, credibility, and a dedication to the organization's mission.
Appreciation for and understanding of the teachings and traditions of the Roman Catholic Church.
A passion for your field and a sense of humor.
Full time position but part time optional if need be (students only)
Data Scientist
Data analyst job in Chicago, IL
Minimum Qualifications:
● 5+ years of experience leading data science projects that have a direct impact on a company's
objectives or PhD degree in quantitative fields such as Statistics, Data Science, Computer Science
with 3+ years of experience
● 5+ years of experience utilizing data mining techniques, ML models to assist business decision
making. Hands-on experience with deep learning frameworks , LLMs, GenAI tools, and NLP
techniques.
● Deep expertise in statistical methods and machine learning concepts, with the ability to mentor
team members on methodologies, model tuning, and evaluation techniques.
● 2+ years hands-on experience with deep learning frameworks, LLMs, GenAI tools, and NLP
techniques.
● 5+ years of experience using Python to process large, diverse datasets, and develop and deploy
predictive models in cloud-based environments and other computing platforms.
● 5+ years of experience in SQL and cloud-hosted data platforms (Google Cloud Platform, AWS,
etc.).
● Demonstrated ability to assist business decision-making through data mining and machine
learning.
● Strong communication skills to collaborate effectively with business stakeholders. Must be able
to interact cross-functionally and drive both business and technical discussions.
● Ability to translate complex business problems into actionable project plans and solve
Eagle Performance Business Analyst
Data analyst job in Chicago, IL
Immediate need for a talented Eagle Performance Business Analyst. This is a 12+ Months Contract opportunity with long-term potential and is located in Chicago IL (Hybrid). Please review the job description below and contact me ASAP if you are interested.
Job ID:25-95831
Pay Range: $86.20 - $100.94/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:
Nuveen Operational Technology Team is looking for a senior BA / BSA having deep knowledge in Investment Performance and GIPS measurement and reporting using Eagle STAR and Eagle Performance module as a tool.
Candidate should be able to work on both Project related and BAU specific enhancements as they may arise at time to time.
Candidate should be able to manage and prioritizing the product backlog that includes the epics, features, and user stories, translating product managers' strategies to development tasks, and learning the customers' and market's requirements.
Communication with the customers, partners, and the Developer. Updating the Product Backlog regularly for the team meetings.
Key Requirements and Technology Experience:
Skills-Business Analysis, Investment Management, Asset Management, Fixed Income and Mutual Funds
10+ Years of progressive work experience in the investment management space
Knowledge across front, middle and back-office solutions focusing investment / asset management
Good knowledge across investment operational process across accounting, trade settlement, corp. actions, collateral management etc.
Candidate with deep knowledge across Fixed Income, Equity and Derivatives performance measurement is a must.
Good working knowledge understanding on Eagle data enrichment, perf.calc construction and Eagle data mart modules
Good working knowledge on identifying and resolving performance returns issues
Strong investment data knowledge across EQ, FI, Derivatives and alternate assets
Strong knowledge on operational process including Mutual Funds, CITs, ETFs and Separately Managed Accounts
Strong working knowledge in Eagle suit of products (Accounting, Pricing, Investment Performance and Data Management)
Ability to review Current Processes of Business Users and identify opportunities or Strategies to improve business efficiency while ensuring maximum Customer Satisfaction with proper negotiation and building good relationship with all key stakeholders involved.
Prepare Functional Requirement Documents, BRDs , Perform Impact and Gap analysis with proper formal documentation.
Identify and communicate risks during analysis phase and raise flags in advance.
Own (Lead) / Contribute (Member) to the end to end analysis tasks like scoping, estimation, planning, work allocation, resource management, progress tracking & status reporting, management reporting, UAT support, Production Deployment etc.
Facilitate regular communication with IT and business partners using various methods to monitor progress toward project goals / milestones, task status, and identify / address issues.
Strong understanding towards data integration, meta data management, data quality and ability to run SQL queries to perform data analysis are must to have
Strong communication and written skills are required
Working in a fast paced and agile environment is a must
Qualification: Graduation in Computer Engineering or related subjects. Post Graduation or Specialization in Finance or Financial Services will be an added advantage.
10 to 11 years of relevant work experience (Team Members / Lead/Manager)
Our client is a leading Insurance 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, color, 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.
Charles River Business Analyst
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
Senior Analyst, Data and Insights
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
AI Analyst
Data analyst job in Chicago, IL
Jenner & Block LLP is a law firm with a fearless reputation and global reach, high-level problem solvers in litigation, government controversies, investigations, regulatory challenges, and complex corporate transactions. With offices in Century City, Chicago, London, Los Angeles, New York, San Francisco, and Washington, DC, the firm represents a wide range of clients, counseling Fortune 100 companies, large privately held corporations, major nonprofits, top universities, private equity investors, and Native American tribes. Consistently recognized as a firm that stands up for its values with its commitment to justice and community service, Jenner has been named the No. 1 pro bono firm 13 times in the United States by The American Lawyer.
POSITION SUMMARY
We are seeking a dynamic AI Analyst to serve as a critical bridge between technology and legal practice. This role combines technical expertise with exceptional communication skills to drive AI adoption, provide hands-on user support, and assist in evaluating AI solutions across the firm. Reporting to the AI Portfolio Manager, the AI Analyst will be the frontline resource for lawyers and staff, helping them responsibly maximize the value of AI platforms through training, prompt engineering guidance, and troubleshooting. The successful candidate will partner with cross-functional teams to enhance system functionality, support vendor evaluations, and contribute to the firm's AI governance framework.
ESSENTIAL JOB FUNCTIONS
AI Adoption and User Support
Guide users on effective use of AI tools and prompting techniques, ensuring adherence to the firm's AI policy and other AI best practices
Provide hands-on user support and issue resolution for AI systems; troubleshoot data and application issues with end users, fully analyze impact, determine resolution strategies, fully test and reconcile resolutions, and assist in implementation
Develop and maintain documentation, training materials, knowledge-sharing resources, and prompt templates for AI system usage on the firm's intranet
Technical Administration and Configuration
Perform administrative and configuration support for the firm's custom-built AI tools
Work with the AI Portfolio Manager, end users, consultants, and project managers to understand business processes and requirements; identify gaps; communicate and define requirements for enhancements to technical solutions
Assist in development of process changes or new technical solutions to satisfy business needs for projects and daily operations
Recommend, implement, and test enhancements or process changes to optimize system performance and user experience
Vendor Evaluation and Implementation Support
Assist in evaluating use cases for custom builds versus commercial solutions and participate in vendor demonstrations
Coordinate with Information Security for Vendor Risk Assessments and partner with Procurement during Master Service Agreement negotiations to ensure appropriate AI safety and governance provisions
AI Governance and Strategy Support
Partner with stakeholders to identify opportunities for AI adoption and provide guidance on best practices for system use
Contribute to developing the firm's AI governance framework, creating evaluation criteria for vendors, and monitoring compliance with AI policies
Stay current with industry trends in generative AI, prompt engineering, and enterprise AI administration
QUALIFICATIONS AND REQUIREMENTS
2-4 years of experience in technical support, business analysis, or technology consulting
Exceptional communication skills with ability to bridge technical and non-technical audiences
Experience providing user training, creating documentation, or delivering technical presentations
Strong writing skills for creating clear, user-friendly materials
Understanding of prompt engineering principles and generative AI best practices
Familiarity with help desk operations and troubleshooting methodologies
Strong analytical and problem-solving capabilities with attention to detail
Patient, service-oriented approach with ability to support users under pressure
Bachelor's degree in Computer Science, Information Technology, Business, Communications, or related field
PREFERRED QUALIFICATIONS
Experience in the legal industry or professional services environment
Familiarity with AI/ML technologies, large language models, or enterprise AI platforms
Background in change management or technology adoption initiatives
Experience with vendor evaluation processes and understanding of information security practices
Knowledge of SDLC methodologies and experience with enterprise software administration
Disclaimer
Additional Duties
This job description is intended to provide a general overview of the primary duties and responsibilities for the position. It is not an exhaustive list of all tasks or responsibilities that may be assigned. The role may include additional duties, specialized projects, and other tasks as required. The firm reserves the right to modify or adjust the responsibilities to meet business needs.
Physical Requirements
Candidates must be able to meet the physical demands of the position, including the ability to commute to the office as required on designated in-office days based on the position. The firm is committed to providing reasonable accommodations in accordance with the Americans with Disabilities Act (ADA) for qualified individuals with disabilities.
EEO Statement
Jenner & Block LLP is an equal opportunity employer. Recruitment and employment decisions are not made on the basis of an individual's race, color, creed, religion, national origin, ancestry, citizenship status, age, non-disqualifying physical or mental disability or medical condition, genetic information, sexual orientation, sex, gender identity and/or expression, pregnancy, childbirth, breastfeeding or related medical conditions, arrest record, matriculation, personal appearance, political affiliation, marital, parental, veteran, military, or order of protection status, or any other protected status or that of their relatives, friends, or associates.
Jenner & Block is proud to offer a competitive total rewards package, including comprehensive health & well-being benefits and 401k profit sharing. The anticipated pay range for this role is $100,000-$123,000. The actual offered rate for this position will be determined based on several factors, including qualifications and experience, geographic location, education, external market data, and consideration of internal equity.
Senior Data Architect
Data analyst job in Oak Brook, IL
We are seeking a highly skilled and strategic Senior Data Solution Architect to join our IT Enterprise Data Warehouse team. This role is responsible for designing and implementing scalable, secure, and high-performing data solutions that bridge business needs with technical execution. Design solutions for provisioning data to our cloud data platform using ingestion, transformation, and semantic layer techniques. Additionally, this position provides technical thought leadership and guidance to ensure that data platforms and pipelines effectively support ODS, analytics, reporting, and AI initiatives across the organization.
Key Responsibilities:
Architecture & Design:
Design end-to-end data architecture solutions including operational data stores, data warehouses, and real-time data pipelines.
Define standards and best practices for data modeling, integration, and governance.
Evaluate and recommend tools, platforms, and frameworks for data management and analytics.
Collaboration & Leadership:
Partner with business stakeholders, data engineers, data analysts, and other IT teams to translate business requirements into technical solutions.
Lead architecture reviews and provide technical guidance to development teams.
Advocate for data quality, security, and compliance across all data initiatives.
Implementation & Optimization
Oversee the implementation of data solutions, ensuring scalability, performance, and reliability.
Optimize data workflows and storage strategies for cost and performance efficiency.
Monitor and troubleshoot data systems, ensuring high availability and integrity.
Required Qualifications:
Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or related field.
7+ years of experience in data architecture, data engineering, or related roles.
Strong expertise in cloud platforms (e.g., Azure, AWS, GCP) and modern data stack tools (e.g., Snowflake, Databricks).
Proficiency in SQL, Python, and data modeling techniques (e.g. Data Vault 2.0)
Experience with ETL/ELT tools, APIs, and real-time streaming technologies (e.g., dbt, Coalesce, SSIS, Datastage, Kafka, Spark).
Familiarity with data governance, security, and compliance frameworks
Preferred Qualifications:
Certifications in cloud architecture or data engineering (e.g., SnowPro Advanced: Architect).
Strong communication and stakeholder management skills.
Why Join Us?
Work on cutting-edge data platforms and technologies.
Collaborate with cross-functional teams to drive data-driven decision-making.
Be part of a culture that values innovation, continuous learning, and impact.
** This is a full-time, W2 position with Hub Group - We are NOT able to provide sponsorship at this time **
Salary: $135,000 - $175,000/year base salary
+ bonus eligibility
This is an estimated range based on the circumstances at the time of posting, however, may change based on a combination of factors, including but not limited to skills, experience, education, market factors, geographical location, budget, and demand
Benefits
We offer a comprehensive benefits plan including:
Medical
Dental
Vision
Flexible Spending Account (FSA)
Employee Assistance Program (EAP)
Life & AD&D Insurance
Disability
Paid Time Off
Paid Holidays
BEWARE OF FRAUD!
Hub Group has become aware of online recruiting related scams in which individuals who are not affiliated with or authorized by Hub Group are using Hub Group's name in fraudulent emails, job postings, or social media messages. In light of these scams, please bear the following in mind
Hub Group will never solicit money or credit card information in connection with a Hub Group job application.
Hub Group does not communicate with candidates via online chatrooms such as Signal or Discord using email accounts such as Gmail or Hotmail.
Hub Group job postings are posted on our career site: ********************************
About Us
Hub Group is the premier, customer-centric supply chain company offering comprehensive transportation and logistics management solutions. Keeping our customers' needs in focus, Hub Group designs, continually optimizes and applies industry-leading technology to our customers' supply chains for better service, greater efficiency and total visibility. As an award-winning, publicly traded company (NASDAQ: HUBG) with $4 billion in revenue, our 6,000 employees and drivers across the globe are always in pursuit of "The Way Ahead" - a commitment to service, integrity and innovation. We believe the way you do something is just as important as what you do. For more information, visit ****************
Data Architect
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.
Technical Solutions Analyst
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.
Data Engineer
Data analyst job in Chicago, IL
Scaylor helps mid-market and enterprise companies make sense of their data. Most teams past $20M ARR are stuck with fragmented systems, old databases, and hundreds of spreadsheets that never quite line up. We build the pipelines that clean, normalize, and connect that data so it can actually be used.
Our platform handles everything from parsing financial models and reports to mapping tables across legacy databases and modern APIs. The goal is simple: give companies a single source of truth they can trust.
We're a small team of four - one backend engineer, one frontend engineer, and 2 founders. We're looking for our fifth teammate to help us scale the engine behind it all.
⸻
The Role
You'll work across data engineering and full-stack development, helping us build reliable data infrastructure that powers real workflows. You'll touch everything from ingestion and transformation pipelines to the APIs and dashboards that surface insights to clients.
You'll work directly with the founding team and help make technical decisions that define the next version of Scaylor's core platform.
⸻
What You'll Work On
• Build data pipelines that extract, clean, and standardize information from Excel files, PDFs, APIs, and legacy databases
• Design schemas and transformation logic for structured and semi-structured data
• Develop and maintain backend APIs (Python/FastAPI or Node/Express) for data access and analytics
• Help connect backend services to our frontend dashboards (React, Node.js, or similar)
• Set up and maintain AWS infrastructure (Lambda, S3, ECS, CloudFormation)
• Collaborate with clients to understand their data problems and design workflows that fix them
⸻
You'd Be Great Here If You
• Have 3-6 years of experience in data engineering, backend, or full-stack roles
• Write clean, maintainable code in Python + JS
• Understand ETL, data normalization, and schema mapping
• Have experience with SQL and working with legacy databases or systems
• Are comfortable managing cloud services and debugging data pipelines
• Enjoy solving messy data problems and care about building things that last
⸻
Nice to Have
• Familiarity with GCP or SQL databases
• Understanding of enterprise data flows (ERP, CRM, or financial systems)
• Experience building and deploying containers (Docker, GitHub Actions, CI/CD)
• Interest in lightweight ML or LLM-assisted data transformation
⸻
Why Join Scaylor
• Be one of the first five team members shaping the product and the company
• Work directly with the founder and help define Scaylor's technical direction
• Build infrastructure that solves real problems for real companies
• Earn meaningful equity and have a say in how the company grows
⸻
Compensation
• $130k - $150k with a raise based on set revenue triggers
• .4% equity
• Relocation to Chicago, IL required
Data Engineer
Data analyst job in Itasca, IL
Primary Location: Itasca, IL Hybrid in Chicago's Northwest Suburbs
2 Days In-Office, 3 Days WFH
TYPE: Direct Hire / Permanent Role
MUST BE Citizen and Green Card
The Data Engineer will be responsible for designing, developing, and maintaining scalable data pipelines and integrations that support data analytics and business intelligence across the organization. This role is essential to ensuring high-quality data delivery, optimizing performance, and enabling effective decision-making through reliable data solutions.
What You Bring to the Role (Ideal Experience)
Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
5+ years of experience as a Data Engineer.
3+ years of experience with the following:
Building and supporting data lakehouse architectures using Delta Lake and change data feeds.
Working with PySpark and Python, with strong Object-Oriented Programming (OOP) experience to extend existing frameworks.
Designing data warehouse table architecture such as star schema or Kimball method.
Writing and maintaining versioned Python wheel packages to manage dependencies and distribute code.
Creating and managing CI/CD pipelines, especially using Azure DevOps for Microsoft Fabric-related assets.
Experience establishing scalable and maintainable data integrations and pipelines in Databricks environments.
Nice to Have's
Hands-on experience implementing data solutions using Microsoft Fabric.
Experience with machine learning/ML and data science tools.
Knowledge of data governance and security best practices.
Experience in a larger IT environment with 3,000+ users and multiple domains.
Current industry certifications from Microsoft cloud/data platforms or equivalent certifications. One or more of the following is preferred:
Microsoft Certified: Fabric Data Engineer Associate
Microsoft Certified: Azure Data Scientist Associate
Microsoft Certified: Azure Data Fundamentals
Google Professional Data Engineer
Certified Data Management Professional (CDMP)
IBM Certified Data Architect - Big Data
What You'll Do (Skills Used in this Position)
Design and develop scalable data pipelines to collect, process, and store large volumes of structured and unstructured data.
Extend and enhance existing OOP-based frameworks developed in Python and PySpark.
Partner with data scientists and analysts to define requirements and design robust data analytics solutions.
Ensure data quality and integrity through data cleansing, validation, and automated testing procedures.
Develop and maintain technical documentation, including requirements, design specifications, and test plans.
Implement and manage data integrations from multiple internal and external sources.
Optimize data workflows to improve performance, reliability, and reduce cloud consumption.
Monitor, troubleshoot, and resolve data pipeline issues to ensure consistent data delivery.
Establish and manage CI/CD pipelines and release processes, particularly using Azure DevOps for Microsoft Fabric.
Provide technical leadership and coordination for global development and support teams.
Participate in creating a safe and healthy workplace by adhering to organizational safety protocols.
Support additional projects and initiatives as assigned by management.
Sr. Data Engineer - PERM - MUST BE LOCAL
Data analyst job in Naperville, IL
Resource 1 is in need of a Sr. Data Engineer for a full-time/ permanent position with our client in Naperville, IL. Candidate must be
local to Illinois
because of future hybrid onsite in Naperville expected. Our client is an employee-owned company with excellent benefits, growth opportunities and profit-sharing bonus.
This position is focused on building modern data pipelines, integrations and back-end data solutions. Selected individual will work within cross-functional Agile teams, collaborating with product owners, business analysts and other engineers to design and deliver data solutions that power business insights and AI products.
Responsibilities:
Design and develop scalable data pipelines for ingestion, transformation and integration using AWS services.
Pull data from PostgreSQL and SQL Server to migrate to AWS.
Create and modify jobs in AWS and modify logic in SQL Server.
Create SQL queries, stored procedures and functions in PostgreSQL and RedShift.
Provide input on data modeling and schema design as needed.
Manage infrastructure through infrastructure-as-code templates (Serverless Framework), supporting new data products and services in AWS.
Support inbound/ outbound data flows, including APIs, S3 replication and secured data.
Assist with data visualization/ reporting as needed.
Follow an Agile development methodology, with regular workshops and standup meetings, working in two-week sprints.
Qualifications:
5+ years of data engineering experience.
Experience with AWS and its associated array of offerings (Glue, Redshift, Athena, S3, Lambda, Spectrum).
Strong experience with SQL, Python and PySpark.
A background in supply chain, logistics or distribution would be a plus.
Experience with Power BI is a plus.
Senior Data Engineer
Data analyst job in Chicago, IL
requires visa independent candidates.
Note: (OPT, CPT, H1B holders will not work at this time)
Design, develop, and maintain scalable ETL pipelines using AWSGlue
Collaborate with data engineers and analysts to understand data requirements
Build and manage data extraction, transformation, and loading processes
Optimize and troubleshoot existing Glue jobs and workflows
Ensure data quality, integrity, and security throughout the ETL process
Integrate AWS Glue with other AWS services like S3, Lambda, Redshift, and Step Functions
Maintain documentation of data workflows and processes
Stay updated with the latest AWS tools and best practices
Required Skills
Strong hands-on experience with AWS Glue, PySpark, and Python
Proficiency in SQL and working with structured/unstructured data (JSON, CSV, Parquet)
Experience with data warehousing concepts and tools
Familiarity with CI/CD pipelines, Terraform, and scripting (PowerShell, Bash)
Solid understanding of data modeling, data integration, and data management
Exposure to AWS Batch, Step Functions, and Data Catalogs
Application Analyst
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.
Data Engineer
Data analyst job in Chicago, IL
The Data Engineer will design, build, and optimize the data pipelines and models that support the firm's evolving research, analytics, and systematic portfolio construction environment. This role is central to enabling data-driven investment processes, including quantitative research, AI/ML capabilities, and front-office automation.
Candidates must have deep expertise with Snowflake, strong SQL skills, and experience integrating diverse datasets used across investment organizations. The role is highly collaborative and requires comfort working in an iterative, fast-moving environment where data needs evolve rapidly based on stakeholder input.
Responsibilities
Design, build, and enhance ETL/ELT pipelines in Snowflake, ensuring high performance, reliability, and scalability.
Integrate internal and external datasets, including pricing, research content, economic releases, market data, and security reference data.
Support real-time or near-real-time data flows where needed (e.g., pricing, indicative quotes, market-sensitive inputs).
Collaborate closely with Product Leads, Quant Developers, and UI/UX teams to ensure data structures meet the requirements of research workflows, analytical models, and user-facing applications.
Partner with front-office stakeholders to rapidly iterate on evolving analytical and data needs.
Implement data validation, monitoring, and quality frameworks to ensure accuracy and reliability across critical datasets.
Translate prototype pipelines into production-ready workflows with appropriate documentation, standards, and controls.
Contribute to data modeling standards, metadata frameworks, and data governance practices across the platform.
Requirements
10+ years of data engineering experience within investment management, financial technology, or similar data-intensive environments.
Expert-level SQL, including complex queries, schema design, and performance optimization.
Deep hands-on experience with Snowflake, including advanced features such as tasks, streams, performance tuning, and secure data sharing.
Strong Python capabilities for ETL/ELT development, data processing, and workflow automation.
Experience integrating APIs and working with structured, semi-structured, and unstructured datasets.
Familiarity with NLP or AI/ML-oriented datasets (e.g., textual research content, PDFs) is a plus.
Experience with Domino or willingness to work within a Domino-based model environment.
Working knowledge of investment data structures (holdings, benchmarks, pricing, exposures) is highly preferred.
Ability to thrive in a rapid prototyping environment with evolving requirements and close partnership with front-office teams.
Sr. BI Analyst
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.