As a Power BI developer with expertise in DAX (Data Analysis Expressions), your primary job duties would revolve around designing, developing, and maintaining Power BI solutions.

II.

Provide technical guidance and expertise in supporting the department in developing Power BI dashboards, DAX, data mappings, and monitoring high-volume of complex data processes.

III.

Data Modeling and Analysis: Designing data models and relationships in Power BI to ensure efficient data retrieval and analysis. Creating DAX formulas to calculate and summarize data for visualizations.

IV.

Report and Dashboard Development: Creating interactive and visually appealing reports and dashboards in Power BI that provide actionable insights to stakeholders.

V.

DAX Formulas and Calculations: Developing complex DAX formulas to perform calculations, aggregations, time intelligence, and other data manipulations within Power BI.

VI.

Data Integration: Extracting, transforming, and loading data from various sources into Power BI, including databases, spreadsheets, cloud services, and APIs.

VII.

Performance Optimization: Optimizing Power BI reports and DAX calculations for improved performance and faster query response times.

VIII.

Data Visualization: Select appropriate visualizations (e.g., charts, tables, maps, KPIs) to represent data effectively and enable users to gain insights quickly.

IX.

Data Security and Governance: Implementing data security measures within Power BI to ensure that sensitive information is accessible only to authorized users. Adhering to data governance policies and regulations.

X.

Data Quality and Validation: Ensuring the accuracy and integrity of data by validating and cleansing data during the integration process.

XI.

Collaboration and Documentation: Collaborating with business stakeholders, data analysts, and other team members to understand requirements and deliver effective solutions. Documenting data models, DAX formulas, and development processes for future reference and knowledge sharing.

XII.

Troubleshooting and Issue Resolution: Identifying and resolving issues related to data connections, DAX calculations, and report performance.

The Vendor will be paid for the staff augmentation hours worked. The Department expects the Vendor’s staff to perform services in a project-like manner. The Vendor staff must be capable of driving the service delivery required purchase order on their own through delivery of quality application changes. Also, the Vendor staff will work cooperatively and in conjunction

Primary Job Duties and Tasks

The department is seeking a Systems Analyst,

The activities this candidate will be tasked with include, but are not limited to the following:

This position is to provide technical guidance and expertise in supporting the department in developing Power BI dashboards, DAX, data mappings, and monitoring high-volume of complex data processes.

Specific Knowledge, Skills and Abilities (KSAs)

The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:

• As a Power BI developer with expertise in DAX (Data Analysis Expressions), your primary job duties would revolve around designing, developing, and maintaining Power BI solutions.

Minimum Required KSAs:

• Candidates should have at least 5 years of experience in the job duties listed below:
• Data Modeling and Analysis: Designing data models and relationships in Power BI to ensure efficient data retrieval and analysis. Creating DAX formulas to calculate and summarize data for visualizations.
• Report and Dashboard Development: Creating interactive and visually appealing reports and dashboards in Power BI that provide actionable insights to stakeholders.

DAX Formulas and Calculations: Developing complex DAX formulas to perform calculations, aggregations, time intelligence, and other data manipulations within Power BI.

• Data Integration: Extracting, transforming, and loading data from various sources into Power BI, including databases, spreadsheets, cloud services, and APIs.
• Performance Optimization: Optimizing Power BI reports and DAX calculations for improved performance and faster query response times.
• Data Visualization: Select appropriate visualizations (e.g., charts, tables, maps, KPIs) to represent data effectively and enable users to gain insights quickly.
• Data Security and Governance: Implementing data security measures within Power BI to ensure that sensitive information is accessible only to authorized users. Adhering to data governance policies and regulations.
• Data Quality and Validation: Ensuring the accuracy and integrity of data by validating and cleansing data during the integration process.
• Collaboration and Documentation: Collaborating with business stakeholders, data analysts, and other team members to understand requirements and deliver effective solutions. Documenting data models, DAX formulas, and development processes for future reference and knowledge sharing.
• Troubleshooting and Issue Resolution: Identifying and resolving issues related to data connections, DAX calculations, and report performance.