Senior Manager, Data Engineering & Reporting

AmaWaterways seeks an experienced Senior Manager in data Engineering & Reporting to lead enterprise data strategy, architecture, and analytics solutions. As the gatekeeper of company-wide data, you will drive data integrity, governance, scalability, and insights that empower executive decision-making, operational efficiency, and digital transformation. You will work across IT, Finance, Sales, Operation, and Marketing to develop cloud-first, AI-ready data ecosystems that optimize business intelligence and reporting. The ideal candidate will have deep expertise in Oracle, Microsoft SQL, Salesforce Data Migration, ETL, SSIS solutions, .NET, AWS, Azure, RDS, and Tableau, supporting our growing business needs and digital transformation initiatives.

As the Senior Manager of Data Engineering, you will design, develop, and maintain our data infrastructure, encompassing on-premises and cloud-based solutions, manage partners, and work with business leaders to design effective data-driven reporting solutions. Your expertise in database technologies, ETL processes, Salesforce data migrations, scripting, and reporting will be essential. You will collaborate closely with IT, Finance, Sales, Operations, Marketing, and BI/Analytics teams to deliver data-driven solutions that empower the business.

Key Responsibilities:

Leadership and Strategy:

• Develop and implement the strategic vision for the enterprise data engineering, reporting, and data warehouse functions.
• Lead and mentor a team of data professionals and agency partners, fostering a culture of continuous improvement and innovation.
• Collaborate with senior leadership to align data initiatives with business goals.

Data Architecture and Warehouse Management:

• Design, develop, and maintain scalable and high-performance data warehouse architecture across Oracle, Microsoft SQL Server, and cloud platforms (AWS RDS, Azure SQL).
• Implement best practices for data modeling, storage, and governance to ensure data consistency and accuracy.
• Manage and optimize Salesforce data migrations, providing seamless integration with CRM, ERP, and other systems.

Data Engineering and Data Quality:

• Design and implement optimal real-time and batch processing, ETL/ELT pipelines using SSIS, SQL, and cloud-based tools (e.g., AWS Glue, Azure Data Fabric) to automate data ingestion and transformation.
• Develop governance and implement processes to ensure data quality, lineage, and validation across all workflows.

Data Reporting and Dashboard:

• Develop and manage a comprehensive reporting and analytics framework using Tableau and PowerBI.
• Provide actionable insights through advanced data analysis and visualization tools.

Business Impact & KPIs:

• Ensure data-driven decision-making by designing scalable reporting frameworks that provide timely insights and reduce manual reporting efforts.
• The reporting and analytics section should emphasize measurable impact, such as: Improved data accessibility for decision-making.
• Reduction in data processing time. Cost savings through cloud optimization

Cloud Integration:

• Architect and manage data solutions on AWS and Azure, leveraging services such as AWS RDS, Azure SQL, Data Lake, and Data Warehouse solutions.
• Implement CI/CD pipelines for database and ETL deployments, integrating DevOps best practices.
• Develop automation scripts using .NET, Python, and PowerShell.

Data Security & Compliance:

• Enforce data security, governance, and compliance policies (e.g., SOX, GDPR, PCI-DSS).
• Implement data encryption, masking, and access control policies.
• Partner with security teams on audits, vulnerability assessments, and disaster recovery/backup strategies.

Collaboration & Business Support:

• Serve as the primary data liaison between IT and business units, ensuring data solutions align with objectives.
• Collaborate with BI, Analytics, and AI teams to support reporting, dashboards, and advanced analytics initiatives.
• Support and troubleshoot SQL queries, stored procedures, and data integrity issues.
• Partner with business units to understand their reporting needs and deliver customized solutions.

Partner Management:

• Manage relationships with external vendors, ensuring data solutions align with business requirements, performance expectations, and cost efficiency.

Required Qualifications:

• 8 years of experience in Data Engineering, Database Administration, ETL development, Marketing Analytics and Reporting, preferably for consumer brands.
• Deep expertise in Oracle, Microsoft SQL Server, AWS RDS, Azure SQL, and cloud-based database services.
• Experience with cloud-based Data Warehousing, Big Data processing, and Data Lakes (e.g., AWS Redshift, Azure Synapse, Snowflake).
• Hands-on experience with Salesforce data migration and integration.
• Strong experience with ETL/SSIS solutions, data integration, and transformation processes.
• Proficiency in .NET, Python, PowerShell, or Terraform for automation and scripting.
• Experience creating enterprise reporting dashboards and specific reports to drive insight-driven decision-making.
• Proven ability to understand business teams' data and reporting needs, create cross-functional priorities, and establish and execute on data reporting roadmap.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work collaboratively in a fast-paced environment.

Preferred Qualifications:

• Knowledge of AI/ML-driven data analytics and predictive modeling.
• Certifications in AWS, Azure, or Microsoft SQL databases.
• Experience with data governance and security best practices.