Business Intelligence Engineer 1

Humana

2d • Remote

About The Position

Become a part of our caring community and help us put health first iMA Rapid Solutions is seeking a BI Engineer 1 that will add bench strength to the maintenance and, more specifically, the enhancement of the overall pricing process. This role requires some development experience, leveraging that to optimize and automate processes as well as the ability to communicate quickly and effectively on technical issues/solutions. Individual Medicare Advantage (IMA) Rapid Solutions owns the MA Pricing Model (web app hydrated via t-SQL), which generates annual pricing of Humana’s largest segment of business, individual plan Medicare Advantage. The team consists of actuaries and business technology professionals who are proficient with t-SQL and databases. The team works closely with a team of IT professionals on the Pricing Model, an upstream Power Platform auditing tool and a myriad of side tools to support CMS bid filing and regular forecasts of Humana’s MA business. Long term, the expectation will be to apply gained business knowledge from optimizing/automating the pricing model to our business partners’ tools and processes to gain preparation/maintenance of and/or fully re-engineering them.

Requirements

• Bachelor's Degree
• 1+ years experience coding in SQL and/or Python.
• Experience manipulating and analyzing data using SQL, Python, R, or similar software.
• Comprehensive knowledge of Microsoft Office, including Word, Excel, Access and PowerPoint.

Nice To Haves

• 1+ years of experience in SQL, SAS or other data systems
• In-depth experience in Microsoft Excel including formulas, pivots, charts, graphs, etc.
• Expertise in assessing complex data sets and performing root cause analysis
• Experience with data mining and predictive modeling techniques
• Ability to use data to drive business outcomes and decisions
• At minimum, a download speed of 25 Mbps and an upload speed of 10 Mbps is required; wireless, wired cable or DSL connection is suggested. Satellite, cellular and microwave connection can be used only if approved by leadership.
• Employees who live and work from Home in the state of California, Illinois, Montana, or South Dakota will be provided a bi-weekly payment for their internet expense.
• Humana will provide Home or Hybrid Home/Office employees with telephone equipment appropriate to meet the business requirements for their position/job.
• Work from a dedicated space lacking ongoing interruptions to protect member PHI / HIPAA information.

Responsibilities

• Convert processes requiring manual steps (many in Excel) to a more effective tech stack.
• Optimize Pricing Model SQL code where there are known performance issues.
• Triage data/code/user error issues and resolve quickly and effectively.
• Design, demo, develop and test new more efficient processes, typically that are short term/high impact projects.
• Effectively communicate technical concepts to a broad range of audiences including customers, business partners and IT.
• Work closely with the business team, customers and IT to collaborate on technical solutions.
• Coordinate with other developers (both business and IT) to ensure dependencies are documented and testing is sufficient for monthly releases.

Benefits

• Humana, Inc. and its affiliated subsidiaries (collectively, “Humana”) offers competitive benefits that support whole-person well-being. Associate benefits are designed to encourage personal wellness and smart healthcare decisions for you and your family while also knowing your life extends outside of work. Among our benefits, Humana provides medical, dental and vision benefits, 401(k) retirement savings plan, time off (including paid time off, company and personal holidays, volunteer time off, paid parental and caregiver leave), short-term and long-term disability, life insurance and many other opportunities.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level