Data Warehouse ETL Developer
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.1
Reclaim your time by letting our AI handle the grunt work of job searching.
We continuously scan millions of openings to find your top matches.
Overview
Remote
On-site
Compensation
$100,000-$125,000/year
Job Description
Job Summary: Our client is seeking an experienced Data Warehouse ETL Developer to join their Data Analytics Team. The ideal candidate will have strong expertise in ETL methodologies, SSIS, and data warehousing, supporting efforts to deliver high-quality data extracts, reports, and dashboards. The role requires a Baltimore-area resident with excellent SQL skills and experience working within cross-functional teams.
- Location: Baltimore, Maryland (Hybrid part-time in office, part-time virtual; may transition to fully on-site) Experience Required: 5+ years ETL development, 3+ years SSIS experience. Education: Bachelor's degree in Computer Science, IT, MIS, Business Management, Engineering, Project Management, Communications, or a related field (or equivalent experience).
- Develop, execute, and monitor ETL processes ensuring accurate and efficient data movement and transformation.
- Retrieve data from multiple systems for data extracts, reports, and dashboards, ensuring data quality before release.
- Write and maintain SQL test scripts to validate data against source transactional systems and the data warehouse.
- Document ETL processes, test cases, and results to support testing repeatability and knowledge sharing.
- Collaborate with SQL Server DBAs, system architects, and developers to design and optimize stable, reliable databases.
- Plan and coordinate data migration activities between systems in line with project goals.
- Assist in defining business and testing requirements in coordination with stakeholders.
- Conduct unit, system, and performance testing; support User Acceptance Testing and issue resolution.
- Adhere to software development standards, change control processes, and security protocols.
- Participate in continuous improvement initiatives to enhance process efficiency and effectiveness.
- Communicate project status and progress regularly to sponsors and stakeholders.
- Build strong relationships with project sponsors, technical staff, vendors, and end-users to drive collaborative success.
- Minimum 5 years' experience in ETL methodologies and development.
- At least 3 years' hands-on experience with SQL Server Integration Services (SSIS).
- Proficient with SQL Server scripting and data modeling.
- Experience working with Azure SQL instances.
- Strong understanding of data warehousing principles, concepts, and architecture.
- Bachelor's degree in Computer Science, Information Technology, MIS, Business Management, Engineering, Project Management, Communications, or related field; or equivalent professional experience.
- Knowledge of software development lifecycle (SDLC) and programming concepts.
- Skilled in Microsoft Office applications including Word, Excel, PowerPoint, and Visio.
- Effective multitasking skills with ability to meet delivery deadlines.
- Excellent analytical, problem-solving, and visualization skills to tackle complex data challenges.
- Strong verbal and written communication skills with ability to effectively interact across all organizational levels.
- Capability to coordinate team efforts with other departments including research, assessment, and accountability units.
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
FAQs About Data Warehouse ETL Developer Jobs at Macpower Digital Assets Edge Private Limited
What is the work location for this position at Macpower Digital Assets Edge Private Limited?
This job at Macpower Digital Assets Edge Private Limited is located in Baltimore, MD, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
What pay range can candidates expect for this role at Macpower Digital Assets Edge Private Limited?
Candidates can expect a pay range of $100,000 and $125,000 per year.
What employment applies to this position at Macpower Digital Assets Edge Private Limited?
The employer has not provided this information. This may be discussed during the hiring process.
What is the process to apply for this position at Macpower Digital Assets Edge Private Limited?
You can apply for this role at Macpower Digital Assets Edge Private Limited either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.