Data Warehouse Developer ETL

Role: Data Warehouse Developer ETL

Location: Middle River, MD

Note: The work is currently part time in the office and part time virtual but may soon revert

completely to the office work site

*Only local candidates in the Baltimore metro area are considered

Key Skills: ETL Development, SSIS, Azure SQL, SQL Programming, Data Warehousing, Data Modeling, Test Automation/ Data Quality Validation/ Performance Tuning / UAT Testing.

About the role:

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.

Preferred Qualifications:

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 principles, 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 and Effective verbal and written communication skills.

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 the

Department of Research, Assessment, and Accountability and other client offices,

schools, and departments.

Ability to effectively communicate with all levels of users and team members.

Ability to produce status reports and communicate the status of projects on a regular

basis.

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.

Roles and 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.

About Us WinningEdge:

Job Search can be a painful & frustrating process. We take time to understand candidate

skillsets, and job search preferences and match them with our ideal clients. Our team has a

combined experience of over 100 years and we have successfully placed hundreds of

candidates.