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 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

Interview type: Telephonic, Virtual

Number of hirings: 1

Key Skills

Education

Any Graduate