Data Integration Specialist with Security Clearance
R-00126539 Description Come join one of our high performing teams responsible for building and supporting enterprise open systems platform of the Social Security Administration (SSA) and their mission to meet the changing needs of the public, positively impacting at least 65 million American lives per month.
The Data Integration Specialist will implement, operate, and maintain load balancing technologies in a large enterprise network.
Duties include updating to new technologies, tuning performance, and implementation of critical system patches.
This infrastructure may include on-premises and cloud resources.
We are a team of forward-looking professionals in need of a strong candidate with these key required skills :
have worked with advanced technical principals, theories, and concepts; well versed in technical products; able to work on complex technical problems and providing innovative solutions; and can work with highly experienced and technical resources.
Do you have most of these key required skills, education, or experience? Do you want to learn more about our telework posture? Are you an US citizen, US resident, or Visa candidate and think you might fit? We recommend you apply and start the conversation today! Join us in supporting our SSA contracts in Woodlawn, Maryland.
If this sounds like a mission you want to be a part of, keep reading! TEAM CULTURE Your passion and values might be a good fit for our teams if you answer yes to the following questions:
Are you looking for a company that puts employees first, with a focus on career, flexibility, and well-being? Do you enjoy collaborating with colleagues and teammates and believe that the best ideas are fostered in an inclusive environment? Are you searching for a team with a strong sense of ownership, urgency, and drive for daily mission success? Are you comfortable with proactive outward communication and technical leadership? Do you enjoy being a catalyst, solving complex problems, and providing innovative solutions? Do you have the flexibility, creativity, and resilience to pivot the mission for success? Do you have the courage to make tough ethical decisions with pride, transparency, and respect? MENTORSHIP & CAREER GROWTH Our teams are dedicated to supporting new team members in an environment that celebrates knowledge sharing and mentorship.
Experienced team members will be assigned to new hires for one-on-one mentoring, collaborative reviews, and coaching on customer engagement to help each new hire successfully onboard and demonstrate their skills.
Projects and tasks are assigned in a way that leverages your strengths and will help you further develop your skillset.
DAY TO DAY RESPONSIBILITIES Every position we take is more rewarding when you know the why behind it.
Know your work makes a difference to support those who need it most.
If your passion is enabling life changing service to those around, you this is the place for you.
Find you passion in a team environment where all members are valued regardless of contractor or employee status.
Find your Why with us and take your place in our Leidos Family!! Demonstrates ability to communicate technical concepts to non-technical audiences both in written and verbal form.
Assembles large, complex data sets to meet business requirements.
Works in tandem with Data Architects to align on data architecture requirements provided by the latter.
Creates and maintains optimal data pipeline architecture.
Identifies, designs, and implements internal process improvements:
automating manual processes, optimizing data delivery.
Implements big data and NoSQL solutions by developing scalable data processing platforms to drive high-value insights to the organization.
Supports development of Data Dictionaries and Data Taxonomy for product solutions.
Demonstrates strong understanding with coding and programming concepts to build data pipelines (e.
g.
, data transformation, data quality, data integration, etc.
).
Builds data models with Data Architect and develops data pipelines to store data in defined data models and structures.
Demonstrates strong understanding of data integration techniques and tools (e.
g.
, Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT)) tools and database architecture.
Demonstrates strong understanding of database storage concepts (data lake, relational databases, NoSQL, Graph, data warehousing).
Identifies ways to improve data reliability, efficiency, and quality of data management.
Conducts ad-hoc data retrieval for business reports and dashboards.
Assesses the integrity of data from multiple sources.
Manages database configuration including installing and upgrading software and maintaining relevant documentation.
Monitors database activity and resource usage.
Performs peer review for another Data Engineer's work.
Assists with development, building, monitoring, maintaining, performance tuning, troubleshooting, and capacity estimation.
Sources data from the operational systems.
Prepares the database-loadable file(s) for the Data Warehouse.
Manages deployment of the data acquisition tool(s).
Monitors and maintains Data Warehouse/ELT.
Monitors, reports, and resolves data quality.
Works closely with all involved parties to ensure system stability and longevity.
Supports and maintains Business Intelligence functionality.
Evaluates, understands, and implements patches to the Data Warehouse environment.
Loads best practices and designs multidimensional schemas.
Attend all customer technical discussions/design/development meetings and provide technical inputs to further enhance the code quality/process.
Provide guidance/support to other junior/mid-level developers.
Impact functional strategy by developing new solutions, processes, standards, or operational plans that position Leidos competitively in the marketplace.
All other duties as assigned or directed.
FOUNDATION FOR SUCCESS ( Basic Qualifications ) This experience is the foundation a candidate needs to be successful in this position:
Bachelor's degree in computer science, IT, or related field/experience Must be able to obtain and maintain a Public Trust.
Contract requirement.
7 years of experience with Data Engineering, working with large-scale data processing and ETL pipelines.
5 years of hands-on experience with data modeling, architecture and management.
5 years of experience with Relational Database Systems, Data Design, RDBMS Concepts, ETL 5 years of experience working with data in cloud environments such as AWS (preferred), Azure, GCP 3 years of experience in T-SQL, SQL, ELT/ETL performance tuning.
Selected candidate must reside within two (2) hours of SSA Headquarters in Woodlawn, MD OR be willing to relocate prior to first day of employment FACTORS TO HELP YOU SHINE ( Required Skills ) These skills will help you succeed in this position:
Programming experience in Snowflake, Hadoop, or other Data Warehouse technologies; Snowflake preferred.
Experience in Microsoft SQL Server 2008R2 or newer.
Experience with SSIS or equivalent ETL tool.
Experience in SQL/Stored Procedure development.
HOW TO STAND OUT FROM THE CROWD (Desired Skills) Showcase your knowledge of modern development through the following experience or skills:
Understanding of semi-structured / unstructured data using JSON, AVRO, Parquet, CSV, etc.
Experience with complex multi-server environments and high availability environments.
Experience using Azure Data Factory, Five Tran, Spark or other similar data integration tools.
Experience with system monitoring, log management, and error notification.
Fundamental network and IT infrastructure knowledge.
Highly motivated; able to work independently, multi-task, respond to changing priorities, and initiative to own specific tasks.
Strong problem determination, troubleshooting, and resolution skills.
Excellent written and oral communication skills & customer service skills.
Ability to work analytically to solve both tactical and strategic problems.
At Leidos, we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customers' success.
We empower our teams and contribute to our communities.
Everything we do is built on a commitment to do the right thing for our customers, our people, and our community.
Our Mission, Vision, and Values guide the way we do business.
Every position we take is more rewarding when you know the why behind it.
Know your work makes a difference to support those who need it most.
If your passion is enabling life changing service to those around, you this is the place for you.
Find your passion in a team environment where all members are valued regardless of contractor or employee status.
We are excited for you to take your place in our Leidos Family.
Are you an US citizen, US resident, or Visa candidate and think you might fit? We recommend you apply and start the conversation today! Join us in supporting our SSA contracts in Woodlawn, Maryland.
ITSSCII Pay Range:
Pay Range $108,550.
00 - $196,225.
00 The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary.
Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
#Featuredjob Original Posting Date:
01/12/2024 While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
Recommended Skills Amazon Web Services Apache Hadoop Apache Spark Architecture Avro Big Data Apply to this job.
Think you're the perfect candidate? Apply on company site $('.
external-apply-email-saved').
on('click', function (event) window.
ExternalApply = window.
open('/interstitial?jobdid=j3s3n56znljjtcgf48b', 'ExternalApply-j3s3n56znljjtcgf48b'); ); Estimated Salary: $20 to $28 per hour based on qualifications.
The Data Integration Specialist will implement, operate, and maintain load balancing technologies in a large enterprise network.
Duties include updating to new technologies, tuning performance, and implementation of critical system patches.
This infrastructure may include on-premises and cloud resources.
We are a team of forward-looking professionals in need of a strong candidate with these key required skills :
have worked with advanced technical principals, theories, and concepts; well versed in technical products; able to work on complex technical problems and providing innovative solutions; and can work with highly experienced and technical resources.
Do you have most of these key required skills, education, or experience? Do you want to learn more about our telework posture? Are you an US citizen, US resident, or Visa candidate and think you might fit? We recommend you apply and start the conversation today! Join us in supporting our SSA contracts in Woodlawn, Maryland.
If this sounds like a mission you want to be a part of, keep reading! TEAM CULTURE Your passion and values might be a good fit for our teams if you answer yes to the following questions:
Are you looking for a company that puts employees first, with a focus on career, flexibility, and well-being? Do you enjoy collaborating with colleagues and teammates and believe that the best ideas are fostered in an inclusive environment? Are you searching for a team with a strong sense of ownership, urgency, and drive for daily mission success? Are you comfortable with proactive outward communication and technical leadership? Do you enjoy being a catalyst, solving complex problems, and providing innovative solutions? Do you have the flexibility, creativity, and resilience to pivot the mission for success? Do you have the courage to make tough ethical decisions with pride, transparency, and respect? MENTORSHIP & CAREER GROWTH Our teams are dedicated to supporting new team members in an environment that celebrates knowledge sharing and mentorship.
Experienced team members will be assigned to new hires for one-on-one mentoring, collaborative reviews, and coaching on customer engagement to help each new hire successfully onboard and demonstrate their skills.
Projects and tasks are assigned in a way that leverages your strengths and will help you further develop your skillset.
DAY TO DAY RESPONSIBILITIES Every position we take is more rewarding when you know the why behind it.
Know your work makes a difference to support those who need it most.
If your passion is enabling life changing service to those around, you this is the place for you.
Find you passion in a team environment where all members are valued regardless of contractor or employee status.
Find your Why with us and take your place in our Leidos Family!! Demonstrates ability to communicate technical concepts to non-technical audiences both in written and verbal form.
Assembles large, complex data sets to meet business requirements.
Works in tandem with Data Architects to align on data architecture requirements provided by the latter.
Creates and maintains optimal data pipeline architecture.
Identifies, designs, and implements internal process improvements:
automating manual processes, optimizing data delivery.
Implements big data and NoSQL solutions by developing scalable data processing platforms to drive high-value insights to the organization.
Supports development of Data Dictionaries and Data Taxonomy for product solutions.
Demonstrates strong understanding with coding and programming concepts to build data pipelines (e.
g.
, data transformation, data quality, data integration, etc.
).
Builds data models with Data Architect and develops data pipelines to store data in defined data models and structures.
Demonstrates strong understanding of data integration techniques and tools (e.
g.
, Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT)) tools and database architecture.
Demonstrates strong understanding of database storage concepts (data lake, relational databases, NoSQL, Graph, data warehousing).
Identifies ways to improve data reliability, efficiency, and quality of data management.
Conducts ad-hoc data retrieval for business reports and dashboards.
Assesses the integrity of data from multiple sources.
Manages database configuration including installing and upgrading software and maintaining relevant documentation.
Monitors database activity and resource usage.
Performs peer review for another Data Engineer's work.
Assists with development, building, monitoring, maintaining, performance tuning, troubleshooting, and capacity estimation.
Sources data from the operational systems.
Prepares the database-loadable file(s) for the Data Warehouse.
Manages deployment of the data acquisition tool(s).
Monitors and maintains Data Warehouse/ELT.
Monitors, reports, and resolves data quality.
Works closely with all involved parties to ensure system stability and longevity.
Supports and maintains Business Intelligence functionality.
Evaluates, understands, and implements patches to the Data Warehouse environment.
Loads best practices and designs multidimensional schemas.
Attend all customer technical discussions/design/development meetings and provide technical inputs to further enhance the code quality/process.
Provide guidance/support to other junior/mid-level developers.
Impact functional strategy by developing new solutions, processes, standards, or operational plans that position Leidos competitively in the marketplace.
All other duties as assigned or directed.
FOUNDATION FOR SUCCESS ( Basic Qualifications ) This experience is the foundation a candidate needs to be successful in this position:
Bachelor's degree in computer science, IT, or related field/experience Must be able to obtain and maintain a Public Trust.
Contract requirement.
7 years of experience with Data Engineering, working with large-scale data processing and ETL pipelines.
5 years of hands-on experience with data modeling, architecture and management.
5 years of experience with Relational Database Systems, Data Design, RDBMS Concepts, ETL 5 years of experience working with data in cloud environments such as AWS (preferred), Azure, GCP 3 years of experience in T-SQL, SQL, ELT/ETL performance tuning.
Selected candidate must reside within two (2) hours of SSA Headquarters in Woodlawn, MD OR be willing to relocate prior to first day of employment FACTORS TO HELP YOU SHINE ( Required Skills ) These skills will help you succeed in this position:
Programming experience in Snowflake, Hadoop, or other Data Warehouse technologies; Snowflake preferred.
Experience in Microsoft SQL Server 2008R2 or newer.
Experience with SSIS or equivalent ETL tool.
Experience in SQL/Stored Procedure development.
HOW TO STAND OUT FROM THE CROWD (Desired Skills) Showcase your knowledge of modern development through the following experience or skills:
Understanding of semi-structured / unstructured data using JSON, AVRO, Parquet, CSV, etc.
Experience with complex multi-server environments and high availability environments.
Experience using Azure Data Factory, Five Tran, Spark or other similar data integration tools.
Experience with system monitoring, log management, and error notification.
Fundamental network and IT infrastructure knowledge.
Highly motivated; able to work independently, multi-task, respond to changing priorities, and initiative to own specific tasks.
Strong problem determination, troubleshooting, and resolution skills.
Excellent written and oral communication skills & customer service skills.
Ability to work analytically to solve both tactical and strategic problems.
At Leidos, we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customers' success.
We empower our teams and contribute to our communities.
Everything we do is built on a commitment to do the right thing for our customers, our people, and our community.
Our Mission, Vision, and Values guide the way we do business.
Every position we take is more rewarding when you know the why behind it.
Know your work makes a difference to support those who need it most.
If your passion is enabling life changing service to those around, you this is the place for you.
Find your passion in a team environment where all members are valued regardless of contractor or employee status.
We are excited for you to take your place in our Leidos Family.
Are you an US citizen, US resident, or Visa candidate and think you might fit? We recommend you apply and start the conversation today! Join us in supporting our SSA contracts in Woodlawn, Maryland.
ITSSCII Pay Range:
Pay Range $108,550.
00 - $196,225.
00 The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary.
Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
#Featuredjob Original Posting Date:
01/12/2024 While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
Recommended Skills Amazon Web Services Apache Hadoop Apache Spark Architecture Avro Big Data Apply to this job.
Think you're the perfect candidate? Apply on company site $('.
external-apply-email-saved').
on('click', function (event) window.
ExternalApply = window.
open('/interstitial?jobdid=j3s3n56znljjtcgf48b', 'ExternalApply-j3s3n56znljjtcgf48b'); ); Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
