Dunn Solutions Group Logo

Dunn Solutions Group

BI ETL Consultant

Posted One Month 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

PNC Bank Logo
PNC Bank

Product Manager

52 Minutes Ago
Remote or Hybrid
USA
100K-223K Annually
Senior level
100K-223K Annually
Senior level
Machine Learning • Payments • Security • Software • Financial Services
Leads strategy, roadmap, prioritization, development, and financial performance for business technology products supporting Vendor Finance. Coordinates technology, business, risk, compliance, and vendor stakeholders; manages product initiatives, timelines, budgets, customer experience, and regulatory requirements. Evaluates product opportunities, drives innovation using emerging technologies including AI, and leads product development teams, including staffing, performance management, and talent development.
Top Skills: Agile MethodologyArtificial IntelligenceSoftware Development Life Cycle
PNC Bank Logo
PNC Bank

Principal Software Engineer

52 Minutes Ago
Remote or Hybrid
USA
112K-250K Annually
Senior level
112K-250K Annually
Senior level
Machine Learning • Payments • Security • Software • Financial Services
Leads enterprise software architecture and development across multiple product lines, establishes design standards, reviews solutions, troubleshoots complex issues, and provides technical guidance across teams. Supports modernization of on-premise systems and migration to Azure cloud. Partners with engineering and executive leaders on technology strategy, security adaptability, automation, and solution design using agile methods.
Top Skills: AgileAzureC#DelphiDevOpsDistributed SystemsJavaJavaScriptTypescript
Federal Reserve Bank of Chicago Logo
Federal Reserve Bank of Chicago

Summer 2027 Intern - Economic Research - Chicago

An Hour Ago
Hybrid
Chicago, IL, USA
20-33 Hourly
Internship
20-33 Hourly
Internship
Agency • Fintech • Payments • Sharing Economy • Social Impact
Supports economists with economic and policy research through data collection, moderately complex statistical analysis, results organization, and preparation of charts, tables, and descriptive text. The 12-week paid internship provides experience across macroeconomics, microeconomics, financial economics, community development, and regional research while developing quantitative, analytical, critical-thinking, and writing skills.
Top Skills: ArcgisMatlabPythonRStata

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