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

Junior
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Picks, stages, inspects, and fulfills customer orders while maintaining accurate inventory and safe, organized staging areas. Operates certified powered equipment, uses retail technology and the Orders App, resolves short picks, completes audits and readiness tasks, and provides customer service. Requires computer and retail technology experience plus certification or ability to obtain certification for forklifts, order pickers, and narrow aisle reach trucks.
Top Skills: ForkliftNarrow Aisle Reach TruckOrder PickerOrders AppSims
11 Minutes Ago
Hybrid
Entry level
Entry level
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Provides customer service in a Lowe’s store by helping shoppers locate and select products, processing orders, replenishing merchandise, preparing department-specific products, and assisting with checkout. The role may involve loading merchandise, cross-training across departments, prolonged standing, and lifting at least 25 pounds. Occasional travel to meetings, training, or neighboring stores may be required.
Top Skills: ComputersRetail TechnologySmartphonesTablets
11 Minutes Ago
Hybrid
DeKalb, IL, USA
Entry level
Entry level
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Fulfill customer orders by picking, staging, inspecting, and loading products accurately and safely. Maintain inventory accuracy using retail technology, resolve short picks, operate certified powered equipment, and complete audits, maintenance, and readiness tasks. Provide customer service, maintain clean and organized work areas, follow safety procedures, and report safety or theft concerns. Strong communication, teamwork, computer skills, and required equipment certifications are essential.
Top Skills: ForkliftNarrow Aisle Reach TruckOrder PickerOrders AppSims

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