Azure Data Warehouse Developer

1 week ago


Downey, United States CodeForce Full time
Position Description: Miscellaneous/Niche/Other

Skills Required: Miscellaneous/Niche/Other

Skills Preferred: 1. Strong understanding of relational database concepts, SQL (Structured Query Language), and data modeling. Knowledge of various databases used in data warehousing, such as Oracle, SQL Server, PostgreSQL, or MySQL. 2. Proficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to extract data from various sources, transform it to fit the target schema, and load it into the data warehouse. 3. Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis. 4. Understanding of data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse. 5. Knowledge of data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow. 6. Familiarity with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses. 7. Experience with BI tools like Power BI and IBM Cognos to create interactive and insightful dashboards and reports for business users. 8. Proficiency in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation. 9. Understanding of data security principles and compliance regulations to protect sensitive information in the data warehouse. 10. Skills in optimizing data warehouse performance, including query optimization, index creation, and partitioning.

Experience Required: Miscellaneous/ Niche/ Other

Experience Preferred: 1) 3 years of experience in the past 4 years in working with Oracle database architecture, data modeling, normalization, and performance optimization is crucial. Knowledge of Oracle PL/SQL (Procedural Language/Structured Query Language) is also essential for writing efficient database queries and stored procedures. 2) 3 years of experience in the past 4 years in working with mainframe databases like IBM DB2 and IMS (Information Management System), including data modeling, database design, and SQL querying. 3) 3 years of experience in the past 4 years in working with Microsoft Azure Cloud platform, including familiarity with other Azure services like Azure Data Lake Storage, Azure Databricks, Azure Data Factory, and Azure DevOps. 4) 3 years of experience in the past 4 years in working with designing and developing data warehouses using other platforms like Microsoft SQL Server, Oracle, or Teradata can be valuable in understanding data warehousing concepts and best practices. 5) 3 years of experience in the past 4 years in working with years of experience in big data technologies such as Apache Hadoop, Apache Spark, or Apache Kafka can be beneficial, as they integrate with Azure Synapse Analytics and enable large-scale data processing and analytics. 6) 3 years of experience in the past 4 years in working with data visualization tools like Power BI or Cognos to create insightful visualizations and reports based on data stored in Synapse Data Warehouse. 7) 3 years of experience in the past 4 years in working with data cleansing, data profiling, and data validation techniques to ensure high data integrity in the data warehouse.

Education Required: Miscellaneous/ Niche/ Other

Education Preferred: A Bachelor's or Master's degree in Computer Science.

