Data Engineer

Barry-Wehmiller • Clayton, MO

1d

About The Position

Who You’ll Work With You will join one of our 45 offices in the US, be part of a committed team of over 1500 professionals, and work in teams and directly with our clients doing work that is shaping the world around us. You will be welcomed into a rapidly growing business and team and empowered to make an impact. You will be valued, cared for, and challenged on your path to becoming a world-class professional consultant and surrounded by leaders who are committed to creating an environment that enables you to realize your own success and fulfillment. When you join Design Group as a Data Engineer, you are joining a team that will challenge you and position you for growth. In this role, you will work with a team of industry experts to help the world’s leading companies solve their most difficult problems. You will partner with seasoned leaders, technical specialists, and subject matter experts to deliver the highest quality solutions to our clients with consistency and accuracy.
Additional Job Description Builds infrastructures that collect and process data according to company needs Scales and builds out infrastructure to extract meaningful data Designs, develops and implements statistical models to carry out various aspects of classification and information extraction from data Leverages existing data infrastructure to fulfill all data-related requests; maintain data models Analyze data to spot anomalies, trends and correlate similar data sets. Troubleshoots and identifies possible solutions Other duties as assigned

Requirements

• 0-2 years’ experience as a data engineer, ETL developer, or similar role (internships experience included).
• Experience with cloud data technologies (Azure preferred) such as Azure Synapse Analytics and Spark Pools.
• Strong expertise with SQL and Python.
• Experience utilizing structured and unstructured data.
• Knowledge of data modeling, warehousing principles, ETL/ELT, and metadata standards.
• Ability to relate data opportunities to business needs.
• Strong communication , collaboration, curiosity, and perseverance skills.
• Analytical mindset with problem solving and troubleshooting skills.
• Bachelor’s degree in Computer Science , Analytics, Information Systems or similar field

Nice To Haves

• Exposure to DAX and M preferred.
• Familiarity with PowerBI or Tableau is a plus.
• Understanding of CI/CD pipelines and DevOps processes is a plus.

Responsibilities

• Design, develop, and maintain cloud data infrastructure leveraging technologies like Azure SQL Database, Azure Data Lakes, and Azure Synapse Analytics , and DuckDB to enable advanced analytics (AWS experience is acceptable)
• Build scalable cloud data solutions and pipelines for big data sources and large datasets using services like Azure Synapse Spark Pools, Azure Data Pipelines, Azure Data Lakes, Spark Notebooks , and DBT
• Create optimized data models, efficient ETL/ELT logic, transformations, and metadata to structure and relate data for business insights.
• Automate and schedule regular data integrations from transactional systems, on-prem data warehouses, enterprise databases and SaaS applications into high performance cloud data platforms.
• Implement data quality checks, validation processes, error handling, partitioning, security, and resilience capabilities into data solutions based on requirements.
• Support migration initiatives to move on-premises data and BI systems into cloud data lakehouses , data lakes and other cloud analytics services.
• Builds infrastructures that collect and process data according to company needs
• Scales and builds out infrastructure to extract meaningful data
• Designs, develops and implements statistical models to carry out various aspects of classification and information extraction from data
• Leverages existing data infrastructure to fulfill all data-related requests; maintain data models
• Analyze data to spot anomalies, trends and correlate similar data sets.
• Troubleshoots and identifies possible solutions
• Other duties as assigned

Benefits

• Our culture and commitment to our people is what sets us apart. We foster an environment of mutual respect, integrity, and unconditional interest in the individual and collective success of our professionals.
• Our model and entrepreneurial mindset offer a rewarding, challenging, and highly flexible path.
• As a Data Engineer, you will build a meaningful and fulfilling career with the support of professional development resources and mentorships including our First Year Experience program, Individual Development Plans, and Career Path resources and tools.
• You will be surrounded by exceptional talent who will support your development as both a world-class professional and a highly effective leader.

What This Job Offers

• Job Type: Full-time
• Career Level: Intern