IT Financial Business Intelligence Developer; Hybrid

Description

The IT Financial Business Intelligence Developer role is primarily responsible for developing business intelligence reports in SSRS. The IT Financial Business Intelligence Developer is also involved in querying, cleansing, troubleshooting, and migrating data. The professional in this role will work productively in a collaborative environment, using data analytic skills in an investigative capacity. 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.

• Develop and maintain stored procedures, functions, and views to facilitate reporting.
• 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.
• 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.
• In collaboration with others, 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.
• Interpret data and develop recommendations based on findings.
• Special projects and additional duties as assigned.

• Minimum 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 (SSIS or similar)
• Data Warehousing and Data Marts
• Multidimensional OLAP reporting (SSAS or similar)
• ETL processes (SSIS or similar)

• Bachelor’s degree in Information Systems, Information Technology or related field.
• Microsoft Certifications and/or completed coursework in Business Intelligence.

Our goal is to promote a work environment in which individuals have access to the resources they need to be their best both professionally and personally, which includes resources that encourage individuals to focus on their health and well-being.

Below is a list of just some of the benefits we offer: comprehensive medical (PPO and HDHPs), dental and vision plans including coverage for domestic partners; life and AD&D insurance; short and long term disability insurance; tax-advantaged accounts for health care expenses, including FSAs and HSAs; FSAs for dependent care; health advocacy services; behavioral health and counseling resources for all family members;

401(k); profit sharing; pre-tax transit and parking program; backup dependent care; senior care planning support; resources for individuals with development disabilities and their caregivers; and paid holidays and other paid time off, including paid leave for new parents.