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
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.
