Dunn Solutions Group Logo

Dunn Solutions Group

BI ETL Consultant

Posted 3 Months Ago
Be an Early Applicant
In-Office
Skokie, IL, USA
Junior
In-Office
Skokie, IL, USA
Junior
Design, develop, test and document ETL processes and ensure data accuracy and integrity. Build data marts/star schemas using Kimball best practices. Perform hands‑on ETL development and advanced SQL work. Collaborate on analysis, coding, and testing; apply big data and NoSQL knowledge as needed.
The summary above was generated by AI
Company Description

Dunn Solutions Group is a full-service information technology consulting firm. We bring exceptional strategic experience, design skills and technology expertise to every project, plus complementary capabilities in client education.
 Focused on the business intelligence, application development and web/portal spaces, Dunn Solutions Group delivers services worldwide through offices in Chicago, Minneapolis, Raleigh, St. Louis, and Bangalore, India.
 We work closely with our software vendor partners including SAP, Liferay, Microsoft, Informatica and others to deliver solutions to our clients.
 Our IT professionals and business experts bridge the gap between business needs and technical solutions. Over the years, we have cultivated our experience and knowledge in a large number of industries and technologies in order to provide our customers with the most valuable solutions possible.
Specialties
Business Intelligence, Custom Application Development, Mobile Applications, Data Warehousing, Portals, E-Commerce
Website
http://www.dunnsolutions.com

Job Description

Experience
    1- 3 years of experience
Technical Skills
    Ensure accuracy and integrity of ETL; analysis, design, coding, testing and documentation
    Hands-on ETL developer (in one or more tools)
    Hands-on experience with designing data marts / star schemas following Kimball best practices
    Deep technical knowledge and hands-on experience with SQL
    Computer Science degree
Pluses
    Experience with SAP Data Services or Informatica or SSIS (or any combination)
    Experience with Talend or Pentaho
    Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks)
    Experience with NoSQL databases
    IOT (Internet of Things)

Qualifications

 Experience with SAP Data Services or Informatica or SSIS (or any combination)
    Experience with Talend or Pentaho
    Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks)
    Experience with NoSQL databases
    IOT (Internet of Things)

Additional Information

All your information will be kept confidential according to EEO guidelines.

HQ

Dunn Solutions Group Skokie, Illinois, USA Office

5550 W Touhy Ave, Suite 400, Skokie, IL, United States, 60077

Similar Jobs

5 Minutes Ago
Remote or Hybrid
Hoffman Estates, IL, USA
46K-84K Annually
Senior level
46K-84K Annually
Senior level
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Investigates and processes commercial insurance claims, determines coverage, establishes reserves, assesses damages, negotiates settlements, prepares estimates, maintains claim documentation, and identifies potential fraud or subrogation opportunities. The role requires regular communication with insureds, claimants, agents, and internal teams while ensuring compliance with policy terms, legal requirements, and company guidelines.
7 Hours Ago
Remote or Hybrid
Riverwoods, IL, USA
138K-158K Annually
Senior level
138K-158K Annually
Senior level
Fintech • Machine Learning • Payments • Software • Financial Services
Manages strategically important global partners and provides operational business support across onboarding, training, customer issue resolution, and internal systems. Leads complex, cross-functional process improvement initiatives, product and solution implementations, and strategic projects. Analyzes metrics to drive improvements, documents requirements, mitigates process and system gaps, and collaborates with technical teams and stakeholders. Coaches peers and mentors junior account executives while facilitating training.
Top Skills: Authorization And Settlement Applications
7 Hours Ago
Hybrid
Riverwoods, IL, USA
138K-173K Annually
Senior level
138K-173K Annually
Senior level
Fintech • Machine Learning • Payments • Software • Financial Services
Manage enterprise risk management initiatives, enhance risk identification frameworks, standardize cross-functional processes, develop risk metrics, and provide executive reporting. Partner with business, technology, product, and data teams to implement improvements, lead training, support governance, fulfill audit and regulatory requests, and ensure consistent risk framework execution across business lines.

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account