RESPONSIBILITIES:
Kforce has a client that is seeking a Business Intelligence Analyst in San Diego, CA.
Summary:
We are looking for a strong Business Intelligence Analyst to work within an agile team to plan, design and develop Business Intelligence dashboards and reports. You will analyze the needs of the business, strategize, and design a plan to meet the specified needs, then execute the plan, using Business Intelligence tools to deliver the Business Intelligence solution. This is a highly collaborative position, and you'll work with business, development, and testing team members, often in multiple geographies.
Duties:
* Develop and manage effective working relationships with other departments, groups, and personnel with whom work must be coordinated or interfaced
* Gather and document functional and technical requirements, and translate requirements into reporting solutions, analytic tools, and dashboards that in turn delivers actionable data to end users
* Develop in-depth understanding of underlying data, data structures, and business uses of data
* Develop expertise in the business operations and how data supports those operations to provide the most effective business intelligence solutions possible
* Identify gaps in data collection, the data model, and meta data for future enhancements
* Create simple to complex data, reporting, and business intelligence solutions by utilizing existing reporting, analytics, and business intelligence platforms
* Comply with standards, best practices, and policies defined for the team
* Provide support as required to ensure the availability and optimized performance of developed business intelligence applications and reports
* Write high quality code to retrieve, analyze and present the data
* Work with testing organization to write and execute comprehensive test plans that validate the accuracy of information and functionality to ensure delivery of high-quality business intelligence applications
REQUIREMENTS:
* Advanced direct work experience developing business focused automated reports using tools as well as building necessary SQL data objects used by reports
* Advanced direct work experience with Data Warehouse and related technologies such Microsoft SSIS, SQL, ETL, and OLAP data structures
* Advanced direct work experience any of the BI tools: Dundas BI, Tableau, Spotfire, Microsoft Power BI, PowerPivot, or Microsoft SQL Server Reporting Services (SSRS)
* Advanced SQL development experience; Demonstrated experience creating, debugging, and modifying complex stored procedures and views, as well as querying and updating data using SQL
* Experience in front end and back-end dashboard development
* Strong experience optimizing storage size and performance in dashboard data models and deploying dashboards to the cloud
* Experience working with data gateways
* Experience with production support and troubleshooting common report/data process issues
* Strong knowledge of data migration between databases
* Familiar with fact/dimension data modeling, and validating results of data transformation processes
* Understands software development methodologies and best practices as it pertains to database and report development, to include reviewing and testing deliverables
* Strong ability to quickly get acquainted with unfamiliar data and evaluate data quality
* Ability to document technical requirements for business processes and development needs
* Ability to create and use DAX to optimize calculations and measures effectively
* Ability to create presentation-ready visuals, mock-ups, charts, graphs, and summary reports in tight timeframes
* Exposure to extracting data from enterprise level system, such as CRMs, HRIS, or ERP a plus
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.