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 at Randstad US involves providing actionable insights to enhance customer experience and improve business performance. The position requires extensive experience in analytics, particularly in the health insurance sector, and proficiency in SQL, Python, and various Business Intelligence tools. The advisor will lead analytics projects, conduct data exploration, and communicate findings to stakeholders.

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 (SQL)
• 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