What are the responsibilities and job description for the Data Warehouse ETL Developer position at Effervescent Consulting?
About us
Effervescent Consulting is a White Glove IT Managed Service Provider that specializes in strategizing, implementing, and optimizing Enterprise Business Applications.
This position will:
- Support the Data Analytics Team in retrieving data from multiple data systems for use in data extracts, reports, and dashboards to ensure data quality before release.
- Create, execute, and monitor ETL processes including tracking and documenting findings.
- Create test scripts using SQL programming to validate data points against transactional systems and the data warehouse.
- Creating documentation needed to support repeatability of testing metrics.
The ideal candidate must possess the following:
- Thorough knowledge of the principles and practices of software development best practices.
- At least five years of experience in ETL methodologies and development.
- Degree from an accredited college with a bachelor’s degree in computer science, Information Technology, Management Information Services, Business Management, Engineering, Project Management, Business or Public Administration, Communications, or a related field. May be substituted with relevant software development experience of 5 or more years.
Responsibilities:
- Develop and maintain the Data Warehouse based on business and technology requirements and industry standard best practices.
- Ability to work with SQL Server DBAs, system architect, and application developers to design stable, reliable, effective, and optimized databases.
- Plan and coordinate data migrations between systems.
- Assists in the formulation of business and testing requirements.
- Develop high quality deliverables.
- Follows all required software development standards, change control procedures, and security requirements.
- Ensure that the databases meet organization and performance requirements.
- Follows all required software development standards, change control procedures, and security requirements.
- Ability to build relationships with project sponsors, stakeholders, other technical staff, vendors, and end users.
- Coordinates and performs required unit, system, and performance testing. Works with other team members on User Acceptance testing and issue resolution.
- Participates in continuous improvement activities by identifying and analyzing the effectiveness and efficiency of existing processes and develops strategies for improvements.
- Produces status reports and communications on a regular basis.
Required Skills:
- 3 years of SSIS experience.
- Experience working with Azure SQL Instance.
- Skill in SQL Server scripting.
- Skill in data modeling.
- Skill in the operation of computers and peripheral equipment.
- Skill in creative and analytic problem solving.
- Understanding of Data Warehousing principals, concepts, and architecture.
- Ability to manage multiple priorities and meet project delivery dates.
- Ability to effectively analyze and manage requirements.
- Ability to visualize complex issues.
- Knowledge of personal computers, Microsoft Office suite of tools including Word, Excel, PowerPoint, and Visio.
- Knowledge of programming concepts and the Software Development Lifecycle (SDLC).
- Ability to coordinate the work of a team with the work of other units within multiple departments of the client.
- Effective verbal and written communication skills.
- Ability to effectively communicate with all levels of users and team members.
Job Type: Contract
Pay: $80,000.00 - $100,000.00 per year
Work Location: Hybrid remote in Middle River, MD 21220
Salary : $80,000 - $100,000