Analytics Engineer - Accounting
Our Data & Business Analytics team works in the Branch Data Office to manage Branch's data environment and its supporting infrastructure. They unearth data stories and enable leaders to make informed data-driven business decisions that impact Branch's short and long term growth.
The Branch Data Environment
Branch has a unique approach to data and business analytics that makes them differentiated in the market. All data is carefully managed through an ETL tool into a cloud data lake. Branch is in the process of implementing a third party software to provide version control and automated testing support for maintaining SQL scripts that organize and process information within the data lake. The data team then shepherds the organization, documentation, and visualization of the data for end users to utilize. Use cases range from core Accounting / Finance infrastructure, daily KPI reporting in all business units, automation implementation, and core data product feature enablement. Data analysts work with departments to process requests, drive insights for the business, and build out many of the use cases from the data lake through end deliverables. Product managers work adjacent to the architects and analysts to shepherd requests from end users and ensure that the end result of requests are being achieved.
About the Analytics Engineer - Accounting role
The position will report directly to the Branch Data Office organization. You will work with the Accounting Department and be responsible for supporting the development, maintenance and reinvention of a variety of business intelligence tools, reports and automation necessary to support self-service within Branch Accounting.
This analyst will be responsible for all of the development tasks associated with data analytics and process automation. Analysts are de-facto querying experts expected to have a good understanding of all relevant data structures needed to monitor behaviors and identify trends for Accounting. Selecting appropriate data sets and assuming full ownership of the process to develop dashboards, easily digestible data visualizations and other reports to support a data driven operation are key responsibilities of this role.
This role will be assessed for level within the Data Analyst vertical based on experience.
Key Responsibilities
- Developing and maintaining dashboards, visualizations and other forms of ad-hoc reporting necessary to support truly data-driven business strategies.
- Troubleshooting, diagnosing and fixing issues within existing tools.
- Assist with automation design and problem-solving for Accounting and cross departmental intersections.
- Becoming a subject matter expert with a deep understanding of our Accounting data architecture and the different data sets we rely on to support the business intelligence needs for a fast paced department.
- Supporting and often owning the execution of all steps in our data analytics pipeline. (Data capture, data lake construction, data visualization and overall business analysis)
- Validating data and following best practices to guarantee quality, compliance and a positive experience for end users.
- Making recommendations to create an environment where ongoing optimization is an organic part of our development processes.
Skills, Knowledge, and Expertise
- We are willing to invest in your development and help you grow along with the rest of the team. We are truly looking for someone with a strong technical background and a passion for continuous learning and continuous improvement.
- Statutory and GAAP Accounting exposure
- Strong basis in SQL is highly desirable, ideally within the google cloud environment.
- Experience designing and developing visualizations in QLik, Tableau, Power BI, Looker, or similar data visualization software
- Python or R introductions
- Data Engineering interest
Compensation:$90,000 / year