ETL Data Analyst
At a glance
Mid-level Data Analysis & BI role at Sonoma Consulting Inc. Chicago · full-time · no salary stated · we estimate $87,588–$129,663.
Sonoma Consulting Inc. has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build SSIS templates that follow established industry practices
- Move customer records from legacy platforms into company systems with SSIS and comparable ETL tools
- Help ETL managers and navigators keep the data-conversion process working well for customers
- Check conversion work against documented quality procedures, then update ETL policies and instructions
What you bring
- A bachelor’s degree in MIS, computer science or a related discipline
- Strong hands-on background in data conversion or integration, including advanced SSIS knowledge
- Working fluency with SQL and Oracle, plus SSIS Data Quality and Data Profiling Services
Who this fits
This mid-level, full-time role is based onsite in Chicago. You’ll suit work that combines careful data checks with practical problem-solving and collaboration, including sharing expertise and training new ETL staff.
From the employer
About Sonoma Consulting, Inc.
Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions to serve its 150 national clients which range from entrepreneurial start-ups to Global Fortune 500.
IT Consulting Services
Executive Search
Sonoma Consulting has a culture which is very distinct, professional, experienced and progressive. We take pride in providing quality consultants to reputable clients in order to ensure a mutually beneficial relationship. Our team is very results driven for our clients and candidates being passionate about the right people with the right companies. We fully understand the competitiveness of our business and rely on each other to maintain an adaptable, professional atmosphere. Our employees work in a fast-paced environment focused on goal setting and accomplishing those goals.
Achieving our mission requires intelligent, energetic and committed people who possess:
Integrity and Honesty
Commitment to excellence
Accountability to the employees, consultants and customers we work with
Community and Diversity
• Building out SSIS templates using industry best practices
• Utilizing SSIS and similar ETL tools to convert customer data from legacy systems to our corporate systems
• Supporting ETL Manager and ETL Navigator(s) to ensure an excellent customer experience for the data conversion process
• Performing quality assurance on data conversion projects using documented processes and procedures.
• Documenting and refining policies and procedures for the ETL department
• Bachelor’s degree in MIS, computer science or similar field
• Excellent experience with data conversion/integration.
• Advanced knowledge of SSIS, including Data Quality Services and Data Profiling Services.
• Fluency in database management systems (SQL, Oracle)
• Proficiency with MS Office suite (Excel, Access, Word)
• SQL and database development fundamentals
• Experience with aforementioned tools and systems
• Ability to read and understand technical documents written in English
• Ability to share knowledge and expertise with ETL and implementation team members, and to train new ETL Department staff
• Professional approach to clients and other team members
• Strong analytical thinking and problem-solving skills
• Strong written and oral communication skills
• Takes initiative and works proactively as a team player.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.