Dunn Solutions Group Logo

Dunn Solutions Group

BI ETL Consultant

Posted 4 Hours 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

8 Minutes Ago
In-Office
Chicago, IL, USA
85K-100K Annually
Mid level
85K-100K Annually
Mid level
Fintech
Drive revenue by developing relationships with title companies, CRE firms, brokers, attorneys, and financial professionals. Execute territory-based business development plans, manage full sales cycle from prospecting to onboarding, represent Accruit at industry events, collaborate with internal teams, and maintain CRM pipeline and forecasts to grow 1031 exchange and CRE-related business.
Top Skills: CRMSaaS
30 Minutes Ago
Remote or Hybrid
United States
82K-102K Annually
Senior level
82K-102K Annually
Senior level
Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Lead delivery across multiple engineering and product teams, plan and track key initiatives, surface risks and dependencies, strengthen Agile practices, use metrics and OKRs to improve predictability, and communicate status to stakeholders to ensure on-time launches.
Top Skills: AirtableChatgptClaudeGeminiGoogle WorkspaceJIRAJpd
31 Minutes Ago
Remote or Hybrid
United States
14-17 Hourly
Entry level
14-17 Hourly
Entry level
Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Monitor and verify accuracy of live e-sports game data feeds in real time, identify and resolve discrepancies, cross-check multiple sources, escalate issues, and collaborate to streamline processes. Maintain knowledge of schedules, rosters, rule changes, and key metrics to ensure contextual data accuracy throughout the season.
Top Skills: APIsE-Sports Data FeedsExcelGoogle SheetsReal-Time Event Tracking Systems

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