Data Engineer

Insomniac Design is a global digital agency headquartered in Washington D.C. with offices in London Bucharest and Chisinau.  We’re an agile determined and innovative team organized by functional areas of expertise — Creative Technology Strategy and Management. We specialize in human-centered design with deep focus on design thinking and digital transformation.

As a Data Engineer you will work closely with the other Engineers to design develop and maintain a robust and scalable unified data repository for our client's global marketing agency. Your primary responsibility will be to ensure the seamless integration and consolidation of various data types implement data pipelines and build an interactive reporting portal. Your expertise in data engineering database management and data integration will be critical in delivering high-quality solutions that meet our client's needs.

General Responsibilities:

• Expected to collaborate and contribute effectively within a team environment.

• Able to solve complex problems and understands interrelated processes within the job role scope.

• Able to work towards achieving business goals without a predefined solution showcasing adaptability and critical thinking skills.

• Implements product process automation and/or streamlines work using industry best practices or incremental ideas to improve experience efficiency or quality.

• Demonstrates the ability to create team-level processes and optimize existing processes.

• Actively mentors junior team members contributes to the hiring and performance management process providing valuable insights.

Responsibilities:

• Design and deliver specifications documentation and implementation of unified data repositories and the data flows of diverse data types from multiple sources.

• Develop and maintain ETL (Extract Transform Load) processes and data pipelines to efficiently extract data from various sources transform and clean it and load it into the unified data repository.

• Design and optimize database structures tables and schemas to ensure efficient storage retrieval and querying of data.

• Implement data quality and data governance processes to ensure the accuracy integrity and security of the data repository.

• Work closely with the development team to integrate the unified data repository with the reporting portal ensuring seamless data access and enabling interactive data visualization and reporting capabilities.

• Collaborate with cross-functional teams to understand and document data requirements and translate them into technical solutions.

• Monitor data integration processes troubleshoot issues and perform data validation and reconciliation to ensure data accuracy and consistency.

• Work closely with clients to understand their business needs and design solutions that meet those needs.

• Troubleshoot technical issues and work with the development team to deliver solutions.

• Provide technical guidance and mentorship to junior team members.

• Stay up-to-date with emerging trends and technologies in web development cloud platforms and data schema design.

Requirements:

• Bachelor's degree in Computer Science Engineering or a related field.

• 4+ years of experience as a Data Engineer or in a similar role preferably in a large-scale data integration or data warehousing project.

• Proficiency in SQL experience with relational database management systems (e.g. MySQL PostgreSQL Oracle) and Python (or similar OOP).

• Proficiency in designing and developing ETL processes and data pipelines using tools like Apache Spark Apache Kafka Airflow or similar technologies.

• Solid understanding of data modeling concepts and experience with data modeling tools.

• Experience with cloud platforms (e.g. AWS Azure GCP) and knowledge of cloud-based data services (e.g. Amazon Redshift Google BigQuery Azure Data Lake).

• Familiarity with data visualization tools and techniques for creating interactive dashboards and reports (e.g. Tableau Power BI Looker).

• Excellent analytical and problem-solving skills with the ability to analyze complex data sets and troubleshoot data-related issues.

• Excellent communication and interpersonal skills with experience managing client relationships.

• Experience working in an Agile development environment.

Insomniac Design is committed to creating a diverse inclusive and equitable workplace where everyone is treated with respect and dignity. We believe that embracing differences in race gender sexual orientation age religion disability and cultural backgrounds allows us to create better solutions for our clients and a stronger team. We strive to ensure that all employees candidates and clients feel valued and respected and we continuously work to improve our practices and policies to foster a more diverse and inclusive environment.

Applicant Eligibility: Please note candidates who are eligible to work in the US without visa sponsorship are eligible to apply. No recruiters or staffing agencies please.