Business Intelligence SQL Analyst

Company: Riggs CAT
Location: Little Rock
Posted on: August 6, 2022

Job Description:

Riggs CATDescription:
**This position requires you to be on-site at our Little Rock, AR location. This is NOT a remote work position.**The Business Intelligence SQL Analyst is responsible for building, implementing, and supporting business intelligence solutions. The right individual will possess experience in all stages of BI project work (requirements and logical design, physical design, implementation, testing, and deployment). The developer will also need a firm grasp of BI implementation methodologies and in-depth professional experience in the Microsoft BI Stack (SSIS, SSRS, SSAS, MSSQL, and Excel).WHAT YOU'LL DODevelopment and implementation of new ETL processes to extract data from various systems and load into the Riggs BI Reporting DatabaseSupport, monitor, and make recommendations for BI infrastructureCreate and maintain documentation related to the BI infrastructureMonitor and administer Riggs's Tableau ServerCreate, publish, and maintain data sources supporting self-service data analyticsMonitor project progress by tracking activity; resolving problems; publishing progress reports; recommending actions to the IT ManagerMaintain user confidence and protect operations by ensuring quality information is producedMaintain professional and technical knowledge by attending events, webinars, and educational opportunitiesOwn and maintain all dealership databases and champion data qualityDrive customer-focused solution development and business strategies by integrating multiple sources of data and sharing findings with management through written reports and effective visualizations.Support internal analytics teams by facilitating knowledge-sharing and skill developmentBuild and maintain strong working relationships with all departments within the enterprise

Requirements:
WHAT YOU'LL NEEDBachelor's degree or 3 or more years related experience; or equivalent combination of education and experience. (education may be waived due to on the job experience)2+ years of Business Intelligence experience2+ years of database design or integration experience with SQL Server databases (2014+)Professional experience developing complex ETL processes, designing/developing logical and physical database models, and developing complex queries using T-SQLBusiness awareness and numerical ability.Ability to take ownership of projects and be self-directedProficient in using analytical tools and instrumentsAbility to estimate tasks accurately and meet agreed upon deadlinesAbility to read, write, and speak fluent EnglishAbility to debug and solve problems effectively and efficientlyFamiliarity with agile methodology or similar project management approachFamiliarity with Tableau Desktop or similar visual analysis reporting tools (such as Power BI)Familiarity in: IBM I DB@ (AS/400), API Programming, C#, JavaScript, and Full Stack SDLCIMPORTANT INFORMATIONWhile performing the duties of this job, the employee is regularly required to sit, talk or hear. The employee is occasionally required to stand and walk. The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.The noise level in the work environment is usually quiet.Required travel up to 10%.This position is not considered a safety sensitive position.The Job description is subject to change by the employer as the needs of the employer and requirements of the job change.EEO/AASalary/Exempt________________________________________Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThe contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)PM20**This position requires you to be on-site at our Little Rock, AR location. This is NOT a remote work position.**PI187902016

Keywords: Riggs CAT, Little Rock , Business Intelligence SQL Analyst, Professions , Little Rock, Arkansas