JMT is an award winning, employee-owned firm, focused on providing infrastructure services to better our clients, communities, environment, and employee owners. Our diverse workforce revolves around a culture of innovation, collaboration, and fun, with a focus on charitable giving, sustainability, and integrity. We are looking for a qualified Project Manager to join our Technology Group (JMTTG) team and contribute to the future success of our company. You can be a part of making a difference in the transportation, utilities, and related public service markets, while taking advantage of a flexible work environment, paid training, competitive benefits package, and funded Employee Stock Ownership Plan (ESOP).  

Position summary: Responsible for architecting, documenting, and developing data architectures models and business reporting applications, providing technical leadership for database development efforts.  Conducts complex data mapping and Extract, Transform and Load (ETL) efforts.

Essential functions and responsibilities

• Conduct complex data mapping efforts between systems in a clear and well defined manner
• Perform data analysis and develop the data models to support ETL development
• Complete complex data migrations (ETL) processes to support development efforts
• Collaborate with Software Architects, Software Developers, and BI Developers to design appropriate solutions for our internal team and external clients.
• Mentor software developers in data architecture and database design best practices
• Perform and assign database development tasks of medium complexity across multiple projects.
• Work directly with third party solutions to design, document, and develop data integrations.
• Create, contribute to, review and collaborate on data and database designs and implementations.
• Work with IT to deploy solutions
• Innovate and contribute to improving development standards, techniques, tools, and processes
• Train and test for industry certifications
• Identify, set, monitor, and achieve individual goals
• Leverage mentorship and peer relationships to increase proficiency in development
• Provide support to team members
• Participate in the development personnel interview process
• Collaborate with project managers, business systems analysts, UX designers, and application developers to deliver high-quality deliverables
• Support production systems as urgent and critical issues arise; including non-business hours support on a rotating basis

 Nonessential functions and responsibilities

• Development and deployment of AI solutions including model training, evaluation, optimization
• Perform other related duties as assigned

Required Skills

• Excellent verbal and written communication skills

Required Experience

• Bachelor’s Degree in computer science, Information Technology, or related fields
• 3+ years of experience developing data/database systems and integrating with third party solutions.
• 3+ years of Extract, Transform and Load (ETL) experience
• 2+ years of experience architecting data/database solutions and designing the integration with third party solutions.
• 3+ years of experience working in a hybrid agile development methodology

Preferred Experience

• Experience with Microsoft’s Azure Technologies
• Experience with a variety of databases and ETL solutions
• Experience with Databricks
• Experience with Python and/or R programming
• Experience with development of AI models for predictive analysis

Working Conditions

Work is performed within a general hybrid office environment. Work is generally sedentary in nature, but may require occasional standing and walking. Lighting and temperature are adequate and there are no hazardous or unpleasant conditions caused by noise, dust, etc. within the office environment.

JMT is an Equal Opportunity Employer M/F/Disability/Vet/Sexual Orientation/Gender Identity, and we are proud to be building an inclusive and diverse workforce.

#LI-KW1