Power BI Data Integration Specialist

Security Clearance required:Able to obtain Public Trust

Do you want to make a difference? 
Cognosante employees are passionate about improving people’s lives. With an innovative mindset and an unwavering commitment to those we serve, we partner with healthcare, civilian and defense agencies to deliver exceptional public services and programs. Our multi-faceted technology and customer experience (CX) solutions achieve program outcomes, solve critical challenges and create meaningful change. Whether we are helping Veterans access healthcare faster, ensuring that members of the military complete their missions safely, or helping people obtain health insurance, our work touches millions of people. Are you ready to make a difference?

Come Join Our Team 
Cognosante is on a mission to transform our country’s healthcare and safety systems. With our health and security-focused solutions, we help public sector organizations achieve the important task of providing the best possible public services to American Citizens. From Enterprise IT, Data Science, and Security Services to full-scale Consumer Engagement and Interoperability solutions, we are moving government services forward with transformation and innovation. Learn how we are making a difference in people’s lives today!
 
What is the position? 
Cognosante are seeking an experienced Power BI Data Integration Specialist to join our team and lead the integration of Power BI with our enterprise data architecture, leveraging real-time data streams such as Kafka. This role is critical to enhancing our data-driven decision-making capabilities by transforming complex data from various sources into meaningful, interactive visualizations. The ideal candidate will have deep expertise in Power BI, a strong understanding of real-time data processing, and the ability to manage cross-functional stakeholder requirements.
 
What will I get to do?  

Design and Develop Power BI Solutions: Build dynamic and interactive Power BI dashboards, reports, and visualizations for various business functions.

      •     Integrate with Real-Time Data Pipelines: Implement real-time Change Data Capture (CDC) and Event-Driven Architecture (EDA) patterns using Kafka or similar data pipelines.

      •     Data Modeling & Transformation: Create optimized data models and DAX formulas to support high-performance reporting.

      •     Data Integration: Connect Power BI to multiple data sources, such as SQL databases, Kafka, REST APIs and AWS Cloud integrations and more.

      •     Advanced Query Development: Utilize Power Query/M, DAX, and SQL for complex data transformations and advanced calculations.

      •     Deployment and Administration: Manage Power BI service deployments, establish security best practices, and optimize user permissions.

      •     Collaboration: Work closely with data engineers, software architects, and business stakeholders to ensure alignment on data requirements and project goals.

      •     Performance Tuning: Conduct performance analysis and optimization of data models, reports, and dashboards.

      •     Documentation: Prepare comprehensive technical documentation, including architectural diagrams, data flow diagrams, and report specifications.

Ability to create custom visuals using R programming language withing a PowerBI reporting environment

Knowledge and experience of working within PowerBI workspaces, to include dataset creations, publishing of reports and end user access.

      •     Support & Training: Provide ongoing support to users, deliver training sessions, and implement enhancements based on feedback.

      •     Troubleshooting: Diagnose and resolve data-related issues to ensure data integrity, modeling integrity, and accuracy in reporting.

      •     Service Deployments: Participate in the deployment of services and applications in applicable environments to support data analytics and reporting requirements.

 
What qualifications do I need? 

      •     5+ years of experience in designing and developing Power BI reports and dashboards.

      •     Proven experience in real-time data integration using RedHat Kafka, Apache Camel, or similar technologies.

      •     Advanced proficiency with DAX, Power Query (M), and SQL.

      •     Knowledge of data modeling concepts, schema design, and ETL processes.

      •     Familiarity with data streaming technologies such as AWS, RedHat Kafka, Apache Camel or Apache Pulsar.

      •     Strong analytical and problem-solving skills.

      •     Ability to translate business requirements into technical solutions.

      •     Excellent communication and collaboration skills. You are comfortable interacting with customers and have the ability to communicate effectively.

 •   Must be able to achieve a moderate (Tier 2) VA position of trust

 Candidates that do not meet the required qualifications will not be considered.

What additional characteristics will help me thrive?  

• Ability to work under minimal supervision on complex issues to deliver great results on schedule
• Ability to work equally well as both an individual contributor and a team member
• Ability to quickly learn new technologies, frameworks, and techniques; ability to facilitate technical conversations within your team and with external stakeholders
• Keen interest contributing to and building communities in open source
• Ability to self-learn
• Experience working in Agile or SAFe methodologies.
• Microsoft Certified: Data Analyst Associate or Power BI Certification.
• Familiarity with DevOps for Power BI (CI/CD pipelines) is a plus.
• Prior experience working with large-scale supply chain or master data management (MDM) systems.

• Experience working in regulated environments (FedRAMP/FISMA, HIPAA, PCI, ITAR, etc).

What We Offer  

Our mission is to provide comprehensive and competitive pay, benefits, services, and programs to eligible employees and their dependents that:  

• Ensure optimal health and productivity of our employees   

• Support employee retention and attraction  

• Provide work/life balance to ensure our employees succeed inside and outside of the office  

Compensation

$96,760.98 - $154,817.56

The pay range for this job is determined by various factors, including but not necessarily limited to location, responsibilities of the job, and alignment with market data. When determining a salary for this role, the following factors may be taken into consideration - contract-specific affordability, education, knowledge, skills, competencies and experience. The estimate displayed represents the salary range for this position and is just one component of Cognosante’s total compensation package for employees. It is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any specific employee. 

Cognosante will not provide sponsorship for employment-based immigration benefits for this position.

What We Promise  

Cognosante employees are inspired by our bold mission to improve lives. To achieve this mission, we put our people first. No matter where they're located around the nation, our innovative workplaces enable individuals to apply their skills and experience to work toward a greater good.  

We foster a winning culture of solution creators built on innovation, collaboration, flexibility, and work-life balance. And we invest in the next generation of diverse talent to foster an inclusive, progressive, adaptable workplace that prioritizes advancement for all. As an affirmative action employer, we are committed to equal opportunity regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.   

  

Your safety during your job search is important. Recruiting communications will always be sent through one of the following corporate domain emails (@cognosante.com or @accurate.com).  

We will never send communications through any other domain, including @cognosantecareers.com, @gmail.com or @yahoo.com). We will never request payment from you, nor will we send payment to you, prior to your start date. If you have been asked to send or receive any payment, or if you have any doubt about whether you have been contacted by a Cognosante employee, please contact us at jobs@cognosante.com