What are the responsibilities and job description for the System Engineer position at Amzur Technologies, Inc.?
Job Details
Strong experience in reporting tools like MS Power BI, Microsoft Visual FoxPro.
Ongoing communication with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate, and validate requirements.
Experience in all phases of project life cycle, starting from business requirement gathering, analysis to testing and deployment.
Experience with data analysis, data modeling, data presentation and importing data from SQL Server, Oracle DB to Power BI to generate reports.
Proficient in creating objects such as tables, stored procedures, views, triggers, user defined functions (UDF), common table expressions (CTEs) and complex queries on Microsoft SQL Server.
Extensive knowledge in Tuning T-SQL queries to improve database performance.
Expert in using SQL Server Profiler, Execution Plan and Performance Monitor.
Experience in creating jobs, SQL Mail, Alert and Schedule SSIS Packages using SQL Server Agent.
Expert in creating SSIS packages for ETL purposes in SQL Server Integration Services (SSIS).
Experience using various transforms in SSIS as an ETL tool while transferring the data from various sources into the destination files.
Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER functions.
Form various measures and calculated columns utilizing DAX in Power BI to answer business questions. Performed time series analysis using DAX in Power BI.
Excellent hands-on experience in groups, hierarchies, and measures, KPIs, well versed in creating DAX (Data Analysis Expressions) functions in creating Power BI dashboards reports.
Design Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density chart.
Build solution-driven dashboards by developing different chart types, including Bar charts, Column charts, Donut charts, maps, Scatter plots, Line charts, cards.
Deploy the Power BI reports to Power BI services and pinned visuals to make dashboards. Expertise in Power BI, Power BI Pro, Power BI Premium.