Process of consolidating separate data and reporting suites
Ensure business users are enabled with carefully curated data visualizations with accurate, reliable and consistent data to monitor contract performance and assist in decision making
Determining reporting needs, developing and building reports, training users and establishing reporting cadences and processes.
Fulfilling the below roles and responsibilities :
Translate logical designs into physical designs, taking account of business requirements, target environments, processes, performance requirements, existing systems and services, and any potential safety-related aspects
Analyze and organize rawdata.
Build data systems andpipelines.
Evaluate business needs andobjectives.
Interpret trends andpatterns.
Conduct complex data analysis and report onresults.
Prepare data for prescriptive and predictivemodeling.
Build algorithms andprototypes.
Combine raw information from differentsources.
Explore ways to enhance data quality andreliability.
Identify opportunities for dataacquisition.
Develop analytical tools andprograms.
Collaborate with data scientists and architects on multiple projects technologies.
Bringing in the below technical experience:
8+ years of hands-on experience in MS SQL Server writing complex T-SQL queries, stored procedures, functions etc.
8+ years of ETL development using Azure Data Factory (experience with SSIS a plus)
8+ years of experience with building data pipelines and analytics solution to stream and process datasets at low latencies.
8+ years of experience with complex data modelling, ELT/ETL design, and using large databases in a business environment. Experience ingesting data from various source formats viz. Parquet, csv, SQL databases, SharePoint, APIs etc. to Azure SQL databases.
3+ years of experience with SSAS (SQL Analysis Services) Tabular and Multi-Dimensional cubes/models. Experience writing DAX expressions a plus.
Expertise in ELT/ETL optimization, designing, coding, and tuning big data processes using Azure Data Factory.
Advanced experience in SQL Server relational database management systems
Extensive understanding and knowledge in data analytics and reporting (TSQL, SSRS, Power BI, etc.)
Strong Knowledge of data warehousing frameworks and methodologies.
Knowledge of Data Engineering and Data Operational Excellence using standard methodologies.
Knowledge experience with CI/CD processes.
Knowledge experience with Azure DevOps.
Knowledge of QA tools (manual and automated)
Experience in data mining, profiling, and analysis
Experience with usage of source control within a team environment (Git, TFS etc.)
A strong understanding of database design best practices
Experience with Azure - setting up and monitoring databases, users access rights.