The Medica Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Medica Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Medica? The Medica Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Medica Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Medica.</li>
<li>Practice real Medica Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Medica Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Medica? The Medica Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Medica Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Medica.
- Practice real Medica Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Medica Business Intelligence interview.
        

Overview

Medica Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Medica Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

<p><strong>Input:</strong></p>

<p><strong><code>friend_requests</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

Medica Business Intelligence Interview Questions

<div>
<p>Medica's Product Manager IV: Individual and Family Business is responsible for the development, implementation, and management of a diverse portfolio of Individual & Family products across multiple states.</p>
<p>The Product Manager collaborates with various functional areas to assess market needs, feasibility for new and enhanced products, and manage regulatory filings at both state and federal levels. Key responsibilities include developing and implementing competitive IFB products, overseeing policy document development, ensuring timely CMS and state submissions, and maintaining the intent of product and plan design. This role requires close collaboration with segment leadership, sales, operations, compliance, legal, finance, pharmacy, underwriting, and actuarial teams to enhance market competitiveness and ensure proper product administration.</p>
<p>As an advanced-level professional, the Product Manager serves as a subject matter expert on product strategy, lifecycle activities and plan performance, particularly for accountable care organization (ACO) products. This includes direct engagement with external ACO leadership to improve product outcomes.</p>
<p>Additionally, the Product Manager contributes to strategic planning for Medica’s Individual & Family product portfolio by managing strategic partnerships and collaborating with legal and governmental agencies, including CMS and State DOIs.</p>
<p><b>Key Accountabilities:</b></p>
<ul>
<li>Lead product strategy and project teams to develop and deliver Individual & Family product solutions while collaborating with segment leadership to address issues and identify improvement opportunities.</li>
<li>Serve as a subject matter expert on benefits, interpreting federal and state regulatory guidance (e.g., ACA, CMS) to ensure compliance and implement aligned policies.</li>
<li>Analyze product areas to identify enhancements in benefits, networks, and formularies, collaborating with finance and actuarial teams to validate findings and recommend improvements.</li>
<li>Maintain a strong understanding of Individual & Family products and the Affordable Care Act (ACA), competitors and market developments, along with familiarity with claims platforms and processes.</li>
<li>Lead regulatory filings for Individual & Family products, ensuring benefit designs align with market trends and member needs while managing competitive intelligence for strategic insights.</li>
<li>Oversee project costs, schedules, and scopes, ensuring timely compliance with contractual reporting requirements from state and federal governments.</li>
<li>Communicate project status and key metrics across management levels, leading cross-functional teams to develop new programs and prioritize recommendations based on consumer demand.</li>
<li>Prepare and maintain comprehensive project documentation and summarize results for senior management.</li>
<li>Utilize analytical skills to identify effective solutions, developing partnerships with internal sales and account management teams.</li>
<li>Represent the segment in internal workgroups and lead external engagements with entities such as ACOs, state regulators, and brokers.</li>
</ul>
<p><b>Qualifications:</b></p>
<ul>
<li>Bachelor's degree or equivalent experience in a related field.</li>
<li>7 years of work experience beyond degree, including a minimum of 5 years of Product Management experience.</li>
<li>Knowledge / experience implementing ACA & state regulations within individual and family or small employer health insurance product.</li>
</ul>
<p><b>Additional Experience, Skills, and Abilities:</b></p>
<ul>
<li>Understanding of the overall customer experience and the product performance lifecycle.</li>
<li>Ability to support other product segments as needed.</li>
<li>Ability to perform tactical execution, identify areas of process improvement, and streamline processes.</li>
<li>Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook).</li>
<li>Detail-oriented.</li>
<li>Strong interpersonal skills, with strong written and verbal communication skills.</li>
<li>Ability to manage competing priorities and meet tight deadlines.</li>
<li>Independent, self-driven professional.</li>
</ul>
<p>This position is a Hub role, which requires an employee to occasionally come onsite to Minnetonka, MN or Madison, WI office for applicable heads-up work. Frequency is determined by business need as decided by leadership.</p>
<p>The full salary range for this position is $85,000 - $145,700. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.</p>
<p>Medica's commitment to diversity, equity and inclusion (DEI) includes unifying our workforce through learning and development, recruitment and retention. We consistently communicate the importance of DEI, celebrate achievements, and seek out community partnerships and diverse suppliers that are representative of everyone in our community. We are developing sustainable programs and investing time, talent and resources to ensure that we are living our values. We are an Equal Opportunity/Affirmative Action employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.</p>
</div>
#J-18808-Ljbffr

