Business Intelligence Developer
Mortgage Connect, LP
Full time
Accounting and Finance
United States
Hiring from: United States
Job Duties
- 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 ad-hoc 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, execution plans and statistics;
- Designing and developing dashboards, scorecards, charts, pivot tables, reports, and reporting systems according to business requirements;
- Delivering ad-hoc 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.
- Bachelor's 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, T-SQL, PL/SQL, MS-SQL 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.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
We’re searching for a Senior Insurance Advisor . Are you searching for new possibilities? Westland Insurance Group Ltd. has an exciting opportunity for a Senior Insurance Advisor for the MyGroup BC division to support the team fully remotely. Do you...
Accounting and Finance
Canada
Hiring from: Canada
We are currently hiring for multiple positions, including roles within the non-profit and finance industries. Are you a dynamic, caring and ridiculously talented executive assistant? If so, Boldly is looking for you! We are seeking full-time employees to support established...
Accounting and Finance
United States
Hiring from: United States
Exodigo is the leading underground mapping solution for non-intrusive discovery. Our platforms combine multi-sensor fusion, 3D imaging, and AI technologies to create complete, accurate underground maps that enable confident decision-making for customers across the built world. We transform the project...
Accounting and Finance
United States
Hiring from: United States