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.