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