Business Intelligence Developer
Business Intelligence Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Overview
Responsibilities
- Communicating with all lines of business to determine their reporting and analytics needs and defining the most appropriate business intelligence (BI) solutions;
- Participating in all phases of the development life cycle and gathering requirements defining solutions and ultimately developing a useful end product;
- Documenting business requirements and building reports according to those requirements;
- Analyzing designing developing and implementing Data Warehouse and Database applications using Microsoft SQL Server;
- Developing adhoc SQL queries SSRS reports and dashboards;
- Building SSRS reports using parameters conditional formatting and grouping;
- Creating Power BI dashboards by joining multiple data tables;
- Writing complex SQL queries stored procedures views and functions with an understanding of performance factors such as indexes plans and statistics;
- Designing and developing dashboards scorecards charts pivot tables reports and reporting systems according to business requirements;
- Delivering adhoc reports under tight deadlines as needed by the business;
- Determining required Microsoft business intelligence components (SQL SSRS SSIS Excel) to meet reporting requirements;
- Creating various Complex reports including drill down drill through and Sub reports;
- Working with business analysts and other developers on design of technical solutions; and
- Estimating technical effort required to deliver assigned tasks.
Qualifications
- Bachelors Degree in a Computer Science Information Systems Electrical Engineering or a related field and experience training or coursework creating complex Stored Procedures writing SQL Queries creating Pivot and Unpivot Tables Common Table Expressions (CTE) Aggregate Conditions Drill through reports and Drill down reports; and
- Experience training or coursework using SQL TSQL PL/SQL MSSQL Server SSRS SSIS ETL Visual Studio MS Office Tools BIDS Joins and Materialized Views.
- Company headquarters is located in Moon Township PA but telecommuting is permitted from anywhere in the United States.
All onboarding employees will be required to complete apreemployment background check and drug screening.
We are an Equal Opportunity/Affirmative Action employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation age national origin disability protected veteran status gender identity or any other factor protected by applicable federal state or local laws.
Employment Type
Full-Time
