Sr. Data Analyst

Responsibilities:

·         Develop, maintain, and manage advanced reporting, analytics, dashboards, and other BI solutions using Power BI Perform and document data analysis, data validation, data mapping/design, by producing ad hoc reports and complex data queries

·         Work closely with teams to integrate systems and data effectively and efficiently, ensuring high levels of data accuracy

·         Design, build and deploy BI solutions for the business teams

·         Work with Power BI Dataflows, build complex DAX calculations, and manage Power BI Datasets

·         Troubleshooting issues reported by users

·         Support problem resolution; consult and advise in application design and tuning; plan, organize and execute product benchmarks for threshold and functionality

·         Supports existing reporting solutions including developing fixes as necessary and providing support for complex issues

·         Participate in product evaluations, design review session, and consulting with application development products

·         Gathers, understands, and documents user requirements and technical specifications.

·         Follows all software requirements development standards

·         Review ongoing and proposed projects to identify opportunities for reuse and process improvement

·         Utilizes available programming methodologies and languages and adhere to coding standards, procedures and techniques while contributing to the technical code documentation

·         Ideal Background:

·         would have background in healthcare data, and strong technical and analytical skills

Top requirements:

·         Power BI relational database concepts

·         experience with Snowflake, SQL Server, Teradata and Oracle DB

Required:

·         5+ years of experience in Power BI; Power BI Desktop, Power BI Service and Power BI Report Builder

·         Solid knowledge of relational database concepts; experience with Snowflake, SQL Server, Teradata and Oracle DB

·         Proven excellent problem-solving, analytical, and communication skills

·         Proven work experience as a SQL Developer or similar role; excellent understanding of T-SQL programming, M Query and DAX

·         Experiences on BI, Data ware housing architecture and implementations

·         Experience with version control, collaboration, and code management (GitHub)

·         Knowledge on Azure or cloud-based solutions on SQL platform, supporting key, business initiatives, and data Gateway

·         Experience with healthcare data (claims, financial, provider enrolment, member eligibility)

Preferred: 

·         familiar with Azure services, SQL, Power BI, Snowflake