Motor City Electric

SUBSIDIARY:

DEPARTMENT:

POSITION SUMMARY:

PRIMARY RESPONSIBILITIES:

Stakeholder Communication

• Communicate clearly with end users and cross‑functional teams, capturing requirements and status updates

Data Integration Operations

• Troubleshoot data sync issues and validate data integrity across systems
• Configure and test file transfers and integration components
• Write SQL queries and deliver reporting and data validation tasks
• Implement and manage SharePoint solutions for document management and team collaboration

Platform Configuration & Integrations

• ESRI/ArcGIS: Maintain map/data updates and environment housekeeping
• SharePoint: Configure sites, permissions, workflows, and content organization
• ACC (Adobe Construction Cloud): Set up workspaces, user permissions, and document workflows
• Third-Party Platforms: Participate in implementation meetings; perform administrative configuration tasks

Scripting & Automation

• Create and maintain Python scripts for ETL and data validation
• Automate routine tasks via scripting and low‑code tools (Power Automate)
• Build internal dashboards and apps using Microsoft tools (Power BI, Power Apps, Power Automate)
• Publish content updates to company intranet and public site(s)

Documentation & Training

• Maintain clear documentation (flowcharts, diagrams, change logs
• Deliver end‑user training and create quick‑reference guides

EDUCATION, EXPERIENCE, AND SKILLS REQUIRED:

• Proficiency in Python for data processing and automation (e.g., pandas, requests)
• Solid SQL skills for querying, joins, filtering, and data quality checks
• Experience integrating systems via REST APIs and file exchanges (CSV/JSON),
• ETL fundamentals: designing, scheduling, and monitoring jobs
• SharePoint configuration and administration (sites, permissions, workflows)
• Version control with Git (branching, pull requests, code reviews)
• Automated testing and debugging (unit tests, logging, error handling)
• Experience with ESRI/ArcGIS or ACC (Adobe Construction Cloud) is a plus
• Experience with Power BI, Power Apps, and Power Automate is a plus
• Clear written and verbal communication; organized and detail‑oriented
• 0–2 years of relevant experience or equivalent projects/internships

OTHER RESPONSIBILITIES:

ADDITIONAL INFORMATION:

• Position Type: Full-Time
• Location: Detroit, MI (hybrid/onsite as business needs dictate)
• Candidates must be authorized to work in the U.S.