Data Engineer

Role Overview: As a Data Engineer at EXO Edge, your primary responsibility will be to design, develop, evaluate, and test data infrastructures. This includes source system analysis, data modeling, business measure development, and report/visualization formatting. Your role will involve ensuring compliance with policies, procedures, safety, state, and federal laws, regulations, and standards. Key Responsibilities: - Consolidating separate data and reporting suites - Enabling business users with carefully curated data visualizations for monitoring contract performance and decision-making - Determining reporting needs, developing and building reports, training users, and establishing reporting cadences and processes - Translating logical designs into physical designs considering business requirements, target environments, processes, performance requirements, existing systems, services, and safety aspects - Analyzing and organizing raw data - Building data systems and pipelines - Evaluating business needs and objectives - Interpreting trends and patterns - Conducting complex data analysis and reporting results - Preparing data for prescriptive and predictive modeling - Building algorithms and prototypes - Combining raw information from different sources - Enhancing data quality and reliability - Identifying opportunities for data acquisition - Developing analytical tools and programs - Collaborating with data scientists and architects on multiple projects and technologies Qualifications Required: - 5+ years of hands-on experience in MS SQL Server writing complex T-SQL queries, stored procedures, functions, etc. - 5+ years of ETL development using Azure Data Factory (experience with SSIS a plus) - 5+ years of experience with building data pipelines and analytics solutions to stream and process datasets at low latencies - 5+ years of experience with complex data modeling, ELT/ETL design, and using large databases in a business environment. Experience ingesting data from various source formats such as 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 is 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 and experience with CI/CD processes - Knowledge and 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.) - Strong understanding of database design best practices - Experience with setting up and monitoring databases, users access rights in Azure - Experience with Yardi system is a big plus Location: Mohali, Punjab,