Business Analyst (Project Management - Backend DBA)

Title: Business Analyst/Project Management – Backend Databases JobID #: 26-00339 Company: Faith based Christian Organization Position Type: 3 months Contract with possible extensions Pay: $65/hour + Healthcare, Vision and Dental premium benefits Location: Reynoldsburg, OH Hybrid role: 50% Remote Engagement Specifications: Anticipated start date: August Duration: 3-month engagement with possible extension Candidate interview date: Early-Mid July Location: Hybrid; 3 days onsite / 2 days remote – initially onsite until the requirements are defined C2C candidates are allowed (US Citizens) Required Skills and Experience • Strong project management/ team oversight and business analysis skills (prefer ~ 6 years) • Strong written and verbal communication skills • The ability to explain complex, technical concepts to non-technical business leaders and technical stakeholders • Proficiency in writing technical specifications, creating flowcharts, and mapping out use cases. • Interview stakeholders, define project scopes, and document clear and understandable summaries • Translate executive visions into actionable user stories for technical and development teams. • Working knowledge of IT systems and backend database platforms such as (prefer ~ 10 years) • Microsoft SQL Server • MySQL/MariaDB • PostgreSQL • Snowflake environments • Advanced problem-solving, critical thinking, and analytical skills: • Logical and analytical skills to assess multiple solutions and choose the most viable approach. • Business acumen with the ability to: • Have a solid understanding of company operations, finance, and market trends to drive organizational value • Evaluate financial data, perform cost-benefit analyses, and assess project risks • Analyze existing workflows, pinpoint bottlenecks, and design more efficient processes • Working knowledge of common IT productivity tools and platforms Tasks, Deliverables, and Responsibilities Task 1 / Phase 1 Task/Deliverable BA Responsibilities Perform a project kickoff and execute the project startup. 1. Lead role in project management: 1. Progress reporting 1. Workflow 1. Scheduling of activities 1. Escalation of requests 1. Communication 1. Build the core project plan and set milestone dates 1. Build the Company's discovery and findings template to be used throughout the engagement 1. Acquire necessary system access to be used by the DBA and BA Perform stakeholder, IT staff, department staff, and product champions' roundtable discussions to establish database count, report count, locations, and other discovery-specific 1. Work with project sponsors and DBA to establish roundtable agendas 1. Schedule and facilitate roundtable discussions with: 1. Sponsor 1. Stakeholders 1. IT staff 1. Product champions 1. Document participants and discussion points 1. Receive documentation from the DBA 1. Review DBA documentation with the DBA 1. Perform an initial findings document review with key client participants and acquire acceptance of its contents A documented inventory of structured data assets across our core backend databases; SQL Server, MySQL/MariaDB, PostgreSQL, and Snowflake. 1. Manage the progress of the DBA discovery and documentation efforts 1. Audit the discovery findings documentation from the DBA 1. Perform project checkpoints with the client 1. Perform checkpoint meetings for progress checks 1. Document and communicate discovery scope change needs based upon findings 1. Facilitate project meetings with the client 1. Update all discovery documents An inventory of non-standard or informal data stores surfaced through stakeholder discovery; Airtable, spreadsheets, SharePoint-based tracking, and similar. 1. Manage the progress of the DBA discovery and documentation efforts 1. Audit the discovery findings documentation from the DBA 1. Perform project checkpoints with the client 1. Perform checkpoint meetings for progress checks 1. Document and communicate discovery scope change needs based upon findings 1. Facilitate project meetings with the client 1. Update all discovery documents A mapping of duplicate or redundant data across systems, identifying the system of record versus informal or derivative copies. 1. Manage the progress of the DBA discovery and documentation efforts 1. Audit the discovery findings documentation from the DBA 1. Perform project checkpoints with the client 1. Perform checkpoint meetings for progress checks 1. Document and communicate discovery scope change needs based upon findings 1. Facilitate project meetings with the client Update all discovery documents Documented data quality issues, schema concerns, and implementation oddities relevant to downstream use of the data. 1. Work with project sponsors and DBA to establish roundtable agendas 1. Schedule and facilitate roundtable discussions with: 1. Sponsor 1. Stakeholders 1. IT staff 1. Product champions 1. Work with project sponsor and DBA to establish roundtable agendas for data quality, schema, and downstream data concerns 1. Document participants and discussion points 1. Receive documentation from the DBA 1. Review DBA documentation with the DBA 1. Perform an initial findings document review with key client participants and acquire acceptance of its contents A working summary written for review by the AVP of IT, who will translate findings to the C&MA executive team. 1. Compile the working summary document 1. Review document contents with the DBA for accuracy, content, and readability 1. Identify any necessary document changes and perform said changes with the DBA's input 1. Present the final summary document to the AVP of IT for consumption 1. Acquire client signoff for the summary document and Phase 1 completion Taske 2 / Phase 2 Task/Deliverable BA A validated and refined report inventory, building on the master inventory, execution log, and in-progress curated work we provide. 1. Work with project sponsors and DBA to establish roundtable agendas 1. Schedule and facilitate report roundtable discussions with: 1. Sponsor 1. Stakeholders 1. IT staff 1. Product champions 1. Document participants and discussion points 1. Receive refined report documentation from the DBA 1. Review DBA documentation with the DBA 1. Present the final summary document to the AVP of IT for consumption 1. Acquire client signoff for the refined report document milestone completion Usage and effectiveness analysis for each report — actively used, underused, or causing confusion — informed by both our execution data and stakeholder input. 1. Receive refined disposition recommendation document from the DBA and review for content and viability 1. Review DBA documentation with the DBA 1. Present the final summary document to the AVP of IT for consumption 1. Acquire client signoff for the usage and effectiveness document milestone completion A recommendation for each existing report: Keep, Retire, Consolidate, or Modify / Review, with the reasoning behind each recommendation. See previous step Cross-report consolidation recommendations — identification of opportunities to merge hyper-specific reports into broader reports that answer multiple questions, where appropriate. See previous step A list of unanswered questions surfaced through stakeholder engagement. 1. Receive unanswered questions definitional conflicts document from the DBA 1. Merge DBA and BA questions into a single master document 1. Review the master document with the DBA 1. Facilitate a roundtable discussion with key stakeholders to review all questions and definitions to: 1. Answer open questions 1. Close unnecessary questions 1. Escalate complex questions 1. Provide change order to unify definitions across the organization 1. Update and the unanswered questions master document and present the final summary document to the AVP of IT for consumption 1. Acquire client signoff for the disposition recommendation document milestone completion A list of definitional conflicts and inconsistent terminology across the organization. See previous step. A working summary written for review by the AVP of IT, who will translate findings to the C&MA executive team. 1. Bind all discovery, findings, recommendations, and associated documentation into a final presentation packet 1. Perform a document packet review with the DBA to validate content and viability 1. Facilitate a roundtable discussion with key client stakeholders to: 1. Review the results of all documents 1. Identify areas of concern 1. Review recommended actions 1. Provide clarity on any point in question 1. Create a "Next Steps” plan for remediation of issues or report changes 1. Acquire client signoff for the engagement efforts and resulting documentation Remarks: The Company is a Christian organization. Are you comfortable supporting clients' actions in a professional capacity, focusing solely on delivering accurate, helpful assistance aligned with your goals, regardless of the company's faith-based nature?