Senior Enterprise Systems Applications Architect (Reporting)

Berry Corporation (bry) has an opening for a Senior Enterprise Systems Applications Architect (Reporting) who will oversee the complete process of developing and maintaining customized reporting solutions for the company. Key responsibilities include designing efficient reporting solutions, closely collaborating with business stakeholders to comprehend their reporting needs, selecting the appropriate reporting tool to fulfill those requirements, creating and implementing data models, ensuring data accuracy and integrity, and optimizing performance. This role involves active collaboration with Database Architects, Data Engineers, and Business Analysts to deliver on business priorities. Additionally, tasks encompass building new software from the ground up or utilizing low-code applications, analyzing and modifying existing software, and integrating and automating software systems. The role extends to managing the software development life cycle service, with documentation adhering to best practices and standards. Success in this position requires a demonstration of the organization's core values: Stronger Together, Own it, Breed Excellence, Do the Right Thing, and Responsible.

Key Accountabilities

• Works with business and technical stakeholders to understand and document their new and existing reporting needs.
• Leads the design, development, testing, and deployment of reposting tools and software integrations that meet the requirements.
• Designs and analyzes logical data models and collaborates with Data Engineers and Database Administrators to translate them into technical specifications, considering the software service requirements and integrations.
• Reads published technical documentation from software vendors.
• Reuses existing resources when possible, but also researches, evaluates, and prototypes new software components and techniques when needed.
• Provides analysis and specifications of the technical limitations and features of the software, such as load, capacity, security, interoperability, automation, etc.
• Communicates and enforces security requirements for the software, especially identification, authentication, and authorization.
• Provides extended diagnostics and troubleshooting for custom and commercial software and software integrations to resolve problems.
• Reviews and corrects programs across a wide range of different technology platforms and complexities.
• Tests and fixes errors and refines changes to software and databases.
• Coordinates with database administrators, programmers, and analysts to make safe and beneficial changes to software and databases, minimizing negative impacts.
• Coordinates with co-workers to determine the effects of database changes on other systems and staff costs.
• Mentors and coaches less experienced application developers.
• Collaborates with the operational and HSE team to meet area and departmental HSE goals.
• Complies with all the company’s safety and environmental policies, practices, and programs. Takes corrective action within training limits. Escalates as necessary.
• Participates in and adheres to all training programs designed to enhance HSE knowledge, safety standards, and job performance.
• Performs other duties as assigned.

Education and Experience

• Bachelor’s Degree in Computer Science, Information systems, or a related field required
• Minimum 7+ years of experience with reporting tools and/or low-code app platforms such as Power BI
• Minimum 7+ years of experience with ANSI SQL and/or Oracle SQL
• Minimum 7+ years of experience with Data Architecture including experience with creating and maintaining Data Marts, Data Warehouses, Data Lakes, etc.
• Minimum 7+ years of experience with Reporting Architecture

Knowledge, Skills, and Abilities

Critical:

• Effective communication skills with your team, team leader, and other internal and external teams or customers.
• Self-motivation and ability to work independently.
• Leadership skills to guide small technical groups through complex projects.
• Adaptability and willingness to help promote change within the organization.
• Proven analytical and design skills.
• Advanced skills in profiling and modifying programs to increase processing performance (sometimes referred to as “performance tuning”).

Required:

• Advanced computer skills.
• Time management and organization skills to manage multiple competing priorities.
• Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
• Advanced skills in reporting tools and low-code application platforms such as Power BI.
• Ability to mentor and coach.
• Advanced knowledge of relational database concepts and/or familiarity with relational database products such as Microsoft SQL and MySQL.
• Advanced knowledge of OLAP database concepts and/or familiarity with OLAP databases such as Microsoft Analysis Services, Oracle OLAP, Snowflake, Cognos, etc.

Desired:

• Ability to communicate clearly and precisely in writing and speaking to a wide audience across the organization.
• Ability to solve practical problems with different variables and limited standardization.
• Ability to interpret various instructions in written, oral, diagram, or schedule form.
• Ability to develop, organize, and present training to others within the organization.
• Experience in supervising other technical personnel.
• Experience in:
  • Cloud integration and hybrid integration.
  • Oracle Database 11g or later, including PL/SQL.
  • MSSQL 2012 –16, including T-SQL.
  • Version control, subversion specifically.
  • Microsoft Visual Studio.
  • Microsoft PowerShell.
  • Formal SDLC (Software Development Life Cycle),in a Sarbanes-Oxley compliance context.
  • Standard web technologies (html5/css, JavaScript, RESTful, and SOAP services), both server and client sides.
  • Oracle EBS and P2 EU.
  • Oracle Essbase.
  • Oracle APEX.

• Fundamental knowledge of business financials.
• Experience in Oil and Gas industry.

Compensation & Benefits

The pay range for this position in California is between $135,960 to $161,453 annually based on a full-time schedule.  Please note that the annual salary information is a general guideline, and that annual salary will vary depending on your location and that Berry Corporation (“Berry”) will consider factors such as (but not limited to) scope of responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as market and business considers when extending an offer.  This position is eligible for short-term cash incentive bonus and long-term incentive bonus, excellent benefits including full health benefits, 401(k) with company match and immediate vesting, tuition reimbursement, 9/80 flex schedules, and generous paid time off.

Equal Employment Opportunity Statement

Berry Corporation is an equal opportunity employer. All qualified applicants will receive consideration for employment 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 and will not be discriminated against on the basis of disability.

LINK to Equal Employment Opportunity Posters:  https://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm

Reasonable Accommodation Notice

If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact Human Resources at 661-616-3900 or HR@bry.com.

Pay Transparency Notice

Berry Corporation (“Berry”) will not discharge or in any other manner discriminate against an applicant or employee because they have inquired about or discussed compensation.

Notice to Third Party Agencies

Please note that Berry Corporation (“Berry”) does not accept unsolicited resumes from recruiters or employment agencies. In the absence of a signed Recruitment Agreement, Berry will not consider or agree to payment of any referral compensation or recruiter fee. In the event a recruiter or agency submits a resume or candidate without a previously signed agreement, Berry explicitly reserves the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted to hiring managers, will not be reviewed or considered in part of the application process.