Power BI & Data Integration Specialist

Socket.dev; United States; Remote; USD 84,000 - 124,000; Full time

Job summary

Calpine Community Energy seeks an experienced Power BI/Data Analytics technical specialist to design and optimize BI solutions across diverse data sources. You will build scalable data models, implement ETL processes, and collaborate with stakeholders to translate business needs into robust analytics.

The role emphasizes strong SQL/SSIS skills, API integration, data warehousing concepts, and production support within a fast-paced environment.

Qualifications

• Minimum 3 years of hands-on experience developing and maintaining Power BI solutions, including dashboards and semantic data models.
• Minimum 3 years of experience with DAX, Power Query, Data Flows, T-SQL, and SSIS.
• Minimum 3 years of experience in API development and integration.
• Minimum 3 years of experience writing, optimizing, and troubleshooting complex SQL queries.
• Experience with database design, data modeling, and data warehouse concepts.
• Proven experience designing, maintaining, and optimizing SQL Server environments supporting large data volumes.

Responsibilities

• Design, develop, maintain, and enhance Power BI reports, dashboards, and visualizations to support business decisions.
• Develop complex data models and perform advanced data transformation, using DAX, Power Query, SQL, and related tools.
• Consolidate, integrate, and transform data from diverse sources including databases, Excel files, text files, web APIs, and enterprise systems.
• Design and maintain relational and dimensional database models for reporting and analytics.
• Build, maintain, and optimize ETL processes using SSIS and other data integration tools.
• Develop scalable data solutions and data delivery mechanisms utilizing APIs and integration technologies.
• Perform data validation, QA, troubleshooting, and root-cause analysis for data accuracy.
• Optimize queries, reports, and data workflows for performance and scalability.
• Participate in DevOps/CI-CD processes including deployment automation and version control.
• Create and maintain technical documentation for data models, workflows, tests, configurations, and support procedures.
• Provide production support and respond to user questions after implementation.
• Collaborate with stakeholders and teams to translate business needs into technical solutions.
• Maintain clear communication with management and end users throughout lifecycle.

Skills

Power BI

DAX

Power Query

Data Flows

T-SQL

SSIS

SQL Server

C#

API Development and Integration

Data Modeling and Database Design

Query Optimization and Performance Tn

Education

Bachelor’s degree in information systems, Computer Science, Data Analytics, Engineering, or another technical discipline

Job description

Calpine Community Energy seeks an experienced Power BI/Data Analytics technical specialist to design and optimize BI solutions across diverse data sources. You will build scalable data models, implement ETL processes, and collaborate with stakeholders to translate business needs into robust analytics.

The role emphasizes strong SQL/SSIS skills, API integration, data warehousing concepts, and production support within a fast-paced environment.