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 robust and scalable unified data repositories. Your primary responsibility will be to ensure the seamless integration and consolidation of various data types, implement data pipelines, and build interactive reporting portals. 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.Apply for this job
