What are the responsibilities and job description for the Data Visualization/Power BI Analyst position at Mediabistro?
Collaborate with stakeholders, including business u , analysts, and IT teams, to understand reporting needs and translate them into technical requirements.Design and develop data models that are optimized for performance and ease of use. This includes creating relationships between tables, defining calculated columns, and implementing measures using DAX (Data Analysis Expressions).Challenge API driven datasets and how they are reported in Power BIConnect to various data sources such as SQL databases, cloud services, Excel spreadsheets, and other data repositories; ensure data is accurately imported and updated regularly.Design and create interactive and visually appealing reports and dashboards. Use Power BI features like slicers, filters, and drill-downs to enhance user experience and data exploration.Use Power Query to clean, transform, and shape data as required; his may involve merging tables, pivoting data, and implementing complex transformations.Monitor and optimize the performance of reports and dashboards. This includes tuning data models, optimizing DAX queries, and ensuring efficient data refresh processes.Perform thorough testing of reports and dashboards to ensure data accuracy and reliability. Validate results with stakeholders to ensure they meet business requirements.Document data models, report logic, and processes. Provide training and support to end-u to help them effectively use Power BI reports and dashboards.Regularly update reports and dashboards to reflect new business requirements, data changes, and feedback from u .Ensure data security and compliance with organizational policies.Ensure the Dashboards are compliant with UI / UX standards set by the organizational policy.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity / affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and / or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy : https : / / insightglobal.com / workforce-privacy-policy / .
Required Skills & Experience- 5 years of experience with Power BI- Expert in writing and reading SQL queries- Strong experience with Python
Power BI Expertise : In-depth knowledge of Power BI features such as Power Query, Power BI Desktop, and Power BI Service. Ability to create interactive reports, dashboards, and utilize slicers, filters, drill-downs, and other visual enhancements.DAX Proficiency : Strong experience with DAX for creating calculated columns, measures, and other complex expressions to ensure accurate and efficient data analysis.Data Modeling : Experience in designing optimized data models, establishing relationships between tables, and using best practices to ensure efficient reporting and performance.SQL and Data Connectivity : Proficient in connecting Power BI to various data sources like SQL databases, cloud services, and Excel, with a focus on ensuring data accuracy and automated refreshes.Power Query Mastery : Deep understanding of Power Query for data cleansing, transformation, and shaping (e.g., merging tables, pivoting, implementing complex transformations).API & Data Integration : Familiarity with API-driven datasets and best practices for reporting data from APIs in Power BI.Business Intelligence Analysis : Ability to collaborate with stakeholders (e.g., business u , analysts, IT teams) to gather reporting requirements and translate them into actionable technical specifications.Performance Optimization : Proven ability to monitor and optimize Power BI reports and dashboards for performance. Includes tuning data models, optimizing DAX queries, and ensuring fast refresh processes.Data Accuracy and Testing : Strong attention to detail when testing and validating reports and dashboards to ensure data accuracy and that business requirements are met.Stakeholder Collaboration : Excellent communication skills to work with cross-functional teams, gather requirements, provide feedback, and ensure alignment between technical and business teams.Documentation & Process : Ability to document data models, report logic, and processes clearly for future reference and team collaboration.
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and / or other paid time off as provided by applicable law.
