Job Seekers, Please send resumes to resumes@hireitpeople.com

Essential Duties and Responsibilities:

Experience in data analysis and data mapping and consequently data integration routines which involves moving, cleansing, and transforming large amount of data between multiple systems. Identifies data sources, provides data flow diagrams, and documents source to target mapping and process. Design, implement and maintain database objects (tables, views, indexes, etc.) and database security. Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc. Troubleshoot performance and reliability issues and investigate anomalous behavior in the Database environment. Power BI Development experience in Reports, Dashboards and DAX queries. Experience in Power BI Administration and/or Angular is a plus. Experience with Source Version Control software like GitHub and CICD pipelines. Provide support after hours as an when needed.

Requirements:

7+ years of experience in Data Warehousing and Business Intelligence. 5+ Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL. 3-4 Years in SSIS and use of Stored Procedures. 3-4 Years in PowerBI Report Development. Ingest and aggregate data from both internal and external data sources to build our data stage areas. Strong understanding data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts). Strong experience with business intelligence and data warehousing design principles and industry best practices.

Qualifications: Bachelors degree from an accredited college or university with coursework in computer science or management information systems and 5 years of related experience.