Business Intelligence Specialist (remote position-must live in TN)
Data Analysis - Proficient (4-6 Years)
Database Transact-SQL Proficient (4-6 Years)
SQL Proficient (4-6 Years)
Job Summary and Responsibilities:
- Under supervision of the Director of Data Manager, this position develops, modifies, and analyzes data components and create insights for a business intelligence technology solution. This position either works in a team collaboration or independently on the data projects while optimizing the resource utilization and ensure proper controls are implemented through data management and meet user requirements.
- · Develops and schedules Extract Transform Load (ETL) solutions that recognizes dependencies, pre-processing tasks, post-processing tasks for data administration, using SSMS, SSIS.
- · Understands pertinent data models and business processes to fulfill user requests for maintenance, support, and enhancements.
- · Develops and maintains complex data storage structures needed to support data warehouse functions to ensure data is maintained in consistent formats.
- · Builds, updates, and monitors the data warehouse and business systems performances maintaining the integrity.
- · Knowledge of OLAP cubes, DataMart and perspectives using SSAS and have an experience in all the stages of a BI development environment.
- · Research and troubleshoot reported problems, validates data results, and ensures logic requirements are met.
- · Deploys solutions utilizing Business Intelligence concepts, such as, data mining, and trend analysis to provide with insights.
- · Design and develops Tableau & PowerBI report visualization including complex dashboard design through MDX queries.
Qualifications:
- · Bachelor’s degree or equivalent education in computer science, math, or related science field required.
- · 5+ years of writing query languages using SQL Server management studio with T-SQL required.
- · 5 years of experience of working on Business Intelligence development tools SSIS required.
- · 3 to 5 years of knowledge of Data Analysis in Production, Development and Staging Environments.
- · 3+ years of experience working on dashboard development in Tableau and PoweBI.
- · Expert knowledge using on source control tools (TFS, Visual Source Safe).
Skills & Strengths:
· Critical Thinking/ Mathematical reasoning
· Complex Problem Solving
· Systems Analysis
· Troubleshooting
· Analytical Thinking