Data Engineer II

Data Engineer II

JAt Personify Health, we value and celebrate diversity and are committed to creating an inclusive environment for all employees. We believe in creating teams made up of individuals with various backgrounds, experiences, and perspectives. Why? Because diversity inspires innovation and collaboration and challenges us to produce better solutions. But more than this, diversity is our strength, and a catalyst in our ability to #changelivesforgood.

Job Summary

As a Business Intelligence developer, you'll understand the Schema layer to build complex BI reports and Dashboards with a keen focus on the healthcare and wellbeing industry. Your SQL skills will play a significant role in data manipulation and delivery, and your experience with MicroStrategy will be vital for creating BI tools and reports. This role will help migrate and build new analytics products based on MicroStrategy to support teams with their internal and external reporting for Health Comp data.

Essential Functions/Responsibilities/Duties

• 
  Work closely with Senior Business Intelligence engineer and BI architect to understand the schema objects and build BI reports and Dashboards
• Participation in sprint refinement, planning, and kick-off to understand the Agile process and Sprint priorities
• Develop necessary transformations and aggregate tables required for the reporting\Dashboard needs
• Understand the Schema layer in MicroStrategy and business requirements
• Develop complex reports and Dashboards in MicroStrategy
• Investigate and troubleshoot issues with Dashboard and reports
• Proactively researching new technologies and proposing improvements to processes and tech stack
• Create test cases and scenarios to validate the dashboards and maintain data accuracy

Education and Experience

• 
  3 years of experience in Business Intelligence and Data warehousing
• 3+ years of experience in MicroStrategy Reports and Dashboard development
• 2 years of experience in SQL
• Bachelors or master’s degree in IT or Computer Science or ECE.
• Nice to have – Any MicroStrategy certifications

Required Knowledge, Skills, and Abilities

• 
  Good in writing complex SQL, including aggregate functions, subqueries and complex date calculations and able to teach these concepts to others.
• Detail oriented and able to examine data and code for quality and accuracy.
• Self-Starter – taking initiative when inefficiencies or opportunities are seen.
• Good understanding of modern relational and non-relational models and differences between them
• Good understanding of Datawarehouse concepts, snowflake & star schema architecture and SCD concepts
• Good understanding of MicroStrategy Schema objects
• Develop Public objects such as metrics, filters, prompts, derived objects, custom groups and consolidations in MicroStrategy
• Develop complex reports and dashboards using OLAP and MTDI cubes
• Create complex dashboards with data blending
• Understand VLDB settings and report optimization
• Understand security filters and connection mappings in MSTR

Work Environment

At Personify Health, we value and celebrate diversity and are committed to creating an inclusive environment for all employees. We believe in creating teams made up of individuals with various backgrounds, experiences, and perspectives. Diversity inspires innovation and collaboration and challenges us to produce better solutions. But more than this, diversity is our strength and a catalyst in our ability to change lives for the good.

Physical Requirements

• Constantly operates a computer and other office productivity machinery, such as copy machine, computer printer, calculator, etc.