BI Developer

Ursus - Los Angeles, CA

Full-time - Mid Level

Los Angeles, CA

Administrative and Support Services

About the position

The BI Developer/Business Analyst role is a critical position aimed at enhancing the business intelligence and analytics capabilities of the organization. The ideal candidate will possess extensive experience in data analysis, data architecture, SQL, and business intelligence tools, particularly in the design and development of dashboards. This position requires a strong understanding of the BI landscape, including the ability to translate business requirements into technical specifications and to develop custom analytics solutions that meet the needs of various stakeholders. The role is hybrid, based in Woodland Hills, CA, and is structured as a 6-month contract with the potential for conversion to a full-time position. In this role, the BI Developer will be responsible for executing the end-to-end development of BI solutions. This includes gathering business requirements, designing and developing solutions, performing user acceptance training, and maintaining the solutions post-implementation. The candidate will also be tasked with developing and maintaining dashboards and other BI solutions using tools such as Tableau, Salesforce, and custom Microsoft solutions. A significant part of the job involves assisting internal stakeholders with their analytics needs, evaluating current tools, and identifying gaps in analytics capabilities to support strategic decision-making based on data analysis. The BI Developer will perform and document data analysis, validation, and mapping, producing data samples and ad hoc analyses. Strong T-SQL skills are essential for agile data analysis and preparation for front-end BI implementation. The role also requires collaboration with business stakeholders to identify weaknesses in current solutions and to implement improvements. Additionally, the candidate will evaluate and plan for the automation of manual data extracts and other reporting activities, ensuring that all project documentation is maintained and updated. The position demands responsiveness to feedback and the creation of training and quality assurance documentation to ensure the accuracy and effectiveness of reports and data usage.

Responsibilities

• Execute end-to-end development of BI solutions, including gathering business requirements, designing and developing a solution, performing user acceptance training, and maintaining the solution.
• Develop and maintain dashboards and other BI solutions using tools available in the landscape including Tableau, Salesforce, custom Microsoft based solutions, Excel, etc.
• Assist internal stakeholders with their analytics needs, evaluating current tools and identifying gaps and opportunity areas in current analytics capabilities.
• Perform and document data analysis, data validation, data mapping/design, produce data samples/prototypes and ad hoc analysis.
• Obtain and analyze data by accessing multiple sources, including SAP and data warehouses, demonstrating strong T-SQL skills.
• Evaluate and utilize appropriate BI tools to streamline solution generation and provide speed to business leader decision making.
• Collaborate with business stakeholders, executives, and department heads to identify weaknesses in current solutions and improve them.
• Evaluate and plan activities to implement automation of manual data extracts and other manual activities supporting reporting.
• Create all required documentation on all projects using pre-defined templates and keep documentation up to date on any existing report changes.
• Respond and resolve all feedbacks within the set thresholds (business days).
• Create training and internal QA/UAT documentation; perform quality assurance and ongoing monitoring of current reports and data for accuracy and usage.

Requirements

• 8+ years of overall business and BI/other technology experience.
• 5+ years as a BI/Business Analyst.
• 3+ years' experience and expertise in Tableau driven dashboard/analytics design, development, and implementation.
• 2+ years of working with SQL.
• Experience in creation of functional specifications and project documentation, translating functional requirements into detailed technical requirements.

Nice-to-haves

• 1+ years working knowledge of Tableau administration/architecture.
• 2+ years of BI project/program management.
• 2+ years working knowledge of BI/data warehouse functionality.