Data Developer - ETL

Skills

• airflow
• analytics
• automation
• aws
• bash
• cloud
• data-engineering
• data-ingestion
• data-modeling
• data-pipelines
• data-quality
• data-science
• data-warehousing
• etl
• git
• hadoop
• iceberg
• lambda
• linux
• pyspark
• python
• rdbms
• scala
• spark
• sql
• version-control
• visio
• workflow-orchestration

Must have

1. You are an early-career data developer with 1-3 years of experience who enjoys working with data, writing SQL, and solving technical problems. You have a solid foundation in relational databases and E
2. At the Analyst-Level, you will support business solutions through research, data collection, and analysis, contribute to client deliverables and proposals, take ownership of tasks, and embody the firm
3. Role and Responsibilities:
4. You may work on various projects throughout your career with Excelacom. The roles and responsibilities noted below pertain to the specific role listed above.
5. • Write, test, and maintain SQL queries used for data extraction, transformation, validation, and reporting.
6. • Develop and support ETL pipelines and data ingestion processes under the guidance of senior team members.
7. • Use joins, aggregations, subqueries, common table expressions, and window functions to analyze and transform data.
8. • Troubleshoot SQL queries, data quality issues, and production job failures, escalating complex issues when appropriate.
9. • Assist with query tuning and performance optimization for large datasets and recurring production workloads.
10. • Perform data validation, reconciliation, and quality checks to ensure datasets are accurate, complete, and reliable.
11. • Partner with data developers, analysts, and data scientists to build datasets that support reporting and analytics.
12. • Document SQL logic, data mappings, ETL workflows, operational procedures, and technical solutions.
13. • Participate in code reviews, testing, deployments, and team knowledge-sharing activities.
14. • Learn and apply data engineering standards, source-control practices, and production support procedures.
15. • Collaborate with technical and cross-functional stakeholders to translate business and analytical needs into data solutions.
16. • In addition to delivering at the client site, you will occasionally be tasked in productizing Excelacom's work, contributing to our Center of Excellence and intermittently working on Excelacom propo
17. • 1-3 years of professional experience in data development, data engineering, database development, analytics, or a related technical role.
18. • Strong hands-on SQL experience, including joins, aggregations, subqueries, common table expressions, and window functions.
19. • Experience using SQL to extract, transform, validate, and troubleshoot data in relational or distributed data environments.
20. • Working knowledge of ETL concepts, data pipelines, data integration, and data warehousing principles.
21. • Experience identifying data quality issues and performing data validation and reconciliation.
22. • Basic Python scripting experience for data processing, workflow automation, or troubleshooting.
23. • Familiarity with version control, testing practices, and writing maintainable production code.
24. • Understanding of data modeling concepts, including tables, keys, relationships, and dimensional data structures.
25. • Ability to learn new technologies, follow technical standards, and work effectively with guidance from senior team members.
26. • Bachelor’s degree required, preferably in Computer Science or related field
27. • Proficiency in Microsoft Office (Word, Excel, PowerPoint, Visio)
28. • Strong math, written and verbal communication skills with an analytical approach
29. • Applicant must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future; Excelacom will not sponsor applicants for U.S. work visa status for this

Nice to have

1. • Prior experience in Telecommunications, Media, or Cable is highly preferred

Full description