Senior Database & ELT Engineer; SQL​/Snowflake

Responsibilities

• Design, develop, test, implement, and support complex platform‑specific ELT code using tools such as Python, SQL and Snowflake.
• Perform data migrations and design business process monitoring solutions.
• Implement high‑availability and disaster‑resilient solutions across multiple data warehouse and reporting environments.
• Monitor load balancing and tune system parameters to ensure optimal performance across databases (e.g., SQL server, Snowflake).
• Provide Tier II technical support for database and ELT issues, including performance, availability, data integrity, security, and customer‑reported concerns.
• Conduct performance tuning across multiple environments and platforms.
• Design standards for data exchange between internal systems and external entities, including data security models, encoding schemes, and data layouts.
• Define and support Data Warehouse business intelligence designs.
• Assist in implementing Data Warehouses and data marts.
• Implement custom SQL solutions and data extracts for business customers.
• Build and support enterprise reporting, dashboards, scorecards, and analytic applications (e.g., Python, SQL).
• Replicate and transform data to support analytics and BI initiatives.
• Develop and maintain documentation, including installation procedures, monitoring guides, security policies, configuration changes, and migration processes.
• Write platform‑specific code to support data migrations across development, UAT, performance, beta‑production, and production environments.
• Work closely with the Data Warehouse Architect, IT Architecture team, CIO, and IT Managers to design solutions that meet enterprise requirements.
• Assist in evaluating solution designs, new technologies, and industry best practices.
• Mentor database administration specialists and junior ELT developers through both formal and informal training.
• Contribute to business cases and solution documentation.
• Create, monitor, and resolve trouble tickets, ensuring timely updates and communication of remediation progress.
• Prepare and submit weekly activity and status reports.

• 60 months combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support; plus 12 months work experience in the primary technology specified by the agency in the position description & job posting.
• Or completion of associate core program in computer science or information systems; 42 months combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support; plus 12 months work experience in the primary technology specified by the agency in the position description & job posting.
• Or completion of undergraduate core program in computer science or information systems; 36 months combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support; plus 12 months work experience in the primary technology specified by the agency in the position description & job posting.
• Or equivalent of minimum class qualifications for employment noted above.
• Primary technology: SQL Server.