Job Closed

This listing is no longer active.

General Dynamics logo
General Dynamics

A business unit of General Dynamics, General Dynamics Information Technology (GDIT) supports some of the United States' most complex government, defense, and in

ETL Developer

Location

United States

Posted

82 days ago

Salary

$119K - $161K / year

Seniority

Senior

Job Description

ETL Developer

General Dynamics

• design and implement industry best ETL technologies to satisfy client requirements • design and develop optimal code to maintain exceptional performance in processing large volumes of data • translate business requirements into technical specifications • design, develop, and test ETL solutions and automating data loading processes • establish ETL environments according to project requirements • develop and implement an efficient migration process to move ETL objects from development to test and production environments • support the project team throughout the design, development and testing process • participate in all design reviews and requirement sessions, as required • support project documentation, as required • understand database design, programming concepts, data modeling, and framework management • communicate ideas to both technical and non-technical people at all levels of the organization • work with Business Analysts, Data Architects, Enterprise Architects, and ETL Architects to ensure business requirements are being met with the solution being developed • identify and reuse of ETL components and services to avoid duplicative implementations • mentor other team members in developing, documenting and modifying ETL components • develop advanced and complex ETL processes in the AWS GovCloud using the tools such as AWS Glue, S3, Python, Spark, SQL, Athena • support and administer the MySql database in the migration environment on the cloud

Job Requirements

  • 6 + years of related experience
  • US Citizenship Required
  • Excellent written and oral communication skills
  • 5+ years of working experience working with some industry leading ETL tools such as Informatica, ODI
  • 1 year of working knowledge Langchain, CrewAi , Llama or other LLM services
  • 2 years of working knowledge of the AWS data services – S3, Glue, Lambda, Sagemaker AI, EMR, RDS(relational data service) and other AWS services
  • 4+ Years of working experience on the MySql, Oracle or any other RDBMS database
  • demonstrated history of working in large enterprise level applications
  • experience in working with database applications and SQL
  • full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, database optimization techniques and other such data architecture best practices
  • ability to work with various stakeholders with different technical abilities to gather data requirements
  • experience working in cloud environments
  • experience working in Agile development environments
  • track record of the delivery in challenging, face-paced environments
  • BS or equivalent +6 yrs related experience, or MS + 3 yrs related experience

Benefits

  • variety of medical plan options, some with Health Savings Accounts
  • dental plan options
  • vision plan
  • 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match
  • full flex work weeks where possible
  • variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave
  • 15 days of paid leave per calendar year
  • additional 10 paid holidays per year
  • GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees
  • short and long-term disability benefits
  • life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Senior Analytics Engineer (SAS to Python Modernization) - 100 Percent Remote Bright Vision Technologies is a forward-thinking software development company dedicated to building innovative solutions that help businesses automate and optimize their operations. We leverage cutting-edge technologies to create scalable, secure, and user-friendly applications. As we continue to grow, we’re looking for a experienced Electrical Engineer (Journeyman) to join our dynamic team and contribute to our mission of transforming business processes through technology. This is a fantastic opportunity to join an established and well-respected organization offering tremendous career growth potential. Role: Senior Analytics Engineer 100 Percent Remote Key Skills Python (pandas, numpy, SQL) SAS (DATA step, PROC SQL, Macros) Legacy analytics modernization Data validation and reconciliation Business stakeholder collaboration Healthcare analytics (preferred) Required Skills Strong experience in Python for data analysis (pandas, numpy, SQL integration) Working knowledge of SAS with the ability to read and interpret existing SAS code Experience modernizing or translating legacy analytics/reporting logic Solid understanding of analytics concepts including joins, aggregations, time-based logic, and derived metrics Experience validating analytical outputs and ensuring data accuracy Ability to translate business analytical requirements into technical implementations Preferred or Nice-to-have Skills Experience in healthcare, payer, or regulated data environments Familiarity with SAS macros and common PROC workflows Exposure to modern data platforms or cloud-based analytics environments Background in analytics engineering, business intelligence, or data transformation roles. Position Overview We are seeking a Senior Analytics Engineer to support the modernization of legacy SAS-based analytics and reporting workflows within a Business Informatics organization. The role focuses on translating existing SAS programs into scalable, maintainable Python-based analytics solutions while preserving business logic and data accuracy. This is not a traditional software engineering role and not a pure reporting position. The ideal candidate combines strong analytical judgment, hands-on Python data expertise, and the ability to interpret and refactor complex SAS logic into modern analytics pipelines. Key Responsibilities Analyze and interpret existing SAS programs including DATA steps, PROC SQL, and analytical procedures Translate SAS-based transformations and analytics into Python using pandas, numpy, and SQL while preserving business logic Validate converted outputs by reconciling row counts, aggregations, joins, and derived metrics between SAS and Python Partner with Business Informatics stakeholders to understand reporting intent, metric definitions, and downstream usage Refactor and simplify legacy logic to improve transparency and reduce technical debt Collaborate with data platform and technology teams to align Python solutions with enterprise standards Document data transformations, assumptions, and business rules to ensure long-term maintainability Would you like to know more about this opportunity? For immediate consideration, please send your resume directly to boon@bvteck.com or contact us via phone/text/whatsapp at +19086506699 At BVTeck, we are committed to providing equal employment opportunities and fostering an inclusive work environment. We encourage applications from all qualified individuals regardless of race, ethnicity, religion, gender identity, sexual orientation, age, disability, or any other protected status. If you require accommodations during the recruitment process, please let us know. Position offered by “No Fee agency.” Equal Employment Opportunity (EEO) Statement BV Teck expressly prohibits any form of workplace harassment or discrimination. Any improper interference with employees' ability to perform their job duties may result in disciplinary action up to and including termination of employment.Equal Employment Opportunity (EEO) Statement Bright Vision Technologies (BV Teck) is committed to equal employment opportunity (EEO) for all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, veteran status, or any other protected status as defined by applicable federal, state, or local laws. This commitment extends to all aspects of employment, including recruitment, hiring, training, compensation, promotion, transfer, leaves of absence, termination, layoffs, and recall. BV Teck expressly prohibits any form of workplace harassment or discrimination. Any improper interference with employees' ability to perform their job duties may result in disciplinary action up to and including termination of employment.

