Jobs via Dice ยท 6 hours ago
System Engineer
Queens, NY
Full-time
Onsite
Mid LevelAmzur Technologies, Inc. is seeking a System Engineer to enhance their data reporting and analysis capabilities. The role involves extensive use of Power BI and SQL Server to develop reports, manage data, and communicate with stakeholders throughout the project lifecycle.
Computer Software
Responsibilities
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
Qualification
Required
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
Company
Jobs via Dice
Welcome to Jobs via Dice, the go-to destination for discovering the tech jobs you want.
0-1 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase