Raleigh's Startup Career Hub

Power BI Developer

Pivotal IT Services

Pivotal IT Services

Software Engineering
Posted on Saturday, June 29, 2024

Power BI Developer

  • Remote
  • Full-time


About Our Team

Our employees thrive in a culture that's fast-paced and ego-free, where innovation and collaboration are encouraged at every turn. We are an organization that provides federal agencies instant access to experienced and talented professionals who understand their unique challenges and know the most efficient ways to address them. We are continually investing in resources and talent, so we stay prepared with specialized teams in place who are experts in creating tailored technologies. Our solutions empower Federal organizations to grow, modernize, and succeed in a rapidly evolving landscape.

We value all voices and want to attract talent from all backgrounds. We're on the lookout for individuals who are passionate about technology and thrive in environments where problem-solving is approached with creativity and enthusiasm. If you're someone who enjoys continuously expanding your skill set while tackling real-world business problems, you'll feel right at home with us. Veterans and military spouses are especially encouraged to bring your unique and valuable experience to our team.

Power BI Developer

i4DM is seeking a Power BI Developer to join our fast-growing IT-project based consulting business. We need a well-rounded team member with a background in SQL, Database Development, Analytics, Reporting, and Data Presentation to support the data visualization needs of a critical, front-line solution for the Department of Veterans Affairs. The Microsoft Power BI Developer will collaborate with a mix of technical experts and architects, business/product owners, business analysts, technical writers, testers, and scrum masters in an Agile-Scrum environment. Our Power BI developer will need to bring analytical thinking to the role and be able to translate data into informative reports and visuals.

i4DM is a full-service information technology firm established in 2002. We work closely with clients to gain an understanding of their environment, assess the available technologies, and build innovative solutions to quickly gain a competitive advantage. It is our mission “to apply innovative technology to transform data into knowledge, so that people can make better decisions."

We're seeking talented and bright team players who are passionate about technology and want to work in a fast-paced, dynamic, and ego-free culture while applying a creative approach to problem-solving. Team members who like to grow their skill sets while solving challenging, real world business problems thrive at i4DM. By joining our team, you’ll become a part of a fun and diverse team of talented and creative people who share the goal of using the latest technology to solve business challenges.


  • You will work and collaborate on a team of project managers, business analysts, developers/engineers, and QA staff within an Agile DevSecOps environment. As a crucial member of our team, you will also be expected to interface with client representatives. Our team member will:
  • Actively engage in the analysis of report design requirements and participate with Agile team members to understand the business requirements
  • Develop visual reports, KPI scorecards, and dashboards using Power BI desktop
  • Create reports using Microsoft Power BI including several types like Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
  • Connect data sources, import data, and transform data for Business intelligence
  • Develop tabular and multidimensional models that are compatible with data warehouse standards
  • Utilize advanced Power BI features such as bookmarks, selections, and drill-through to enhance user experience.
  • Connect data sources, import data, and transform data for business intelligence (ETL).
  • Create queries using DAX in Power BI desktop
  • Perform data transformations and data cleaning to generate meaningful reports.
  • Support analytics initiatives to ensure that the right people are seeing the right data at the right time.
  • Integrate Power BI with Microsoft Dynamics 365 to streamline data analysis and reporting processes.
  • Develop and maintain Power BI data flows and datasets.
  • Implement and manage Power BI service features such as data gateways, apps, and workspaces.
  • Conduct performance tuning of Power BI reports and dashboards to ensure optimal performance.
  • Actively participate with an Agile-Scrum team.
  • Engage with the team to refine and estimate stories in the backlog.
  • Support the development of technical strategies aimed at improving productivity across various functional areas within the organization.
  • Operate effectively under tight deadlines and manage multiple tasks concurrently.


  • Have a BA/BS Degree in Computer Science or related area or equivalent work experience.
  • Minimum Three (3) years of experience in designing and implementing complex Power BI Reports and Dashboards leveraging Power BI desktop and service.
  • Minimum Three (3) years of experience using DAX and Power Query
  • Minimum Five (5) years of experience writing T-SQL queries and development within MS SQL Server
  • Minimum of two (2) years of experience working with Microsoft Dynamics 365, specifically in data integration and report generation.
  • Demonstrated expertise in using advanced level calculations on the data set
  • Knowledge of Azure and Azure Data Lake is strongly preferred
  • Have solid experience running/participating in meetings with remote team members through collaboration technology
  • Have some experience with Agile and collaboration technologies including Jira, Confluence, and SharePoint
  • Have solid Client Interaction and Problem-solving skills
  • Military experienced candidates are encouraged to apply
  • Candidates will need to obtain Security Clearance of Public Trust once hired
  • Candidates are required to be full vaccinated against COVID 19
  • Work Remotely


  • Experience supporting Veterans Affairs programs or Healthcare IT programs
  • Expertise in modular application architectures
  • Understanding and expertise of HCD/UCD principles
  • Strong knowledge of APIs and integration strategies


Comprehensive healthcare coverage, HSA Plan, Life and Disability Insurance, and Retirement Savings Plan.