ETL Analyst/Developer Job at TriTech Enterprise Systems, Inc., Middle River, MD

NUg2YldMRXJxNFVSbjFEQ0JFaU1qY2Z6TlE9PQ==
  • TriTech Enterprise Systems, Inc.
  • Middle River, MD

Job Description

*   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!

 

Job Tags

Full time, Contract work, Part time, Work at office,

Similar Jobs

Rustman Agency

Entry-Level Sales Consultant Job at Rustman Agency

 ...Overview Were hiring motivated individuals to join our team as Entry-Level Sales Consultants . This is a great opportunity for someone...  ...training and ongoing support Flexible schedule with remote options Performance-based compensation (commission structure... 

Placements USA LLC

Interventional Cardiologist Job at Placements USA LLC

 ...We have an exciting opportunity available for a BC/BE Interventional Cardiologist to join our progressive and thriving, large multidisciplinary practice with 4 locations in Southeast New Mexico. This experienced team of 14 providers and 100+ member support staff... 

Marriott

Night Auditor and Hotel Operations Job at Marriott

**Additional Information** Pay: $23.15/hour**Job Number** 25108588**Job Category** Finance & Accounting**Location** SpringHill Suites Los Angeles Burbank/Downtown, 549 South San Fernando Boulevard, Burbank, California, United States, 91502VIEW ON MAP (**Schedule** Part...

Framework Construction Recruiting

Superintendent - Multifamily Construction (LIHTC) Job at Framework Construction Recruiting

 ...Superintendent Multifamily Construction Jacksonville, FL $75-95k Why this role might be worth your time: Youre a Superintendent...  ...developer-builder hire a Superintendent for their multifamily pipelinethink garden-style, 3- to 5-story walk-ups, and similar wood-... 

Get It - Executive

Entry Level Help Desk - Remote Job at Get It - Executive

 ...looking for motivated individuals with a knack for problem-solving and a passion for customer service to join our team as an Entry-Level Help Desk Technician. This fully remote opportunity offers the chance to grow your skills, gain hands-on experience, and make a real...