Business Intelligence Engineer (on-Site)

Description

Business Intelligence Engineer (on-site)

Join to apply for the Business Intelligence Engineer (on-site) role at Asembia

Business Intelligence Engineer (on-site)

Join to apply for the Business Intelligence Engineer (on-site) role at Asembia

Get AI-powered advice on this job and more exclusive features.

Position: Business Intelligence Analyst

Department:Data & Client Reporting

Reports to:Director, Data & Client Reporting

FLSA: Exempt

Primary Function

This role is responsible for data aggregation, data quality, reporting and trending to understand program performance and pharmacy performance. The candidate must demonstrate the ability to query and analyze data and assist end users with understanding and visualizing data. Accomplishes reporting requirements by translating business needs into technical capabilities.

Job Scope And Major Responsibilities

- Translate business needs into technical requirements for the purpose of analyzing and visualizing data.

- Write SQL queries and build reports that pull accurate data from various databases for reporting purposes.

- Design and develop interactive dashboards and reports using Power BI.

- Analyze data, identify trends, implement optimizations on a day-to-day basis, build dashboards and deliver timely reports to support analyses

- Evaluate data and report findings for accuracy, completeness, scope; ability to provide reasoning for data variations or anomalies using Power BI.

- Support pharmaceutical manufacturer client on data needs and insights

- Responsibility for data aggregation from different data sources for report generation

- Identify, investigate, and resolve data anomalies using SQL or other statistical analysis software

- Monitor and process daily reporting and trending needs for various programs

- Ensure that Asembia’s data reports meet program requirements and are delivered in a timely manner by making necessary changes to improve data accuracy

- Successful collaboration with other Asembia team members to attain a common goal.

- Develops reporting solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; following the software development lifecycle.

- Compliance with the provisions of the Health Insurance Portability and Accountability Act of 1996 and its implementing regulations, as amended (“HIPAA”)

- Proficiency in using Python code and knowledge of embedding in .Net framework.

Performance Criteria

This role is evaluated by the accuracy and effectiveness of relevant reporting as well as timely communication with customers and internal teams. Achieving performance targets for individual programs is critical for assessing this role’s performance.

Minimum Qualifications

- Bachelor’s Degree required. B.A./B.S. Information Systems or similar field preferred.

- 3 - 4 years of experience working with pharmaceutical data in a team-driven environment.

- Minimum 4 years of experience working in Power BI and Python is a must.

- Advanced Excel skills (building pivot tables & pivot charts, writing formulas, etc.)

- Advanced skills in PowerBI, building dashboards and drill through reports.

- Proven track record with taking ownership of data investigations and seeing them through to resolution, preferably using SQL Management Studio

- The candidate must have client-facing experience and be able to articulate themselves clearly and concisely in their verbal and written communications

- Excellent presentation and collaboration skills

- Solid understanding and hands on experience with Microsoft SQL tables, views, stored procedures and ad-hoc queries.

Seniority level

- Seniority levelMid-Senior level

Employment type

- Employment typeFull-time

Job function

- Job functionBusiness Development and Sales

- IndustriesPharmaceutical Manufacturing

Referrals increase your chances of interviewing at Asembia by 2x

Sign in to set job alerts for “Business Intelligence Engineer” roles.

Business Intelligence Engineer, Experimentation

Manhattan, NY $110,000.00-$160,000.00 1 week ago

New York City Metropolitan Area $150,000.00-$200,000.00 1 week ago

Brooklyn, NY $120,000.00-$170,000.00 3 weeks ago

Business Intelligence Engineer, Amazon Flex

New York, NY $135,000.00-$180,000.00 1 week ago

Somerset, NJ $93,463.00-$128,512.00 2 days ago

Elizabeth, NJ $70,000.00-$80,000.00 12 hours ago

New York, NY $175,000.00-$230,000.00 2 weeks ago

New York, NY $114,000.00-$171,000.00 2 days ago

New York, NY $165,000.00-$180,000.00 1 week ago

Staten Island, NY $89,600.00-$185,000.00 16 hours ago

Business Intelligence Analyst, Global Research Operations

New York, NY $124,000.00-$176,000.00 1 week ago

New York, NY $120,000.00-$170,000.00 2 months ago

New York, NY $80,000.00-$160,000.00 1 week ago

New York, NY $180,000.00-$230,000.00 2 weeks ago

New York, NY $170,000.00-$240,000.00 4 months ago

Business Intelligence Engineer, Chronicle

New York, NY $89,600.00-$185,000.00 1 week ago

New York, NY $126,000.00-$163,800.00 2 weeks ago

Business Intelligence Developer on Python, SQL (Qlikview) - C71603 6.0 Whippany, NJ

BI/Data Engineer – Supply Chain & Inventory Planning

New York, NY $90,000.00-$130,000.00 4 months ago

New York, NY $90,000.00-$120,000.00 1 week ago

New York, NY $120,000.00-$121,000.00 1 week ago

Jersey City, NJ $126,000.00-$163,800.00 2 weeks ago

New York, NY $125,000.00-$150,000.00 2 weeks ago

New York, NY $132,600.00-$160,000.00 4 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr