Business Intelligence Developer II

Almac Group is currently seeking a Business Intelligence Developer II for our Lansdale, Pennsylvania location. The Business Intelligence Developer’s primary focus is to execute the business intelligence vision for Almac’s Clinical Technology’s business unit.
Responsibilities include but are not limited to:
  • Developing in T-SQL, Analysis Services tabular models, and assisting with the planning and “lift and shift” into Azure and Power BI.  Performing analysis on large and diverse data sets.
    • Tasks to include: writing code in various programming languages, performing analysis, action-ing technical tasks as directed, report and data modeling, participating in design discussions
  • Supporting end users, including assistance in defining requirements and manipulating data in end user tools.
    • Tasks to include: answering support questions from end users, troubleshooting, contributing to scope/planning for upcoming sprints
  • Writing and maintaining the documentation for Business Intelligence solutions.
    • Tasks to include: creating functional specifications for Business Intelligence solutions, translating business requirements into technical requirements, contributing to data dictionaries. 
Required Education / Experience:
  • A bachelor's degree OR HS diploma and 5 years technical experience in the area of business intelligence, data analytics or software development
  • 5+ years of experience in T-SQL development on SQL Server
  • 5+ years of data manipulation skills in Excel pivot tables
  • 3+ years of experience supporting end users or similar customer-facing role
  • 3+ years of experience developing tabular data models (JSON, DAX, Mashup, MDX, XML) OR experience with analytical (de-normalized) data warehouse development
Preferred Education / Experience:
  • Microsoft Certification in SQL Server, Business Intelligence, or Power BI
  • 2+ years working with Power BI
  • 2+ years working in an agile environment
  • Prior exposure to Azure Synapse, Azure Analysis Services, PowerShell, or Python

Customer Service Skills

  • This position involves supporting end users. It requires listening and interpersonal skills. The successful candidate will be patient, understanding, and respectful in all written and verbal communication.

Documentation Skills

  • This position will produce and maintain documentation. It requires the ability to define logic clearly and explicitly in user-friendly terms, and the ability to identify gaps and errors.

What can Almac Group offer you?
  • Medical, Vision & Dental benefits from the 1st of the month following start date
  • 20 days PTO per year, accrued monthly following start date
  • 12 holidays per year
  • Company paid Long and Short-term disability along with Life Insurance
  • 401k company contribution
  • Hybrid work available for applicable roles
  • Professional development programs/ continuous learning opportunities
Want to see our latest job opportunities? Follow us on LinkedIn
Almac is an exceptional, award winning, drug development solutions provider at the forefront of the pharmaceutical industry.  We are a privately owned organization that has organically grown over 50 years now employing 7,000 highly skilled personnel worldwide. Our US Headquarters is located at Souderton, PA with additional operations scattered around the US and Europe. ‘Partnering to Advance Human Health’ is more than just a tagline – it is our way of life.
Embracing diversity is at the heart of enhancing Almac Group’s unique culture and reflects our fundamental belief that all people deserve equality, inclusivity and the opportunity for advancement. We are committed to cultivating a welcoming, supportive, and inclusive environment for all.  Together, we will build on the strength in our diversity and deliver exceptional solutions to advance human health globally.
RECRUITMENT AGENCIES PLEASE NOTE: Almac will only accept applications from agencies/business partners that have been invited to work on this role through our portal. Candidate Resumes/CV’s not submitted through our portal or directly to Hiring Managers will be considered unsolicited and no fee will be payable. Thank you for your cooperation.
Almac Group, Inc. is an Equal Opportunity Employer - Minorities/Women/Protected Veterans/Disabled - Proudly embracing diversity in all of its expressions.
Almac provides reasonable accommodations to people with disabilities who need assistance completing the application process.  Please email us at [email protected] to request assistance.

Similar positions