What are the responsibilities and job description for the MSBI Developer/Architect With Azure Stack position at Innovyt?
Role: MSBI Developer/Architect With Azure Stack
Duration: 9 Months Contract
Location: Irving/Dallas, TX (Onsite)
Must Have
BI Solution Development:
Translate business requirements into effective BI solutions, utilizing the full Microsoft BI Stack.
Develop and implement BI solutions with a focus on data accuracy, reliability, and performance.
ETL Processes with SSIS:
Develop and maintain ETL processes using SQL Server Integration Services (SSIS) for seamless data extraction, transformation, and loading.
Ensure the integration of data from diverse sources into the BI ecosystem.
Reporting and Visualization:
Design and develop interactive reports and dashboards using PowerBI, ensuring they meet end-user needs.
Create visually appealing and insightful reports that facilitate data-driven decision-making.
SSAS and SSRS Expertise:
Utilize SSAS for multidimensional and tabular data modeling.
Develop and maintain SSRS reports for operational and business reporting needs.
Performance Tuning and Optimization:
Monitor and optimize the performance of BI solutions, identifying and resolving performance bottlenecks.
Implement best practices for indexing, partitioning, and query optimization, including NoSQL-specific optimizations.
Collaboration and Documentation:
Collaborate with cross-functional teams to understand and address business requirements.
Document BI solutions, data models, and processes for knowledge sharing and future reference.
Data Modeling:
Design and maintain data models to support business reporting and analytics needs.
Implement best practices in data modeling for scalability and flexibility, including NoSQL data modeling.
Azure Integration:
Leverage Azure Data Factory for data integration and orchestration of ETL processes.
Implement and manage data pipelines in Azure to support BI initiatives, integrating NoSQL data sources.
Nice to Have
- NoSQL Database
Expertise:
- Design, implement, and optimize high-performance NoSQL databases, particularly Cosmos DB
- Ensure seamless integration of NoSQL data into the BI ecosystem.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a BI Developer, with expertise in the Microsoft Azure Stack.
- knowledge and expertise in ADF, Azure Synapse Analytics, Azure Data Lake, Cosmos DB (or any other NoSQL DB), BLOB Storage.
- Experience in SSAS, SQL Server, Power BI, SSRS, DAX Queries, DWH is added advantage.
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Ability to work independently and as part of a team.
