Sr. Business Intelligence Engineer in Charlotte, North Carolina at AccruePartners

Date Posted: 9/15/2020

Job Snapshot

Job Description

TEAM YOU’LL BE JOINING:

  • Diversified Fortune 100 healthcare company with revenue over $60 billion, focused on providing local solutions to ensure accessibility, quality, and culturally attentive healthcare programs
  • CORE Certified and nationally accredited by the NCQA and the URAC
  • Voted one of Fortune’s Fastest Growing Companies in 2018 and one of Fortune’s Most Admired Companies for 2019

WHAT THEY OFFER YOU:

  • A career focused on developing your skillset while providing value through new ideas and innovative thinking
  • Employee development and growth opportunities: learn new skills, cross paths with other disciplines, and grow within the organization
  • Collaborative environment, work with a team to provide quality healthcare solutions coast-to-coast
  • Work with purpose every day in an environment built around helping others 
  • Excellent benefits package including Medical, Dental, and Vision coverage in addition to other benefits such as tuition reimbursement/educational assistance, paid company holidays, and adoption reimbursement.

WHAT YOU WILL DO:

  • Design, build, test and maintain scalable and stable off the shelf application or custom built technology solutions to meet business needs. Act as a subject matter expert for Application Software developers and Engineers.
  • Designing and architecting data pipelines for Provider& Core Workflow Reporting. Involved in extensive requirement gathering sessions for data acquisition via ETL. Development activities involving multiple ETL tools, streaming platforms, and RDMBS tools. Contribute to the entire implementation process including driving the definition of improvements based on business need and architectural improvements
  • Designing, building, and maintaining real-time or near real-time data pipelines using technologies such as Apache Kafka and/or Spark Stream
  • Meet with business partners to understand business needs
  • Responsible for overall design of the solution
  • Design, build and test applications
  • Conduct root cause analysis and advanced performance tuning for complex business processes and functionality

QUALIFICATIONS:

  • Experience with SQL. Advanced working knowledge of Business Intelligence Tools, including: MicroStrategy, Business Objects, Cognos or Oracle Business Enterprise Edition (OBIEE), Kafka, Tableau, or SAS. Experience with UNIX and ETL.
  • Experience with various databases, including: Teradata, Oracle or SQL Server preferred
  • Experience designing, building, and maintaining real-time or near real-time data pipelines using technologies such as Apache Kafka and/or Spark Stream
  • Strong experience of data architecture and data modeling of complex systems from various sources including use of tools such as erwin and/or PowerDesigner
  • Advanced ETL experience with multiple tools, including Informatica PowerCenter and/or Talend
  • Experience implementing BI Visualization and Reporting toolsets such as Tableau, MicroStrategy, and/or Power BI
  • Strong experience using Informatica Power Center 9.5 or higher
  • Strong experience using SQL Assistant or traditional SQL
  • Strong experience developing complex SQL scripts, views, and stored procedures
  • Strong experience performing SQL performance tuning & data profiling
  • Strong experience handling/processing large volumes of data
  • Embrace new technology to facilitate next generation architecture
  • Experience in designing, building and maintaining data pipelines using Apache Kafka and/or Spark Stream