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 headquarteerd in Bloomfiled 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 .

Job Description:

Education:

• Bachelor's degree in computer science, Information Systems, or another related field. Or equivalent work experience.

Experience:

• A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing. Extensive experience with Informatica PowerCenter and Snowflake is preferred.

Primary Job Duties/ Tasks:

• Participates in strategic planning for the Informatica and Snowflake infrastructure, environment and process
• Administers the Informatica and Snowflake infrastructure, environment and process
• Analyzes transactional data stores and develops data warehouse models to optimize the warehouse data stores for reporting and analytics
• Prototypes, builds, and tests extraction, transformation, and load (ETL or ELT) jobs
• Prototypes, builds, and tests of data quality processes and related jobs
• Ensures data warehouse metadata is collected and maintained
• Prototypes, builds, and tests Power BI reports and dashboards
• Prototypes, builds, and tests Tableau reports and dashboards
• Coaches and mentors peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
• Assists with the development and maintenance of methods and practices documentation.

Job Specific Knowledge, Skills, and Abilities (KSAs):

• Extensive knowledge of data warehouse and data mart concepts
• Ability to model transactional data for data warehousing usage
• Knowledge of and skill in Snowflake cloud data warehouse functionality
• Extensive knowledge of and expert skill in use of Informatica PowerCenter and Cloud functionality
• Extensive Knowledge of and expert skill in administration of Informatica and Snowflake
• Knowledge of and skill in Informatica Data Quality functionality
• Knowledge of and skill in Informatica Data Catalog functionality
• Knowledge of and skill in Power BI functionality
• Knowledge of and skill in Tableau functionality
• Knowledge of and skill in relational database platforms including DB2, SQL Server, and Oracle

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.