DEFENDERS Data Warehouse Analyst II in INDIANAPOLIS, Indiana


Job Summary:

Responsible for designing, developing,supporting, and enhancing solutions that offer our internal customers data for the purpose of strategic and operational decision-making.


Essential Functions:

  • Develop, support and enhance Azure data warehouse/DataMart ELT feeds.

  • Develop, support and enhance multi-dimensional cube solutions.

  • Develop, support and enhance operational reporting and data analysis solutions.

  • Design and develop database and data warehouse solutions for Microsoft Azure SQL cloud platform through all phases of design (e.g. conceptual design, logical modeling, technical design, development).

  • Develop and support Business Analytics solutions using Microsoft’s PowerBI.

  • Establish a collaborative and proactive dialogue with key internal business intelligence customers.

  • Perform root-cause analysis for data and business intelligence related issues.

  • Contributes to team effort by accomplishing related results as needed.


Background & Education:

Education :Bachelor’s Degree in a related field

Skills/Background: Highly proficient in authoring and troubleshooting Transact-SQL language. Proficient in developing scorecards and dashboards.Proficient with basic principles and processes of business intelligence. Possess thorough knowledge of Business Analytics concepts (e.g. ROLAP, MOLAP, ETL, Data Universes, Data Cubes, Data Marts, De-normalization, and data visualization techniques). Familiarity with DAX, MDX, and C# languages is a plus. Familiarity with Microsfot MDM and DQS is a plus.

Minimum Years of Experience : 0-2 years

If found to be qualified for the next step of our process, you may receive an email and/or text message from our DEFENDERS Talent Attraction team.

All qualified applicants to DEFENDERS will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, veteran's status, age, or disability.

Company Code


Connect With Us!

Not ready to apply?for general consideration.

Job ID 2018-2836


Category Information Technology