Product Analyst

Who we are: BAL is a team of brilliant people who change lives through elite immigration work and collaborative innovation. We pursue the exceptional in all that we do, but never at the expense of our values. There’s no denying our work is demanding, both in volume and pace, but we’re up for the challenge. We love the balance of hard work and fun – so, you’ll see us in jeans as we shatter glass ceilings and conventional stereotypes. BAL employees feel valued, rewarded, and respected. We seek opportunities to be of service to others and our communities. We are committed to your growth and development, and want to set you up for success here at BAL and beyond.

Who you are: You are looking for work that has a purpose. You aren’t afraid to roll up your sleeves and get stuff done. You learn quickly. You move fast. You embrace challenge and detail as well as creative thinking. You believe you have something unique to contribute and you aren’t afraid to raise your hand. You understand that powering human achievement is ultimately about impacting a real person. You are looking for a place to grow and an environment where everyone has a spot and is genuinely welcome.

We’re better together: A bright, driven person like you and an industry-leading powerhouse like BAL? It’s a perfect combination! We truly want to see you succeed here and become an integral part of our mission to provide an experience that makes a positive difference in people’s lives. Come be a part of something special, where you can have an impact and be valued just for being you!

In addition to competitive pay, a discretionary annual bonus, and a supportive, team oriented culture, we offer an outstanding benefits package that includes medical, dental, vision, disability, and life insurance, sick time, unlimited vacation, and 401(k) with company match.

OVERVIEW: The Product Analyst is responsible for analyzing and modeling existing business processes to understand and document current business procedures, identify areas for improvement, and define those areas for engineering to improve. The incumbent will identify best practices and suggest ways to improve current practices within BAL’s proprietary software and Salesforce platform solutions. Develops recommendations to solve problems and issues related to business operations within the product(s), including Salesforce-enabled processes, data flows, reporting, and user adoption..

______________________________________________________________________________________

PRIMARY RESPONSIBILITIES (Under the supervision of the Product Manager):

• Partners with Salesforce administrators, developers, product managers, and business stakeholders to support Salesforce enhancements, testing, release readiness, and adoption.
• Uses modeling tools to document the current state of business processes as well as the desired future state.

• Creates detailed Business Requirement Document (BRD) and translate it into functional specifications.

• Responsible for the knowledge transfer of business implications to the application/database developers and project managers.

• Performs feasibility analysis, scopes projects, and works with the product management team to provide input for prioritizing product functionalities.

• Provides analytic support by coordinating data extraction from various databases and data interpretation and trend analysis.

• Provides business process, system support and data quality governance for master data through data coordination and integration to ensure efficient processes and consistent data flows to business and stakeholders.

• Gathers, documents, and translates business requirements into Salesforce functional specifications, including configuration needs, workflows, reports, dashboards, and integration considerations.

• Identifies and implements process improvements in relation to master data processes.

• Communicate with external and internal clients on their data reporting needs.

• Creates product documentation, such as release notes, diagrams for how data is modeled, and spreadsheets for how objects/functionality are connected in the backend of the product(s).

• Evaluates tools and manages implementation projects with 3rd party software vendors (related to the product or product management team).

SECONDARY RESPONSIBILITIES (Under the supervision of the Product Manager):

• Supports Salesforce user acceptance testing, including test script development, defect tracking, validation of configuration changes, and coordination with business users.
• Leads Integration Testing, User Acceptance Testing (UAT – including writing scripts and environment setup), and Functionality Testing.

• Reports bugs found in product(s) through the appropriate channel.

• Has the ability to demo the product(s) and explain product functionality.

• Categorizes and catalogues product feature/functionality requests that come in from business users and/or clients.

• Efficiently manages multiple projects with competing deadlines.

• Other duties as assigned

______________________________________________________________________________________

QUALIFICATIONS:

Skills and Abilities:

• Experience working with Salesforce CRM capabilities, including requirements gathering, process mapping, reports and dashboards, data quality, user acceptance testing, and stakeholder support
• Strong SQL programming experience with Microsoft SQL Server 2008 R2 including experience writing stored procedures and defining views

• Experience developing customized reports using a tool like SSRS or Crystal Reports is a must

• Expertise in the use of Microsoft applications; specifically Excel, Access, Visio and Project

• Excellent project management skills

• Experience with web analytics tools like Google Analytics, Omniture or Mixpanel

• Knowledge of statistical analysis techniques such as correlation, regression and time-series analysis

• Ability to work independently and in a collaborative team environment

• Excellent written, verbal, and interpersonal skills

Physical Requirements:

• Able to maintain a sedentary position for up to 90% of the work day

• Able to type and to grasp, grip, push and pull file drawers and doors

• Able to walk and climb stairs or use elevator to coordinate with other departments

• Able to bend, stoop, kneel and/or stand to access files and documents

• Able to lift up to 25 lbs of files and/or boxes

Experience:

• 3 – 5 years of experience working as a Product Analyst, Business Analyst, or Data Analyst
• 3+ years of customer interfacing experience – project oversight, customer presentation.

• 3+ years SQL Server 2005/2008 knowledge – T-SQL, Tables, Views

• Experience working with data mart, data warehouse, or OLAP cube is preferred

• Experience using SharePoint is preferred

• Experience supporting Salesforce implementations, enhancements, or administration is preferred

Minimum Education Level:

• Bachelor’s degree in Information Technology, Mathematics, Statistics or equivalent discipline

Note: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required and are not intended to be an exhaustive list of all duties, responsibilities or qualifications associated with this job.

Berry Appleman & Leiden is an Equal Opportunity Employer. It is the policy of BAL to ensure an equal employment opportunity without discrimination or harassment on the basis of race, color, national origin, religion, gender, gender identity or expression, age, disability, alienage or citizenship status, marital status, creed, genetic predisposition or carrier status, sexual orientation or any other characteristic protected by law. BAL prohibits and will not tolerate any such discrimination or harassment.

BAL does not accept unsolicited resumes from recruiters or employment agencies. BAL is under no obligation to pay any referral compensation or recruiter fee in the absence of a current executed Recruitment Services Agreement. In the event a recruiter or agency submits an unsolicited resume or candidate without an agreement, BAL reserves the right to pursue and hire said candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted to hiring managers, shall be deemed the property of BAL. If your agency would like to be considered as a potential recruiting partner, please forward your contact information to [email protected].