Data Engineer

Job Description

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 masters 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.