What are the responsibilities and job description for the Database Administrator position at Diversified Systems, Inc.?
Remote
Description
DSI is searching for a Database Administrator who will be the lead in transitioning the ownership of a Tableau-based dashboard, including developing and maintaining dashboards to extract additional insights that come from collecting new provider data. This position will also spearhead the development of reports from other data sources, including SPARCS.
Responsibilities
Engineer and maintain an automated data pipeline in a GCP environment, leveraging Vertex AI Workbench for ETL processes to maintain, analyze, and report KPI's from healthcare facilities, with data visualized in Tableau.
Report generation for financial data on funding, grants, and statewide hospital rate setting, using BigQuery to automate.
Develop and deploy macros to automate reports in Excel and Data storage from Shared mailboxes in OneDrive.
Maintain FDH Tableau dashboards and handle updates/changes/reports. Utilize both Tableau desktop and Tableau Server.
Assist fiscal analysts in their analytics tasks through reports from FDH Tableau Dashboards.
Communicate with the team to analyze and inspect the scope for automation of tasks either using Macros/VBA or Python.
Requirements
6 months of experience working in Medicaid programs.
6 months of experience maintaining an automated data pipeline in a GCP environment.
60 months experienced as a data scientist/analyst using SQL, Tableau, and/or Python.
24 months experience data cleaning and preparation for use in complex data models.
6 months experience maintaining, analyzing, and reporting KPIs from healthcare facilities.
6 months experience developing and deploying VBA macros to automate reports in Excel.
60 months of experience visualizing data in Tableau.
Bachelor's of Engineering Degree.
Master of Business Administration in Finance and Marketing.
Master of Science Degree in Data Science.
About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusivity by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.
Description
DSI is searching for a Database Administrator who will be the lead in transitioning the ownership of a Tableau-based dashboard, including developing and maintaining dashboards to extract additional insights that come from collecting new provider data. This position will also spearhead the development of reports from other data sources, including SPARCS.
Responsibilities
Engineer and maintain an automated data pipeline in a GCP environment, leveraging Vertex AI Workbench for ETL processes to maintain, analyze, and report KPI's from healthcare facilities, with data visualized in Tableau.
Report generation for financial data on funding, grants, and statewide hospital rate setting, using BigQuery to automate.
Develop and deploy macros to automate reports in Excel and Data storage from Shared mailboxes in OneDrive.
Maintain FDH Tableau dashboards and handle updates/changes/reports. Utilize both Tableau desktop and Tableau Server.
Assist fiscal analysts in their analytics tasks through reports from FDH Tableau Dashboards.
Communicate with the team to analyze and inspect the scope for automation of tasks either using Macros/VBA or Python.
Requirements
6 months of experience working in Medicaid programs.
6 months of experience maintaining an automated data pipeline in a GCP environment.
60 months experienced as a data scientist/analyst using SQL, Tableau, and/or Python.
24 months experience data cleaning and preparation for use in complex data models.
6 months experience maintaining, analyzing, and reporting KPIs from healthcare facilities.
6 months experience developing and deploying VBA macros to automate reports in Excel.
60 months of experience visualizing data in Tableau.
Bachelor's of Engineering Degree.
Master of Business Administration in Finance and Marketing.
Master of Science Degree in Data Science.
About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusivity by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.
