Data Integration & Business Intelligence Project Manager

hermitage dental center
Nashville, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior
Compensation
$ 85K

Job location

Nashville, United States of America

Tech stack

API
Agile Methodologies
Application Integration Architecture
Business Systems
Information Systems
Databases
Data Architecture
Information Engineering
Data Governance
Data Integration
Data Integrity
ETL
Data Migration
Data Security
Relational Databases
Database Connection
Database Design
Database Development
DevOps
PostgreSQL
Microsoft SQL Server
SQL Azure
MySQL
Oracle Applications
Scrum
Query Optimization
Power BI
Cloud Services
Software Engineering
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Data Streaming
Systems Architecture
Systems Integration
Web Services
Microsoft Power Automate
Azure
Indexer
Database Migration
Microsoft Fabric
Information Technology
Integration Frameworks
Software Version Control
Powerapps

Job description

We are seeking an experienced Database Integration & Business Intelligence Project Manager to design, develop, and manage database integrations across our internal software ecosystem. This role will be responsible for creating secure, reliable, and scalable database connections that enable seamless data flow between applications while supporting reporting, analytics, and business intelligence initiatives using Microsoft Power BI., Database Development & Integration

  • Design, develop, and maintain database integrations between internal software applications, third-party systems, and cloud platforms.
  • Create and optimize database connections, ETL/ELT processes, APIs, and automated data workflows.
  • Develop and maintain SQL scripts, stored procedures, views, and database objects.
  • Ensure data integrity, consistency, security, and performance across integrated systems.
  • Troubleshoot and resolve database connectivity, synchronization, and performance issues.
  • Support database migrations, upgrades, and system enhancements.

Business Intelligence & Reporting

  • Develop and maintain Power BI datasets, data models, dashboards, and reports.
  • Build and manage secure data connections between Power BI and multiple data sources.
  • Optimize reporting performance and data refresh processes.
  • Partner with business stakeholders to identify reporting needs and deliver actionable business intelligence solutions.
  • Ensure data governance, accuracy, and consistency across reporting environments.

Project Management

  • Lead database and integration projects from requirements gathering through implementation and post-deployment support.
  • Develop project plans, timelines, resource requirements, and risk mitigation strategies.
  • Coordinate with software developers, IT teams, vendors, and business users to ensure successful project delivery.
  • Track project milestones, communicate status updates, and manage competing priorities.
  • Document technical specifications, system architecture, and integration processes.

Collaboration & Continuous Improvement

  • Work closely with software development teams to improve application integration and data architecture.
  • Recommend improvements to database design, automation, and reporting capabilities.
  • Establish and maintain documentation, standards, and best practices for database development and integrations.
  • Stay current on emerging database technologies, integration platforms, and business intelligence tools., * Database Architecture & Design
  • Database Integration & Data Migration
  • Power BI Development
  • SQL Programming & Query Optimization
  • ETL/ELT Development
  • API & Systems Integration
  • Project Planning & Execution
  • Business Process Analysis
  • Data Governance & Security
  • Technical Documentation
  • Cross-Functional Collaboration
  • Continuous Process Improvement

Success Measures

Success in this role will be measured by:

  • Reliable and secure integration of internal software systems.
  • Accurate, timely, and scalable Power BI reporting solutions.
  • Successful delivery of projects on schedule and within scope.
  • Improved data quality, accessibility, and operational efficiency.
  • High stakeholder satisfaction with reporting and integration solutions.

Pay: $70,000.00 - $85,000.00 per year

Requirements

The ideal candidate combines strong technical expertise in database development and systems integration with proven project management skills to lead cross-functional initiatives from planning through implementation., * Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related field (or equivalent professional experience).

  • 5+ years of experience in database development, systems integration, or data engineering.
  • Strong experience with Microsoft SQL Server, MySQL, PostgreSQL, Oracle, or similar relational database platforms.
  • Advanced SQL development skills, including stored procedures, views, indexing, and query optimization.
  • Experience developing ETL/ELT processes and integrating data from multiple systems.
  • Hands-on experience developing Power BI reports, dashboards, semantic models, and data connections.
  • Experience with APIs, web services, and database connectivity technologies.
  • Proven project management experience leading technical implementation projects.
  • Strong analytical, troubleshooting, and problem-solving skills.
  • Excellent written and verbal communication skills.

Preferred Qualifications

  • Experience with Azure SQL, Azure Data Factory, Microsoft Fabric, SSIS, or other cloud data platforms.
  • Familiarity with Power Automate, Power Apps, or the Microsoft Power Platform.
  • Experience integrating ERP, CRM, accounting, manufacturing, or other enterprise business systems.
  • Knowledge of data governance, security, and compliance best practices.
  • Project Management Professional (PMP), Agile, Scrum, or similar certification is a plus.
  • Experience with version control and DevOps practices., * Power BI: 1 year (Preferred)

Benefits & conditions

Pulled from the full job description

  • Parental leave
  • Health insurance
  • Paid time off
  • Dental insurance
  • Life insurance, * Dental insurance
  • Health insurance
  • Life insurance
  • Paid time off
  • Parental leave

Apply for this position