Job Description
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 q uery 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
Requirements
Qualifications
Type
Category
Qualification
Description
Competency
Required
Skills
Database
Data Analysis
Proficient (4-6 Years)
Skills
Database
Transact-SQL
Proficient (4-6 Years)
Skills
Languages
Proficient (4-6 Years)
Skills
Others
Communication skills both verbal and written
Advanced (7-9 Years)
Skills
Others
Data Analytics Specialist
Proficient (4-6 Years)
Skills
Others
Learning ability
Proficient (4-6 Years)
Requirements
Qualifications Type Category Qualification Description Competency Required Skills Others Help desk support Help desk Novice (1-3 Years) No Skills Others Communication skills both verbal and written Novice (1-3 Years) No