Business Intelligence Developer II

ALMAC Group; Lansdale (Montgomery County); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading company is seeking a Business Intelligence Developer II in Lansdale, PA. The role focuses on executing the business intelligence vision, developing in T-SQL, and supporting end users. The ideal candidate has significant experience in data analytics, SQL Server, and customer service skills. This position offers competitive benefits including medical, dental, and 20 days PTO per year.

Benefits

Medical, Vision & Dental benefits

20 days PTO per year

12 holidays per year

Company-paid Long and Short-term disability

401k company contribution

Professional development opportunities

Qualifications

• 5+ years of experience in T-SQL development on SQL Server.
• 5+ years of data manipulation skills in Excel pivot tables.
• 3+ years developing tabular data models.

Responsibilities

• Developing in T-SQL and assisting with Azure and Power BI.
• Supporting end users and defining requirements.
• Writing and maintaining documentation for BI solutions.

Skills

T-SQL

Data Manipulation

Customer Service

Documentation Skills

Education

Bachelor's degree

HS diploma

Tools

Power BI

SQL Server

Excel

Azure

Python

Job description

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.


• Supporting end users, including assistance in defining requirements and manipulating data in end user tools.


• Writing and maintaining documentation for Business Intelligence solutions, including creating functional specifications, translating business requirements into technical requirements, and contributing to data dictionaries.

Qualifications:

Required Education / Experience:

• Bachelor's degree or HS diploma with 5 years of technical experience in 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 supporting end users or in a customer-facing role.


• 3+ years developing tabular data models (JSON, DAX, Mashup, MDX, XML) or experience with analytical 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.


• Exposure to Azure Synapse, Azure Analysis Services, PowerShell, or Python.

Customer Service Skills

• This position involves supporting end users, requiring strong listening and interpersonal skills. The candidate should be patient, understanding, and respectful in all communications.

Documentation Skills

• This role requires producing and maintaining documentation, with the ability to clearly define logic and identify gaps or 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.


• 12 holidays per year.


• Company-paid Long and Short-term disability along with Life Insurance.


• 401k company contribution.


• Hybrid work options available for applicable roles.


• Professional development and continuous learning opportunities.

Follow us on LinkedIn to see our latest job opportunities.

Almac is an award-winning drug development solutions provider with over 50 years of experience, employing over 7,500 personnel worldwide. Our US Headquarters is in Souderton, PA. We are committed to diversity, equality, and inclusion, fostering a welcoming environment for all.

RECRUITMENT AGENCIES: Please note that applications from agencies must be submitted via our portal. Resumes sent directly to managers will be considered unsolicited, with no fee payable.

Almac Group is an Equal Opportunity Employer and provides accommodations for applicants with disabilities. Contact [e-mail] for assistance.