Job Title: Business Intelligence Specialist (Remote - Must Reside in TN)
Job Summary:
The Business Intelligence Specialist will work closely with the Director of Data Management to develop, modify, and analyze data components while providing key insights for business intelligence solutions. The role involves collaboration with cross-functional teams or independent work to meet user requirements, optimize resource utilization, and ensure data management controls are in place.
Responsibilities:
- Develop and schedule ETL (Extract, Transform, Load) solutions using SSMS and SSIS, recognizing dependencies, pre-processing, and post-processing tasks for data administration.
- Analyze and understand data models and business processes to meet user requests for system maintenance, support, and enhancements.
- Design, develop, and maintain complex data storage structures to support data warehouse functions, ensuring data consistency and integrity.
- Build, update, and monitor data warehouse and business systems, ensuring optimal performance and integrity.
- Utilize OLAP cubes, DataMart, and perspectives using SSAS across all stages of BI development.
- Troubleshoot reported problems, validate data, and ensure that business logic requirements are met.
- Deploy BI solutions using data mining and trend analysis techniques to derive actionable insights.
- Design and develop report visualizations and complex dashboards in Tableau and Power BI, including advanced MDX queries.
Qualifications:
- Bachelor’s degree in Computer Science, Mathematics, or a related field (or equivalent education).
- 5+ years of experience in writing query languages using SQL Server Management Studio (SSMS) with T-SQL.
- 5+ years of experience working with BI development tools like SSIS.
- 3–5 years of experience with data analysis in production, development, and staging environments.
- 3+ years of experience developing dashboards in Tableau and Power BI.
- Proficient with source control tools (e.g., TFS, Visual SourceSafe).
Skills & Strengths:
- Strong critical thinking and mathematical reasoning skills.
- Expertise in complex problem-solving and systems analysis.