This position is in VANCOUVER WA USA

Implements and supports business intelligence platforms including the enterprise data warehouse and BI reporting platforms. Administers and manages reporting and analytical solutions including table structures and processes such as ETL. Resolves issues including SQL error messages (warning and errors), load failures, data and table issues, KB-SQL & T-SQL errors.Acts as a technical liaison between technical resources and business partners including Enterprise Analytics. This position requires proficiency with analytical tools (SAP, Excel), knowledge of data analysis methodology, strong communication skills and a strong commitment to delivering the highest level of customer service. Functions with a high degree of independence to proactively identify needs or issues, develop strategies and propose/implement data model solutions.

ESSENTIAL RESPONSIBILITIES

• Configures and maintains data warehouse, reporting and ancillary business intelligence platforms


• Manages data acquisition from primary or secondary data sources and maintain databases/data systems including custom ETL development


• Resolve issues such as error messages (warnings and errors), load failures, data and table issues, KB-SQL problems, to deliver accurate data meeting our customer's requirements.


• Assists in technical support of corporate web properties and integration between internal and external web services and data sources (JSON feeds, etc.)


• Develops and maintains documentation of all processes associated with administration of the business intelligence infrastructure


• Coordinates and collaborates with multiple partners including enterprise data governance, data custodian, data stewards, data analyst, data and system architects.


• Provide downstream database owners with results of upgrade analyses, to ensure changes are clearly communicated to colleagues.


• Design, develop, test and release reports and tools working closely with business and clinical leaders.


• Achieve Epic Clarity & Caboodle Administrator certification within 12 months of hire.

EDUCATION AND EXPERIENCE

• Bachelors or technical degree in related field (computer science, information systems, etc.) or equivalent work experience. Minimum 2 years administrator level experience.


• Minimum 2 years of continuous hands on Microsoft SQL, SSRS, SSIS tools including direct T-SQL coding


• Epic Cogito Clarity & Caboodle Administrator certification required or acquired within 1 year


• Technical expertise regarding data models, database design development and data mining.


• Minimum 2 years experience with BI tools preferably SAP WebI, InfoView, & Crystal Reports.


• Proficiency in SQL programming language


• Proficiency in .NET, PowerShell or other scripting language preferred


• Proficiency in MS Office software required


• Familiarity with healthcare clinic operations preferred


• Experience with installing, implementation and testing complete Clarity & Caboodle environments (i.e., console, Compass, Hyperspace, configuration of Epic tools) for Clarity & Caboodle non production and production environments preferred


• Demonstrated ability to work independently


• Excellent interpersonal and rapport-building skills to bridge communication between technical and non-technical project staff, clinical staff and other stakeholders


• Proven ability to analyze business reporting requirements and systems functionality to develop and support reporting systems

The above information is intended to indicate the general nature and level of work required in this position. It is not designed to contain or be interpreted as a comprehensive description of all duties, responsibilities, and qualifications required of those assigned to this job.

We offer a competitive Total Rewards Program which includes insurance programs covering medical, dental, vision, life, long-term disability, generous time off, holidays, education reimbursement, and a 401(k) plan. Eligibility for benefits is dependent on factors such as position type and FTE. Contact your recruiter for more information.

Vancouver Clinic is proud to be an Equal Opportunity Employer. Vancouver Clinic does not discriminate on the basis of race, color, gender, disability, veteran, military status, religion, age, creed, national origin, gender identity or expression, sexual orientation, marital status, genetic information, or any other basis prohibited by local, state, or federal law.

Vancouver Clinic is an alcohol and drug-free workplace. Offers are contingent on successful completion of drug and background screenings. Please note we follow Federal Guidelines regarding prohibited substances, even for those legal at the state level.