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

$104,000 - $130,000/Yr

Unclassified - Bloomfield, CT

Full-time - Mid Level

Remote - Bloomfield, CT

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 propose solutions tailored to client needs.

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

• Comprehensive benefits package including health insurance
• Incentive and recognition program
• 401K contribution (based on eligibility)