Systems Administrator - Data Analytics

Other Jobs To Apply

No other job posts for this day.

About the position

The Data Analytics and Infrastructure System Administrator is responsible for integrating corporate data assets from various sources to support insightful reporting and decision-making. This position involves working with data, extracting insights, and transforming information into compelling reports and visualizations that drive business strategy. Responsibilities include extracting and preparing data from the data warehouse for one-time requests and analytic purposes, optimizing data workflows, developing and delivering data solutions for analytics and reporting, and ensuring seamless integration of data across systems while leveraging visualization tools to present findings effectively. We are seeking an Infrastructure Administrator to join our team. This role is open to candidates with a range of experience levels. The final level (System Administrator or Senior System Administrator) will be determined based on qualifications, skills, and experience. This position is eligible to work hybrid (9 or more days a month onsite) in accordance with our Telecommuting Policy. Applicants must reside in Kansas or Missouri or be willing to relocate as a condition of employment.

Responsibilities

  • Extract, analyze, and transform data to support business intelligence and reporting needs.
  • Fulfill data requests by developing and implementing data integration solutions, integrating disparate data sources to support reporting, analytics, business needs, and vendor data delivery.
  • Maintain a knowledge repository documenting data sources, business rules, and processing methodologies.
  • Collaborate with data analysts, business stakeholders, and IT teams to align data solutions with organizational needs.
  • Support reporting and visualization tools, including Power BI, Tableau, SSRS, internal solutions, and third-party products.
  • Develop and optimize data solutions using SQL and scripting languages for data manipulation.
  • Utilize modern data integration technologies, including cloud platforms (AWS, Azure) and big data solutions (e.g., Spark), to streamline data processing and enhance analytics capabilities.
  • Provide mentorship, training, and assistance to colleagues to foster a culture of continuous improvement and self-service analytics.
  • Maintain system performance by performing regular and critical maintenance tasks within defined service levels.

Requirements

  • Experience utilizing ETL tools and frameworks, including Informatica, SSIS, and data pipelines, for efficient data extraction, transformation, and loading processes.
  • Strong proficiency in SQL with experience accessing and querying various corporate and disparate data sources for analysis and reporting.
  • Familiarity with modern data architectures, including data lakes, relational databases, and data models.
  • Hands-on experience with reporting and visualization tools, including Power BI, Tableau, and other related platforms.
  • Excellent problem-solving skills with a proactive approach to addressing data management challenges, including data quality, data profiling, and other related issues.
  • Project management skills with a demonstrated ability to complete small to medium-sized projects successfully.
  • Knowledge of data governance, data security, and compliance best practices.
  • Experience working with operational data in the Health Care Industry and a solid understanding of regulatory requirements related to health care data.

Nice-to-haves

  • Knowledge of data gateways and pipelines for integrating and securely transferring data, ensuring seamless connectivity between on-premises and cloud-based data sources.

Benefits

  • Incentive pay program (EPIP)
  • Health/Vision/Dental insurance
  • 6 weeks paid parental leave for new mothers and fathers
  • Fertility/Adoption assistance
  • 2 weeks paid caregiver leave
  • 5% 401(k) plan matching
  • Tuition reimbursement
  • Health & fitness benefits, discounts and resources
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...