Senior Specialist Business Intelligence
- Other
Are you looking for a dynamic company with daily new challenges and opportunities?
Then, Pharmalex (now part of Cencora) is your next career move! Pharmalex is one of the leading service companies for the Pharmaceutical Industry globally and is specialized in all aspects of drugs and medical devices approval, of the market development and any action of effective product maintenance.
Senior Specialist Business Intelligence
We are seeking qualified BI Specialists to build and verify new data models that will help in decision-making.
You will be responsible for designing, developing, and deploying business analytics dashboards using Microsoft BI technologies, such as the Azure suite of technologies, SQL, Power BI, etc., as well as develop both physical and logical data models.
On top of it, we expect you to take a leading role in evaluating new data warehouse applications, architecture, and technology choices, and maintain plus develop various database scripts and tools to facilitate automation process.
Your Job
- Analyse all data warehouse architecture goals and identify skill requirement for same
- Prepare design for all metadata according to various ETL processes.
- Perform troubleshoot on all ETL processes and resolve issues effectively.
- Define meta data standards for the data warehouse.
- Develop various ETL processes and prepare OLAP cubes (probably in the future).
- Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more.
- Designs and implements highly scalable ETL processes with complex data transformations and data formats including error handling and monitoring.
- Maintains and supports the data model by implementing and managing strategies for tuning and optimization for stability and performance.
- Convert raw data into meaningful analysis with the help of interactive, easy-to-understand dashboards and reports.
- Build automated reports and dashboards with the help of Power BI and other reporting tools.
- Understand business requirements to set functional specifications for reporting applications.
- Be able to quickly shape data into reporting and analytics solutions.
Your Profile
- Very good command of English
- Autonomous, concentrated, and high-quality work
- Ability to work in a team (highly valued)
- Previous experience on international projects
- Agile methodology implementation knowledge
- Capacity to create documentation, technical but functional documents even
- Azure DevOps knowledge
- Knowledge on the following technologies
- MS SQL Server BI Stack
- Power Query
- MDX
- Understanding of PowerBI
- DAX
- DevOps
- Releases
- Pipelines
- Microsoft Azure Ecosystem
- Azure SQL
- Synapse
- Familiarity with Fabric
- SQL DW
- Data Factory
- Azure Data Lake
- Expertise connecting to data sources, importing data, and transforming data for Business Intelligence
- Familiarity with JavaScript, CSS, and other JavaScript libraries
- Sincerity and assertiveness are highly valued.
For further information please don’t hesitate to contact us.
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, creed, national origin, ancestry, sex, age, handicap or disability, marital status, sexual orientation, gender identity or expression, pregnancy or pregnancy-related condition, genetic information, veteran status, immigration or citizenship status, military obligations, status as a domestic violence victim or a victim of sexual assault or stalking, participation in discrimination complaint-related activities, or any other status protected under applicable federal, state or local law.
Address
PharmaLex
Boston, MAIndustry
Technology
Posted date
Create or sign into a ZipRecruiter account, and then apply on the company site¹
You Already Have an Account
We're sending an email you can use to verify and access your account.
If you know your password, you can go to the sign in page.