BI Developer/Database Administrator - PBMares, LLP

PBMares is a leading accounting and business consulting firm serving the Mid Atlantic, as well as specialty areas nationwide and internationally. With over 270 employees in Virginia and Maryland, we are a full-service accounting and advisory firm with a strong reputation for integrity and ethical leadership. We are also a firm that has experienced uninterrupted growth throughout our 50-year history. Since 2016 we have earned the honor of being named as one of the nation’s Top 100 accounting firms by INSIDE Public Accounting, the leading public accounting publication. With so much to offer professionals at all experience levels, PBMares is one firm you definitely want to get to know when you are ready to move forward in your career.

We are in search of a BI Developer/Database Administrator to function as the resident database and reporting services Subject Matter Expert. This role will also interact with internal stakeholders to understand data reporting/analytics needs, collect requirements, data transformation, and build business intelligence and reporting solutions. This role will be located in Newport News, Virginia, and reports to the Chief Information Officer (CIO).

Core Responsibilities

•  Analysis, relational database design, data integration, and reports/dashboards development and management using reporting and analytics tools including, but not limited to, SQL Server, TSQL, SSIS, SSRS, Power Query and Power BI
•  Perform DBA duties including support of schema design, ETL, monitoring and administration of batch jobs, and monitoring database usage.
•  Makes recommendations for standardized processes, methodologies, and applications to collect, store, process, and analyze data and meta-data
•  Design and development of standard and complex reports focusing on the delivery of operational and insights-based reports.
•  Develops scripts for database maintenance jobs to write the extraction, transformation, and load (ETL) or data transformation services (DTS) tasks required for ETL development primarily in a SQL environment.
•  Configures and maintains databases and their servers both in development and production including capacity planning, updating, troubleshooting, access management, performance management, and disaster recovery 
• Develops technical specifications and business requirements documents pertaining to BI and data analytics needs.
• Manages interface with database vendors for technical support and works with vendors on consultative design projects
• Provides training and support to users related to databases, user interfaces, reporting and analytics tools (Practice Engine, Power BI, and SQL)
• Designs, develops and supports new and existing data warehouses
• Support any future firm projects as it relates to database and reporting solutions
• Collaborate with Information security and advise/maintain data classification standards and data management guidelines/procedures.
• Collaborates and communicates regularly and effectively with team members

Job Requirements

•  At least 4 years working with SQL Server managing databases, developing complex queries/reports, and 2 years of ETL experience.
• Experience and working knowledge of TSQL, SSIS, SSRS, SQL
• Strong knowledge of design, development, and implementation of APIs for system and data integration.
• At least 3 years’ experience in database performance tuning and query optimization
• experience with advanced and complex data reporting tools including Power Query, Power BI and similar data analytics tools
• Bachelor’s Degree in Computer Science, Information Science, or related field or an acceptable combination of education, training, and experience
• A minimum of 5 years’ worth of relevant experience
• Solid understanding of APIs
• Strong knowledge of business process knowledge
• Reliable, accessible and able to work under pressure
• Ability to work on multiple projects with multiple deadlines
• Ability to adapt to change and learn new skills quickly
• Ability to work independently and with minimum supervision under a system of discipline and accountability
• Expert analytical and problem-solving skills
• Exceptional customer service orientation
• Able to work with people of varied technical\non-technical backgrounds and management levels
• Technical writing and documentation experience

Our Firm’s policy is to provide equal opportunity for employment to all individuals regardless of their race, color, religion, sex, national origin, age, genetic information, disability, veteran status, sexual orientation, gender identity, or any other characteristic protected by federal, state, or local laws.

We are proud to be an EEO/AA employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing.

This contractor and subcontractor shall abide by the requirements of 41 CFR 60-741.5(a).  This regulation prohibits discrimination against qualified individuals on the basis of disability and requires affirmative action by covered prime contractors and subcontractors to employ and advance in employment qualified individuals with disabilities.

Must be authorized to work in the United States permanently without the requirements of sponsorship at any point in the future.