Haymarket Media US · 3 days ago
Senior Data Engineer
Wonder how qualified you are to the job?
Media Production
Insider Connection @Haymarket Media US
Responsibilities
Build integrated solutions that are in line with the architecture framework that meets business requirements
Provide guidance regarding data modeling best practices, data governance and quality practices.
Ensure data adheres to enterprise governance standards and maintain credibility and reputation of high quality data
Work with IT and business customers to capture requirements for designing the data warehouse, data analytics and business intelligence architecture.
Apply broad knowledge of technology options, technology platforms, design techniques and approaches across the data engineering ecosystem to design systems that meet business needs
Play a leading role in building systems and datasets using software engineering best practices, data management fundamentals, data storage principles, recent advances in distributed systems, and operational excellence best practices
Develop, institutionalize and drive best practices and data architectural awareness
Create the blueprint for data management systems to integrate, centralize and maintain data sources
Analyze source systems, define underlying data sources and transformation requirements, design suitable data models and document the design/specifications
Define and implement integrations between source data and data warehouse as needed to ensure data integrity and support data & reporting requirements
Develop and maintain programs on source systems, ETL applications, data cleansing functions, systems management functions including load automation, and data acquisition functions among others
Ensure a fault-tolerant, self-correcting, adaptive, highly accurate ETL platform
Continuously seek opportunities to optimize data flows, improve SQL query performance, and maintain reasonable user experience for field and power users working on data
Demonstrate passion for quality and productivity by use of efficient development techniques, standards and guidelines
Effectively communicate with various teams and stakeholders, escalate technical and managerial issues at the right time and resolve conflicts
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Ability to think broadly, understand business strategy, provide consultative business analysis, and have a broad understanding of technology landscape for developing effective and scalable data warehouse and business intelligence solutions
Strong overall architecture experience with high proficiency in data architecture
5-8+ years of building large scale data-processing systems with 2+ years in big data technologies
Expertise in cloud database technologies such as Google BigQuery with proficiency in SQL
Experience in data transformation tools such as DataForm or DBT
Experience designing and coding in python
Experience in BI tools like Looker
Thorough understanding of dimensional modeling, as well as knowledge of best practices and techniques for transforming, validating, logging, auditing, error handling, and performance tuning in a data warehousing setting
Proven track record of strong verbal/written communication & data presentation skills, including an ability to effectively communicate with both business and technical teams
Has excellent problem-solving skills and experience handling multiple projects and assignment in a fast-paced environment
Can work well in a cross-team collaborative environment, with little oversight, and be able to engage stakeholders with various business and technical backgrounds
Bachelor’s degree in math, computer science, engineering, statistics, or a related technical field is required. Master’s degree a plus
Preferred
Experience with ETL and DW platforms such as Stitchdata a plus
Experience with orchestration tools such as Airflow is a plus
Experience working with Agile methodologies in a data warehouse, BI environment
Benefits
Comprehensive health plans including medical, dental and vision
Life insurance
Commuter benefits
Employee referral awards
Tuition reimbursement
Training opportunities through industry-recognized programs
Three Week 'Work from Anywhere' benefit, to ensure work-life balance
Company
Haymarket Media US
Haymarket Media, Inc. is an award-winning specialist content and information company.
H1B Sponsorship
Haymarket Media US has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Trends of Total Sponsorships
2021 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase