Aetna Senior Informatics Consultant in Bismarck, North Dakota

Req ID: 51540BR


Responsible for the successful delivery of complex analyses and reporting solutions to meet business needs. Interacts directly with internal customers and colleagues in the development of reporting and analytic solutions. Acts as a project lead for complex projects involving multiple resources and tasks. Provides mentoring to other team members.

Fundamental Components:

Collaborates with internal partners and organizations in the design and execution of reporting solutions and analytic studies to support business needs.

Develops, validates and executes complex queries, develops complex reports and performs complex data analysis that answers business questions for internal customers; interprets results, and makes recommendations to business areas based on findings.

Develops project plans and timelines; responsible for project commitments to quality and on-time deliverables.

Evaluates data needs of assigned projects, assures data integrity and suitability, and determines data collection methods, metrics definitions and evaluation methods.

Turns data into actionable information through reporting solutions.

Troubleshoots technical details / issues.

Presents analysis and reports to internal customers and stakeholders.

Acts as a mentor to other analysts.


7 or more years experience using advanced SQL and SAS programming abilities in data warehouse environment AND/OR advanced reporting tool development skills using Excel, Access, VBA and/or Tableau and/or Power BI.

Experience working in a data warehouse environment and/or the ability to work with large data sets from multiple data sources.Knowledge of analytic programming tools and methods and reporting platforms.Understanding of relational databases, data systems and data warehouses.Demonstrated extensive and diverse knowledge of health care data, metrics, systems and standards; demonstrated subject matter expertise in multiple subject areas.Ability to communicate technical ideas and results to non-technical clients in written and verbal form.

Experience leading project teams; strong collaboration skills with the ability to work effectively with all levels of management and staff.Strong collaboration and communication skills within and across teams.Strong problem-solving, analytical, critical thinking and project management skills.Ability to manage conflicting priorities and multiple projects concurrently.


The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.


Functional - Information Management/Business information analysis/7-10 Years

Functional - Information Management/Data acquisition, data management, programming and documentation/7-10 Years


Technology/Leveraging Technology/FOUNDATION

Technology/Promoting Emerging Technology/FOUNDATION

Telework Specifications:

Telework arrangements may be considered for selected candidates who currently telework.


The Clinical Operations Reporting team is staffing multiple positions to develop a team with a blend of skillsets, including data query specialists (with SAS/SQL experience) and report development specialists (with Tableau, Power BI, Excel/Access/VBA experience). The positions will be either PRF3 or PRF4, depending on the skills and experience of selected applicants. Please refer also to the PRF3 job posting. The positions are not location-specific and can be staffed in a variety of locations.

Aetna is about more than just doing a job. This is our opportunity to re-shape healthcare for America and across the globe. We are developing solutions to improve the quality and affordability of healthcare. What we do will benefit generations to come.

We care about each other, our customers and our communities. We are inspired to make a difference, and we are committed to integrity and excellence.

Together we will empower people to live healthier lives.

Aetna is an equal opportunity & affirmative action employer. All qualified applicants will receive consideration for employment regardless of personal characteristics or status. We take affirmative action to recruit, select and develop women, people of color, veterans and individuals with disabilities.

We are a company built on excellence. We have a culture that values growth, achievement and diversity and a workplace where your voice can be heard.

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

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 for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.

Job Function: Health Care