sql developer (etl, ssis, sql server, oracle, teradata - python/databricks is a deal)

$104,000 - $122,762/Yr

Randstad - Bloomfield, CT

Full-time - Mid Level

Remote - Bloomfield, CT

Administrative and Support Services

About the position

The Business Analytics Advisor role within the Cigna Enterprise Operations Analytics organization focuses on providing actionable insights to enhance customer experience, reduce costs, and improve business performance. The advisor will conduct detailed business analyses, identify problems and opportunities, and implement solutions for their client group, utilizing various analytical tools and methodologies.

Responsibilities

• Using SQL to write queries to answer questions and perform ETL tasks to create datasets.
• Utilizing Python libraries (scikit-learn, pandas, numpy) to conduct statistical analyses.
• Communicating findings and coordinating with peers, leaders, and business partners.
• Using Business Intelligence tools to create self-service reporting for business partners.
• Leading analytics-based projects and experiments.
• Conducting self-driven data exploration and documentation of tables, schemas, and tests.
• Using SQL to query data structures to help inform our business partners.
• Examining and interpreting the data to discover weaknesses and identify root causes.
• Conducting hypothesis testing on business partners' assumptions.
• Completing ad hoc requests for business partners' data needs.
• Identifying and implementing automation to consolidate similar or repeated ad hoc requests.
• Understanding business needs to better inform reporting and analytics duties.
• Giving guidance on any recurring problems or issues.
• Completing proposals in cooperation and conjunction with experts on the subject (SME).
• Refactoring reporting to enhance performance, provide deeper insight, and answer questions.
• Updating project documents as well as status reports.

Requirements

• 8+ years of relevant analytics experience
• Experience as a Business Analytics Advisor is a plus
• Expertise in health insurance contact center operations
• Proficiency in Agile practices (Jira)
• Proficiency with Structured Query Language
• Experience with a scripting language (Python, Powershell, VBA)
• Experience with Big Data Platforms (Databricks, Hadoop, AWS)
• Experience with Business Intelligence Software (Tableau, PowerBI, Looker, etc.)
• Excellent verbal, written and interpersonal communication skills
• Problem-solving, consulting skills, teamwork, leadership, and creativity skills
• Analytical mind with outstanding ability to collect and analyze data.

Benefits

• Health insurance
• Incentive and recognition program
• 401K contribution