Search for Senior SQL Data Engineer roles in Dallas, Texas, requiring 10+ years of experience, focusing on ETL development and AWS technology, with skills in Snowflake and Python.

Okay, I've searched for Senior SQL Data Engineer roles in Dallas, Texas, requiring 10+ years of experience, focusing on ETL development and AWS technology, with skills in Snowflake and Python. I have found 27 positions for you.

Senior SQL Data Engineer

Dallas, TX

10 years + Experience

ETL

AWS

Snowflake

Python

Can you help me to analyze the job description and company culture?

Sure. Here's the analysis:

Job Analysis:

The Sr. SQL Data Engineer role at Compunnel Inc. is fundamentally about architecting and optimizing data management strategies to support business intelligence and operational efficiency. The candidate is expected to leverage extensive experience in SQL and data engineering to design and maintain robust data lakes and warehouses, critical for transforming raw data into actionable insights. Responsibilities include managing ETL processes with tools like Informatica, developing data models, and ensuring data flow from sources to databases aligns with business needs. Given the company's emphasis on digital transformation solutions, the engineer will face challenges like integrating diverse data sources, maintaining data integrity, and ensuring responsiveness to evolving client demands. Success in this role will be measured by the stability, performance, and usability of the data solutions deployed, alongside the breadth of insights they yield for strategic decision-making. Within the first year, achieving seamless integration of multiple database technologies and enhancing reporting capabilities through tools like Tableau will likely be key performance indicators.

Company Analysis:

Compunnel, Inc. operates in the competitive realm of customized workforce and digital transformation solutions, positioning itself as a trusted partner for both private enterprises and public agencies. Given its strong market presence, particularly among Fortune 500 companies, the Sr. SQL Data Engineer role stands at the intersection of innovation and strategic delivery, demanding a blend of technical aptitude and adaptability to client needs. The company prioritizes a human-centric dialogue, inferring a collaborative culture that values diversity and inclusivity as a recognized Minority Business. This cultural backdrop creates an empowering environment for engineers, encouraging not only technical excellence but also creative problem-solving. The role likely reports within a broader team structure, potentially collaborating cross-functionally with data analysts, product managers, and business stakeholders, giving it significant visibility and influence over strategic data initiatives. Overall, this position is integral to Compunnel’s mission of using technology to unlock potential, aligning tech-savviness with the organization’s growth-focused trajectory.

Mock up some interview questions based on the job description.

Absolutely. Here are some mock interview questions that could come up:

Describe a time when you encountered a significant challenge while designing a data warehouse. How did you solve it?
Can you provide an example of a successful ETL process you designed from scratch? What were the key metrics you focused on?
Tell me about a situation where you had to explain complex data models to non-technical stakeholders. How did you ensure their understanding?
In your experience, what best practices do you follow for maintaining data quality within a data lake?
How would you approach integrating a new data source into an existing architecture?
Explain your experience with AWS services that are relevant to data engineering and how you've utilized them in past projects.
What strategies do you implement for version control in your data engineering projects?
How do you stay updated with advancements in data engineering technologies and best practices?
Imagine you are tasked with optimizing an underperforming ETL pipeline. What steps would you take to diagnose and enhance performance?
Why are you interested in working at Compunnel, and how do you see yourself contributing to our mission?
How do your personal values align with the diversity and inclusivity initiatives that Compunnel promotes?
What attracts you specifically to the role of Sr. SQL Data Engineer within our organization?
What are two or three questions you have for us regarding our team dynamics or company culture?

Job Details

Overview Company

Senior SQL Data Engineer

Compunnel Inc.

3 days ago

Highlight

HybridFull-time10+ yearsSenior

Summary

Compunnel Inc. is seeking a Sr. SQL Data Engineer to join their team in Dallas, TX. The role involves designing and delivering data lake, data warehouses, and reporting platforms.

About the Role

As a Sr. SQL Data Engineer, you will be responsible for designing and delivering data lake, data warehouses, and reporting platforms. You will work with SQL, ETL, Informatica, Data Modeling, Snowflake, Python, and AWS in a hybrid work environment.

About You

Required:

Bachelor’s degree
10+ years experience in designing and delivering data lake, data warehouses and reporting platforms
Strong expertise in SQL
Experience with Extract, Transform & Load and ELT development
Familiarity and good understanding of Data Models - relational and dimension models
Experience with AWS cloud technology
Experience with multiple database technologies
Experience with CI/ CD and software version control

Preferred:

Experience with Snowflake
Experience with reporting tools such as Tableau, OBIEE
Programming experience with Python, Java

Compunnel Inc.

Compunnel, Inc., founded in 1994 and headquartered in New Jersey, is at the forefront of providing customized workforce and digital transformation solutions, enhancing the total experience for our valued business allies. Our approach integrates innovative technologies with a human-centric dialogue, exceeding the needs of our customers, employees, partners, and key growth contributors and delivering exceptional value. 

With a strategic presence across the United States through over 30 local service delivery centers and global support from our centers in Canada, India, and the UK, Compunnel proudly serves over 200 clients, including 23% of Fortune-listed enterprises. Our expertise is trusted by various clients, from global corporations to various federal, state, and local agencies seeking premier talent solutions. 

An 12-time honoree by Inc. 5000 as one of the Fastest-Growing Private Companies in the US, Compunnel facilitates businesses in multiple sectors to secure top-tier talent and cutting-edge technology solutions. We specialize in Software Development, Cloud Services, Data Analytics, AI & Machine Learning, Cybersecurity, and Recruitment Solutions in IT, Non IT & for Public Sector. Our AI-powered, intelligent solutions are at the core of our digital offerings, driving smarter decision-making and empowering organizations to bridge the gap between their current and desired states with precision, speed, and a measured approach. For over three decades, we have been the leading choice of more than 23% of Fortune 500 companies for their technology and talent needs.  

As a recognized Minority Business in the US and Canada, we champion diversity and inclusivity, ensuring equal opportunities for talent from diverse backgrounds. Our robust partnerships with technology leaders like AWS, Microsoft, UiPath, and Google Cloud reflect our commitment to pioneering AI-driven innovations and establishing centers of excellence for our Fortune 500 clients worldwide. 

Dallas, TX