ICF Consulting Group, Inc. DBA/Data Engineer in Augusta, Maine
DBA/ Data Engineer
Job Description:This is a cross functional position with significant responsibility and opportunity to shape the future direction of our team. The selected candidate will work to design, monitor, and optimize SQL servers on daily basis. In addition to that, candidate will be required to focus on data development tasks like coding in T-SQL to collect, store, validate and process large datasets.
This position will be part of a small analytical team working on quantitative software products and services so experience working in a product development environment is desired. Successful candidates will be very analytical with a high attention to detail in a quantitative environment to ensure a stable, repeatable, and accurate production data stream. Successful candidates will also enjoy a highly independent work environment where they can take a high level of ownership of their accomplishments.
Architect, design, implement, configure, and troubleshoot database instances, replication, backup, partitions, storage and access.
Monitor and optimize database systems for performance and reliability.
Provide database performance analysis resulting in specific actionable recommendations.
Architect/Implement code migration strategies across environments.
Develop reports as well as perform ad hoc data reporting as needed.
Provide feedback and suggestions for process automation, improvements, and efficiencies.
Oversees implementation of IT Security Policies as they relate to database systems security.
Software and hardware upgrades; ability to manage outside vendors for Networking, Security & IT environment services.
Work with team leads to prioritize business and information needs.
Develop and execute T-SQL code to facilitate data movements and ETL processing with a focus on consistency, reliability, and accuracy.
Design and code workflows, create database releases, and optimize production data pipelines to ensure data accuracy Perform hands on data research to provide insights and uncover potential data issues.
Map data feeds and combine them with third party content ensuring consistency.
Develop and code operational processes to automatically report on data conditions and KPIs during processing.
Be a part of fast-moving development teams using agile methodologies.
8+ years of professional database solution development with Microsoft SQL Server
Proven ability within the database performance and query optimization arena.
Strong analytical and reasoning skills that result in clear, robust, and accurate solutions
Strong data debugging skills
Expertise in Data Analysis, Data Profiling, and SQL Tuning
Has deep understanding of data architecture & data modeling best practices, and guidelines for different data and analytic platforms including scrum and agile procedures.
8+ years of experience working within the full lifecycle SDLC as part of a software product and operations team environment
Experience developing SQL scripts, data processing processes, and performance tuning quantitative queries
Superior organizational and end to end delivery skills in an Agile environment
Ability to manage multiple tasks and shifting priorities with proactive communication in mind
Ability to maintain strong working relationships with development and business teams based on a proactive communication style
Additional Preferred Skills/Experience:
Experience with PowerShell scripting
Ability to work in a distributed team environment
Experience working on quantitative software products
An outstanding academic record with a focused on Energy, Science, Math, and Engineering or similar.
Excellent listening, interpersonal, written, oral, and phone communication skills
Highly self-motivated and self-directed to solve complex technical problems
Ability to exercise independent judgment
Builds and maintains relationships with stakeholders to ensure buy-in and adoption of technology solutions
Self-motivated to continuously improve technical and professional skills
Ability to effectively prioritize and execute tasks
In accordance with the EPEWA (https://leg.colorado.gov/bills/sb19-085) , based on the qualifications and experience required, the annual salary range for this position is $117,000 to $130,000 per year. For more information regarding our benefits, click here (https://www.icf.com/careers/benefits)
Working at ICF
Working at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth. If you’re seeking to make a difference in the world, visit www.icf.com/careers to find your next career. ICF—together for tomorrow.
We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy (https://www.icf.com/legal/equal-employment-opportunity) .
Reasonable Accommodations are available for disabled veterans and applicants with disabilities in all phases of the application and employment process. To request an accommodation please email firstname.lastname@example.org and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about non-discrimination: EEO is the law (https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf) and Pay Transparency Statement (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_English_unformattedESQA508c.pdf) .
Colorado Remote Office (CO99)Need help? We're here:ICFCareerCenter@icf.com
ICF (NASDAQ:ICFI) is a global consulting services company with over 7,000 full and part-time employees, but we are not your typical consultants. At ICF, business analysts and policy specialists work together with digital strategists, data scientists and creatives. We combine unmatched industry expertise with cutting-edge engagement capabilities to help organizations solve their most complex challenges. Since 1969, public and private sector clients have worked with ICF to navigate change and shape the future. Learn more at icf.com.