Skip to main content

A new day in healthcare. Together, CVS Health and Aetna help people on their path to better health.

BI Developer/Analyst

Primary Location: New Albany, Ohio
Additional Locations: OH-New Albany
Apply
Description:
Support reporting and analytics solutions for American Health Holding Inc. – an Aetna company, through SQL development and participating in the design, build and management of our data warehouse by creating and modifying Extract/Load/Transform (ETL) workflows.



Fundamental Components:
  • Maintain and enhance ETL processes for data conversion and incremental loading. Map source data to data warehouse.
  • Creates and manages data quality initiatives.
  • Supports the BI team with SQL query needs.
  • DesignsandcodesefficientlyusingSQLprograms.
  • Extractsdatafrommultiplesourcesandcreatesintegratedanalyticdatasetsandcreatesreportsandstudiestoaddressbusinessandresearchquestions.
  • Formulate and document technical specifications.
  • Develop scripts to validate Tableau dashboards and reports.
  • Conductsperiodicupdatesofanalyticalroutinesanddepartmentproductionsystems.
  • Investigatesandevaluatesalternativesolutionstomeetingbusinessneeds.
  • Participatesinpresentationsandconsultationstoconstituentsoninformationservices,capabilitiesandperformanceresults.
  • Documentsmethods,specificationsandfindingsclearly;contributestowritingandpresentationofresults,findingsandconclusions.
  • Createsandevaluatesthedataneedsofassignedprojectsandassurestheintegrityofthedata.
  • Managespersonalresourcesefficientlytocompleteassignedprojectsaccuratelyandontime.
  • Participatesinthedevelopmentofprojectplansandtimelines.
  • Responsibleforcommitmentstoqualityandon-timedeliverables.Motivatedandiswillingtounderstandandprobeintotechnicaldetailsanddatairregularities.
  • Contributestoa motivatedworkenvironmentbyworkingeffectivelytoachievecommongoals.


Background Experience:
  • 5+ years’ experience and strong technical skills in one or more technologies such as Tableau, SSIS, or SQL Server including the following:
  • StrongSQLprogrammingskills (T-SQL and SSIS)
  • Experience with data visualization tools such as Tableau or Power BI
  • Experience with data warehouses; solid understanding of facts/measures and dimensions
  • Advanced in Excel, including pivot tables
  • Self-motivated and detail-oriented
  • Healthcareorpharmaceuticalindustryexperienceispreferred.
  • Knowledgeofbigdataanalytics anddatamining.
  • Strong understandingofrelationaldatabases,datasystemsanddatawarehouses.
  • Experienceinstatisticalanalysisanddatabasemanagement.
  • Knowledgeofanalyticprogrammingtoolsandmethods.
  • Demonstratedanalyticalandproblem-solvingskills.
  • Demonstratedwrittenandverbalcommunicationskills.Abletopresentinformationtovariousaudiences.


Functional Skills:
Information Management - Data Warehousing, Information Management - Query and Database Access Tools

Technology Experience:
Database - Microsoft SQL Server, Development Language - Microsoft TSQL/OSQL

Potential Telework Position:
No

Percent of Travel Required:
0 - 10%

EEO Statement:
Aetna is an Equal Opportunity, Affirmative Action Employer

Benefit Eligibility:
Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

Candidate Privacy Information:
Aetna takes our candidate's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests

Click To Review Our Benefits (PDF)

Apply

Jobs for you

Recently Viewed Jobs

You do not have any recently viewed jobs

Your Saved Jobs

You do not have any saved jobs

Sign up for Job Alerts

Join our Talent Community

At Aetna, we are pioneering a total approach to health and wellness and we need talented candidates like you to join our team. Become a member of our talent community to be the first to know about career initiatives that match your skills and interests as they become available, in addition to details on upcoming events, networking opportunities, and news about Aetna.

Join Our Talent Community

Sign up to receive information about job openings that are tailored to your skills and interests. Plus, get the latest career news from Aetna.