- Hourly: $75.00 - $85.00
- Expert
- Est. time: 3 to 6 months, Less than 30 hrs/week
We are a growing technology consulting firm seeking a skilled Microsoft Power Platform Solutions Architect and Developer to deliver client-facing solutions that drive real business results. The right candidate has a portfolio of shipped applications they are proud of, a consulting mindset, and the ability to work directly with clients to turn business requirements into working software. If you have spent your career as a back-office developer waiting for tickets, this is not the role for you. If you have built things that made a measurable difference for real clients and can prove it, we want to talk. WHAT YOU WILL BE DOING • Design and build Power Platform solutions - Canvas Apps, Model-Driven Apps, Power Automate workflows, Power BI dashboards, and Dataverse implementations • Work directly with clients to gather requirements, clarify scope, and translate business needs into a clear technical solution without requiring heavy oversight. • Own your projects end-to-end: from the first client conversation through design, development, testing, deployment, and post-launch support. • Build SPFx components and SharePoint Online solutions as part of broader Microsoft 365 engagements. • Integrate Power Platform solutions with external systems and APIs, including SQL Server, Dataverse, SharePoint, and third-party platforms. • Deliver on time and communicate proactively • Produce clean technical documentation that supports handoff, training, and future enhancements. • Contribute to solution estimates and help scope new client engagements accurately. REQUIRED QUALIFICATIONS • 5+ years of hands-on Power Platform development: Canvas Apps, Model-Driven Apps, Power Automate, Power BI, and Dataverse. • Demonstrated consulting or contract delivery experience, you have worked across multiple clients, not just one employer. • A portfolio of shipped applications you can speak to: what the problem was, how you solved it, and what the outcome was for the client. • Strong SharePoint Online experience, including SPFx component development and Microsoft 365 integrations. • Proficiency in JavaScript, TypeScript, REST APIs, HTML, and CSS for custom UI and integration work. • Ability to work independently, manage your own time, and deliver without daily supervision. • Strong communication skills, you can run a client meeting, explain a technical decision in plain language, and push back professionally when scope creeps. • U.S. Citizenship required. PREFERRED QUALIFICATIONS • Experience leading client engagements as the primary architect and point of contact. • Azure fundamentals - Entra ID, App Services, Azure DevOps, and basic cloud infrastructure knowledge. • Copilot Studio or Azure OpenAI integration experience - AI-assisted app development is increasingly part of what clients expect. • Experience with Agile or sprint-based delivery in a consulting context. • Version control discipline - GitHub or Azure Repos. Deployments should be repeatable, not manual. • Federal government or regulated industry client experience is a plus, but not required.
- Hourly
- Expert
- Est. time: 1 to 3 months, 30+ hrs/week
***No agency, please*** The contractor must be located within the United States. The expected volume of hours will be high, so please provide your most competitive rate. Requirements: • Experience in multiple Power Platform and/or D365 projects as a technical consultant. • Experience with Microsoft Dynamics 365 and/or Power Platform in the following areas: o Minimum 5-8+ years consulting/development experience in Microsoft technologies. o Experience in Data Modeling and mapping. o PowerApps, Azure Portal/Services, Dataverse. o Model driven forms, views, workflows and reports development. o Programming languages o Understanding of Synchronous and Asynchronous integration patterns o Role-based security design and customization o Development and change tracking using Visual Studio, Azure DevOps/GIT o Provide Dynamics 365 development effort estimates. o Create technical design documents o Ensure that code is testable and is tested. o Execute unit testing for the new functionality developed. o Ability to organize, prioritize, estimate and deliver tasks meeting deadlines o Confidence and willingness to expand technical prowess o Ability to adapt to constantly evolving technologies o Ability to meet deadlines and multi-task effectively o Experience working with a multicultural and/or multilingual team across several time zones o Power BI report development/data modeling
- Hourly: $100.00 - $108.00
- Expert
- Est. time: More than 6 months, 30+ hrs/week
The configuration/release manager plays a crucial role in managing the release of software applications, ensuring smooth code deployments and maintaining high-quality standards. Along with software releases, this role is responsible for the development, configuration, administration and technical support for the Dynamics 365 Sales application. This individual will participate in the continued rollout of Dynamics 365 and all subsequent CRM development projects. The release manager will be working collaboratively with the IT technical team, IT business analysts, IT managers/architects and business subject matter experts to develop, configure, integrate and document all technical components pertaining to the CRM solution. In addition, this individual will assist with the training and development of the existing IT staff regarding the technical development and features of Dynamics 365 Sales, bringing forth their technical expertise and best practices. The individual will also be coordinating with adjacent application owners to coordinate successful multi-application deployments, for example, Dynamics 365 CE, Finance & Operations, Fabric & Power BI, etc. ESSENTIAL FUNCTIONS: • Core responsibilities of this role include release management including scheduling and coordinating PI (Program Increment) deployments across multiple environments, tracking release progress, issues and resolutions using Azure DevOps continuous integration/continuous deployment (CI/CD) tools. • Managing and organizing code in Azure DevOps and/or GitHub repositories. Maintaining and improving code management systems and practices. • Helping developers with code merging issues and providing guidance related to promoting Solutions to higher environments. • Dynamics CRM development experience with in-depth knowledge of Sales, Marketing, Power automates, Power portals and Dataverse • Administer and maintain the Dynamics 365 applications to ensure Sandbox environments are in sync with Production. • Manage user roles and permissions. • Ensure application components are in compliance with the enterprise and solution architecture and apply best practices. • Conduct hands-on implementation, configuration and development of the various components of Dynamics CRM. • Adhere to an iterative, Scaled Agile (SAFe) implementation methodology. • Complete technical design deliverables and documentation. • Adhere to organizational policies and values. • Perform additional duties and participate in special projects as assigned. • Monitor Wave release and be a proactive on it • Environment refreshes from production to lower environments including post refresh steps like removing PII, updating connections, environment variables, etc. • Writing automation using scripting and use of AI agents to automate recurring tasks • Conduct hands-on implementation, configuration and development of various components of Dynamics CRM Required: • Bachelor’s or master’s degree in a technology/engineering/computer science related degree. • At least seven years’ work experience in a technical development role and at least five years working with Dynamics. • Technical, development and administration experience with Dynamics 365 Sales, including configuration, security assessment, security optimization, and customization experience. • Must have in-depth knowledge of Git SCM system including extensive experience with PR based development, resolving git code merge issues, cherry picking git commits, etc. • Azure DevOps CI/CD pipeline experience. • Extensive experience with CI/CD tools like Azure DevOps or VSTS. • Hands-on experience with Azure. • Extensive experience in Power portal setup, configuration and Dataverse environment creation and refresh activities managing Dataverse storage by developing and monitoring data cleanup jobs • Demonstrated understanding of the common data model and security model and mechanisms to extend and build new data relationships. • Must be a dynamic and self-starting individual with strong interpersonal skills who is able to work independently or in a team environment with minimal guidance and direction. • Must be able to effectively prioritize work to meet deadlines. • Must commit to continuous learning by developing new skills to keep abreast of industry trends and state of the art technology. • Must demonstrate excellent written, verbal, and presentation skills to effectively communicate with both technical and non-technical users at all levels of an organization across a variety of stakeholder groups. • Must possess proficiency in MS Office applications (Word, Excel, PowerPoint, Outlook, Access, Visio). • Demonstrated analytical and qualitative abilities. • Experience in Information Technology in business application development and maintenance in a technical capacity. Preferred: • Ability to apply Agentic AI to optimize code quality, recurring processes, release management, etc. • Experience with Dynamics creating plug-ins, custom workflow activities, XAML workflows, web services, and the use of the Dynamics 365 SDK. • Experience with adjacent Dynamics 365 applications like Finance & Operations, Microsoft Fabric and Power BI.
- Hourly: $60.00 - $90.00
- Expert
- Est. time: 1 to 3 months, Less than 30 hrs/week
I am looking for an experienced Microsoft 365 Solution Architect to design and build a reusable workflow management framework using SharePoint Online, Microsoft Lists, Power Apps, and Power Automate. This is not a simple SharePoint list or Power Automate flow. I am looking for someone who understands data architecture, business process automation, and scalable Microsoft 365 solutions. Project Goal Develop a modular framework that can: * Manage organizational requests * Assign work to one or multiple departments * Track each assignment independently * Route requests automatically based on request type * Collect and organize supporting documentation * Provide dashboards and reporting * Be expanded with new request types and workflows without redesigning the application The framework should be designed for long-term growth. Core Components Request Management Create a request management solution that supports: * Dynamic request forms * Multiple request types * Document uploads * Status tracking * Approval routing * Automatic request numbering Task Management Develop a task management framework capable of: * Creating one task assigned to multiple departments or users * Tracking progress independently for each assignment * Rolling assignment progress into an overall task status * Managing due dates and overdue work * Supporting recurring and one-time tasks Workflow Automation Using Power Automate, develop reusable workflows that: * Generate unique IDs * Create assignments automatically * Route requests based on request type * Update statuses automatically * Flag overdue tasks * Notify users * Support document routing * Minimize duplicate data Power Apps Develop dynamic forms that display fields based on the selected request type and enforce required information before submission. Reporting Design list views and reporting structures that support operational dashboards and future Power BI integration. Deliverables * SharePoint List architecture * Power Apps * Power Automate workflows * JSON column formatting (where appropriate) * Solution architecture diagram * Data model * Deployment documentation * Configuration guide * Exportable solution components Development Requirements Development must be completed in your own Microsoft 365 environment using sample data. No production Microsoft 365 access will be provided. No confidential information will be shared. The final solution must be deployable into another Microsoft 365 tenant. Required Experience Please apply only if you have experience designing complete Microsoft 365 business applications using: * SharePoint Online * Microsoft Lists * Power Apps * Power Automate Please include examples of similar solutions you have designed. Before Development Begins The selected freelancer will first produce: * A proposed solution architecture * A data model showing relationships between requests, tasks, assignments, and supporting lists * An implementation roadmap Development will begin after the architecture is reviewed and approved. Definition of Success The final deliverable should be a production-ready Microsoft 365 framework that can be deployed into another Microsoft 365 tenant with minimal modification. The architecture should be modular, scalable, and easy to maintain. I expect well-documented list relationships, reusable Power Automate flows, configurable Power Apps forms, and a solution that can support additional request types, departments, and workflows without major redesign. When you apply, please start your proposal with the words “Workflow Architect” so I know you’ve read the entire project description. Also include a brief explanation of how you would design a system where one task can be assigned to multiple departments while tracking each department’s progress independently.
- Hourly: $50.00 - $70.00
- Expert
- Est. time: More than 6 months, Less than 30 hrs/week
Operi is an operations and technology consulting firm focused on connected workflows, reporting environments, business applications, operational analytics, and custom solutions that help organizations unify processes, systems, and decision-making. We are building a trusted network of independent consultants and small firms for future teaming and subcontracting opportunities on projects involving: * Microsoft 365 * SharePoint Online * Power Platform (Power Apps / Power Automate) * Power BI * Data Engineering & ETL * SQL Databases * Azure * Dashboard Development * Custom Internal Applications * Higher Education Analytics * Workforce Development Analytics * Government & Nonprofit Technology Projects * Accessibility (WCAG) * UI/UX Design Ideal Candidates We are especially interested in professionals with experience serving: * State Government * Local Government * Higher Education Institutions * School Districts * Nonprofit Organizations * Enterprise Organizations Please Include 1. Full Name 2. LinkedIn Profile 3. Resume/CV 4. Location & Time Zone 5. Years of Experience 6. Primary Technical Specialties 7. Certifications (if applicable) 8. Government, Higher Education, or Nonprofit Experience 9. Sample Projects or Portfolio 10. Hourly Rate 11. Current Availability 12. 3 past performance references Questions Please answer the following: 1. What is your primary area of expertise? 2. Have you worked on projects involving Microsoft 365, SharePoint, Power Platform, Power BI, Azure, or enterprise data environments? 3. Have you supported state government, local government, education, nonprofit, or grant-funded organizations? 4. Are you comfortable being listed as a subcontractor, key personnel, or teaming partner in proposal submissions when appropriate? 5. Can you provide references and a resume for proposal purposes if requested? 6. Have you participated in RFP, RFQ, or government contract projects before? Important: This posting is intended to identify highly qualified professionals for future project opportunities and proposal teams. While this is not necessarily an immediate project award, selected consultants may be contacted regarding upcoming subcontracting, teaming, or implementation opportunities.
- Hourly: $45.00 - $70.00
- Intermediate
- Est. time: 1 to 3 months, Less than 30 hrs/week
Job Description:We are looking for an experienced Microsoft Power Platform Developer to design, build, and deploy two internal business applications optimized for tablets and iPhones. Our company operates fully within the Microsoft environment, so native integration, security best practices, and clean architecture are critical. Project Scope: Application 1 (Factory Floor Quality Checklist): A tablet-optimized Canvas App for factory operators to record quality control data. It must feature large, touch-friendly UI elements, dropdowns, and camera integration for capturing and uploading defect photos directly to a SharePoint List database. Application 2 (Azure & IoT Sensor Dashboard): An iPhone and tablet-friendly app allowing users to input field data directly into an Azure Cloud environment (Azure SQL / Data Factory). Additionally, this app must pull, aggregate, and visually display incoming IoT sensor data from our Azure environment via clean, responsive dashboards (or an embedded Power BI frame). Required Technical Expertise:Proven track record building responsive Canvas Power Apps for mobile and tablet form factors.Deep understanding of SharePoint Online list architecture and standard data connectors.Strong experience with Premium Connectors, specifically connecting Power Apps to Azure SQL, Azure IoT Hubs, or custom Azure APIs. Experience with Power Automate for backend logic, data transformation, and automated notifications.Familiarity with data optimization to ensure high-frequency sensor data does not cause app latency.Strong focus on UI/UX tailored for fast-paced operational environments. Deliverables:Fully functioning Canvas Apps deployed to our environment. Architecture documentation detailing data connections and flows. Brief handoff session to outline maintenance steps. To Apply:Please share examples of past Canvas Apps you have built (specifically any manufacturing, inspection, or dashboard-related apps). In your proposal, briefly highlight your experience managing premium Azure data connections within Power Apps.
- Hourly: $70.00 - $85.00
- Expert
- Est. time: More than 6 months, 30+ hrs/week
eSoftware Associates is seeking a Senior Full Stack Microsoft 365 Developer / Architect to design, develop, and deliver enterprise business solutions across the Microsoft ecosystem. This is a hands-on development role requiring expertise in Microsoft 365, SharePoint Framework (SPFx), Power Platform, Azure, Copilot Studio, Microsoft Graph API, React, TypeScript, C#, and SQL Server. The ideal candidate is a senior Microsoft 365 developer who can independently design, architect, and build enterprise business solutions. Candidate has a proven track record delivering production-ready Microsoft 365 solutions and is comfortable moving between client discussions, architecture design, development, troubleshooting, and deployment. What You Will Do · Design and develop Microsoft-based business solutions · Build SPFx applications and modern web experiences · Develop Power Apps, Power Automate solutions, and Copilot agents · Create integrations using Microsoft Graph API, Azure services, and third-party platforms · Develop Azure Functions, Logic Apps, and cloud-native solutions · Participate in client discovery, solution design, and technical planning sessions · Create technical documentation and architecture deliverables · Lead technical delivery across client projects · Troubleshoot, optimize, and enhance existing client solutions Non-Negotiable Requirements · 8+ years of Microsoft development experience · Extensive SPFx development experience · Power Platform development experience · Experience with Azure Functions and/or Logic Apps · Experience with Microsoft Graph API · Experience delivering client-facing projects · Ability to demonstrate previous work · Strong written and verbal communication skills Required Technical Skills Microsoft Ecosystem · Microsoft 365 · SharePoint Online · SharePoint Framework (SPFx) · Power Apps · Power Automate · Dataverse · Copilot Studio · Microsoft Teams Integrations · Microsoft Graph API Azure · Azure Functions · Azure Logic Apps · Azure App Services · Azure Storage · Azure SQL Development · C# · .NET / ASP.NET Core · SQL Server · REST APIs · JavaScript · TypeScript · React · HTML5 / CSS3 Development Lifecycle · Azure DevOps · Git · CI/CD · Agile/Scrum Additional Experience That Will Differentiate Top Candidates · Power BI · Power Pages · AI Builder · Microsoft Certifications · Microsoft MVP Recognition · Enterprise Architecture Experience · Multi-Tenant Microsoft 365 Environments · SaaS Application Development Portfolio & Demonstration Requirement Applicants must provide a resume, LinkedIn profile, portfolio of completed work, and/or examples of Microsoft solutions they personally developed, including SPFx, Power Platform, Azure, Copilot, or Microsoft Graph API projects. Candidates selected for interviews should be prepared to demonstrate previous solutions and discuss their specific contributions to those projects. Applicants who cannot provide examples of previous work will not be considered. What We Are Looking For We are looking for a Microsoft technology expert who can design solutions, build applications, integrate systems, and guide clients from concept through deployment. This is a hands-on development role. Candidates should currently be developing solutions and not solely functioning in project management, consulting, or advisory positions.
- Hourly
- Expert
- Est. time: More than 6 months, Less than 30 hrs/week
We are looking for a senior consultant to help stabilize and improve our Jet Analytics / Jet Reports / SQL Server / SSAS cube environment connected to a heavily customized Microsoft Dynamics NAV 2016 system. Our current cube environment is unreliable and periodically goes down or fails to refresh properly. We need someone who can diagnose the root cause, stabilize the environment, improve cube refresh reliability, and advise whether parts of the current cube should be repaired, refactored, or rebuilt. This is not a basic Jet Reports report-writing project. This is also not a general Power BI dashboard project. We need someone with hands-on technical experience across Jet Analytics, Jet Data Manager, SQL Server, SSAS / OLAP cubes, data warehouse design, and Dynamics NAV data structures. Current Environment: - Microsoft Dynamics NAV 2016 - Heavily customized NAV environment - LS Retail embedded - Jet Reports / Jet Analytics - SQL Server - SSAS / OLAP cube environment - Reporting environment used for business visibility and operational reporting Primary Goals: - Determine why the cube environment is unstable. - Stabilize Jet Analytics / Jet Data Manager processing. - Improve SQL Server / SSAS cube refresh reliability. - Review and improve job scheduling, processing sequence, and monitoring. - Identify whether the current cube should be repaired, refactored, or partially rebuilt. - Establish a longer-term support relationship if the fit is strong. Responsibilities: - Review the current Jet Analytics / Jet Reports configuration. - Review Jet Data Manager projects, execution packages, and dependencies. - Review SQL Server databases, SQL Server Agent jobs, job schedules, and job history. - Review SSAS cube structure, processing history, refresh failures, and performance indicators. - Analyze relevant SQL Server logs, SSAS logs, Windows event logs, and application errors. - Identify failure points causing the cube to go down or fail refreshes. - Diagnose whether issues are related to Jet, SQL Server, SSAS, infrastructure, data quality, permissions, resource constraints, or cube design. - Recommend stabilization steps. - Implement approved fixes where appropriate. - Improve monitoring and alerting for cube refresh failures. - Tune SQL Server / SSAS performance where appropriate. - Review data warehouse and dimensional model design. - Validate cube outputs against Dynamics NAV source data where needed. - Document findings, support procedures, and recovery steps. - Provide knowledge transfer to our internal IT team. Required Experience: - Hands-on experience with Jet Analytics and/or Jet Data Manager. - Experience with Jet Reports using cube-based reporting. - Strong Microsoft SQL Server experience. - Strong SSAS / OLAP cube experience. - Experience troubleshooting cube processing failures. - Experience with SQL Server Agent jobs, ETL scheduling, and refresh automation. - Experience with data warehouse design and dimensional modeling. - Experience working with Microsoft Dynamics NAV / Navision data structures. - Ability to troubleshoot across application, database, cube, and infrastructure layers. - Ability to work independently and explain findings clearly. Preferred Experience: - Dynamics NAV 2016 experience. - LS Retail experience. - Experience with heavily customized NAV environments. - Retail, hospitality, museum, zoo, aquarium, resort, or destination retail reporting experience. - Power BI experience against SSAS or cube-based sources. - Experience stabilizing legacy BI environments. - Experience creating monitoring, alerting, and operational runbooks. - Experience providing ongoing fractional support after an initial assessment. Initial Engagement: We would like to begin with a paid diagnostic / health-check engagement. Expected initial deliverables: - Current-state architecture review. - Root-cause analysis of cube instability. - Review of Jet Analytics / Jet Data Manager configuration. - Review of SQL Server / SSAS jobs, logs, schedules, and processing history. - Identification of major failure points and risks. - Recommended stabilization plan. - Estimate for remediation and ongoing support. Potential Ongoing Work: If the initial engagement is successful, we may continue with: - Stabilization project work. - Cube refactoring or rebuild support. - Monitoring and alerting improvements. - Ongoing fractional support. - Monthly health checks. - Report/cube enhancement support. - Knowledge transfer and documentation. How We Like to Work: - We prefer clear communication and practical recommendations. - We value root-cause analysis over temporary fixes. - We are comfortable starting with a focused diagnostic before committing to a larger engagement. - We prefer a consultant who can explain findings clearly to both technical and business stakeholders. - We want documentation and knowledge transfer, not a black-box support relationship. - We are looking to build a longer-term working relationship with the right person. Preferred Time Zones: Pacific or Mountain Time preferred due to IT team coverage in California and Utah. U.S.-based candidates in other time zones may still be considered if they can regularly support Pacific/Mountain business hours. Rate: Open to consultant's proposed rate based on experience. Please state your hourly rate in your response. We are more concerned with finding the right senior specialist than the lowest rate. The right fit will have hands-on experience with Jet Analytics / Jet Data Manager, SQL Server, SSAS / OLAP cubes, and Dynamics NAV. Screening Questions: Please answer these in your response. 1. Have you personally worked with Jet Analytics or Jet Data Manager, not just Jet Reports? 2. Have you supported SSAS / OLAP cube environments in production? 3. Have you diagnosed cube processing failures or unreliable cube refresh jobs? 4. Have you worked with Microsoft Dynamics NAV / Navision data structures? 5. Have you worked with NAV 2016 or older NAV environments? 6. Have you worked with LS Retail or retail ERP environments? 7. What logs or tools would you review first when a Jet / SSAS cube keeps failing or going down? 8. How would you determine whether the issue is Jet-related, SQL Server-related, SSAS-related, data-related, or infrastructure-related? 9. What is your hourly rate for this type of work, and would you recommend starting with an hourly diagnostic or a fixed-price health check? 10. Are you open to a longer-term fractional support relationship after the initial diagnostic? 11. Please describe one similar BI/cube/reporting reliability issue you have resolved. Important: Please do not apply if your experience is limited to basic Jet Reports report writing or Power BI dashboard development. This role requires backend Jet Analytics, SQL Server, SSAS, cube processing, and Dynamics NAV troubleshooting experience.
- Hourly: $35.00 - $50.00
- Intermediate
- Est. time: 1 to 3 months, Less than 30 hrs/week
Job Description We are looking for an experienced data engineer / BI modernization consultant to assist with a Phase 1 data modernization implementation for a mid-market company moving from legacy reporting tools into a modern Snowflake-based analytics environment. The project involves building out a Snowflake data foundation, supporting ingestion planning and implementation, helping replace legacy Qlik dashboards and Excel refreshables, and assisting with the setup and development of dashboards in Apache Superset hosted through Preset. This is not a simple dashboard-only role. We need someone who can work across data discovery, source inventory, data modeling, ingestion, dashboard migration, and documentation. The ideal candidate is comfortable working in partially discovered environments where some of the work involves identifying what exists, documenting it clearly, and then helping migrate or replace it. Core Responsibilities The selected contractor will assist with some or all of the following: Data Source Inventory Develop and maintain an itemized inventory of data sources relevant to reporting and analytics, including source name, owner, business function, access method, refresh frequency, downstream dependencies, and recommended ingestion method. Refreshables Inventory and Replacement Inventory Excel refreshables and similar spreadsheet-based reports, including file location, use case, owner, refresh method, dependencies, embedded formulas/macros/Power Query logic, and recommended disposition. Assist with replacing, consolidating, redesigning, or retiring these refreshables as part of the modern reporting environment. Dashboard Inventory and Migration Inventory current dashboards, especially Qlik dashboards, including current purpose, audience, source dependencies, embedded logic, refresh schedule, metrics, required migration work, and final destination. Assist with rebuilding, redesigning, consolidating, or retiring dashboards in Preset/Superset. Snowflake Data Modeling Help design and implement the initial Snowflake database structure and data model, including landing, staging, core, and mart layers where appropriate. Support development of initial fact/dimension structures, reporting marts, canonical definitions, and naming conventions. Data Ingestion Planning and Implementation Help document and implement data import methods by source, including Airbyte, Snowpipe, Snowflake-native loading, file-based ingestion, API-based ingestion, or custom connector approaches. Microsoft Access Replacement Assessment Help identify Access databases or Access-based reporting assets that need to be replaced, retired, rebuilt, or replicated in Snowflake and Superset. Preset / Apache Superset Dashboard Development Assist with configuring Superset / Preset, connecting it to Snowflake, building datasets, creating charts and dashboards, validating outputs, and documenting dashboard logic. Documentation and Knowledge Transfer Create clean, client-ready documentation, including source inventories, dashboard registers, data import method plans, data model notes, known-issues registers, and migration disposition trackers. Required Skills Strong candidates should have experience with: * Snowflake database design and implementation * SQL data modeling for analytics * Building reporting marts or semantic layers * Data ingestion into Snowflake * Airbyte or similar ELT tools * Snowpipe or file-based ingestion patterns * Apache Superset and/or Preset * BI dashboard migration or modernization * Qlik dashboard analysis or migration experience * Excel reporting, Power Query, ODBC connections, macros, or refreshable reporting workflows * Microsoft Access reporting/database analysis * Data documentation and technical inventory creation * Translating business reporting needs into data models and dashboards Nice-to-Have Experience * Epicor Prophet 21 / P21 data experience * ERP reporting migration experience * Finance, sales, operations, inventory, or supply-chain reporting experience * Experience replacing Qlik with Superset, Power BI, Tableau, Looker, or similar tools * Experience working with messy legacy reporting environments * Experience supporting executive reporting or KPI standardization * Git-based analytics development workflows * Data quality testing and reconciliation experience Work Style Required We need someone who is: * Detail-oriented and highly organized * Comfortable documenting unknowns and dependencies * Able to work independently with limited handholding * Strong at asking precise technical questions * Practical and implementation-focused * Able to communicate clearly with both technical and business stakeholders * Comfortable working in an environment where the current-state architecture may be incomplete or poorly documented Expected Deliverables The contractor may contribute to the following deliverables: * Itemized data source inventory * Itemized refreshables inventory * Itemized dashboard inventory * Qlik dashboard migration / disposition register * Access reporting replacement assessment * Snowflake database design notes * Snowflake schemas, tables, views, and reporting marts * Data import method plan * Ingestion pipeline setup or implementation support * Preset/Superset datasets, charts, and dashboards * Dashboard validation and reconciliation notes * Documentation for handoff and knowledge transfer Project Duration and Availability Estimated duration: 8–12 weeks, with potential for follow-on work. Expected availability: approximately 10–25 hours per week, depending on skillset and project phase.
- Hourly
- Expert
- Est. time: 1 to 3 months, Less than 30 hrs/week
We're looking for an AI & Data Analysis expert to lead the integration of intelligent tools within the business platform. You'll connect Google Ads, marketing data files, and operational data sources to build AI agents via Claude that support business decision-making across our pet retail operations. Key Responsibilities Design and configure Claude-powered agents using tool use, structured prompts, and automated workflows for data analysis Integrate the Google Ads API to extract campaign metrics and feed decision-making dashboards Ingest, clean, and structure CSV, Excel, and other marketing data formats for agent processing Generate automated narrative reports and actionable visualizations for the executive and marketing teams Maintain and iterate on data pipelines connecting advertising, sales, and inventory data Required Technical Skills Claude API / Anthropic MCP (Model Context Protocol) Prompt engineering and LLM tool use / function calling Google Ads API Python or JavaScript (for pipelines and integrations) SQL / PostgreSQL / Supabase Pandas / NumPy or equivalent data libraries REST API consumption and integration Advanced Excel / Google Sheets Nice to have: Google Analytics, BigQuery, Looker, Power BI Ideal Profile Proven experience building data pipelines or LLM-powered tools in a production environment Hands-on familiarity with the Anthropic API and agent/tool-use patterns Ability to translate raw data into clear, actionable business recommendations Self-directed — can propose and build solutions without exhaustive specs Initial Projects Campaign ROI Agent — connects Google Ads + business sales data to generate automatic performance alerts and recommendations Marketing File Pipeline — ingests CSV/XLSX marketing files and produces AI-generated summaries and insights Executive Dashboard — decision-support interface with Claude-generated action recommendations based on live data