Data Analyst
Location: Chicago, IL
Duration: CTH
This role requires a unique blend of deep technical ability with regards to database skills, ETL systems and excellent visualization skills especially in Tableau, coupled with end customer white glove treatment. Co-creation, definition & delivery of major strategic projects will be the norm. The role requires a highly resourceful individual with strong customer presence, self-motivation, and strong technical skills.
Essential Duties and Responsibilities:
Essential functions for this job include but is not limited to:
• Develop complex SQL Queries
• Design and delivery of large-scale, high-performance data transformation and storage systems such as ETL using SSIS
• Design and delivery of Analytics. Extract, transform and load with Teradata fastload
• Work heavily with Tableau and other visualization tools
• Develop technical requirements based on business requirements
• Define and manage the full development lifecycle to meet client needs
• Willing to translate business requirements into technical architectures
Minimum Skills and Competencies:
The requirements listed below are representative of the knowledge, skill and/or ability required.
• Bachelor Degree.
• 4+ years of demonstrated advance proficiency in SQL development methodologies, R and Python
• Strong background in Relational Databases (Teradata, Microsoft SQL, Oracle) and strong ETL (Microsoft SSIS) experience
• Experienced with automation in Python and/or R
• Must possess effective verbal and written communication skills
• Excellent consulting skills and the ability to work effectively with clients and team members
• Ability to translate business requirements into technical solutions
• Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint)
• 4-6 year experience using Tableau
• 4-6 year experience using SSIS
Desired Skills:
• MBA, Master Data Management (MDM), MS in Computer Science or Information Systems, or other advanced technical degree
• Extensive knowledge in Tableau and ETL in SSIS
• Extensive knowledge in Tableau, R, Python and ETL in SSIS and other analytical tools
• Health Insurance industry experience
• Experience with project management
• Familiarity with HIPAA requirements