Data Warehouse / ETL Developer
October 16, 2024Business Intelligence Developer
October 16, 2024Experience / Qualifications
- Minimum 12 years of experience working with in Data warehousing, Data Analysis, Source to Target Mapping, Multi-dimensional modeling and Relational modeling, Star schema, Snowflake schema, Fact and dimension tables and ETL Processes
- 10 + years’ experience in Microsoft SQL Server and relational SQL databases that include data modeling, development, and management.
- Experience in designing database tables and structures, creating views functions and stored procedures as required.
- 5+ years of experience with Azure Analysis services in AAS Data Model Development, AAS Data model Deployment in Azure, Querying data from AAS to build Reports.
- Experience in developing, optimizing, and administering Tabular Models in ‘Azure Analysis services’.
- Experience in design and Create AAS/OLAP/ Tabular cubes and automate processes for analytical needs. Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using DAX functions in – Azure Analysis services.
- Experience in writing optimized SQL queries for integration with other applications, maintain data quality and overseeing database security, Partitions, and Index. Extensively used performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries and trouble-shoot cubes SQL and T-SQL.
- Experience or Knowledge of reporting tools like Power BI, Cognos or tableau preferred.
- Experience in applying data visualization best practices and tell stories through data visuals and reports to inform the who, what, when, where, and how to be able to understand the key factors driving positive outcomes.
- Excellent communication skills, presentation skills with ability to interact at all levels of the organization on a regular basis.
Education
- Bachelor’s degree in computer science/engineering or related fields.
Work Location
- Hybrid work at 2 Montgomery Street Jersey City, NJ 07302