Strategic BI & SQL Analyst for People Analytics

DevsData LLC; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Justjoin is seeking a Business Analyst (BI/SQL) to enhance data analytics for a global pharmaceutical organization. You will translate business needs into technical designs and drive ETL, data models, and reporting through Visier, Oracle, VBA and BI dashboards.

You will validate data with SQL, collaborate with developers, and review dashboards for accuracy. Strong documentation and English communication are required for this role.

Qualifications

• 5+ years in BI/data/analytics environments.
• Strong SQL for validation, analysis, and troubleshooting.
• Experience with BI tools, ETL and dashboards.
• Understanding ETL processes and data warehousing.
• Hands-on with Power BI and Qlik Sense.
• Experience IBM DataStage, Oracle DB, or Azure Databricks.
• Excellent technical documentation and data modelling.
• Advanced English communication.

Responsibilities

• Translate user requirements into technical design documents for ETL flows, data models, and business logic.
• Implement and maintain solutions in Visier, including data ingestion, semantic layer, and security setup.
• Define and document ETL processes in IBM DataStage.
• Define and document data structures in Oracle Database.
• Write SQL queries for data validation, analysis, and troubleshooting.
• Collaborate with developers to clarify requirements and support implementation.
• Support QA and testing with data validation and expected results.
• Review Power BI and Qlik Sense dashboards for accuracy against requirements.

Skills

SQL skills

BI tools

ETL & data warehousing

Data analysis

Technical documentation

English communication

Analytical skills

Education

Degree in Information Systems/Computer Science

Tools

IBM DataStage

Oracle Database

Azure Databricks

Power BI

Qlik Sense

Visier

Job description

Justjoin is seeking a Business Analyst (BI/SQL) to enhance data analytics for a global pharmaceutical organization. You will translate business needs into technical designs and drive ETL, data models, and reporting through Visier, Oracle, VBA and BI dashboards.

You will validate data with SQL, collaborate with developers, and review dashboards for accuracy. Strong documentation and English communication are required for this role.