SQL Data Engineer

BPM Overview:What does BPM stand for? Innovation, opportunity, community, diversity, inclusivity, flexibility and so much more.
B-P-M stands for “Because People Matter,” because at our core, our people drive everything we do and how we do it. 
We are a forward-thinking, full-service accounting firm providing modern solutions to businesses across the globe. We focus on comprehensive assurance, tax, and consulting services for our clients, and we provide our people and our community with the resources to lead meaningful and purposeful lives.
While we are one of the largest California-based accounting firms, our flexible work locations and schedules mean we have professionals across the continent. Our teams and our clients drive us to provide quality services and ignite unique insights and ideas that contribute to our continued success. Our clients come from different backgrounds and industries, which keep our people intellectually challenged every day.
Our initiatives and ideals lead to our continued recognition as one of the “Best Places to Work” in the Bay Area and beyond. We are dedicated to providing meaningful careers for all of our employees along with fostering an environment that allows an integrated lifestyle. Our flexible culture allows our professionals to live a balanced lifestyle between their work responsibilities and personal commitments.
Job Responsibilities:-      To gain intimate knowledge of STAR data structures and code (stored procedures, functions, and triggers).-      To understand reports that STAR has developed for BPM and be able to modify existing or create new ones.-      Understand current pain points with STAR, research daily issues and work with STAR engineers to resolve them.-      Learn BPA system within STAR.  Be able to modify and create alerts and other aspects of it using STAR SQL Databases including modifying Stored Procedures.-      Work closely with the Integration framework and be able to assist other developers in implementing integration modules.-      Oversee STAR new releases and analyze compatibility with existing code and systems.-      Take over regular update procedures currently performed by STAR such as Budget and Rates updates.-      Creating and running ad-hoc SQL Queries of various complexity.-      Assist with technical training and documentation on newly released STAR modules.
Qualifications / Skills:-      Profound knowledge of RDBMS data design principles.-      5-7 years of working with MS T-SQL writing queries and stored procedures.-      Experience performing root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement.-      Strong analytic skills related to working with structured and unstructured datasets.-      Expert knowledge of SQL queries performance, scaling, and optimization.-      3-5 years of working experience with SQL Server Reporting Services and SSRS.-      Solid experience working with SSMS or similar Integrated environments.-     Excellent communication skills.
Highly Desired:-      Experience with Azure SQL DB.-      Familiarity working with .Net Framework, .Net Core, C#.-      Development experience in working with Accounting Systems and Industries
Note:STAR will assist with all aspects of initial training related to their structures and systemsWondering if you should apply?
BPM is powered by knowledgeable, enthusiastic, and forward-thinking people committed to developing a culture of inclusion. We recognize, develop, and empower talent and encourage diversity of thought. Your point of view, skillset and experience will only make us stronger, so if you're eager to share new ideas and try new things, we want to hear from you.
***************
BPM provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
For positions based in San Francisco, consideration of qualified candidates with arrest and conviction records will be in a manner consistent with the San Francisco Fair Chance Ordinance.
Please note - this posting is for prospective candidates only. Unsolicited third party resume submissions will be considered property of BPM and will not be acknowledged or returned.