ETL Analyst/Developer

*   The work is currently part time in the office and part time virtual but may soon revert completely to the office work site.

TriTech Enterprise Systems, Inc. (TriTech) is seeking a ETL Analyst/ Developer for a State of Md contract (BCPS).   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 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.

• 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 BCPS offices, schools, and departments.

• Effective verbal and written communication skills.

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

TriTech is an Equal Opportunity Employer!

Powered by JazzHR