Data Warehouse Engineer

4 weeks ago

Charlotte, United States Compunnel Inc. Full time

USC/GC on W2

Sr. Data Warehouse Designer

Remote


Position is working in an AWS environment • Work individually and in a matrix environment • Work creatively and analytically in a problem-solving environment • Communicate (written and oral) effectively and demonstrate professional interpersonal skills • Interact professionally with clients and vendors • Build positive working relationships with employees at all levels within the organization • Meet deadlines as necessary • Effectively work with minimal supervision • “Can-do” attitude, pro-active and resourceful • Knowledge of CI/CD pipeline. • Experience with scripting languages – e.g. PowerShell, Python, etc.


• Bachelor’s Degree in Computer Science, Information Systems or similar • 7+ years of experience • Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques. • Strong experience working with ETL/ELT concepts of data integration, consolidation, enrichment, and aggregation in large volume data sets. • Expert in SQL and/or SQL-based languages and performance tuning of SQL queries. • Working knowledge of Data Pipelines, stream processing and highly scalable ‘big data’ data stores. • Experience with various data storage technologies - e.g. RDBMS (Oracle, SQL Server, etc.), columnar, tabular, document store, NoSQL • Experience with various ETL/ ETL tools – e.g. ODI, SSIS, Informatica Power Center, Talend, IICS, etc. • Experience with cloud-based data warehouses - e.g. Snowflake, BigQuery, Azure Synapse, RedShift, etc • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. • Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements. • Data validation skills to verify data integrity, understand discrepancies, and resolve them with the highest sense of urgency. • Demonstrated ability to share findings with non-technical or business stakeholders. • Familiarity with Analytical/Reporting Solutions like Tableau, Power BI is a plus • Virtual team collaboration tools such as WebEx, Zoom etc. • Experience with developing detailed migration plans, including data profiling, source/target mapping, transformation, data validation, deployment, data load and rollback strategies. • Create documentation covering all aspects of migration projects, including technical design, architecture diagrams, configurations, data lineage, migration procedures. • Experience working and leading large scale data migration projects ensuring clarity, accuracy, completeness and alignment with project objectives and compliance requirements. • Excellent written, verbal communication and Interpersonal skills • Excellent problem solving skills


