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

Education

Any Graduate