The anticipated hiring range for this position is $80,000 to $90,000.Hiring offers will be determined based on the final candidate's qualifications and experience.The recruiter can share more information about what the anticipated hiring salary would be based upon your specific qualifications during the selection process. The CIA offers a substantial benefits package that includes medical coverage available at no cost to qualifying employees, dental insurance, vision insurance, life insurance, short and long term disability insurance, retirement savings plan with high employer contributions, a generous paid time off program, and more! As the benefits package at the CIA results in a significant value above the base hiring salary for this position, we encourage you to apply so that our recruiters can share more information with you about the benefits of working for the CIA. POSITION SUMMARY The Business Intelligence (BI) Analyst designs and builds data marts and data warehouses by aggregating data from multiple sources for data mining, writing queries and designing reports and dashboards.This includes gathering and analyzing data in support of business reporting and analysis.The Analyst collaborates in the planning, design, development, and deployment of new applications, and enhancements to existing applications. ESSENTIAL RESPONSIBILITIES
- Design and build BI effective solutions in a timely manner.
- Debug, monitor and troubleshoot BI solutions.
- Write relational and multidimensional database queries.
- Create and deploy reports as needed.
- Prepare and deliver reports, recommendations, or alternatives that address existing and potential opportunity areas of data in the database.
- Work closely with other team members to deliver effective global BI architecture in a timely manner.
- Educate and advise internal customers on how to leverage available data for consumption.
- Assist in development, roll-out, and maintenance of dashboards, both executive and management reporting, across the enterprise.
- Build relationships with BI partners to understand data needs in order to execute with excellence on documented user requirements and prototypes.
- Develop and maintain an enterprise data architecture roadmap to improve the maturity and effectiveness of enterprise data management.
- Any and all other duties as assigned.
REQUIRED QUALIFICATIONS Education:
- Bachelor's Degree in computer science or a related field, or significant work experience in lieu thereof.
Experience:
- Minimum of three to five (3-5) years experience with developing technical BI data solutions with Microsoft tools.
PREFERRED QUALIFICATIONS
- Prior work experience as a Database Programmer or Programmer Analyst strongly preferred.
- Experience in higher education work experience.
- Experience with data modeling.
- Experience with Entrinsik Informer.
- Experience in technical support and training.
REQUIRED SKILLS
- Excellent verbal and written communication skills, including ability to communicate complex ideas in a simple way.
- Strong organizational, detail, and project management skills, with the ability to solve problems and consistently meet demanding deadlines.
- Demonstrated SQL skills with extensive experience in developing stored procedures, views, functions, triggers and advanced logical methods.
- Strong skills in Microsoft Excel, expertise in SQL Server, Microsoft Reporting and/or Crystal BI tools.
- Strong interpersonal skills.
- Strong documentation skills.
- Demonstrated ability to show a high level of service responsiveness to customers.
- Excellent analytical and troubleshooting skills to test and solve database and application issues.
- Proficient knowledge of MS Office applications.
- Expertise utilizing Microsoft data integration tools (SQL scripts).
WORKING CONDITIONS
- Must be available to work nights and weekends as required due to business needs.
- Regular work requires the use of a computer, sometimes in excess of eight (8) hours per day.
- Dexterity of hands and fingers to operate a computer keyboard, mouse, and to handle other computer components.