SQL BI Developer

Job Summary:

The IT Financial Business Intelligence Developer is primarily responsible for developing business intelligence (BI) reports in SSRS, and the technical design and support of the BI infrastructure. The role is also involved in querying, cleansing, troubleshooting, and migrating data. The incumbent in this will work productively in a collaborative environment, using data analytic skills in an investigative capacity to provide direct support to Attorney Practices. This position is currently a hybrid role with specific days required to be in the office, which may change based on the future needs of the firm or industry standards.

Key Responsibilities and Essential Job Functions:

• Develop and maintain stored procedures, functions, and views to facilitate reporting.
• Design and develop dashboard reporting for Attorney Practice Groups
• Acquire and abstract primary or secondary data from existing internal or external data sources.
• Perform ad hoc queries and assists in the development of reports based in response to internal and external requests using Microsoft SQL Server and SQL Server Reporting Services
• Develop and maintain databases and data systems necessary for projects and department functions.
• Develop and implement data collection systems and strategies that optimize data quality.
• Provide technical guidance and support to junior level BI Developers
• Interpret data and develop recommendations based on findings.
• Review data for the purposes of identifying errors and anomalies.
• Resolve problems related to inconsistencies and irregularities in data.
• Prioritize and manage multiple tasks.
• Analyze and solve problems logically.
• Communicate effectively regarding assigned tasks.
• Provide excellent customer service to internal and external Customers.
• Special project and duties as assigned.

Required Qualifications & Education:

• Bachelor’s degree in business Analytics, Information Systems, Information Technology or related field

3-5 years of related experience with:

• SQL-Server database development (database design, stored procedures, triggers, etc.)
• Microsoft SQL Server Reporting Services
• Transact-SQL
• ETL processes
• Data Warehousing and Data Marts

Preferred Qualifications & Education:

• Master’s degree in business Analytics, Information Systems or Technology preferred.
• Multidimensional OLAP reporting (SSAS or similar) preferred.
• Microsoft Certifications and/or completed coursework in Business Intelligence preferred.