Power BI Developer / Analyst

Cloud Hybrid Technologies, LLC; Clark (NJ); On-site; USD 70,000 - 90,000; Full time

Job summary

A technology solutions provider based in New Jersey is seeking a skilled Power BI Developer to manage responsibilities like requirements gathering, data modeling, and creating impactful dashboards. Candidates should possess a relevant Bachelor's degree and at least 2 years of Power BI experience. Strong SQL skills and proficiency in DAX are essential. The role involves collaboration with stakeholders and aims at optimizing data integrity and performance in reporting solutions.

Qualifications

• 2+ years of experience working with Microsoft Power BI and developing dashboards.
• Strong proficiency in DAX for creating measures and calculated columns.
• Solid understanding of relational databases and SQL skills for data manipulation.

Responsibilities

• Collaborate with stakeholders to understand data needs.
• Design and develop data models in Power BI.
• Create interactive Power BI reports and dashboards.
• Connect to various data sources and ensure data integrity.
• Optimize performance of Power BI reports.

Skills

Power BI

DAX (Data Analysis Expressions)

SQL

Data modeling

ETL processes

Analytical skills

Communication

Education

Bachelor's degree in a relevant field

Tools

Microsoft Power BI

SQL databases

Excel

Job description

Responsibilities

• Requirements Gathering: Collaborate with stakeholders from different departments to understand their data analysis, reporting, and dashboarding needs.
• Data Modeling & Transformation: Design and develop robust and efficient data models within Power BI, including establishing relationships, creating calculated columns and measures using DAX (Data Analysis Expressions).
• Report & Dashboard Development: Create interactive and visually appealing Power BI reports and dashboards that provide clear, actionable insights for business users.
• Data Source Connectivity: Connect to various data sources (e.g., SQL databases, Excel, SharePoint, cloud data warehouses, APIs) and ensure data integrity and accuracy.
• Performance Optimization: Optimize Power BI reports and dashboards for performance, ensuring quick load times and efficient data refresh.
• Data Governance & Security: Implement row-level security (RLS) and ensure data governance best practices are followed within Power BI.
• Documentation & Training: Create and maintain documentation for Power BI solutions, including data models, reports, and dashboards. Provide training and support to end-users to maximize their adoption and understanding of the tools.
• Collaboration: Work effectively with data engineers, data scientists, and other IT professionals to ensure seamless data flow and integration.
• Troubleshooting & Maintenance: Identify and resolve issues related to Power BI reports, data refreshes, and data quality.
• Stay Current: Keep abreast of the latest Power BI features, updates, and best practices to continuously enhance our BI capabilities.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Business Analytics, Statistics, or a related quantitative field.
• Proven experience (typically 2+ years depending on seniority) working with Microsoft Power BI, including extensive experience in dashboard and report development.
• Strong proficiency in DAX (Data Analysis Expressions) for creating complex measures and calculated columns.
• Solid understanding of relational databases and strong SQL skills for data extraction and manipulation.
• Experience with data modeling, ETL processes, and data warehousing concepts.
• Excellent analytical and problem-solving skills, with the ability to translate complex data into understandable insights.
• Strong communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
• Ability to work independently and manage multiple priorities in a fast-paced environment.

Preferred Skills

• Experience with other BI tools (e.g., SAP Business Objects, Spotfire).
• Knowledge of Cloud data services (e.g., Google Cloud Platform, Azure SQL Database).
• Familiarity with Python or R for data analysis.

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.