Applications Data Architect

Massachusetts Municipal Wholesale - Ludlow, MA

Full-time - Mid Level

Ludlow, MA

Computer and Electronic Product Manufacturing

About the position

The Massachusetts Municipal Wholesale Electric Company (MMWEC) brings a competitive edge to Massachusetts municipal utilities dedicated to providing its customers with low-cost and reliable electricity. We plan, develop, and manage energy resources in an evolving marketplace that requires high levels of innovation and expertise. Our values are old-fashioned, reflecting nearly 50 years of public power joint action, but our service is enlightened. We are currently seeking an innovative and skilled Applications Data Architect to manage and improve data strategies, architecture, and infrastructure for MMWEC business users and external customers. This role involves designing solutions to collect, manage, and analyze data, ensuring efficiency and accuracy while supporting business objectives.

Responsibilities

• Translate business needs into efficient databases, data warehouses, and data streams.
• Create processes to ensure data accuracy, security, and accessibility.
• Develop and maintain data architecture frameworks, including reference data, metadata, and master data.
• Use tools like SQL, Python, and data modeling software to visualize metadata and database schemas.
• Lead cross-functional projects to implement software improvements and enhance operational efficiency.
• Collaborate with organizational teams to devise data strategies and align them with business objectives.
• Apply data mining techniques to uncover actionable insights and develop APIs for efficient data retrieval.
• Implement machine learning solutions to handle big data and drive innovation.
• Document business processes, workflows, and technical requirements to support the software lifecycle.

Requirements

• Bachelor's degree in a related field or equivalent experience.
• 3 to 5 years of experience in data analysis, architecture, and database management.
• Proficiency in SQL, Python, and Java for data analysis and application development.
• Experience implementing, managing, and maintaining Business Intelligence (BI) software solutions.
• Experience with data modeling tools like ERWin or Visio to visualize metadata and database schema.
• Strong project management and organizational skills, with a focus on delivering high-quality results.
• Excellent written and verbal communication skills and ability to collaborate with all levels of the organization.

Benefits

• Comprehensive medical and dental benefits with low employee cost from day one.
• Retirement savings plan with a 6% company contribution and up to an additional 3% company match.
• Earned vacation time, sick time, and 11 paid holidays.
• Professional development and tuition reimbursement opportunities.