Skip navigation
Unable to save this job. Please try again later.

{msg}

Email this Job to Yourself or a Friend

To begin the application process, please enter your email address.

Company Contact Info

  • Detroit, MI
  • Gemma Pritchard

Already have an account?

Sign in to apply with your saved resumes.

New to CareerBuilder?

Don't have an account? Continue as a guest!

Sorry, we cannot save or unsave this job right now.

Report this Job

Trust and Site Security Team.

Email Send Failed!

Expert Excel Developer

OpTech • Detroit, MI

Posted 1 month ago

Job Snapshot

Contractor
Experience - At least 5 year(s)
Insurance
Information Technology
14

Applicants

How Do You Compare to the Competition?

Get facts about other applicants with a CareerBuilder Account

Job Description

Engagement Description:

  • Candidate will be working on a variety of projects including data visualization, data staging, and interactive report development
  • Must be able to join complex data sets from multiple relational databases and present the output in a visually appealing format; preferably one that is interactive with drill down capabilities
  • Experience with CISCO call center data is a plus

Job Requirements

Top 3 Required Skills/Experience – The most important must-have skills.  Include:

  • Excel and VBA – 5+ years
  • SQL and SQL Server – 2-4 years
  • Data Visualization and Design – 3+ years



Required Skills/Experience:

  • Microsoft Excel – (Advanced-Expert)
    • Creating Dynamic, Interactive Dashboards
    • PowerPivot
    • Power Query
    • Building Complex Macros (VBA)
    • Writing complex formulas


  • Microsoft SQL Server – (Intermediate -Advanced)
    • Staging Data for Reporting Purposes
    • Writing Complex Queries
    • Joining Tables
    • Creating Tables and Views
    • Stored Procedures
    • SSRS


  • Microsoft Access – (Intermediate -Advanced)
  • Experience with Complex and Large Data Sets
  • Strong eye for design and visuals
  • Experience with BI Tools (Tableau, Qlik, Power BI, Cognos, SSAS, etc.)
  • Project Management Experience
  • Knowledge of Call Centers and providing back office support a plus
  • Knowledge of the Health Insurance industry is a plus
  • 5 years of application programming and analysis experience required


Education/Certifications:

Bachelor's degree in related field preferred.
Help us improve CareerBuilder by providing feedback about this job: Report this Job.
CAREERBUILDER TIP
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.
By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.