Data Warehouse Analyst

V2Soft is a global leader in IT services and business solutions, delivering innovative and cost-effective technology solutions worldwide since 1998. We have We have headquartered in Bloomfield Hills, MI and have 16 offices spread across six countries. We partner with Fortune 500 companies to address complex business challenges. Our services span AI, IT staffing, cloud computing, engineering, mobility, testing, and more. Certified with CMMI Level 3 and ISO standards, V2Soft is committed to quality and security. Beyond our work, we actively support local communities and non-profits, reflecting our core values. Join us to be part of a dynamic and impactful global company! Please visit us at www.V2soft.com to know more.Education:

• Bachelor’s degree in computer science, Information Systems, or other related fields. Or equivalent work experience. Equivalent work experience may substitute for the educational requirement.

Experience:

• Required minimum of 5 years of IT work experience in business intelligence tools and systems.
• A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports, dashboards, and data models using Microsoft Power BI, including advanced report design, paginated reports, performance tuning, and DAX.
• Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.
• Strong understanding of star schema design and fact/dimension modeling.
• Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.
• Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance.
• Proficient in building Power BI semantic models with strong DAX and clean dimensional design.
• Experience in integrating Power BI with Snowflake and connection modes.
• Proficiency in Power BI Report Builder, workspace management, and performance optimization.

• Experience with metadata management, data lineage, and documentation.
• Experience embedding Power BI reports into web or internal applications.
• Knowledge of CI/CD for Power BI and version control is a plus.

Job Duties:

• Design and develop Power BI dataflows and semantic models using dimensional modeling practices.
• Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.
• Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.
• Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.
• Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.
• Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.
• Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.

V2Soft is an Equal Opportunity Employer ( EOE). We welcome applicants from all backgrounds, including individuals with disabilities and veterans.https://www.v2soft.com/careers - to view all of our open opportunities and to learn more about our benefits.