Skip to main content

T-SQL Developer

At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the limitless potential of technology and ingenuity for clients across defense, national security, public safety, civilian, and military health organizations.

Join Accenture Federal Services to do the work you love in an inclusive, collaborative, and caring community, where you can be empowered to grow, learn and thrive through hands-on experience, certifications, industry training and more.

Join us to drive positive, lasting change that moves missions and the government forward!

**You are:**

A Data Engineering pro—someone who thrives in a team setting where you can use your creative and analytical prowess to obliterate problems. You’re passionate about digital technology, and you take pride in making a tangible difference. Complex issues don’t faze you thanks to your razor-sharp critical thinking skills. Working in an information systems environment makes you more than happy. As part of our AI & Technology group, you will lead cloud technology innovation for our clients through robust delivery of world-class data platforms. There will never be a typical day and that’s why people love it here. The opportunities to make a difference within exciting client initiatives are unlimited in the ever-changing cloud data landscape.

**The work:**

The Data Integration Engineer will be part of a Data Migration Team on a larger Case Management System Modernization Program being implemented on Azure using MS Dynamics CRM (PowerApps). You help build the infrastructure to answer questions with data, using software engineering best practices, data management fundamentals, data storage principles, and recent advances in distributed systems. You develop and drive automated solutions and solve challenging data integration problems utilizing optimal ETL patterns, frameworks, query techniques, and sourcing from structured and unstructured data sources.

The Data Engineer should have extensive Data Migration experience and understand all the intricacies required of developing data integration routines for moving data from multiple source systems to a new target system with a different data model.

+ Design and develop Cloud ETL processes and workflows.

+ Develop Extract, transform, and load (ETL) processes to transmit data from legacy on-premises source system to Azure SQL Databases and Dataverse data repository on Azure; create necessary data structures or data models to support data at all stages.

+ Use Azure Data Factory/SSIS platform to extract, transform, and load data from legacy source system data extracts to multiple staging area AzureSQL Databases.

+ Use KingswaySoft to move data from AzureSQL Database to Common Data Service (CDS) data repo

**Here's what you need:**

+ Overall 8 years of experience in data conversion or data migration

+ Experience in SQL scripting (extremely strong SQL skills required, including writing T-SQL stored procedures)

+ Experience with SSIS (SQL Server Integration Services)

+ Experience with Azure data factory

+ Experience with MS SQL Server

**Eligibility Requirements:**

+ US Citizenship required

+ Eligible for a Government issued Public Trust Clearance

As required by local law, Accenture Federal Services provides reasonable ranges of compensation for hired roles based on labor costs in the states of **California, Colorado, Hawaii, New York, Washington, and the District of Columbia** . The base pay range for this position in these locations is shown below. Compensation for roles at Accenture Federal Services varies depending on a wide array of factors, including but not limited to office location, role, skill set and level of experience. Accenture Federal Services offers a wide variety of benefits. You can find more information on benefits here. (https://www.accenture.com/us-en/careers/your-future-rewards-benefits) We accept applications on an on-going basis and there is no fixed deadline to apply.

The pay range for the states of California, Colorado, Hawaii, New York, Washington, and the District of Columbia is:

$88,600—$178,600 USD

**_What We Believe_**

_We have an unwavering commitment to diversity with the aim that every one of our people has a full sense of belonging within our organization. As a business imperative, every person at Accenture Federal Services has the responsibility to create and sustain an inclusive environment._

_Inclusion and diversity are fundamental to our culture and core values. Our rich diversity makes us more innovative and more creative, which helps us better serve our clients and our communities. _ Read more here (https://www.accenture.com/us-en/about/inclusion-diversity/us-workforce)

**_Equal Employment Opportunity Statement_**

_Accenture Federal Services is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion or sexual orientation._

_All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law._

_Accenture is committed to providing veteran employment opportunities to our service men and women._

_For details, view a copy of the _ Accenture Equal Opportunity and Affirmative Action Policy Statement (https://afscommunities.force.com/careers/s/equal-opportunity-annual-policy) _._

**_Requesting An Accommodation_**

_Accenture Federal Services is committed to providing equal employment opportunities for persons with disabilities or religious observances, including reasonable accommodation when needed. If you are hired by Accenture Federal Services and require accommodation to perform the essential functions of your role, you will be asked to participate in our reasonable accommodation process. Accommodations made to facilitate the recruiting process are not a guarantee of future or continued accommodations once hired._

_If you_ **_ _** _are being considered for employment opportunities with Accenture Federal Services and need an accommodation for a disability or religious observance during the interview process or for the job you are interviewing for, please speak with your recruiter._

**_Other Employment Statements_**

_Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States._

_Candidates who are currently employed by a client of Accenture Federal Services or an affiliated Accenture business may not be eligible for consideration._

_Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process._

_The Company will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. Additionally, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the Company's legal duty to furnish information._


Similar jobs

T-SQL Developer

Full time
Washington, DC

Published on 06/17/2024

Share this job now

Similar jobs