Legends & ASM Global is looking to hire a Data Engineer to support developing and managing tools and processes crucial for their data-driven decision-making across various verticals.
Requirements
Over three years of hands-on experience in data integration development.
Data pipelines to and from relational databases (Azure/SQL Server, Postgres SQL, Oracle), CRMs (e.g., Salesforce, Hubspot), marketing automation (ex. Klaviyo, Salesforce Marketing Cloud), and e-commerce platforms (ex. Shopify, Big Commerce).
A demonstrated proficiency with Microsoft data services including Azure Data Factory, Azure SQL Database, Azure Function, Azure Blob Storage, SQL Server and SSIS.
Proven expertise in using Python for data pipelines, analysis, or transformations.
Advanced skills in connecting to data sources using standard protocols such as HTTPS, ODBC/JDBC, sFTP, and S3, facilitating the ingestion of structured and unstructured data formats like CSV and JSON.
Experience designing database structures for data science (ex. Python) and visualization (ex. Tableau)
Experience with handling PII data and associated policies and compliance requirements (Preferred)
Responsibilities
Develop performant and scalable data pipelines (ETL/ELT) using PL/SQL, Python, and data transformation/IaaS platforms (ex. SSIS, Azure Data Factory, Fivetran).
Develop processes for data cleansing, matching name and address data, and data enrichment (ex., demographics, and firmographics).
Deploy data storage solutions capable of handling structured and unstructured data effectively.
Normalize and denormalize transactional data for integration into the data warehouse or data lake house architecture.
Advocate for and implement best practices and SOPs in alignment with DevOps (CI/CD) principles.
Adhere to change management and version control protocols (ex., Bitbucket, GitHub).
Deliver solutions focusing on time-to-market, quality, accuracy, efficiency, and scalability.
Other
Bachelor’s degree in computer science or related field
Translate business specifications into technical design specifications and code.
Working knowledge of data governance best practices and data privacy policies (Preferred)
Location: Hybrid (Chicago, IL or Dallas, TX)
Legends & ASM Global is an Equal Opportunity/Affirmative Action employer, and encourages Women, Minorities, Individuals with Disabilities, and protected Veterans to apply.