Additional Information: The candidate must have a live scan and background check performed by Probation.

  • Downey, United States CodeForce Full time

    Position Description: An Informatics Data Analyst works independently to document external data acquisition policies and procedures as well as interface with other business units to define and document data needs and ad-hoc analysis requirements; identify business practice workflow and process issues and concerns; provide leadership and guidance to define...

  • Azure Data Engineer

    7 months ago


    Downey, United States West Advanced Technologies Full time

    Job Title: (Azure Data Engineer) with Lakehouse Platform Location: Downey, CA, 90242 :: Remote Duration: 12 Months Skills Required Possess knowledge and technical expertise in standards and technologies to support complex business analysis, solution selection, systems design, and application integration - SQL and Relational Databases such as Oracle,...


  • Downey, California, United States West Advanced Technologies Full time

    At West Advanced Technologies, we're seeking a skilled Data Warehousing Specialist to join our team. This role involves designing and implementing efficient data models for data warehousing, including dimensional modeling techniques such as star and snowflake schemas.Key ResponsibilitiesDeveloping and maintaining data warehouses using Microsoft Azure Cloud...


  • Downey, California, United States West Advanced Technologies Full time

    Azure Data Engineering Lead Job Description">Location: Downey, CA 90242 (Remote)">Duration: 12 Months">Estimated Salary: $170,000 - $230,000 per year">We are seeking an experienced Azure Data Engineering Lead to join our team. The successful candidate will design, develop, and implement data solutions on the cloud using Azure technologies. This includes...


  • Downey, California, United States CodeForce Full time

    Job OverviewWe are seeking an experienced Data Integration Specialist to join our team at CodeForce. As a key member of our data analytics group, you will play a crucial role in designing and implementing efficient data models for data warehousing.About the Role:Design and develop data warehouses using Microsoft Azure Cloud platform, including familiarity...


  • Downey, United States Perfict Global, Inc. Full time

    About Us: Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...


  • Downey, California, United States CodeForce Full time

    Job DetailsWe are seeking a talented Business Intelligence Developer to join our team at CodeForce. As a key member of our data analytics group, you will design and implement data visualization tools, ETL processes, and data warehouses to support business decision-making.About the Role:Develop and maintain data visualization tools like Power BI or Tableau to...

  • ETL Consultant

    5 days ago


    Downey, United States West Advanced Technologies Full time

    ETL Consultant Downey CA (Remote) Duration: 12 months Skills Required The Informatics Data Analyst will possess knowledge and experience in basic statistical concepts; identifying the trends, business opportunities, and relevant issues; commonly-used demographics and databases; definitions of fields and how data is entered and processed; data...

  • Cloud Data Architect

    4 weeks ago


    Downey, California, United States West Advanced Technologies Full time

    Job Title: Cloud Data Architect">Location: Remote, Downey, CA 90242">Duration: 12 Months">Salary: $150,000 - $200,000 per year (estimated)">This role involves designing and developing data architectures on the cloud using Azure technologies. Key responsibilities include designing and implementing scalable data solutions, optimizing database performance, and...


  • Downey, California, United States West Advanced Technologies Full time

    Data Solutions Specialist Opportunity">Location: West Advanced Technologies, Downey, CA 90242 (Remote)">Duration: 12 Months">Estimated Salary: $160,000 - $220,000 per year">We are seeking an experienced Data Solutions Specialist to join our team. The successful candidate will design, develop, and implement data solutions on the cloud using Azure...


  • Downey, United States West Advanced Technologies Full time

    Senior Data Engineer Cloud Platform Downey, CA - Remote 12+ months A Senior Enterprise Architect applies their management skills and specialized functional and technical expertise to support complex projects in applying organizing principles and methods of enterprise architecture. Methods of enterprise architecture include IT business systems development and...


  • Downey, United States CodeForce Full time

    Position Description: A Senior Enterprise Architect applies their management skills and specialized functional and technical expertise to support complex projects in applying organizing principles and methods of enterprise architecture. Methods of enterprise architecture include IT business systems development and technical solutions that align with the...

  • Data Architect

    4 weeks ago


    Downey, California, United States West Advanced Technologies Full time

    Job Title: Data ArchitectWe are seeking an experienced Data Architect to join our team at West Advanced Technologies, Inc. As a key member of our data management group, you will be responsible for designing and implementing efficient data models for data warehousing.Salary: $120,000 - $180,000 per annum, depending on experience.About the Job: This is a...


  • Downey, California, United States West Advanced Technologies Full time

    At West Advanced Technologies, we are committed to delivering exceptional results for our clients. As a Data Engineering Leader, you will lead a team of engineers in designing and developing data engineering solutions that meet the needs of our clients.We are looking for an experienced professional with a strong background in data engineering, particularly...


  • Downey, United States James Perse Full time

    WE ARE CURRENTLY HIRING A BUSINESS INTELLIGENCE ANALYSTOBJECTIVE OF THE POSITIONWe are seeking a skilled Business Intelligence (BI) Analyst with expertise in Power BI and data warehouses to join our dynamic team. The ideal candidate will be responsible for transforming data into actionable insights and facilitating data-driven decision-making processes. They...


  • Downey, United States James Perse Los Angeles Full time

    WE ARE CURRENTLY HIRING A BUSINESS INTELLIGENCE ANALYST OBJECTIVE OF THE POSITION We are seeking a skilled Business Intelligence (BI) Analyst with expertise in Power BI and data warehouses to join our dynamic team. The ideal candidate will be responsible for transforming data into actionable insights and facilitating data-driven decision-making processes....


  • Downey, California, United States Veritiv Corporation Full time

    About the JobWe are seeking an experienced Warehouse Management Lead to join our team at Veritiv Corporation. As a key member of our distribution center, you will be responsible for planning, directing, and monitoring day-to-day operational activities to ensure a competitive service advantage is achieved.This role requires strong leadership skills, with...


  • Downey, California, United States West Advanced Technologies Full time

    Job Title: Senior Backup Storage EngineerThis is a challenging role that requires an experienced professional to lead the implementation, testing, and support of complex IT infrastructure, modification, installation, and storage systems. The ideal candidate will have expertise in managing core system hardware and software products, including CommVault,...

  • ETL Specialist

    3 weeks ago


    Downey, California, United States West Advanced Technologies Full time

    Job Description: We are looking for an ETL Specialist to join our team at West Advanced Technologies, Inc. As an ETL Specialist, you will play a crucial role in extracting, transforming, and loading data into our data warehouse. If you have a passion for data and enjoy working with complex data sets, we encourage you to apply!Responsibilities:- Extract data...


  • Downey, California, United States West Advanced Technologies Full time

    We're looking for an ETL Solutions Architect to help us optimize query performance and data processing in Azure Synapse Analytics through techniques like partitioning, indexing, and query optimization. The successful candidate will have a minimum of two years of experience in processing, management, and retrieval of information.RequirementsFamiliarity with...