Technical Skills & Expertise:
- Technical expertise with data models, data mining, and segmentation techniques
- Knowledge of programming languages (e.g., Java and Python)
- Hands-on experience with SQL database design
- PL/SQL Server development experience
- NoSQL databases experience
- Dimensional modeling experience
- Experience especially on (Azure Data Bricks, ADF, ADLS, BLOB, Private endpoint connections)
- Experience in building backend data lakes and Azure Synapse, Azure Presto
- OLAP, SSAS and MDX experience
- ETL tools experience, such as SSIS
- Modeling tools experience, such as Toad Data Modeler, Erwin, and Embarcadero
- Good to have experience on Intelligent Automation tools like UiPath, Abby, HDFS, Spark, HBase, Hive, Sqoop
Data Analysis & Management Responsibilities:
- Great numerical and analytical skills
- Analyze and organize raw data
- Build data systems and pipelines
- Evaluate business needs and objectives
- Interpret trends and patterns
- Conduct complex data analysis and report on results
- Prepare data for prescriptive and predictive modeling
- Build algorithms and prototypes
- Combine raw information from different sources
- Explore ways to enhance data quality and reliability
- Determines data storage needs
- Uses different data warehousing concepts to build a data warehouse for internal departments of the organization
- Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data
- Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts
- Designs, develops, and automates data extraction using any of the extraction methodologies that make use of RPA (Power Automate, Selenium, UiPath)
- Support complex applications to transform and load data
- Ensures data quality
- Develops logical and physical data flow models for ETL applications
- Translates data access, transformation, and movement requirements into functional requirements and mapping designs
