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
Counterpart is an insurtech platform reimagining management and professional liability for the modern workplace. We believe that when businesses lead with clarity and confidence, they become more resilient, more innovative, and better prepared for what's ahead. That's why we built...
Accounting and Finance
United States
Hiring from: United States
Overview The Title Specialist is responsible for directly supporting the title vendor business needs of the Consumer Direct Channel. Support includes ensuring each title vendor company consistently delivers expectations by assisting Processing, Closing, and Funding managers in day-to-day deliverables by...
Accounting and Finance
United States
Hiring from: United States
The global financial system is undergoing a fundamental and inevitable transformation. The legacy infrastructure, characterized by slow, intermediary-laden processes, is giving way to a new paradigm of programmable, transparent, and real-time value transfer. This shift, driven by the maturation of...
Accounting and Finance
United States
Hiring from: United States