Principal Data Analyst(PowerBI,Azure) - Remote

Other Jobs To Apply

<strong>Description<br><br></strong>Principal Data Analyst<br><br>100% Telecommute<br><br><strong>Responsibilities<br><br></strong>Develop and deliver long-term strategic goals for data architecture vision and standards in conjunction with data users, clients, and other key stakeholders.<br><br>Lead data architecture, data modeling, and data movement initiatives to enhance the architecture of data warehouse which supports analytics for Medicaid and Medicare and Commercial healthcare data; including domains such as claims, provider, TPL, and member information subject areas.<br><br>Create end-to-end vision on how logical design translates into one or more physical databases, and how the data will flow through the successive stages. Analyzing and translating business needs into long-term solution data models.<br><br>Evaluating existing data systems. Working with the development team to create conceptual data models and data flows.<br><br>Ensure that data strategies and architectures are in regulatory compliance.<br><br>Recognize and identify potential areas where existing policies and procedures require change, or where new ones are needed.<br><br>Oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.<br><br>Create and maintain data model and metadata policies and procedures for functional design.<br><br>Provide technical recommendations and engage with other ETL Architects, Business SMEs and other stakeholders throughout the Solution/Data Architecture and implementation lifecycle and recommend effective solutions to develop high performance and highly scalable data solutions (data marts/warehouse, data mining, and advanced analytics)<br><br>Address data-related problems regarding systems integration, compatibility, and multiple-platform integration.<br><br>Develop and implement key components as needed to create testing criteria to guarantee the fidelity and performance of data architecture.<br><br>Document data architecture and enterprise environment to maintain a current and accurate view of the larger data picture, an environment that supports a single version of the truth and is scalable to support future analytical needs.<br><br>Communicate with customer, project team in a timely manner and escalates issues & risks appropriately.<br><br><strong>Skills<br><br></strong>Strong problem solving, influencing, communication, and presentation skills, self-starter.<br><br>Expertise in Data Modeling, Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client.<br><br>Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards.<br><br>Strong Healthcare domain knowledge of Medicaid, Medicare, and Commercial healthcare data sets.<br><br>Expertise with normalized OLTP, OLAP, MDM and Dimensional modeling techniques, Star schemas, slowly changing dimensions, role-playing dimensions, dimensional hierarchies, and data classification.<br><br>Expert level SQL skills with direct experience writing complex analytic queries, stored procedures, DDL, DML and DCL. Thorough knowledge of query optimization techniques with the ability to write code to ANSI standards and inspect code written by other developers.<br><br>Expertise in Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival and Data Migration strategies using appropriate tools.<br><br><strong>Preffered Skills<br><br></strong>Experience with Microsoft Azure cloud infrastructure and services (Azure Data Lake Storage, Azure Data Factory, Purview, Azure Maps, etc.)<br><br>Experience with Snowflake DBMS<br><br>Experience with PowerBI or Tableau<br><br><strong>Ideal Candidate<br><br></strong>We want to be as specific as possible with our firms so they can find the type of candidate you're looking for.<br><br>Data modeler with Medicaid/Healthcare experience<br><br><strong>Top 3 Skills<br><br></strong>Strong problem solving, influencing, communication, and presentation skills, self-starter.<br><br>Expertise in Data Modeling, Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client.<br><br>Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards.<br><br>Strong Healthcare domain knowledge of Medicaid, Medicare, and Commercial healthcare data sets.<br><br>5+ years of experience with Erwin data modeler<br><br>Optum is currently seeking a hands-on Senior Health Data Modeler to support our CT EDW within the Enterprise Datawarehouse and Analytics group. The Data Modeler will work with large healthcare datasets and will translate client's business requirements into enterprise systems, applications, or process designs for large complex health data solutions. The role will drive and support initiatives for the CT EDW as well as participate in the wider EDW group's areas of data usage and governance, information management, privacy and security, SOA, data analytics and visualization and information modeling.<br><br>Required Skills : Data Analysis<br><br><strong>Basic Qualification<br><br></strong>Additional Skills :<br><br>Background Check : No<br><br>Drug Screen : No

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...