What are the responsibilities and job description for the Power BI Developer position at Core Technology Solutions?
We are seeking an experienced Power BI Developer for a long term contract located in Columbia, SC. This is a hybrid role but the candidate will be asked to work onsite 1-2 days weekly. Candidate must be authorized in the US and no c2c candidates please.
SCOPE OF THE PROJECT:
MICROSOFT POWERBI DEVELOPER TO SUPPORT DATA VISUALIZATION AND REPORTING NEEDS
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:
- Power BI Expertise
- Proficient in Power BI Desktop and Power BI Service for report creation and publishing.
- Experience embedding PowerBI in custom applications.
- Strong understanding of data modeling concepts and experience in building complex data models.
- Ability to write advanced DAX queries for calculations and data manipulation.
- Proficient in SQL for querying and extracting data from relational databases.
- Data Visualization.
- Strong verbal and written communication skills for collaboration.
- EXPERIENCED IN POWER APPS, POWER PLATFORM, AND DYNAMICS 365 APPS.
- SKILLED WITH SHAREPOINT, STREAM, AND TEAMS
PREFERRED SKILLS:
- EXPERIENCE WITH ETL TOOLS
- FAMILIARITY WITH ETL (EXTRACT, TRANSFORM, LOAD) TOOLS SUCH AS AZURE DATA FACTORY OR SSIS.
- UNDERSTANDING OF AZURE SERVICES RELATED TO DATA ANALYTICS AND REPORTING.
- FAMILIARITY WITH BUSINESS INTELLIGENCE METHODOLOGIES AND BEST PRACTICES.
- EXPERIENCE WITH .NET AND C#.
- UNDERSTANDING OF PROGRAMMING LANGUAGES LIKE DATA MANIPULATION AND ANALYSIS.
- EXPERIENCE WITH IBM SPSS
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)
