ETL Data Analyst at Sonoma Consulting in Chicago, IL

Company Description

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

Job Description

• 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

Qualifications

• 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.

Additional Information

All qualified applicants will receive consideration for employment without regard to race, color, religion, place of origin, ethnic origin, national origin, ancestry, age, sex, sexual orientation, gender identity, transgender status, genetic information, mental or physical disability, marital status, pregnancy, veteran status, or any other characteristic protected by applicable national, state, or local law.