<p>As a Senior Data Engineer, you work in a team who strengthens data engineering to support agile growth. Engineer and build the data warehouse and ODS to manage increased demand from analytics and other consumers. Enable transitions to open source, machine learning and Cloud technology based on a solid data foundation. Consult with Domain Data Architects, Business Stakeholders, Data and Application Integration, solution architect and DBA.</p><br/><p>This role is responsible for converting Medica's data architecture into physical designs, implementing and maintaining data structures and processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of data sources. You will design and develop robust, scalable solutions that transform data into a useful format for analysis, enhance data flow, and enable efficient, cost-effective consumption and analysis of data. Support in designing Data solution to support cloud Data strategy evolution. You can write complex SQL or programs and mentor technical and business users about our data. You may evaluate and recommend tools and technologies for data infrastructure and processing.</p><br/><p>This role is involved in these areas:</p><br/><ul><li>Understand business and technical requirements.</li><li>Convert logical data models to physical data models, DDL, roles and views.</li><li>Create and update data architecture designs and data flows for subject areas impacted by a program/project. Create source to target documents for ETL developers and ensure an efficient design.</li><li>Work with BAs and Business SMEs on program/projects to understand requirements and identify non-functional requirements that will impact the data design.</li><li>Actively engaged as core member of scrum teams to deliver on data programs/projects.</li><li>Work with ETL and QA to ensure all requirements are met by the solution.</li><li>Work with DBA's to tune performance.</li><li>Experience with Cloud, SnowFlake databases, ADLS, Python.</li></ul><br/><p><strong>Required:</strong></p><br/><ul><li>BS in Computer Science or related field. An MS is a plus.</li><li>5 years of experience in software development and database applications with a majority of this experience in data strategy, sourcing, modeling, integration, and architecture.</li></ul><br/><p><strong>What you bring:</strong></p><br/><ul><li>Business Intelligence / Data Warehousing methodology.</li><li>Proficiency in SQL, Oracle PL/SQL and Informatica Powercenter/IDMC.</li><li>Evaluate, analyze, design, and implement solutions based on technical requirements.</li><li>Extensive experience creating data warehouses, data marts, and operational system databases.</li><li>Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence and deployment infrastructure diagrams.</li><li>Skilled in data analysis, data profiling, data integration, and data quality.</li><li>Data modeling for logical, physical, dimensional, and relational 3NF models.</li><li>Advanced knowledge of SQL, query tuning, RDBMS, and Query tools. Database performance tuning.</li><li>Strong implementation experience and deep knowledge in any one of the following three areas and knowledge of the other 2 areas at a minimum. Implementation experience in all the 3 areas preferred: ETL, Data Integration, Data Governance and Data Quality.</li><li>Experience with any modern RDBMS with 3NF and Dimensional design. Strong SQL skills and familiarity with executing DDL. Query and database performance tuning is a plus.</li><li>Strong knowledge of cloud Datawarehouse in particular Snowflake.</li><li>Must have experience at least with two / one end to end implementation of Snowflake cloud data warehouse.</li><li>Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts.</li><li>Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features.</li><li>Experience with concepts Snowflake utilities, SnowSQL, SnowPipe.</li><li>Experience partnering with cloud platform vendors, Microsoft Azure and/or AWS.</li><li>Healthcare experience is very desirable, especially payer knowledge of member, enrollment, claims and provider data.</li></ul><br/><p>In addition to above qualifications, please note:</p><br/><ul><li>CDMP (certified data management professional) or CBIP (certified business intelligence professional) is nice to have.</li><li>Experience with any of ERwin, ER Studio, PowerDesigner.</li><li>Experience with Informatica (preferred), Data Stage, or Microsoft SSIS/SSRS when used with a defined SDLC in a large, structured work process.</li><li>Certification in Agile methodology and ITIL foundations is a plus.</li><li>In depth experience in running data initiatives using agile methodology preferred.</li><li>Prior experience in ETL, reporting and analytics, and business intelligence tools is preferred.</li></ul><br/><p>The full salary range for this position is $85,000 - $145,700. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.</p><br/><p>Medica's commitment to diversity, equity and inclusion (DEI) includes unifying our workforce through learning and development, recruitment and retention. We consistently communicate the importance of DEI, celebrate achievements, and seek out community partnerships and diverse suppliers that are representative of everyone in our community. We are developing sustainable programs and investing time, talent and resources to ensure that we are living our values. We are an Equal Opportunity/Affirmative Action employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.</p>
#J-18808-Ljbffr

