Sr. Data Engineer at Allen Integrated Solutions LLC

Carmel, Indiana, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

N/AIndustries

Requirements

Bachelor’s Degree required, or equivalent education/work experience
5+ years of experience with data warehousing, databases (MS SQL Server, Snowflake), and dimensional modeling
5+ years of experience in end-to-end data analysis and development
3-5 years of experience in AWS cloud services (AWS Glue, Lambda, S3, etc.)
3-5 years of experience with Snowflake (Snowpipe, Snowpark, Streamlit, Streams/Tasks) (preferred)
Extensive Experience with SQL required
Experience with R or Python (preferred)
Experience with Git and CI/CD (preferred)
Strong attention to detail
Familiarity with Object Oriented Analysis, Project Management, Business Analysis Methodology, and the SDLC
Ability to collaborate effectively and work as part of a team
Customer-oriented, with a desire to resolve problems to the customer's satisfaction while maintaining focus on productivity, efficiency, and quality
Effective communicator to clients, management, and project partners
Experience with cloud-based technologies and services (SaaS, PaaS, IaaS) (preferred)
Experience with Master Data Management (preferred)
Strong analytical and product management skills required, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements

Responsibilities

Creates detailed documentation of data warehouse, data stores, and end to end data flows
Troubleshoots and corrects data and data processing errors in existing solutions
Works with other technical teams as well as with internal and external users to develop technical designs
Develops and continually refines the BI-focused data architecture
Works closely with the Data Intelligence department to understand the data and reporting requirements from internal and external customers and the steps to take on the back-end data side to achieve the expected results
Conducts gap analysis on source system databases against Allied’s enterprise data warehouse in support of Business Intelligence efforts
Develops and maintains data sets and standardizes data collection and processing methodologies
Provides technical advice and weighs in on technical decisions that impact cross functional teams
Attends and contributes to architecture meetings to determine project scope, time frame and cost estimates
Works on plan and technical architecture to extract, integrate, and or push data to or from third party providers
Provides enterprise data solutions for Allied including ETL maintenance, warehouse data models, periodic upgrades, security, governance, and performance optimization
Understands the data warehouse and data mart models as well as being familiar with the business information contained in each
Locates and defines new process improvement opportunities or alternative technologies that will enhance speed to business value delivery with our data
Collaborates with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs
Mentors other ETL Developers and Data Engineers

Skills

Key technologies and capabilities for this role

SQLData WarehouseData ArchitectureData ModelingETLBusiness IntelligenceData FlowsData Processing

Questions & Answers

Common questions about this position

What experience is required for the Senior Data Engineer role?

Candidates need a Bachelor’s Degree or equivalent, 5+ years of experience with data warehousing, databases like MS SQL Server and Snowflake, and dimensional modeling, plus 5+ years in end-to-end data analysis and development, and 3-5 years of experience.

What are the key skills needed for this position?

Key skills include expertise in SQL, data design, data processes, data modeling, ETL development, BI-focused data architecture, and subject matter expertise in data domain knowledge.

Is this a remote position or does it require office work?

This information is not specified in the job description.

What is the salary or compensation for this role?

This information is not specified in the job description.

What does the team collaboration look like in this role?

The role involves working cross-functionally with teams across the organization, collaborating with the Data Intelligence department, other technical teams, internal and external users, developers, and subject matter experts, and mentoring other ETL Developers and Data Engineers.

Allen Integrated Solutions LLC

Provides technical and management services for government security missions

About Allen Integrated Solutions LLC

Allen Integrated Solutions LLC specializes in a range of technical and management services aimed at enhancing performance in government and security sectors. With a focus on integration management, intelligence, cyber security, and more, the company expertly handles missions related to national security and defense. This firm stands out as a reliable provider of comprehensive systems engineering, technical assistance, and advisory services, making it a pivotal support system for complex federal operations.

Stafford, VA 22554, USAHeadquarters

2015Year Founded

VENTURE_UNKNOWNCompany Stage

Consulting, AerospaceIndustries

11-50Employees