Role: Business Intelligence Specialist (Remote)
Location: Nashville TN.
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 preprocessing tasks postprocessing 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:
Bachelors 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 TSQL 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