United States
Job Closed
Prime Therapeutics logo

Senior Analytics Engineer

Prime Therapeutics

Reimagining pharmacy management to provide the same care we would want for our loved ones

Full TimeRemoteTeam 1,001-5,000Since 1998H1B Sponsor

• Aid in stakeholder holder analysis across all levels of the organization to understand current and future state needs for large and complex datasets and databases that drive business processes and the delivery of Prime’s products and services; collaborates with analytics leadership to develop a strategic roadmap for analytic resource(s) and reporting platform(s) in alignment with business requirements • Develops, constructs, tests and maintains data architecture, extract, load, transform (ELT) processes, logical and physical data models, data marts, meta data repositories and data warehouse designs in alignment with business requirements • Optimizes data retrieval, develops data set processes, algorithms and identifies ways to improve data reliability, efficiency and quality • Contributes to and maintains business glossary and other resources that foster cross-functional collaboration on analytical data resources • Collaborates with business stakeholders to identify needs and opportunities for improved delivery, business processes and tasks that can be automated, and to understand the underlying data resources and their relationship to deliver actionable data driven insights and decision support • Provides technical guidance to the analytics function and projects, ensuring that new initiatives enable effective analytic information management; builds and tests proof of concepts to test and demonstrate business value • Cross-train, support, and work closely with team members in the following roles: Data Scientist, Systems Analyst, Report Developer, Database Administrator

United States
$108K - $184K / year
Job Closed
Prime Therapeutics logo

Analytics Engineer

Prime Therapeutics

Reimagining pharmacy management to provide the same care we would want for our loved ones

Full TimeRemoteTeam 1,001-5,000Since 1998H1B Sponsor

• Optimizes data retrieval, develops data set processes, algorithms and identifies ways to improve data reliability, efficiency and quality • Develops, constructs, tests and maintains data architecture, extract, load, transform (ELT) processes, logical and physical data models, data marts, meta data repositories and data warehouse designs in alignment with business requirements • Collaborates with business stakeholders to identify needs and opportunities for improved delivery, business processes and tasks that can be automated, and to understand the underlying data resources and their relationship to deliver actionable data driven insights and decision support • Work to understand and collaborate with the following team members to ensure a seamless transition between databases and user facing applications

United States
$81K - $138K / year
Job Closed
OtherRemoteTeam 11-50

About Prep Network Prep Network (www.prepnetwork.com) operates websites -- 100+ in total -- aimed at maximizing visibility and value for high school athletes at all levels. Our scouts provide content, player rankings, and event coverage year-round. Prep Network operates Prep Hoops, Prep Girls Hoops, Prep Redzone, Prep Dig, and Prep Lacrosse. Combined, Prep Network websites have over 300 scouts nationwide that produce 2,500+ articles each month on prep basketball, football, and volleyball. Prep Network also operates 100+ tournaments and showcases that host hundreds of teams and thousands of prospects across the country each year. Job Description As a scout, you will create written and social media content. You will attend high school and club games, watch game film, and publish player-driven analysis on Prep Network's website. You will utilize your existing network with high school and college coaches in your community to grow the Prep Network footprint. We are a rapidly growing sports-focused company where your voice will be heard and you can make a real impact. Aside from helping high school players get recruited, we want someone who fits our culture, work ethic, and, most importantly, our passion for learning and improving. Responsibilities and Duties - Attend high school and club games and publish written and social media content - Promote players at all levels of collegiate recruitment - Work with other Prep Network contributors to maximize the value added to teams, players, and coaches in your state - Network with coaches at all levels to grow the Prep Network brand We Are Looking For Someone Who Is - Entrepreneurial. Help us build the fastest-growing high school sports network in the country - A Great Teammate. No job is too small. We need someone willing to do whatever is needed to build something great - Driven. You are self-motivated and perform without direct supervision - A Strong Communicator. You need excellent interpersonal, verbal, and written skills - Experienced with Microsoft & Google. You are proficient with Microsoft Office (Word, Excel, and PowerPoint), as well as Google Apps (Gmail, Google Calendar, Google Docs) Benefits and Perks - Flexibility. We care more about the quality of your work than your location. - Awesome Co-Workers. Company culture is important to us. We love hiring curious, self-motivated people who work hard and have a blast doing it. - Potential for Growth. Make an impact, and earn the opportunity for an expanded role. Join the Prep Network team, selected as a 2020 recipient of the Best Employers in Sports Award by Front Office Sports as well as 2023 and 2023 Minneapolis St. Paul Best Places to Work.

United States