Data Engineer

Summary

DMA - DuCharme, McMillen & Associates, Inc. is an employee-owned company that prioritizes employee well-being and offers a supportive work environment. The Data Engineer will be responsible for creating and maintaining the infrastructure and systems for data collection, storage, and processing, ensuring data is accessible and reliable for analysis.

Responsibilities

• Design, build, and maintain robust data pipelines and ETL processes to ingest, transform, and deliver data from various sources
• Mine data from primary and secondary sources, then reorganize said data in a format that can be easily read by either human or machine
• Use statistical tools to interpret data sets, pay particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts
• Collaborate with programmers and engineers to improve efficiency and data organization; improve performance through data structure and query optimization
• Ensure data integrity, quality, and security across all systems and platforms
• Work with departments to provide insight and identify opportunities, improvements, recommend system modifications, and develop policies for data governance
• Integrate structured and unstructured data from internal and external sources
• Monitor and troubleshoot data workflows, resolving issues proactively
• Design, implement, and maintain critical data systems from ETL/ELT, Data Warehouse, BI Tools, and everything in between
• Maintain documentation for data architecture, processes, and standards
• Collaborate with data scientists, analysts, and product teams to support data needs
• Analyze requirements from the business and provide solutions or guidance for solutions
• Work with senior data analyst to establish data governance
• Perform other duties as assigned

Skills

• Bachelor's degree in computer science, information systems, engineering, or related field
• 2 to 5 years' experience as a data engineering role
• Ability to analyze large datasets and write comprehensive reports
• Experience in data models and reporting packages
• Experience working with data and data analytics development, preferably within the Microsoft data platform
• Ability to understand business needs and translate them into technical solutions
• Works effectively with analysts, stakeholders, and IT teams to deliver data solutions that drive business value
• Proficiency in SQL and experience with relational and non-relational databases
• Proficient with ELT/ETL and Data Warehousing development
• Knowledge of relational databases and object-relational mapping concepts
• Commitment to data quality, governance, and compliance
• Understanding of data modeling, normalization, and schema design
• Excellent organizational skills: ability to handle multiple projects
• An analytical mind and inclination for problem-solving
• Strong verbal and written communication skills
• Familiarity with professional programming
• Familiarity with relevant business domains

Qualifications

Must Haves

• Bachelor's degree in computer science, information systems, engineering, or related field
• 2 to 5 years' experience as a data engineering role
• Ability to analyze large datasets and write comprehensive reports
• Experience in data models and reporting packages
• Experience working with data and data analytics development, preferably within the Microsoft data platform
• Ability to understand business needs and translate them into technical solutions
• Works effectively with analysts, stakeholders, and IT teams to deliver data solutions that drive business value
• Proficiency in SQL and experience with relational and non-relational databases
• Proficient with ELT/ETL and Data Warehousing development
• Knowledge of relational databases and object-relational mapping concepts
• Commitment to data quality, governance, and compliance
• Understanding of data modeling, normalization, and schema design
• Excellent organizational skills: ability to handle multiple projects
• An analytical mind and inclination for problem-solving
• Strong verbal and written communication skills

Nice to Haves

• Familiarity with professional programming
• Familiarity with relevant business domains

Benefits

• Employee stock ownership program eligibility begins on day one of employment (ESOP contribution is targeted at 6% of your annual compensation)
• Company paid parental leave
• Generous time off package
• Multiple benefit plans, eligibility begins on day one of employment
• Culturally focused on work/life balance, mental health, and the overall wellness of our employees