Amtex Systems Inc is an information technology and talent solutions company offering talent and BI consulting to the companies in US for over 20 years.
Our solutions are designed to fill resource gaps, by providing the right candidates who deliver value to the organization. Our propensity to nurture and build strong relationships with our clients helps us better understand their business demands and gives us the ability to provide services that are on time and rise above the rest.
Hi All!
Business Intelligence Specialist
location: local Nashville, Tennessee(remote )
Please share profiels to email:sherly@amtexsystems.com
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
Position: Contract to hire (US citizen or Green card candidates)