Data and Insights - Supervisor

About the role

Geosyntec is seeking a highly skilled Data and Insights – Supervisor with 7 or more years of relevant experience to join our dynamic and growing Financial Systems team based in Boca Raton, Florida. At the company’s discretion a remote work option may be available within the United States. Geosyntec is an innovative, international engineering and consulting firm serving private and public‑sector clients to address complex problems involving civil infrastructure, environment, and natural resources. Ranked by ENR as one of the top environmental engineering design firms, Geosyntec is known for its technical leadership, broad experience, and exceptional client service. The firm invests in its people and offers competitive pay, benefits, and well‑being programs.

Responsibilities

• Hands‑on experience with Infor Data Fabric and Microsoft Data Fabric.
• Proficiency in data mapping techniques and tools.
• Design, develop, and maintain basic to complex data technologies and pipelines.
• Implement basic data mapping strategies and execute data quality checks to ensure data integrity.
• Perform data migration and synchronization tasks between various systems under guidance, ensuring data integrity.
• Collaborate with cross‑functional teams to understand basic data requirements and contribute to the delivery of data solutions.
• Optimize and automate routine data processes with guidance from senior team members to improve efficiency.
• Monitor data pipelines and systems and perform initial troubleshooting of basic data‑related issues to ensure seamless operations.
• Adhere to established data security protocols, data governance policies, and coding standards.
• Create and maintain clear documentation for developed data pipelines and processes.
• Power BI Desktop expertise: data modeling, creating DAX measures, building relationships between tables, and designing interactive reports.
• Apply data visualization best practices to present financial data clearly and effectively in Power BI.
• Publish reports to the Power BI Service, configure dashboards, and manage workspace permissions.
• Connect to and transform various data sources (SQL Server, Excel, cloud services) for use in Power BI reports.
• Demonstrate financial reporting acumen, including knowledge of common financial reports, KPIs, and industry best practices.
• Write and optimize SQL scripts and stored procedures for data extraction and manipulation.
• Assist in producing ad‑hoc data queries and reports and develop systems to capture and analyze operational and financial data.
• Provide end‑user support, prioritizing and escalating service needs as required.
• Work under pressure, exercise sound judgment, and resolve or escalate system issues.
• Exhibit strong organizational, planning, customer service, and responsiveness skills.
• Self‑starter capable of meeting project scope and timeline requirements.
• Familiarity with Agile and Scrum methodologies.
• Flexibility to travel to company offices as needed.

Technical Skills

• Infor Data Fabric, Microsoft Data Fabric
• Azure Data Factory, Synapse, AWS cloud‑based data solutions
• SQL Server, SQL scripting, stored procedures
• Python programming
• Power BI Desktop and Service (data modeling, DAX, visualization, report publishing)
• Data mapping, migration, and synchronization
• Agile and Scrum methodologies

Qualifications

• Bachelor’s degree in Computer Science, Business Administration, Accounting, or an equivalent combination of education, experience, and training.
• Minimum of seven (7) years of reporting experience or over eleven (11) years of relevant experience.
• Hands‑on experience with Infor Data Fabric and Microsoft Data Fabric (required).
• Experience with Azure or AWS cloud‑based data solutions; Azure Data Factory/Synapse, Infor Data Fabric (ION Data Lake Flows, Stream Pipelines, Infor’s ETL tool) (preferred).
• Knowledge of SQL, Python, and other programming languages (required).
• Hands‑on experience in query optimization & performance tuning of Azure resources, OLTP and OLAP databases, ETL, and reporting applications (required).
• Experience in middleware and Power BI (required).
• Experience with finance and accounting reporting (required).
• Ability to pass a background check as required by company and/or client policy.
• Visa sponsorship is not available for this position.