Power BI Analyst - CHA Consulting, Inc.

Finding a better way.

At CHA, we believe in the power of clean water, resilient energy, safer roads, and structures that harmoniously blend with their surroundings. We create solutions. We help People. We improve our world. At CHA, we embed ourselves in our communities - and take pride in improving things where we live. At the foundation is a commitment to inclusion and diversity and choosing to treat everyone with dignity and respect. We also take accountability for making decisions that promote sustainability in our business and our designs. We are on a mission to reduce our environmental footprint and bring greener solutions to our clients. We are responsibly creating a more sustainable future in ways that we can all see and touch. Together. Every day.

CHA Consulting, Inc. is currently seeking a Power BI Analyst to join our Corporate – Ops & Innovation Team at our office in Colonie, NY.

CHA's corporate support teams provide vital specialized services to our technical business lines and market teams including financial, legal, marketing, business development, human resources, information technology and operational services.  These teams may also support clients when their skills and expertise are required.

The Power BI Analyst will be responsible for designing, developing, and maintaining Power BI dashboards and reports that align with business requirements. Their expertise will be critical in implementing row-level security on data and understanding application security layer models for Power BI, leveraging Microsoft Fabric to enhance the deployment and functionality of dashboards. They will also develop DAX queries and calculations to ensure our reports deliver meaningful insights.

Collaboration with stakeholders will be key, as the Power BI analyst assesses business needs to provide data-driven solutions that optimize existing BI systems for performance and scalability. The Power BI Analyst will document all reports, dashboards, and data models thoroughly, ensuring clarity and accessibility for users. Additionally, they will assist with training users on BI reports and dashboard releases, empowering staff to leverage the insights effectively for informed decision-making. The contributions of the Power BI Analyst will play a vital role in enhancing our data analytics capabilities and driving business success.

At CHA, you can build a career and find your passion across our diverse business lines and project teams. Being part of CHA means being part of a team of talented professionals, where you’ll find support for your career growth and the opportunity to impact our industry and our communities. Find your “why” at CHA!

• Bachelors degree from an accredited college/university in Data Science, Data Analytics, Computer Science, or related fields
• Minimum of 5 years of progressive, increasingly responsible, experience with computer applications programming, supporting, and developing small and large-scale computer software applications
• Minimum two years recent experience in Power BI Development or Data Analytics
• Ability to problem solve effectively, detail oriented
• Proficient in SQL, and data model techniques; Experience with DAX is a plus
• Prior experience working in a Professional Services firm and with Deltek Vision is a plus
• Expertise working with data lakes, data warehouses, relational databases, and data modeling techniques; Experience with Microsoft Fabric and Azure Data Factory is a plus
• Ability to interpret business requirement and translate them into technical requirements
• Familiarity with other BI tool such as Tableau,  and data visualization best practices

$67,000 - $86,000

Salary is based on a variety of factors, including, but not limited to, qualifications, experience, education, licenses, specialty, training, and fair market evaluation based on industry standards. 

At CHA, we work every day to create solutions, help people, and improve our world, committed to creating and fostering excellence in our diverse and highly talented teams. Our teams continually strive to find better ways – always searching, never settling – to achieve extraordinary results. Our values around hiring, training, and community engagement reflect a company culture that is inclusive and forward leaning, always pushing the limits of what is possible.

We as an organization celebrate the values of inclusion and equality, and advocate for the full participation of all people in an environment free of discrimination. To support these values, we invite all qualified applicants to be considered for employment regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, age, disability, protected veteran status, or any other characteristic protected by law.