What are the responsibilities and job description for the System Analyst -Onsite position at Ikon Software Services?
Job Descripition As a Power BI developer with expertise in DAX (Data Analysis Expressions), your primary job duties would revolve around designing, developing, and maintaining Power BI solutions. Minimum Required KSAs : Candidates should have at least 5 years of experience in the job duties listed below : Data Modeling and Analysis : Designing data models and relationships in Power BI to ensure efficient data retrieval and analysis. Creating DAX formulas to calculate and summarize data for visualizations. Report and Dashboard Development : Creating interactive and visually appealing reports and dashboards in Power BI that provide actionable insights to stakeholders. DAX Formulas and Calculations : Developing complex DAX formulas to perform calculations, aggregations, time intelligence, and other data manipulations within Power BI. Data Integration : Extracting, transforming, and loading data from various sources into Power BI, including databases, spreadsheets, cloud services, and APIs. Performance Optimization : Optimizing Power BI reports and DAX calculations for improved performance and faster query response times. Data Visualization : Select appropriate visualizations (e.g., charts, tables, maps, KPIs) to represent data effectively and enable users to gain insights quickly. Data Security and Governance : Implementing data security measures within Power BI to ensure that sensitive information is accessible only to authorized users. Adhering to data governance policies and regulations. Data Quality and Validation : Ensuring the accuracy and integrity of data by validating and cleansing data during the integration process. Collaboration and Documentation : Collaborating with business stakeholders, data analysts, and other team members to understand requirements and deliver effective solutions. Documenting data models, DAX formulas, and development processes for future reference and knowledge sharing. Troubleshooting and Issue Resolution : Identifying and resolving issues related to data connections, DAX calculations, and report performance. Ability to provide excellent customer support, meticulous quality of work, and work product. Education : Bachelor s or Master's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience. (Required) Certifications : Microsoft Dynamics 365 Certification (Desired) and MS Dynamics Power Platform Certifications (Desired)
