Data Analyst

Payrate: $67.00 - $70.00/hr. Summary: Data Analyst coordinates changes to computer databases and tests/implements database updates, applying knowledge of database management systems. This role will drive vendor supported CRM changes to support the full lifecycle Opportunity → Order/PO → Delivery → Invoice → Payment, reduce manual entry, and improve data quality/governance across Client, MAI Acquisition, and Procurement. Responsibilities: • Work with senior management and technical client teams to determine data requirements, business data implementation approaches, and best practices for advanced data manipulation, storage, and analysis strategies. • Design the CRM data model in Dataverse (reuse Orders and Invoices; add Deliveries) to enable one to many relationships and multi delivery tracking under a single opportunity/PO while minimizing field bloat. • Write code and logical/physical database descriptions; specify identifiers/keys; provide clear specifications to management; and direct coding/descriptions for implementation. • Implement, automate, and maintain enterprise ETL processes (Power Automate/Dataflows, SQL, Python/PowerShell) to ingest PO/Invoice metadata from finance systems (e.g., MSInvoice) and link to CRM records, reducing manual entry. • Modify existing databases and database management systems; direct programmers/analysts to make schema, form, view, and business rule changes in Dynamics 365 CRM. • Audit and rationalize fields (Advanced Find/exports), define a minimal viable field set per team, and configure role-based forms/views to improve usability and adoption. • Test programs and databases; correct errors from modifications and integrations; establish validation rules, duplicate detection, and referential integrity for lookups. • Establish governance (RACI) for data ownership across Client, Acquisition, and Procurement; configure auditing and usage telemetry; and document SOPs, bulk update workflows (export → fill → import), and SLAs. • Deliver reporting and insights (Power BI/Dataverse charts) showing delivery status vs. expected inventory, invoice/payment state, and operational KPIs for stakeholders. • Maintain security/compliance practices (role-based access, auditing) and support environment/solution management for safe change delivery. Qualifications: • Bachelor’s degree in a technical field (Computer Science, Engineering, Information Systems, or related). • 8-10 years of relevant experience, including substantial work with Dynamics 365/Dataverse and the Power Platform. • Dynamics 365 & Dataverse configuration - expertise in entities/relationships, forms/views, business rules. Desired Skills: • Hands on Dynamics 365 CRM/Dataverse (entities, relationships, forms, views, business rules, auditing). • ETL tools and automation: Power Automate/Dataflows/Power Query; API/webhooks; bulk import/export; Excel based data update patterns. • SQL and one scripting language (e.g., Python or PowerShell) for data shaping, validation, and automation. • Power BI dashboards and Dataverse charts for operational reporting. • Strong written/oral communication, stakeholder facilitation, troubleshooting, and problem-solving skills; demonstrated success working with data to help businesses make better data driven decisions. Pay Transparency: The typical base pay for this role across the U.S. is: $67.00 - $70.00/hr. Non-exempt positions are eligible for overtime at a rate of 1.5 times the base hourly rate for all hours worked in excess of 40 in a work week, or as required by state or local law. Final offer amounts, within the base pay set forth above, are determined by factors including your relevant skills, education and experience. Full-time employees are eligible to select from different benefits packages. Packages may include medical, dental, and vision benefits, health savings accounts with qualified medical plan enrollment, 10 paid days off, 3 days paid bereavement leave, 401(k) plan participation with employer match,  life and disability insurance, commuter benefits, dependent care flexible spending account, accident insurance, critical illness insurance, hospital indemnity insurance, accommodations and reimbursement for work travel, and discretionary performance or recognition bonus. Sick leave and mobile phone reimbursement provided based on state or local law. Consent to Communication and Use of AI Technology: By submitting your application for this position and providing your email address(es) and/or phone number(s), you consent to receive text (SMS), email, and/or voice communication whether automated (including auto telephone dialing systems or automatic text messaging systems), pre-recorded, AI-assisted, or individually initiated from Aditi Consulting, our agents, representatives, or affiliates at the phone number and/or email address you have provided. These communications may include information about potential opportunities and information. Message and data rates may apply. Message frequency may vary. You represent and warrant that the email address(es) and/or telephone number(s) you provided to us belong to you and that you are permitted to receive calls, text (SMS) messages, and/or emails at these contacts. You also acknowledge and agree to Aditi Consulting LLC’s use of AI technology during the sourcing process, including calls from an AI Voice Recruiter. AI is used solely to gather data and does not replace human-based decision-making in employment decisions.  Calls may be recorded. Consent is not a condition of purchasing any property, goods, or services. You may revoke your consent at any time by replying “STOP” to messages or by contacting  privacy@aditiconsulting.com. For information about our collection, use, and disclosure of applicant's personal information as well as applicants' rights over their personal information, please see our Privacy Policy . #AditiConsulting # 25 - 24379