> Markdown version of [/jobs/ext/2988767-msbi-data-architect](https://www.wearedevelopers.com/jobs/ext/2988767-msbi-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# MSBI Data Architect

- **Company:** Vaarida Technologies Llc
- **Location:** Davenport, IA, United States (Remote available)
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Databases, Extract Transform Load (ETL), Data Transformation, Data Retrieval, Data Warehousing, Microsoft SQL Server, Oracle (Applications), Power BI, Cloud Services, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Freeform SQL, System Availability, Powerquery, Web Api
- **Published:** September 18, 2026
- **Apply:** https://www.dice.com/job-detail/ae3b23b4-f887-4f28-b842-1e64aca8e5bf

## About the Role

* Understanding and support existing reports in SSRS and developing new reports.
 * Domain knowledge of metal and manufacturing industry is a big plus
 * Strong analytical and problem-solving skills.
 * Excellent communication and presentation skills, with the ability to convey technical concepts to
 * non-technical audiences.
 * Ability to work effectively both independently and as part of a team, * Familiar with Agile and waterfall models.
 * Strong analytical and problem solving skills.
 * Excellent communication skills with business and technical stakeholders.
 * Ability to work independently in a high availability manufacturing environment.
 * Proactive mindset with ownership and accountability.
 * Experience working in onsite-offshore delivery models.

CONTRACTOR, FULL_TIME, PART_TIME

## Description

Strong foundation in MS SQL server

 * Create complex SQL queries, view, Stored procedure etc. in SQL server.
 * Design and implement robust ETL using SSIS.
 * Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.
 * Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI.
 * Optimize data models for performance, ensuring efficient data retrieval and processing.
 * Develop advanced DAX formulas and Power Query transformations to create complex calculations and data transformations., * Coordinate with external technical and Functional team to understand requirements, convert that to
 * technical specifications.
 * Understand existing source SQL data architecture
 * and rearchitect downstream SQL Datawarehouse based on new source system
 * Modify existing standards as well as customized program based on requirement
 * Analyze issues and provide resolution
 * Work with offshore team to provide the requirements and supervise the overall work
 * Testing of application
 * Estimate the effort and timelines for enhancements
 * Create/update technical specifications
 * Generic Managerial Skills, If any
 * Strong communication skills and client/stakeholder interfacing is mandatory.
 * Developing reusable code/components for future use.
 * Optimization of the applications or modules for maximum performance and scalability.
 * Must follow and ensure the coding standards defined by Oracle and the community in the project.


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Web APIs you might not know about](https://www.wearedevelopers.com/videos/281-web-apis-you-might-not-know-about)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)