•10 to 15 years of Data Warehousing and Data Modeling experience. Please ask the candidate the following pre-screening questions over the phone (not email) and add both the questions and the responses to the top of their resume file. What is a table and fields and their usage? What is a join? What are the different types of joins? How do you code those joins in ANSI vs Oracle syntax? What is a subquery? What is a view and why use a view? What are entities and relationships? What is a key and what types of keys are there? What is an alias? What is the distinct statement and how does it work? What is a NULL value and how is it different than 0/blank space? What is a SQL function and how are they used? What is the difference between UNION and UNION ALL? What is a decode?

  • Data Warehouse Senior Data Engineer

    14 hours ago

    Charlotte, United States Wells Fargo Full time

    The Enterprise Functions Technology (EFT) group provides technology solutions and support for Risk, Audit, Finance, Marketing, Human Resources, Corporate Properties, and Stakeholder Relations business lines. In addition, EFT provides unique technolog Data Engineer, Warehouse, Information Technology, Engineer, Senior, Data, Banking

  • Data Engineer

    2 days ago

    Charlotte, United States Syntricate Technologies Inc Full time

    Hi, Hope you are doing well Number of position : 5 Only Full Time Full-time I, Shakib (i3 infotek) would like to share a job opportunity as Data Engineer based in Charlotte, NC (Onsite) location for a Full-time position. In case, if you are not comfortable with this location, please share your preference with contact details for further requirements...

  • Senior Data Warehouse Developer

    1 month ago

    Charlotte, United States Emblue Full time

    Responsibilities Create and maintain database objects in our data warehouse. Problem-solve issues around data integration unusable data elements unstructured data sets and other data management incidents. Research opportunities for data acquisition and new uses for existing data. Integrate new data management technologies and software engineering tools...

  • Senior Data Warehouse Developer

    1 month ago

    Charlotte, North Carolina, United States Emblue Full time

    Responsibilities Create and maintain database objects in our data warehouse. Problem-solve issues around data integration unusable data elements unstructured data sets and other data management incidents. Research opportunities for data acquisition and new uses for existing data. Integrate new data management technologies and software engineering tools into...

  • Senior Data Warehouse Developer

    15 hours ago

    Charlotte, North Carolina, United States Emblue Full time

    Responsibilities Create and maintain database objects in our data warehouse. Problem-solve issues around data integration unusable data elements unstructured data sets and other data management incidents. Research opportunities for data acquisition and new uses for existing data. Integrate new data management technologies and software engineering tools into...

  • SQL Data Engineer

    2 weeks ago

    Charlotte, United States Saxon Global Full time

    Role: SQL Date Engineer Location: Charlotte, NC Length: 3 + months We are seeking a SQL Data Engineer to collaborate directly with our Finance teams. The successful candidate will be instrumental in constructing comprehensive audit tables for financial reporting. This role requires a strong background in data warehouse methodology, Slowly Changing...

  • SQL Data Engineer

    22 hours ago

    Charlotte, United States Saxon Global Full time

    Role: SQL Date Engineer Location: Charlotte, NC Length: 3 + months We are seeking a SQL Data Engineer to collaborate directly with our Finance teams. The successful candidate will be instrumental in constructing comprehensive audit tables for financial reporting. This role requires a strong background in data warehouse methodology, Slowly Changing...

  • Lead Data Engineer

    1 week ago

    Charlotte, United States Circle K Full time

    Job Description:As the Technical Lead Data Engineer, your primary responsibility will be to spearhead the design, development, and implementation of data solutions aimed at empowering our organization to derive actionable insights from intricate datasets. You will take the lead in guiding a team of data engineers, fostering collaboration with...

  • Lead Data Engineer

    5 hours ago

    Charlotte, United States Circle K Full time

    Job Description:As the Technical Lead Data Engineer, your primary responsibility will be to spearhead the design, development, and implementation of data solutions aimed at empowering our organization to derive actionable insights from intricate datasets. You will take the lead in guiding a team of data engineers, fostering collaboration with...

  • Lead Data Engineer

    6 days ago

    Charlotte, United States Irvine Technology Corporation Full time

    Position: Lead Data Engineer (Python, SQL, Databricks, Azure, Retail industry)Location: Charlotte, NC or Tempe, AZ (Hybrid Model - 3 Remote / 2 Onsite)Duration: (CTH) 6+ month contract to permanent full time hire (Must be in Hirable Status)Hourly Rate: 80/hr to 90/hr (W2 or Corp to Corp)Required experience: Python, SQL, Databricks, Azure, Retail industryWhat...

  • Lead Data Engineer

    4 days ago

    Charlotte, United States Irvine Technology Corporation Full time

    Position: Lead Data Engineer (Python, SQL, Databricks, Azure, Retail industry)Location: Charlotte, NC or Tempe, AZ (Hybrid Model - 3 Remote / 2 Onsite)Duration: (CTH) 6+ month contract to permanent full time hire (Must be in Hirable Status)Hourly Rate: 80/hr to 90/hr (W2 or Corp to Corp)Required experience: Python, SQL, Databricks, Azure, Retail industryWhat...

  • Lead Data Engineer

    1 week ago

    Charlotte, United States Irvine Technology Corporation Full time

    Position: Lead Data Engineer (Python, SQL, Databricks, Azure, Retail industry)Location: Charlotte, NC or Tempe, AZ (Hybrid Model - 3 Remote / 2 Onsite)Duration: (CTH) 6+ month contract to permanent full time hire (Must be in Hirable Status)Hourly Rate: 80/hr to 90/hr (W2 or Corp to Corp)Required experience: Python, SQL, Databricks, Azure, Retail industryWhat...

  • IT Manager Data Engineering

    2 weeks ago

    Charlotte, United States Brightspeed Full time

    Job Description We are currently looking for an IT Manager, Data Engineering professional to join our growing team. In this role, you will lead a team of analysts and data engineering to deliver new functionality on the data warehouse and analytics data platforms. You will lead a team with a wide range of technical skills which include ETL tools, Python and...

  • IT Manager Data Engineering

    2 weeks ago

    Charlotte, North Carolina, United States Brightspeed Full time

    Job DescriptionWe are currently looking for an IT Manager, Data Engineering professional to join our growing team. In this role, you will lead a team of analysts and data engineering to deliver new functionality on the data warehouse and analytics data platforms. You will lead a team with a wide range of technical skills which include ETL tools, Python and...

  • IT Manager Data Engineering

    17 hours ago

    Charlotte, North Carolina, United States Brightspeed Full time

    Job DescriptionWe are currently looking for an IT Manager, Data Engineering professional to join our growing team. In this role, you will lead a team of analysts and data engineering to deliver new functionality on the data warehouse and analytics data platforms. You will lead a team with a wide range of technical skills which include ETL tools, Python and...

  • Data Engineer

    2 months ago

    Charlotte, United States Infinicsinc.com Full time

    Bachelors' degree in Computer Science Engineering Information Technology or related area 7+ years' experience on ETL Development Tools Spark / Java (preferred) Python Ab Initio Informatica Advanced experience & demonstrated proficiency in Spark. Experience with Apache Beam Cloud Data Flow Dataproc Cloud Composer and Big Query 3+ years'...

  • Data Engineer

    2 months ago

    Charlotte, North Carolina, United States Infinicsinc Full time

    Bachelors' degree in Computer Science Engineering Information Technology or related area 7+ years' experience on ETL Development Tools Spark / Java (preferred) Python Ab Initio Informatica Advanced experience & demonstrated proficiency in Spark. Experience with Apache Beam Cloud Data Flow Dataproc Cloud Composer and Big Query 3+ years' experience in Big Data...

  • Data Engineer

    16 hours ago

    Charlotte, North Carolina, United States Infinicsinc Full time

    Bachelors' degree in Computer Science Engineering Information Technology or related area 7+ years' experience on ETL Development Tools Spark / Java (preferred) Python Ab Initio Informatica Advanced experience & demonstrated proficiency in Spark. Experience with Apache Beam Cloud Data Flow Dataproc Cloud Composer and Big Query 3+ years' experience in Big Data...

  • Data Engineer

    1 month ago

    Charlotte, North Carolina, United States Belk Full time

    EDW Data Engineer is responsible for designing, maintaining, and optimizing data infrastructure for data collection, management, transformation, and access. Creates pipelines that convert raw data into usable formats for data scientists and other data consumers to utilize. Builds and leverages information loaded into the Belk Enterprise Data Warehouse (EDW)...

  • Data Engineer

    13 hours ago

    Charlotte, North Carolina, United States Belk Full time

    EDW Data Engineer is responsible for designing, maintaining, and optimizing data infrastructure for data collection, management, transformation, and access. Creates pipelines that convert raw data into usable formats for data scientists and other data consumers to utilize. Builds and leverages information loaded into the Belk Enterprise Data Warehouse (EDW)...