Business Intellgience Developer

The Business Intelligence (BI) Developer is responsible for strategically designing, implementing, and maintaining BI software and systems, including developing integrations with databases, data lakes, and warehouses. This includes selecting, designing, and rolling out BI and reporting solutions to a wide variety of end users. This role is also responsible for ensuring high levels of system availability through support functions, and in-depth testing reporting systems as well as continuous optimization of data processes and technology.

As a Business Intelligence Developer, you will work closely with stakeholders in other departments to conduct needs analyses to identify, recommend, develop, implement, and support analytics solutions that deliver essential information and analytics to their teams. You will also tune production databases to ensure high levels of data availability and mine enterprise systems and applications for knowledge and information that enhance business processes.

Responsibilities

Requirements Analysis and Design

• Work with stakeholders to define business and systems requirements for information technologies, particularly in the areas of BI, analytics, and data warehousing.
• Identify, refine, and develop key BI metrics, reporting, and dashboards for various business roles and functions.
• Evaluate and recommend BI solutions, and database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Analyze user requirements and based on findings, design functional specifications for BI front-end applications and analytical tools.

Standards and Strategies

• Assist in the development of data management policies, procedures, and corporate data strategy.
• Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.

Data Engineering

• Conduct in-depth evaluations of various data sources and their associated business functions.
• Design of databases and data warehouses to support robust historical and correlative analyses.
• Create models for new database development and/or changes to existing models.
• Produce ETL design guidelines and maintain ETL pipeline processes to ensure a robust and manageable ETL infrastructure for BI systems.
• Monitor database system details within production systems, including stored procedures and execution time, and implement efficiency improvements.
• Provide and apply quality assurance best practices for data analysis services across the organization.
• Develop integrations for BI platforms with enterprise systems and applications.

BI Development

• Design, code, test, and document all new or modified BI systems, applications, and programs.
• Develop the semantic layer, metadata, reports, and report definitions.
• Develop SQL queries and reports to meet the analytical needs of the business.

Support

• Troubleshoot, performance-tune, BI and database tools, systems, and software
• Troubleshoot and update SQL routines as needed to account for changes in underlying data and needs of the business.
• Promote BI usage to relevant departments.
• Mentor and provide leadership to members of the team.
• Design and deliver end-user training and training materials; provide technical support as necessary.

Perform other related duties as required and assigned.

Position Requirements

Minimum Qualifications

• Bachelor’s degree in Computer Science, Data analytics, Information Systems, or Mathematics, and a minimum of 6 years of direct work experience implementing and developing BI solutions

Technical Experience

• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling for on-premise and SaaS deployments.
• Proven experience in BI/data warehousing planning and development.
• Database Structure knowledge
• Strong understanding of relational database structures, theories, principles, and practices.
• Extensive knowledge of SQL, T-SQL, OLAP Cubes, data manipulation languages, and programming languages.
• Experience with data processing flowcharting techniques.
• Experience with tier-one applications, databases, and data warehouse support.
• Extensive experience implementing and maintaining Enterprise BI visualization tools such as Sisense, MS Power BI, Tableau, and MS SSRS
• Experience/exposure working with data lakes such as Snowflake and/or Azure Synapse Analytics is a plus.
• Demonstrated ability to effectively leverage a variety of enterprise ETL/ELT tools, either on-premises and/or SaaS based.
• Experience working with CData, DBT, Azure Data Factory, and/or other pipeline solutions and tools.
• Demonstrated knowledge of scripting languages (such as PowerShell and Python)
• Working technical experience with designing, building, installing, configuring, and supporting database servers
• Prior database administrator experience to provide routine maintenance such as recalculating statistics, log space clean out, index rebuilds, and performance tuning.
• Demonstrated ability to manage, configure and optimize BI related aspects of Microsoft Windows Server operating systems.

Other Skills and Capabilities

• Full project management and development life cycle experience.
• Strong ability to conduct a need analysis to obtain and document user requirements.
• Ability to break down and interpret key business data. Ability to analyze data, employ statistical concepts, and present recommendations based on that data.
• Strong understanding of retail and/or fuel financial/business processes and associated analytics. Experience within the convenience and retail fuel industry is a plus.
• Strong presentation, interpersonal, written, and oral communication skills.
• Exceptional analytical, conceptual, and problem-solving abilities.
• Able to prioritize and execute tasks in a high-pressure and agile environment.

Highly self-motivated and self-directed.