Business Intelligence Developer (Information Technology)
:
: - This position is located onsite in Hatfield, Pennsylvania*
Basic Function Participate as a Business Intelligence Developer to enhance our data analytics capabilities in Power BI and manage our data warehouse. Data warehouse management will consist of SQL server administration and ETL development (Currently SSIS). Must be comfortable working with non-IT colleagues to understand their requirements and translate them to technical specifications. Essential Duties and Responsibilities - Manage and Maintain the Datawarehouse platform including its ETL processes and ensure a high level of user satisfaction.
- Collaborate with non-IT professions to capture requirements and translate them into meaningful Power BI reports.
- Troubleshoot data related issues by working with both IT and non-IT professionals to determine the root cause and provide solutions.
- Utilize advanced Power BI tools such as Dax, Power Query, and Python.
- Write and optimize complex SQL queries.
- Lead efforts to migrate reports done in QlikView and other tools to Power BI.
- Research and encourage the use of modern BI tools such as Azure Data Factory and Fabric.
- Establish a governance model for our Power BI workspaces, data sources, and on-premises data gateways.
- Monitor and maintain our Microsoft SQL server environment (6 servers).
- Assist application developers with troubleshooting SQL related issues in other applications.
- Ensure our data is safe by implementing security best practices in both Power BI and MS SQL Server.
Education and Experience - BS in Information Systems or Computer Science
- 3 - 5 plus years of experience required.
- Extensive hands-on experience with Power BI
- Proficiency in SQL.
- Experience managing Microsoft SQL Servers.
- Experience designing data processes including loading, transformations, mapping, etc.
Recommended Jobs
Staff Accountant
Job Description Job Description About the Role We’re seeking a detail-oriented Staff Accountant to join our growing public accounting team. This role is ideal for someone with 3—5 years of exp…
Senior Clinical Trial Associate
Cambridge (England) Senior Clinical Trial Associate to start ASAP! ICON plc is a world-leading healthcare intelligence and clinical research organization. We’re proud to foster an inclusive environ…
PA Facilities Maintenance
Position Summary: Primary responsibility is to assist the maintenance team and with maintaining outdoor spaces. This role involves performing various landscaping tasks to ensure that lawns, gardens…
CNC Programmer, Operator
Job Description Job Description We are searching for machine operators and programmers who can operate and make adjustments to haas lathes or Haas tmp2 mills. You will be responsible for keeping …
Senior Analyst, Paid Social
Description Position at CMI Media Group Senior Analyst of Paid Social - Lead Digital Excellence! Ready to take charge and steer brands toward digital excellence? Here's your chance to shine an…
Armed Security Officer
Job Description Job Description:\n\nAbout Bering Straits Professional Services Bering Straits Professional Services (BSPS) is committed to world-class management of global logistics, training and …
Occupational Therapist
Summary The VISN 4 Eastern Market is comprised of five VA Medical Centers: Coatesville - Lebanon - Philadelphia - Wilkes-Barre & Wilmington. These facilities work with VISN/Market stakeholders to …
Electrical Instrumentation Designer - Energy
About Us At Larson Design Group (LDG), we’re more than an award-winning Architecture, Engineering, and Consulting firm; we’re a team of passionate professionals united by a bold purpose: creativel…
Instructional Aide (IA) $26.50/hr Virtual & In-Person
Job Description Job Description Salary: $26.50 per hour LETS Therapy | Multiple Openings | 20252026 School Year Did you know? Instructional Aides are the backbone of classroom success. LE…
Travel Licensed Practical Nurse
Job Description Job Description Travel Licensed Practical Nurse Location: Pennsylvania Schedule: Full-time (5 days per week) Salary: $40,000 - Based on an average of 38 patients seen per…