Business Intelligence Developer

GENERAL JOB DESCRIPTION

The Business Intelligence (BI) Developer’s role is to strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. The Business Intelligence Specialist is also responsible for ensuring high levels of BI availability through support functions and in-depth testing.

MAJOR DUTIES AND RESPONSIBILITIES

• Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
• Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Direct, organize, and lead projects in the implementation and use of new BI software tools and systems.
• Lead the integration efforts for merging BI platforms with enterprise systems and applications.
• Design, code, test, and document all new or modified BI systems, applications, and programs.
• Develop the semantic layer, metadata, reports, and report definitions.
• Develop graphs and portal interfaces.
• Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.
• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Work with project managers to ensure that data entry, retrieval, change, and delete functions meet business requirements for project completion.
• Conduct job duties and responsibilities according to the organization’s business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology.
• Design and deliver end-user training and training materials; provide technical support as necessary.
• Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.
• Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
• Mentor and/or provide leadership to junior members of the team.

EXPERIENCE/CREDENTIALS

• Bachelor’s degree in computer science, information systems, engineering, or a related field.
• 3-5 years’ experience building BI dashboards with management KPIs, required.
• Certifications in SQL Server and PowerBI are a plus.
• Technically fluency in programming languages, such as python, is a plus.
• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
• Experience with tier-one applications, databases, and data warehouses, such as MS SQL Server, MySQL, Snowflake, CRM, ERP, etc.
• Demonstrated ability with Windows and UNIX operating systems.
• Demonstrated ability with Azure Data Factory and other ETL tools.
• Experience working on projects with a team and project managers.
• Experience with database design.
• Experience with data process flowcharting techniques.
• Proficient in Microsoft Office (Word, Excel, PowerPoint, Visio).

COMPETENCIES

• Deep knowledge of data visualization.
• In-depth technical knowledge of network, PC, and platform operating systems, including Microsoft Azure.
• Strong ability to analyze user requirements and build front-end BI applications according to specifications.
• Exceptional analytical, conceptual, and problem-solving abilities.
• Good knowledge of applicable data privacy practices and laws.
• Maintains absolute confidentiality of client information and safeguards client and company data; maintains high ethical standard in all practices.
• Experience working in a team-oriented, collaborative environment.
• Ability to effectively communicate verbally and in writing throughout all levels of the firm.
• Strong presentation and interpersonal skills, both in-person and virtual.
• Able to prioritize and execute tasks in a high-pressure environment.
• Strong understanding of the organization’s goals and objectives.

FEATURED BENEFITS

• Medical Insurance
• Dental Insurance
• Vision Insurance
• 401(k)
• Health Savings Account
• Paid Maternity Leave
• Paid Parental Leave
• Tuition Reimbursement
• Wellness Program