Systems Engineer

Systems Engineer is needed to perform the following duties:

• Design and develop interactive Power BI dashboards and reports for business intelligence and analytics.
• Create data models, measures (DAX), and calculated columns for insightful analysis.
• Optimize report performance using aggregations, indexing, and query tuning techniques.
• Implement Row-Level Security (RLS) and role-based access for secure data visualization.
• Develop and optimized T-SQL queries, stored procedures, and views to manage and retrieve data efficiently.
• Design and maintain normalized and denormalized data models for Power BI integration.
• Ensure database performance optimization by implementing indexing, partitioning, and query tuning techniques.
• Manage data integrity, security, and compliance within Azure SQL Database.
• Design and develop ADF pipelines for extracting, transforming, and loading (ETL) data from multiple sources.
• Configure linked services, datasets, and triggers for automated data processing.
• Implement incremental data loading strategies, error handling, and monitoring mechanisms in ADF.
• Integrate Azure SQL, Azure Data Lake Storage (ADLS), and on-premises databases for seamless data flow.
• Optimized Apache Spark performance using techniques like data partitioning and caching.
• Performed data aggregation, enrichment, and transformation to support business analytics.
• Integrated Databricks with ADF, Azure SQL, and Power BI for advanced data processing.
• server and custom development if required.
• use data from IT systems to evaluate performance and quality and to plan improvements
• Develops, manages and tests database and information system backup and recovery plans.
• Ensure data quality, validation, and consistency across Power BI and Azure data services.
• Optimized data refresh schedules, query performance, and resource allocation for cost efficiency.
• Troubleshot performance bottlenecks in Power BI, ADF, and Databricks workflows.
• Worked closely with business analysts, data engineers, and key stakeholders to define reporting requirements.
• Documented ETL workflows, Power BI reports, SQL queries, and architecture for future reference.
• Provided end-user training and support to empower business teams with self-service analytics.
• Stayed updated with Azure cloud services, Power BI enhancements, and industry best practices.
Bachelor's Degree is required in Computer Science or Computer Engineering or Information Systems or Information Technology.