Data Engineer
DMA - DuCharme, McMillen & Associates, Inc.
full-time
Posted on:
Location Type: Hybrid
Location: Fort Wayne • 🇺🇸 United States
Visit company websiteJob Level
JuniorMid-Level
Tech Stack
ETLSQL
About the role
- 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
Requirements
- Bachelor’s degree in computer science, information systems, engineering, or related field.
- 2 to 5 years’ experience as a data engineering role
- Familiarity with professional programming preferred
- Familiarity with relevant business domains
- 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
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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data pipelinesETL processesdata transformationstatistical toolsdata modelingSQLELTData Warehousingdata governancedata analytics
Soft skills
analytical skillsproblem-solvingorganizational skillscommunication skillscollaborationattention to detailability to translate business needsproactive issue resolutionstakeholder engagementreport writing