Business Intelligence Data Warehouse Developer

Location: Pittsburgh, PA

Job Type: Full Time / Permanent

The ideal candidate will have strong knowledge of Database, BI, Data warehouse and a good understanding of web development. Responsible for enhancing, maintaining and modernizing the firm’s proprietary portfolio of custom financial applications and data visualization initiatives. This person will be responsible for helping to develop and maintain custom systems, data integrations and reports in support of various legal practice groups, staff departments and system integration efforts (both legal specific products and large enterprise systems). The Developer must possess the skill-sets necessary to hit the ground running. Must be able guide other developers in team in use of new development tools and technologies.

Responsibilities:

  • A minimum of three years of relevant experience in BI development, reporting and customization
  • Advanced SQL Server development skills – Development of Transact SQL stored procedures and functions, Troubleshooting and Performance Tuning & Data Modelling and Analysis
  • Database design, development, and data warehousing utilizing SQL. Migrate, convert, import / export data to and from SQL databases.
  • Assist in data architecture and data technical design for our financial accounting system (Elite 3E).
  • Experience with data analysis, modeling, creating technical documentation
  • Able to assist in building data structures that are consistent, maintainable, flexible, and cost effective.
  • Develops SQL, T SQL, views, stored procedures, and scripts to deliver database components as required.
  • Participate in SQL reviews, performance profiling and performance tuning recommendations.
  • Contribute to the overall design of our solutions with a focus on scalability, maintainability and performance.
  • Identify and communicate development best practices at a code and project level within the development team. Help educate, mentor new and existing staff members in techniques, methods, policies, and best practices in coding.
  • Identify improvements where necessary to existing procedures and practices related to application development.
  • Take ownership of particularly confidential, high-profile, or otherwise sensitive projects, users, and requests, keeping the Business Applications Sr. Manager or other personnel up to date as appropriate.
  • Provide second/third-level support for custom and third-party applications supported by the Business Applications team.
  • Excellent written and verbal communication skills
  • Identify improvements where necessary to existing procedures and practices related to application development
  • Work with other teams to develop efficiencies in existing firm processes through the use of application automation and integration
  • Remain current on relevant technologies and industry standards through networking, as well as formal and informal training/education
  • Provide off-hours and weekend technical support as required

Education & Experience:

  • Bachelor’s Degree in computer-related field. Additional training, education, and/or certification in relevant areas preferred.
  • Over all of 5-7 years of IT Applications development experience.
  • At least five years of experience utilizing Microsoft development environments, ASP .NET, VB.NET or other OO development language.
  • Experience with Windows server, a strong familiarity with Microsoft IIS, relational database design, SQL Programming including stored procedures
  • Analyzing and programming large and complex financial data sets
  • 2+ years of strong SQL (MS SQL); experience in writing complex ETL packages
  • 2+ years of experience in financial report writing (SSRS Preferred)
  • 2+ years of experience with data analysis, modeling, creating technical documentation
  • Excellent understanding of relational database concepts, impact of various design on performance
  • Strong experience with data warehousing concepts and data modeling best practices
  • Demonstrated a strong ability to provide effective solutions for complex problems and requests
  • Excellent written and verbal communication skills
  • Able to perform well with very limited supervision and adhere to tight deadlines
  • Able to effectively interact with individuals at all organizational levels and adapt to changing timelines and requirements
  • Preferred:
    • Strong Experience in report writing (SSRS Preferred)
    • Strong SQL knowledge (MS SQL preferred)
    • Experience with legacy ASP.net and classic ASP custom applications
    • Experience working within an Agile development environment
    • Experience with Tableau visualization or similar BI tool and dashboard construction
    • Experience with Snowflake Data warehouse & Azure Data Factory is a plus
    • Experience developing client server & web applications. Web programming (HTML 5)
    • Experience with SSAS a plus
    • Experience within the Legal industry is a plus
    • SSIS will be a plus but is not required
APPLY NOW