Business Intelligence Developer

$71,000 - $113,500/Yr

Xylem - Yellow Springs, OH

Full-time - Mid Level

Yellow Springs, OH

10,001+ employees

Computer and Electronic Product Manufacturing

About the position

As a Power BI Developer on the BI team at Xylem, you will play a crucial role in designing, developing, and maintaining data-driven reports and dashboards. Your work will enable organizations to make informed, data-driven decisions by transforming raw data into actionable insights. This position is integral to the business intelligence team, focusing on optimizing data processing and reporting pipelines to exceed customer expectations through innovative solutions.

Responsibilities

• Develop, design, and maintain interactive dashboards and reports using Power BI.
• Connect to and integrate various data sources, including Databricks and Data Sphere, to optimize data processing and reporting pipelines.
• Perform data transformation and cleansing to ensure data accuracy and consistency.
• Build and maintain data models to support report and dashboard development.
• Optimize data models for performance and scalability.
• Use Power Query and DAX for data manipulation and modeling.
• Collaborate with data engineers and architects to ensure efficient data sourcing, transformation, and visualization.
• Translate business requirements into technical specifications and provide actionable insights based on data analysis.
• Ensure optimal performance and scalability of dashboards through testing and tuning of data models and reports.
• Test dashboards and reports to ensure they meet business requirements and are free of errors.
• Validate data accuracy and consistency in reports.
• Document the development process, data models, and report configurations.
• Create user guides and training materials to support end-users.
• Monitor and optimize report performance to ensure quick load times and responsiveness.
• Stay updated with the latest trends and best practices in Power BI.
• Provide technical support and troubleshooting for reporting tools and data connections.
• Troubleshoot and resolve problems with reports, data connections, and dashboards.
• Collaborate with cross-functional teams, including IT and business stakeholders, to understand reporting needs and deliver impactful solutions.

Requirements

• Bachelor's degree in computer science, information technology, data science, or a related field.
• 3+ years of experience with Power BI in a professional environment.
• Strong expertise in connecting to and working with Databricks and Data Sphere.
• Proficient in SQL, DAX, and data modeling techniques.
• Experience working with large datasets and optimizing queries for performance.
• Familiarity with cloud platforms such as Azure, AWS, or Google Cloud is a plus.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication skills and the ability to work effectively with both technical and non-technical stakeholders.

Nice-to-haves

• Experience with version control systems like Git for tracking changes to dashboards, reports, and data models.
• Exposure to other BI tools like MicroStrategy, SAP BusinessObjects, or Looker can be advantageous.

Benefits

• Paid Volunteer Program (Xylem Watermark)
• Diversity, Equity, and Inclusion initiatives
• Employee Resource Groups (ERG)
• Equal Employment Opportunity (including disability and veterans)
• Affirmative Action workplace