20 Apr
Business Intelligence Data Analyst
Vacancy expired!
Our client is looking to bring aboard a Business Intelligence Data Analyst for a 12+ month contract. This position can be remote or onsite in the San Diego area. Local candidates preferred.
The Scoop:The Business Intelligence (BI) Data Analyst I is responsible for developing an in-depth understanding of the underlying data and proper business uses to translate end-user data and information requirements into a format to aid various Client organizations and teams in drawing insight from that data. This includes creating queries, visualizations, algorithms, and reports. By creating a more data-driven approach to business, you will enable your colleagues to make smarter, faster decisions enabling the business to grow and adapt to an ever-changing global environment.What You Get To Do:- Defines methodology and analytic approach as required for each specific request
- Writes complex, highly-optimized queries across large volumes of data to create detailed and accurate outputs with understanding of statistics
- Performs ad-hoc data analysis and reporting
- Writes and maintains detailed documentation of including specifications, expected outcomes, validation methodology/processes, test results, recommendations, version control, and configuration design
- Understands data standards and identifies data abnormalities
- Instills data quality in all outputs that are delivered
- Takes personal ownership and accountability for pre-determined Service Level Agreements by following up and following through on all deliverables
- Recommends and implements improvements to existing processes and assists with adoption of new software tools
- Effectively communicates technical and statistical findings with fellow team members
- Possess excellent oral and written communication skills, and is comfortable presenting to everyone from entry-level employees to senior vice presidents
- Acts as a technical business liaison to explain complicated technical information to non-technical audiences (both internal and external) effectively
- Promptly responds to service failures, resolves issues, and escalates concerns as appropriate
- Promotes continuous improvement by ensuring adherence to quality principles
- Seeks out and actively participates in business initiatives that contribute to service excellence
- Keeps current with industries best practices and seeks additional training/seminars to improve technical skills
- For consideration candidates will need a Bachelor degree or higher from a university in engineering, IT, economics, math, statistics, science or other related fields in quantitative or analytical discipline (or equivalent combination of education and experience)
- One (1) to three (3) years relevant hands-on experience in analytics, business intelligence or comparable data engineering role, including data warehousing, and business intelligence tools, techniques and technology
- Experience with pharmacy claims data, insurance data, managed health care industry or PBM operations preferred
- Working knowledge of standard business applications, Microsoft Office Suite (MS Access, MS Visio, MS Project, MS Word, and MS PowerPoint), Golden 32 or TOAD and Salesforce
- Advanced proficiency with Excel (Pivot tables, pivot charts, conditional formatting, VLOOKUP, formulas); VBA macro experience a plus
- Strong knowledge of PL/SQL (complex joins, nested subqueries, aggregation, partitions, functions, pivots and unions)
- Knowledge of SAS and Cognos a plus
- Solid understanding of databases, their architectures and database constraints
- MYSQL Certification or demonstrated knowledge
- Oracle Certified Professional is a plus
- SAS Certified Base Programmer a plus
- Executes and delivers within the confines and timeframes provided by regulatory agencies
- Strong knowledge of the US healthcare system and healthcare claims data
- Ability to write analytical test cases for QA
- Ability to work beyond standard business hours as required by deadlines and deliverables
- Ability to prioritize urgent issues effectively
- Proven team player, delivery-focused, yet flexible and creative when called upon
- Ability to communicate positively, tactfully and effectively with multiple stakeholders including team members, management, and customers
- Well-developed facilitation and collaboration skills
- Experience and understanding of how to accomplish deliverables in a matrixed environment
Vacancy expired!