Anthem, Inc. Business Information Developer Consultant in Dearborn, Michigan
SHIFT: Day Job
Be part of an extraordinary team.
We are looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve. You will thrive in a complex and collaborative environment where you take action and ownership to solve problems and lead change. Do you want to be part of a larger purpose and an evolving, high-performance culture that empowers you to make an impact?
Location: This position is eligible for a full-time remote schedule. Preferred location within a commutable distance from an Anthem office; preferred locations are St. Louis, MO; Atlanta, GA; Richmond, VA; Norfolk, VA; Mason, OH; Denver, CO; Indianapolis, IN. Other U.S. locations will be considered.
This Business Information Developer Consultant position will be responsible for developing and executing complex data mining analyses in support of commercial finance and actuarial pricing teams. The majority of time will be spent programming using program languages (mostly SQL) to write queries and running programs to extract data and synthesize for use in reporting and data analysis.
Primary duties may include, but are not limited to:
Establishing and maintaining excellent knowledge of data warehouse database design, data definitions, data sources and flows, system capabilities, related programming languages, and data integrity issues (main internal data sources will be EDWard, EDM, EGD and ARMA).
Gathering business requirements from customers (primarily from commercial pricing health actuaries), developing/maintaining queries and extracting data.
Creating and publishing ad hoc and recurring standard reports.
Coordinating the activities of a project team and monitoring project schedules and resources for your projects.
Educating and training actuarial and other business partners on proper use of applications developed or maintained by our team.
Serving as a source of direction, training and guidance for less experienced teammates (usually BI Developers).
Performing data reconciliations, variance and impact analyses; researching cause and effect of data issues identified; developing solutions to remediate detected problems.
Designing test cases and performing user acceptance testing and regression testing as needed;
Collaborating with business partners, data warehouse teams and IT teams to support data quality and keep data stores maintained and relevant in our ever-changing industry.
Developing and maintaining various types of documentation.
Minimum Required Qualifications:
Requires a BS/BA degree and a minimum of 4 years of related analytical experience; or any combination of education and experience, which would provide an equivalent background.
Ability to produce clear, transparent and succinct communication and explanations appropriate to a variety of audiences (in both written and verbal formats) of observed results in data, models and reporting.
Experience using query tools to manipulate large data sets and experience using statistical software preferred. Tools used will primarily be Teradata SQL Assistant and SAS Enterprise Guide (PROC SQL, SAS DATA Step Procedures, etc.).
Basic knowledge of Statistics/Mathematics, Actuarial Science, Finance/Accounting, Computer Science, Information Management/Data Science, and Business Administration.
PC, Microsoft Office (Excel, Word, PowerPoint, SharePoint, Teams, Outlook), Spreadsheet (Excel) and relational database skills.
Familiarity with SAS MACRO language, SAS Viya, OLAP, Python/R, Hadoop, VBA, RPA, Cloud-based technology (e.g. AWS) and tools (e.g. Snowflake), PeopleSoft/Essbase/General Ledger and BI Tools (e.g. Power BI, Tableau).
Proficiency at the effective visual communication of data.
Health insurance and health care industry knowledge.
A desire to innovate, collaborate, lead with purpose and heart, promote talent excellence, inspire a high performance culture and help improve the health of humanity by simplifying healthcare and expecting more.
Valuing integrity, agility, community, leadership and diversity.
Ability to embrace change, pivot and respond with urgency and resilience when faced with challenges.
Promoting an open and inclusive culture where people of all backgrounds feel appreciated, engaged and valued.
Having an interest in being a life-long learner -- taking personal responsibility for developing new skills and learning about the business to help you and your colleagues change and grow with the Company.
If this job is assigned to any Government Business Division entity, the applicant and incumbent fall under a `sensitive position' work designation and may be subject to additional requirements beyond those associates outside Government Business Divisions. Requirements include but are not limited to more stringent and frequent background checks and/or government clearances, segregation of duties principles, role specific training, monitoring of daily job functions, and sensitive data handling instructions. Associates in these jobs must follow the specific policies, procedures, guidelines, etc. as stated by the Government Business Division in which they are employed. We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) +match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few. The health of our associates and communities is a top priority for Anthem. We require all new candidates to become vaccinated against COVID-19. If you are not vaccinated, your offer will be rescinded unless you provide – and Anthem approves – a valid religious or medical explanation as to why you are not able to get vaccinated that Anthem is able to reasonably accommodate. Anthem will also follow all relevant federal, state and local laws. Anthem, Inc. has been named as a Fortune Great Place To Work in 2021, is ranked as one of the 2021 World’s Most Admired Companies among health insurers by Fortune magazine, and a Top 20 Fortune 500 Companies on Diversity and Inclusion. To learn more about our company and apply, please visit us at careers.antheminc.com. Anthem is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process may contact firstname.lastname@example.org for assistance.