<div>
<p>As a Senior Data Engineer, you work in a team who strengthens data engineering to support agile growth. Engineer and build the data warehouse and ODS to manage increased demand from analytics and other consumers. Enable transitions to open source, machine learning and Cloud technology based on a solid data foundation. Consult with Domain Data Architects, Business Stakeholders, Data and Application Integration, solution architect and DBA.</p>
<p>This role is responsible for converting Medica’s data architecture into physical designs, implementing and maintaining data structures and processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of data sources. You will design and develop robust, scalable solutions that transform data into a useful format for analysis, enhance data flow, and enable efficient, cost-effective consumption and analysis of data. Support in designing Data solution to support cloud Data strategy evolution. You can write complex SQL or programs and mentor technical and business users about our data. You may evaluate and recommend tools and technologies for data infrastructure and processing.</p>
<p>This role is involved in these areas:</p>
<ul>
<li>Understand business and technical requirements.</li>
<li>Convert logical data models to physical data models, DDL, roles and views.</li>
<li>Create and update data architecture designs and data flows for subject areas impacted by a program/project. Create source to target documents for ETL developers and ensure an efficient design.</li>
<li>Work with BAs and Business SMEs on program/projects to understand requirements and identify non-functional requirements that will impact the data design.</li>
<li>Actively engaged as core member of scrum teams to deliver on data programs/projects.</li>
<li>Work with ETL and QA to ensure all requirements are met by the solution.</li>
<li>Work with DBA’s to tune performance.</li>
<li>Experience with Cloud, SnowFlake databases, ADLS, Python.</li>
</ul>
<br/>
<p><b>Required:</b></p>
<ul>
<li>BS in Computer Science or related field. An MS is a plus.</li>
<li>5 years of experience in software development and database applications with a majority of this experience in data strategy, sourcing, modeling, integration, and architecture.</li>
</ul>
<br/>
<p><b>What you bring:</b></p>
<ul>
<li>Business Intelligence / Data Warehousing methodology.</li>
<li>Proficiency in SQL, Oracle PL/SQL and Informatica Powercenter/IDMC.</li>
<li>Evaluate, analyze, design, and implement solutions based on technical requirements.</li>
<li>Extensive experience creating data warehouses, data marts, and operational system databases.</li>
<li>Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence and deployment infrastructure diagrams.</li>
<li>Skilled in data analysis, data profiling, data integration, and data quality.</li>
<li>Data modeling for logical, physical, dimensional, and relational 3NF models.</li>
<li>Advanced knowledge of SQL, query tuning, RDBMS, and Query tools. Database performance tuning.</li>
<li>Strong implementation experience and deep knowledge in any one of the following three areas and knowledge of the other 2 areas at a minimum. Implementation experience in all the 3 areas preferred: ETL, Data Integration, Data Governance and Data Quality.</li>
<li>Experience with any modern RDBMS with 3NF and Dimensional design. Strong SQL skills and familiarity with executing DDL. Query and database performance tuning is a plus.</li>
<li>Strong knowledge of cloud Datawarehouse in particular Snowflake.</li>
<li>Must have experience at least with two / one end to end implementation of Snowflake cloud data warehouse.</li>
<li>Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts.</li>
<li>Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features.</li>
<li>Experience with concepts Snowflake utilities, SnowSQL, SnowPipe.</li>
<li>Experience partnering with cloud platform vendors, Microsoft Azure and/or AWS.</li>
<li>Healthcare experience is very desirable, especially payer knowledge of member, enrollment, claims and provider data.</li>
</ul>
<p>In addition to above qualifications, please note:</p>
<ul>
<li>CDMP (certified data management professional) or CBIP (certified business intelligence professional) is nice to have.</li>
<li>Experience with any of ERwin, ER Studio, PowerDesigner.</li>
<li>Experience with Informatica (preferred), Data Stage, or Microsoft SSIS/SSRS when used with a defined SDLC in a large, structured work process.</li>
<li>Certification in Agile methodology and ITIL foundations is a plus.</li>
<li>In depth experience in running data initiatives using agile methodology preferred.</li>
<li>Prior experience in ETL, reporting and analytics, and business intelligence tools is preferred.</li>
</ul>
<br/>
<p>The full salary range for this position is $85,000 - $145,700. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.</p>
<p>Medica's commitment to diversity, equity and inclusion (DEI) includes unifying our workforce through learning and development, recruitment and retention. We consistently communicate the importance of DEI, celebrate achievements, and seek out community partnerships and diverse suppliers that are representative of everyone in our community. We are developing sustainable programs and investing time, talent and resources to ensure that we are living our values. We are an Equal Opportunity/Affirmative Action employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.</p>
<p>Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities</p>
<p>The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)</p>
</div>
#J-18808-Ljbffr

