Business Intelligence Developer Jobs

HairClub’s vision is to be the trusted leader in total hair solutions for all, helping people discover their true confidence and achieve their goals. The Business Intelligence (“BI”) Developer with will be responsible for organizing and analyzing data to provide key insights to the business while developing process and extract, transform and loan (“ETL”) for ongoing analysis of information, obtained from a variety of sources. This position involves proficiency with analytical tools, knowledge of data analysis methodologies, use of reporting and presentation software, and strong communication skills.

MAJOR RESPONSIBILITIES:

Oversee Data Analysis Solutions and Development: Manage data retrieval and analysis and organize data points according to the organization’s needs. Design, develop and maintain business

intelligence solutions. Craft and execute queries upon request for data. Present information

through reports and visualization. Write complex queries to perform data analysis to ensure the

accuracy and integrity of data. Identify problematic areas and conduct research to determine the

best course of action to correct the data. Troubleshoot and research data anomalies and recommend corrective actions. Monitor for timely and accurate completion of data processes and scheduled jobs and troubleshoot, as necessary.

Develop and Create Process: Evaluate and improve existing BI systems. Design, build and deploy BI

solutions (e.g. reporting tools). Maintain and support data analytics platforms. Create and maintain

tools to store data. Conduct unit testing and troubleshooting. Collaborate with internal and external teams to integrate systems. Develop and execute database queries and conduct analyses.

Creating reports and testing: Develop graphs and reports, and presentations of project results.

Perform basic statistical analyses for projects and reports. Create and present quality dashboards.

Generate routine and ad-hoc reports. Provides timely and accurate progress information for project status reports. Utilize analytics to improve availability, reliability, efficiency, and capacity.

Effective Partnerships: Partner cross-organizationally to drive minimal costs on optimal solutions.

Provide in-depth technical information to stakeholders as needed. Collaborate with internal

Information Technology (“IT”) personnel and external IT Partners.

Performs other duties as required

QUALIFICATIONS:

• Must have 8 years plus related experience as BI Developer, SQL Developer, or similar position.

• Must have advanced and strong hands-on experience of BI technologies (e.g. SSRS, SSIS, Advanced SQL Development, Power BI, SQL Server Administration)

• Excellent problem-solving skills and soft skills to interface with report users directly to vet requirements and troubleshoot report inaccuracies.

• Bachelor’s or associate degree in information technology, Computer Science, Mathematics, Statistics, or related fields preferred or equivalent professional experience

• Experience with reporting from salesforce desired but not required.

• Experience performance tuning SQL server desired but not required.

KEY COMPETENCIES:

• Ability to collect, gather and aggregate data from multiple sources and present in comprehensive reports

• Ability to demonstrate initiative, priority setting, problem solving and follow through.

• Experience with the T-SQL scripting/programming language, including the ability to develop, test, and debug ad-hoc queries, stored procedures, and data migration scripts.

• Experience with Microsoft Reporting and BI Tools (SSIS, SSRS, Power BI, etc.).

• Solid understanding of ETL strategies and design, (staging environments, data transformation, change data capture, slowly changing dimensions, etc.), with an eye towards delivering functional and useful solutions in a timely manner.

• Expert organizational and project management skills

• Knowledge of standard data modeling patterns and practices, e.g. Relational and Dimensional models.

• Strong analysis, coding, testing, documenting and implementation experience in both a development and maintenance environment.

• Exceptional interpersonal and communication skills with the ability to deal with a diverse range of people, which includes the upper levels of corporate management

• Proven abilities to take initiative and be innovative

• Analytical mind with a problem-solving aptitude

• Highly effective verbal and written skills with ability to effectively summarize data in laymen’s terms in reports and presentations

• Detail oriented, curious and always looking for new ways to engage our potential customers