Skip to content

Analytics Engineer II SQL Virtualization Reporting

HCA Healthcare LogoHCA Healthcare
View Organization

We are seeking an Analytics Engineer II for our team to ensure that we continue to provide all patients with high quality, efficient care. Did you get into our industry for these reasons? We are an amazing team that works hard to support each other and are seeking a phenomenal addition like you who feels patient care is as meaningful as we do. We want you to apply!

Job Summary and Qualifications

Department Introduction:

  • The ITG Field Operations department is responsible for the development and implementation of HCA’s division and facility programs as well as the expansion of business processes and performance related to HCA's local strategies.
  • The person hired to this position will develop dashboards and data models within the ITG division and learn the subject-matter necessary to develop and implement identified requirements as they relate to local projects and initiatives defined by business leaders.
  • This role will support division and facility reporting needs, ad hoc reporting, report configuration, and report distribution throughout the organization. This role will be responsible for creating ad hoc and standard reports per local project or operational expectations.

Job Summary: Primary Purpose of the job

The Analytics Engineer II is a part of the division ITG organization of HCA. This technically focused position within the division ITG team is responsible for designing, developing, testing and deploying our business intelligence solutions across the enterprise. This goal will be achieved by working with cross-functional business teams and utilizing relevant development platforms (such as PowerBI). Analytics Engineer II is responsible for application creation, administrative tasks, and supporting dashboard and report solutions development.

The Analytics Engineer II will collaborate with Business Analysts, Data Scientists, and Project Managers, provide leadership regarding reporting and BI, as well as support and develop subject matter knowledge for reporting within the necessary solutions created.

The Analytics Engineer II will ensure the effective design, build, deployment, documentation and maintenance of reports against relational and multidimensional databases to support end-user processes.

Experience/ Requirements:

  • Expertise/experience in data acquisition, data cleansing and parsing required.
  • Expertise/experience in data analysis, modeling and visualization required
  • Experience with a business intelligence platform (e.g., PowerBI, Qlik, MicroStrategy) required.
  • SQL experience required; Teradata preferred, may substitute MSSQL, Oracle, Postgres, or other ANSI-extended SQL.
  • Experience with a formal development language (e.g., Python, R, JavaScript, Ruby, Scala, or Clojure) required.
  • Expertise/experience in the areas of data structures and data warehousing required.
  • Experience using a distributed version control system (DVCS; e.g., GitHub, TFS) preferred.
  • Experience working in an Agile/Scrum environment preferred.
  • ETL experience preferred.

Adaptability:

  • Quickly modifies behavior to deal effectively with changes in the work environment.
  • Readily tries new approaches appropriate for new or changed situations.
  • Actively seeks information about new work situations so they can share with peers and manager.

Strategic Working Relationship:

  • Partners with colleagues and customers to achieve meaningful discussions regarding data outputs and feedback on usage activities to improve Data and Analytics output.

Customer Focus :

  • Creates formal networks involving coordination among groups.
  • Serves as departmental spokesperson on specialized deliverables.
  • Technical and Professional Development:
  • Broad application of health industry data standards.
  • Seasoned data professional with a full understanding of data tools and concepts; ability to resolve a wide range of issues in creative ways.
  • Technical experience in analytics engineering and BI development and deployment.
  • Actively participates in application design sessions.
  • Provides technical guidance to business users and application developers. Capable of documenting technical requirements.
  • Intermediate programming experience, preferably in a dynamic language such as Clojure, Python or R. Solid SQL development experience.
  • Familiarity and understanding of the agile process.
  • Ability to manage multiple assignments simultaneously.
  • Technical aptitude to learn and adapt to new industry applications and tools.

Working Standards:

  • Continues to refine development and analytical skills.
  • Applies an expert development approach to provide creative solutions to complex problems.
  • Participate in strategic design, construction and implementation of software and analytics solutions in the BI development environment. This includes selecting, gathering specifications for, designing and implementing solutions for consumers throughout the enterprise.
  • Participate in team code reviews and functional testing.
  • Ability to write and test software in a variety of languages.
  • Works on increasingly unique problems.
  • Works to build technical knowledge by taking advantage of internal team mentoring and attending professional development opportunities.

Business and Financial Impact:

  • Produces actionable reporting that drives business decisions.
  • Contributes to the development of goals and objectives related to the business.
  • Failure to accomplish results can normally be overcome without a significant effect on the organization.

Freedom to Act/ Independent Judgment:

  • Works independently with limited supervision and acts as a resources for colleagues with less experience.
  • Work is evaluated to ensure objectives are met.
  • Exercises judgment in selecting and adapting methods and techniques for obtaining solutions.
  • Possesses the ability to make decisions which may deviate from established policy due to special circumstances.

Educational Requirements & Technical Experience:

  • Degree or equivalent work experience preferred.
  • 3+ years of professional experience.