As a Senior Data Engineer, you work in a team who strengthens data engineering to support agile growth. Engineer and build the data warehouse and ODS to manage increased demand from analytics and other consumers. Enable transitions to open source, machine learning and Cloud technology based on a solid data foundation. Consult with Domain Data Architects, Business Stakeholders, Data and Application Integration, solution architect and DBA.<br><br>This role is responsible for converting Medica's data architecture into physical designs, implementing and maintaining data structures and processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of data sources. You will design and develop robust, scalable solutions that transform data into a useful format for analysis, enhance data flow, and enable efficient, cost-effective consumption and analysis of data.Support in designing Data solution to support cloud Data strategy evolution. You can write complex SQL or programs and mentor technical and business users about our data. You may evaluate and recommend tools and technologies for data infrastructure and processing.<br><br>This role is involved in these areas:<br><br><ul><li>Understand business and technical requirements.</li><li>Convert logical data models to physical data models, DDL, roles and views.</li><li>Create and update data architecture designs and data flows for subject areas impacted by a program/project. Create source to target documents for ETL developers and ensure an efficient design.</li><li>Work with BAs and Business SMEs on program/projects to understand requirements and identify non-functional requirements that will impact the data design.</li><li>Actively engaged as core member of scrum teams to deliver on data programs/projects.</li><li>Work with ETL and QA to ensure all requirements are met by the solution.</li><li>Work with DBA's to tune performance</li><li>Experience with Cloud, SnowFlake databases, ADLS, Python</li></ul><br><br><strong>Required:</strong><br><br><ul><li>BS in Computer Science or related field. An MS is a plus.</li><li>5 years of experience in software development and database applications with a majority of this experience in data strategy, sourcing, modeling, integration, and architecture.</li></ul><br><br><strong>What you bring:</strong><br><br><ul><li>Business Intelligence / Data Warehousing methodology</li><li>Proficiency in SQL, Oracle PL/SQL and Informatica Powercenter/IDMC</li><li>Evaluate, analyze, design, and implement solutions based on technical requirements.</li><li>Extensive experience creating data warehouses, data marts, and operational system databases.</li><li>Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence and deployment infrastructure diagrams.</li><li>Skilled in data analysis, data profiling, data integration, and data quality.</li><li>Data modeling for logical, physical, dimensional, and relational 3NF models.</li><li>Advanced knowledge of SQL, query tuning, RDBMS, and Query tools. Database performance tuning.</li><li>Strong implementation experience and deep knowledge in any one of the following three areas and knowledge of the other 2 areas at a minimum. Implementation experience in all the 3 areas preferred: ETL, Data Integration, Data Governance and Data Quality</li><li>Experience with any modern RDBMS with 3NF and Dimensional design. Strong SQL skills and familiarity with executing DDL. Query and database performance tuning is a plus</li><li>Strong knowledge of cloud Datawarehouse in particular Snowflake</li><li>Must have experience at least with two / one end to end implementation of Snowflake cloud data warehouse.</li><li>Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts</li><li>Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features</li><li>Experience with concepts Snowflake utilities, SnowSQL, SnowPipe</li><li>Experience partnering with cloud platform vendors, Microsoft Azure and/or AWS</li><li>Healthcare experience is very desirable, especially payer knowledge of member, enrollment, claims and provider data.</li></ul><br><br>In addition to above qualifications, please note:<br><br><ul><li>CDMP (certified data management professional) or CBIP (certified business intelligence professional) is nice to have.</li><li>Experience with any of ERwin, ER Studio, PowerDesigner</li><li>Experience with Informatica (preferred), Data Stage, or Microsoft SSIS/SSRS when used with a defined SDLC in a large, structured work process.</li><li>Certification in Agile methodology and ITIL foundations is a plus.</li><li>In depth experience in running data initiatives using agile methodology preferred.</li><li>Prior experience in ETL, reporting and analytics, and business intelligence tools is preferred.</li></ul><br><br>The full salary range for this position is $85,000 - $145,700. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data.In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.<br><br>The compensation and benefits information is provided as of the date of this posting. Medica's compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.<br><br>Medica's commitment to diversity, equity and inclusion (DEI) includes unifying our workforce through learning and development, recruitment and retention. We consistently communicate the importance of DEI, celebrate achievements, and seek out community partnerships and diverse suppliers that are representative of everyone in our community. We are developing sustainable programs and investing time, talent and resources to ensure that we are living our values. We are an Equal Opportunity/Affirmative Action employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.<br><br>Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities<br><br>The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Medica Business Intelligence Interview Guide

Overview

Medica Business Intelligence Salary

Medica Business Intelligence Interview Process

Medica Business Intelligence Interview Questions

Medica Business Intelligence Jobs