Business Intelligence Developer

Mortgage Connect, Lp - Coraopolis, PA

Full-time - Mid Level

Remote - Coraopolis, PA

Credit Intermediation and Related Activities

About the position

The Business Intelligence Developer will engage with various business units to assess their reporting and analytic needs, participating in all phases of the development life cycle. This role is crucial for gathering requirements, defining solutions, and developing effective reporting and analytic solutions that align with business objectives, fostering user trust in the BI group's capabilities.

Responsibilities

• Communicate with all lines of business to determine their needs and define the most appropriate BI solutions.
• Document requirements and build reports according to those requirements.
• Design and develop dashboards, scorecards, charts, pivot tables, reports, and reporting systems according to business requirements.
• Deliver ad-hoc reports under tight deadlines, as needed by the business.
• Determine required Microsoft business intelligence components (SQL, SSRS, SSIS, Power BI, Excel…) to meet reporting requirements.
• Work with business analysts and other developers on design of technical solutions.
• Estimate technical effort required to deliver assigned tasks.

Requirements

• 5+ Years Work Experience in BI Development Role
• Analyze complex problems and move them quickly to resolution
• Self-Motivated: Ability to Work with Minimal Supervision
• Excellent Verbal and Written Communication Skills
• Fluency with Microsoft SQL is a must.
• Build SSRS reports using parameters, conditional formatting, and grouping.
• Create Power BI dashboards by joining multiple data tables.
• Ability to write complex SQL queries, stored procedures, views, and functions with an understanding of performance factors such as indexes, execution plans and statistics.
• Advanced Microsoft Excel knowledge
• Microsoft SQL Server, SSRS, SSIS, (SSAS, PowerApps, and Microsoft Flow a plus)
• Azure Synapse (preferred)
• Ability to combine multiple datasets using PowerBI
• Handle and maintain the confidentiality of highly sensitive information.

Nice-to-haves

• Experience with SSAS, PowerApps, and Microsoft Flow
• Familiarity with Azure Synapse

Benefits

• Flexible work environment
• Remote work options
• Equal Opportunity/Affirmative Action employer