What are the responsibilities and job description for the Microsoft Power BI Developer position at Vector Consulting, Inc?
Job Details
Our government client is looking for experienced Microsoft Power BI Developer on a 75% remote 6 months renewable contract opportunity in Columbia, SC.
Role: Microsoft Power BI Developer
SCOPE OF THE PROJECT:
MICROSOFT POWERBI DEVELOPER TO SUPPORT DATA VISUALIZATION AND REPORTING NEEDS WITHIN THE AGENCY
DAILY DUTIES / RESPONSIBILITIES:
• Data Modeling and Transformation: Collaborate with stakeholders to gather requirements and translate them into technical specifications. Build and maintain data models within Power BI using DAX (Data Analysis Expressions) and Power Query.
• Report Development: Design, develop, and publish interactive dashboards and reports in Power BI. Ensure reports are user-friendly and meet business requirements.
• Data Integration: Connect Power BI to various data sources, including databases, APIs, and flat files. Perform data cleansing and transformation to prepare data for analysis.
• Performance Optimization: Monitor and optimize dashboard performance and responsiveness. Implement best practices for data visualization and reporting.
• Collaboration and Communication: Work closely with business stakeholders, data analysts, and other stakeholders to understand reporting needs. Provide training and support to end-users and ITS on using Power BI.
• Documentation: Maintain documentation of Power BI solutions, including data models, reports, and business logic. Create user guides and training materials for stakeholders.
• DEVELOP TECHNICAL DOCUMENTATION FOLLOWING AGENCY POLICIES, CJIS SECURITY GUIDANCE, AND STATE SECURITY STANDARDS.
• Troubleshooting and Support: Address any Power BI reports and dashboards issues. Provide ongoing support and maintenance for existing Power BI solutions.
• Facilitate ongoing knowledge sharing sessions with IT Team
• SUPPORTS AND ADHERES TO CHANGE MANAGEMENT PROCESS
• AWARENESS OF SECURITY-BASED CHANGE PROCESSES, I.E., DOCUMENTATION, DEPLOYMENT STRATEGIES, AND CHANGE LOG REVIEWS.
• IDENTIFIES RISKS AND COMMUNICATES RISKS TO THE CIO AND IT TEAMS.
REQUIRED SKILLS (RANKED IN ORDER OF IMPORTANCE):
• 1. Power BI Expertise:
• - Proficient in Power BI Desktop and Power BI Service for report creation and publishing. – Experience embedding PowerBI in custom applications
• 2. Data Modeling:
• - Strong understanding of data modeling concepts and experience in building complex data models.
• 3. DAX Proficiency:
• - Ability to write advanced DAX queries for calculations and data manipulation.
• 4. SQL Skills:
• - Proficient in SQL for querying and extracting data from relational databases.
• 5. Data Visualization:
• - Strong skills in creating engaging and effective visualizations that communicate data insights clearly.
• 6. Analytical Thinking:
• - Ability to analyze data requirements and translate them into actionable insights.
• 7. Communication Skills:
• - Strong verbal and written communication skills for collaboration and
• EXPERIENCED IN POWER APPS, POWER PLATFORM, AND DYNAMICS 365 APPS
• SKILLED WITH SHAREPOINT, STREAM, AND TEAMS
• CANDIDATE MUST BE ABLE TO DEMONSTRATE WORKING KNOWLEDGE
• ABILITY TO COMMUNICATE DIRECTLY WITH THE IT TEAM, BUSINESS EMPLOYEES, AND VENDOR PARTNERS.
PREFERRED SKILLS (RANKED IN ORDER OF IMPORTANCE):
• . EXPERIENCE WITH ETL TOOLS:
• - FAMILIARITY WITH ETL (EXTRACT, TRANSFORM, LOAD) TOOLS SUCH AS AZURE DATA FACTORY OR SSIS.
• 2. KNOWLEDGE OF AZURE SERVICES:
• - UNDERSTANDING OF AZURE SERVICES RELATED TO DATA ANALYTICS AND REPORTING.
• 3. BUSINESS INTELLIGENCE CONCEPTS:
• - FAMILIARITY WITH BUSINESS INTELLIGENCE METHODOLOGIES AND BEST PRACTICES.
• 4. EXPERIENCE WITH .NET AND C#
• - UNDERSTANDING OF PROGRAMMING LANGUAGES LIKE DATA MANIPULATION AND ANALYSIS.
EXPERIENCE WITH IBM SPSS
GOOD TIME MANAGEMENT SKILLS TO MEET PROJECT AND ACTION ITEMS DEADLINES
• EXCELLENT DECISION MAKING AND CRITICAL-THINKING SKILLS
• EXCELLENT ORAL AND WRITTEN COMMUNICATION SKILLS TO COMMUNICATE EFFECTIVELY WITH OTHERS
• ABILITY TO UNDERSTAND, DEVELOP, AND CREATE TECHNICAL DOCUMENTATION TO DEMONSTRATE WORKING KNOWLEDGE
• GOOD ORGANIZATION SKILLS AND DETAIL ORIENTED
• ABILITY TO LEARN AND SUPPORT NEW TECHNOLOGIES AND TRAIN OTHERS
• GOOD INTERPERSONAL SKILLS
• PROVEN ABILITY FOR SUPPORT TO END-USERS AND TECHNICAL SUPPORT TEAMS
• PROACTIVE AND SELF-MOTIVATED
• SELF-MANAGE ABILITIES
REQUIRED EDUCATION:
BACHELOR'S DEGREE OR MASTER’S DEGREE COMPUTER SCIENCE, INFORMATION TECHNOLOGY, DATA SCIENCE, OR A RELATED FIELD.
OR EQUIVALENT WORK EXPERIENCE.
PREFERRED MICROSOFT AZURE ASSOCIATE OR EXPERT CERTIFICATIONS:
MICROSOFT CERTIFIED: DATA ANALYST ASSOCIATE
- MICROSOFT CERTIFIED: AZURE DATA SCIENTIST ASSOCIATE
- MICROSOFT CERTIFIED: AZURE DATA ENGINEER ASSOCIATE
- POWER BI CERTIFICATION (FROM RECOGNIZED INSTITUTIONS)
About Vector:
Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAY
“Celebrating 30 years of service.”
#LI-DC1
Role: Microsoft Power BI Developer
SCOPE OF THE PROJECT:
MICROSOFT POWERBI DEVELOPER TO SUPPORT DATA VISUALIZATION AND REPORTING NEEDS WITHIN THE AGENCY
DAILY DUTIES / RESPONSIBILITIES:
• Data Modeling and Transformation: Collaborate with stakeholders to gather requirements and translate them into technical specifications. Build and maintain data models within Power BI using DAX (Data Analysis Expressions) and Power Query.
• Report Development: Design, develop, and publish interactive dashboards and reports in Power BI. Ensure reports are user-friendly and meet business requirements.
• Data Integration: Connect Power BI to various data sources, including databases, APIs, and flat files. Perform data cleansing and transformation to prepare data for analysis.
• Performance Optimization: Monitor and optimize dashboard performance and responsiveness. Implement best practices for data visualization and reporting.
• Collaboration and Communication: Work closely with business stakeholders, data analysts, and other stakeholders to understand reporting needs. Provide training and support to end-users and ITS on using Power BI.
• Documentation: Maintain documentation of Power BI solutions, including data models, reports, and business logic. Create user guides and training materials for stakeholders.
• DEVELOP TECHNICAL DOCUMENTATION FOLLOWING AGENCY POLICIES, CJIS SECURITY GUIDANCE, AND STATE SECURITY STANDARDS.
• Troubleshooting and Support: Address any Power BI reports and dashboards issues. Provide ongoing support and maintenance for existing Power BI solutions.
• Facilitate ongoing knowledge sharing sessions with IT Team
• SUPPORTS AND ADHERES TO CHANGE MANAGEMENT PROCESS
• AWARENESS OF SECURITY-BASED CHANGE PROCESSES, I.E., DOCUMENTATION, DEPLOYMENT STRATEGIES, AND CHANGE LOG REVIEWS.
• IDENTIFIES RISKS AND COMMUNICATES RISKS TO THE CIO AND IT TEAMS.
REQUIRED SKILLS (RANKED IN ORDER OF IMPORTANCE):
• 1. Power BI Expertise:
• - Proficient in Power BI Desktop and Power BI Service for report creation and publishing. – Experience embedding PowerBI in custom applications
• 2. Data Modeling:
• - Strong understanding of data modeling concepts and experience in building complex data models.
• 3. DAX Proficiency:
• - Ability to write advanced DAX queries for calculations and data manipulation.
• 4. SQL Skills:
• - Proficient in SQL for querying and extracting data from relational databases.
• 5. Data Visualization:
• - Strong skills in creating engaging and effective visualizations that communicate data insights clearly.
• 6. Analytical Thinking:
• - Ability to analyze data requirements and translate them into actionable insights.
• 7. Communication Skills:
• - Strong verbal and written communication skills for collaboration and
• EXPERIENCED IN POWER APPS, POWER PLATFORM, AND DYNAMICS 365 APPS
• SKILLED WITH SHAREPOINT, STREAM, AND TEAMS
• CANDIDATE MUST BE ABLE TO DEMONSTRATE WORKING KNOWLEDGE
• ABILITY TO COMMUNICATE DIRECTLY WITH THE IT TEAM, BUSINESS EMPLOYEES, AND VENDOR PARTNERS.
PREFERRED SKILLS (RANKED IN ORDER OF IMPORTANCE):
• . EXPERIENCE WITH ETL TOOLS:
• - FAMILIARITY WITH ETL (EXTRACT, TRANSFORM, LOAD) TOOLS SUCH AS AZURE DATA FACTORY OR SSIS.
• 2. KNOWLEDGE OF AZURE SERVICES:
• - UNDERSTANDING OF AZURE SERVICES RELATED TO DATA ANALYTICS AND REPORTING.
• 3. BUSINESS INTELLIGENCE CONCEPTS:
• - FAMILIARITY WITH BUSINESS INTELLIGENCE METHODOLOGIES AND BEST PRACTICES.
• 4. EXPERIENCE WITH .NET AND C#
• - UNDERSTANDING OF PROGRAMMING LANGUAGES LIKE DATA MANIPULATION AND ANALYSIS.
EXPERIENCE WITH IBM SPSS
GOOD TIME MANAGEMENT SKILLS TO MEET PROJECT AND ACTION ITEMS DEADLINES
• EXCELLENT DECISION MAKING AND CRITICAL-THINKING SKILLS
• EXCELLENT ORAL AND WRITTEN COMMUNICATION SKILLS TO COMMUNICATE EFFECTIVELY WITH OTHERS
• ABILITY TO UNDERSTAND, DEVELOP, AND CREATE TECHNICAL DOCUMENTATION TO DEMONSTRATE WORKING KNOWLEDGE
• GOOD ORGANIZATION SKILLS AND DETAIL ORIENTED
• ABILITY TO LEARN AND SUPPORT NEW TECHNOLOGIES AND TRAIN OTHERS
• GOOD INTERPERSONAL SKILLS
• PROVEN ABILITY FOR SUPPORT TO END-USERS AND TECHNICAL SUPPORT TEAMS
• PROACTIVE AND SELF-MOTIVATED
• SELF-MANAGE ABILITIES
REQUIRED EDUCATION:
BACHELOR'S DEGREE OR MASTER’S DEGREE COMPUTER SCIENCE, INFORMATION TECHNOLOGY, DATA SCIENCE, OR A RELATED FIELD.
OR EQUIVALENT WORK EXPERIENCE.
PREFERRED MICROSOFT AZURE ASSOCIATE OR EXPERT CERTIFICATIONS:
MICROSOFT CERTIFIED: DATA ANALYST ASSOCIATE
- MICROSOFT CERTIFIED: AZURE DATA SCIENTIST ASSOCIATE
- MICROSOFT CERTIFIED: AZURE DATA ENGINEER ASSOCIATE
- POWER BI CERTIFICATION (FROM RECOGNIZED INSTITUTIONS)
About Vector:
Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAY
“Celebrating 30 years of service.”
#LI-DC1
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
