Business Intelligence Developer

$71,000 - $113,500/Yr

Xylem - Pittsburgh, PA

Full-time - Mid Level

Pittsburgh, PA

10,001+ employees

Computer and Electronic Product Manufacturing

About the position

As a Business Intelligence Developer at Xylem, you will play a crucial role in the BI team by designing, developing, and maintaining data-driven reports and dashboards using Power BI. Your work will enable organizations to make informed, data-driven decisions by transforming raw data into actionable insights that stakeholders can easily interpret. This position is integral to addressing critical water challenges through innovative and sustainable 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

• Familiarity with OLAP (Online Analytical Processing) cubes and their role in BI reporting.
• 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