Post in 1 month ago

SQL Server & Power BI Developer

Summary

The client wants an experienced developer to improve an existing SQL Server data warehouse and Power BI reporting environment. The main goal is to make the company's data storage, data processing, reporting, and KPI calculations more reliable and efficient. The developer will likely work on: - Improving the existing data warehouse. - Optimizing SQL queries, views, and stored procedures. - Building or improving ETL pipelines. - Automating data refreshes. - Developing Power BI dashboards and semantic models. - Creating consistent KPI definitions across reports. - Managing SQL Server and Power BI access permissions. - Improving reporting performance and data accuracy. This is an ongoing technical role, not simply a task to create one dashboard.

  1. Required work
  2. 1. SQL Server and T-SQL
  3. Write and optimize SQL queries.
  4. Develop SQL views and stored procedures.
  5. Troubleshoot slow database operations.
  6. 2. Data Warehousing
  7. Improve warehouse structure.
  8. Apply dimensional modeling concepts.
  9. Organize data for reliable reporting.
  10. 3. ETL Pipelines
  11. Extract data from different sources.
  12. Transform and load data into the warehouse.
  13. Automate scheduled data refreshes.
  14. 4. Power BI Development
  15. Build and improve dashboards and reports.
  16. Use DAX measures and calculated columns.
  17. Transform data using Power Query.
  18. 5. Semantic Modeling and KPIs
  19. Create reusable data models.
  20. Define consistent business metrics.
  21. Ensure reports use the same KPI calculations.
  22. 6. Access Controls
  23. Configure appropriate database permissions.
  24. Manage Power BI access.
  25. Help protect sensitive business data.
  26. Expected deliverables
  27. Improved SQL Server database and warehouse.
  28. Optimized queries, views, and stored procedures.
  29. Reliable ETL and automated refresh processes.
  30. Improved Power BI semantic models and reports.
  31. Documented KPI definitions.
  32. Appropriate access-control configuration.
  33. Technical documentation and ongoing maintenance.
$2,000.00
Medium
Remote Job
Ongoing project

Skills and Expertise

4. Skills and ExpertiseRequired skill ImportanceSQL EssentialMicrosoft SQL Server EssentialTSQL programming EssentialMicrosoft Power BI EssentialDAX EssentialPower Query EssentialData warehousing EssentialDimensional modeling ImportantETL pipelines ImportantSQL performance optimization ImportantSemantic data modeling ImportantDatabase security and access controls Important

Activity on this job

Proposals:0 to 2
Last viewed by client:1 month ago
Interviewing:0
Hired:0

Explore similar jobs on Working Trust

Posted 10 days agoMedium
Proposals:0 to 2

Data Analyst for Business Insights

The client is looking for a data analyst who can help the business make better decisions through data. The freelancer will work with internal teams to understand business requirements, process and analyze datasets, identify patterns and trends, and communicate findings in a clear and practical way. The main focus is not just preparing spreadsheets. The client wants someone who can translate raw data into useful business insights. The work includes: - Understanding business requirements. - Reviewing and cleaning business data. - Identifying trends and patterns. - Checking data quality and accuracy. - Building dashboards. - Preparing clear business reports. - Presenting findings to internal teams. - Providing recommendations to improve operations.

UB

UK Business Insights & Data Analysis Client

Verified client

United Kingdom

$30.00 fixed price

Mandatory skills listed:Data Analysis+19 Skills

$ 450 spent

Payment Verified

Posted 30 days agoMedium
Proposals:0 to 2

A Website for Local Company Handling Water Supply

The client wants a website for a local water supply company in Riyadh, Saudi Arabia. The website should present the company's services, allow customers to contact the business, and support card payments. The client has provided two reference websites: - Fresh Water Supplier - Water Tanker Supply in Riyadh The references should help establish the desired design, layout, and water-supply service features. The client has not specified whether the website needs online ordering, delivery scheduling, customer accounts, or an administrative dashboard.

WC

WorkingTrust Client

Riyadh, Saudi Arabia

$200.00 fixed price

Required skills: Web DesignWeb Development+11 Skills

$ 450 spent

Payment Unverified