Azure Data Engineer

1 week ago

San Diego, California, United States Avantiico Full time
About the Role

The Data Engineer will play a crucial role in providing technical expertise and coordinating day-to-day deliverables with the consulting team. This position will be responsible for designing, developing, and supporting data solutions using Microsoft tools such as Fabric, Synapse, Data Lake Gen2, Power BI, Tableau, SSRS, and SSAS.

Key Responsibilities
  • Develop code in ETL tools for extracting, transforming, and loading data from source systems to data stores.
  • Design and construct operational data stores, data lakes, and data marts.
  • Design key and indexing schemes and design partitioning.
  • Identify and implement internal process improvements, including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
  • Build analytical tools to provide actionable insights into key business performance metrics, including operational efficiency.
  • Work with stakeholders to assist with data-related technical issues.
  • Provide support for front-end development, delivery, and support of Business Intelligence and Analytical solutions.
  • Develop complex back-end data schemas to support front-end reporting requirements.
  • Assist management with evaluating and accepting new projects by providing cost estimates, application analysis, and recommendations based on application and project experience.
  • Meet with decision makers, systems owners, end users, and business analysts to define business requirements and systems goals and identify and resolve business data issues.
  • Responsible for setting development standards and practices. Manage and maintain responsibility for assigned projects.
  • Assist employees in solving routine data, system software, hardware, and procedure problems.
  • Regularly evaluate existing development footprint and identify areas to improve software. Evaluate industry best practices to determine fit within the customer's infrastructure.
  • Assist with periodic testing and implementation of contingency plans to ensure availability of data in case of system failure.
  • Follow internal project management methodology by adhering to documentation and production change control processes when implementing application enhancements and maintenance to ensure a stable production environment.
  • Participate in proactive team efforts to achieve departmental and company goals.
  • Must comply with current applicable laws, regulations, and bank policies and procedures. Comply with all safety policies, practices, and procedures. Report all unsafe activities to supervisor and/or Human Resources.
  • Self-motivated with ability to work effectively with limited supervision, enthusiasm for collaboration, continuous learning, and a team player.
  • Understand importance of code review and automated testing and different levels at which these need to be performed and write and implement tests as required.
  • This job may require up to 25% travel when working remotely. Ability for occasional travel for corporate meetings, retreats, or client locations.
Requirements
  • At least 5 years of information technology experience.
  • 3 years of experience working on Azure services such as Azure Data Lake Gen 1 and 2, Synapse Analytics, Azure Data Factory, Azure SQL Database, Azure SQL DW, Rest API's.
  • 5 or more years of T-SQL language/query experience with data manipulation such as stored procedures, functions, etc. Knowledge of data models, data modeling (Relational and Dimensional), Data profiling, and working with large data environments.
  • 3 or more years with Enterprise Resource Planning systems such as Dynamics 365 Finance & Operations, SAP, NetSuite, etc.
  • 3 to 5 years querying data sources using tools like Excel (PowerPivot, Power Query, Power Map), Power BI, and other reporting tools such as Tableau, SAS, and Teradata.
  • Strong communication, team player, and advance analytical skills to analyze data issues and drive appropriate actions with data operations and business processes.
  • Experience in solving ambiguous requests and problems using data.
  • Bachelor's degree or foreign equivalent from an accredited institution.
Preferred Qualifications
  • Experience with Microsoft Dynamics 365 Finance & Operations is highly desirable.
  • Experience with Microsoft Fabric is highly desirable, however, experience with prior applicable tools is required: Synapse Analytics, Data Factory, Power Query, advanced T-SQL, and SSMS are required.
  • Python, Spark, Java, or R; C++
  • Knowledge or experience in implementing solutions with Microsoft PowerApps, Power Automate, and/or Common Data Service (Power Platform).
  • Data Governance, Data Quality, Master Data Management, Insurance domain knowledge.
  • Data Science background or skills are not required but please mention them as appropriate.
About Avantiico

Avantiico is a business automation company and Microsoft Partner delivering integrated Microsoft Cloud solutions for Sales, Finance, Supply Chain, and Customer Service. With purpose-built 3PL Billing Automation and 3PL WMS solutions for Microsoft Dynamics 365 Finance and Supply Chain, Avantiico serves the needs of next-generation enterprise fulfillment and supply chain organizations. Avantiico's Multicompany Automation solution supports all industries, including Shared Services functions, centralized franchise account, and multi-company businesses. It is aimed at empowering enterprise businesses to improve accounting productivity, increase accuracy, and financial closing velocity.

The services offered by Avantiico range from enabling SMB and Enterprise Businesses in their software selection process, readiness, implementing Microsoft Solutions, providing 'Live Services' to clients, and driving user adoption in our client's teams. Avantiico serves clients across time-zones, industries, and business models including public traded, public sector, and privately held businesses. All Avantiico solutions are natively built on the Microsoft Cloud architecture and made for Microsoft Dynamics 365. Learn more about Avantiico, Careers, or Solutions at Avantiico is a Great Place to Work.

Equal Employment & Opportunity Statement

Avantiico is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity Employer, making decisions without regard to race, color, religion, sex, national origin, age, veteran status, disability, or any other protected class.

Avantiico Compensation and Company benefits:

  • Competitive salary + allowance + monthly performance-related bonus depending on the role
  • Salary commensurate with experience
  • Low travel expectation/work life balance
  • 99% of employee healthcare paid for by the company
  • Choices of premium HMO/PPO plans
  • Matching 401k plan
  • Paid vacation/sick/holidays

Compensation for roles at Avantiico varies depending on a wide array of factors including but not limited to the specific office location, role, skill set, and level of experience. As required by local law, Avantiico provides a reasonable estimate of the current salary range for this position as $140,000 to $160,000.

  • Senior Azure Data Engineer

    3 days ago

    San Diego, California, United States Kyocera Full time

    Job Title: Senior Azure Data EngineerAt Kyocera, we are seeking a highly skilled Senior Azure Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing, building, and maintaining large-scale data systems on the Azure platform.Key Responsibilities:Design and implement data architectures for enterprise...

  • Azure Data Engineer

    1 week ago

    San Francisco, California, United States Outdefine Full time

    About the Role:We are seeking a skilled professional to join our dynamic team as an Azure Databricks Engineer. In this role, you will be responsible for designing, developing, and implementing big data solutions using Azure Databricks. You will collaborate with data scientists, analysts, and other stakeholders to ensure efficient data processing,...

  • Data Engineer, Senior

    4 weeks ago

    San Diego, California, United States Booz Allen Hamilton Full time

    About the OpportunityWe are seeking a highly skilled Data Engineer to join our team at Booz Allen Hamilton. As a Data Engineer, you will play a critical role in developing, operating, and maintaining complex technology systems using engineering principles, theories, and concepts.Key ResponsibilitiesDesign, develop, and deploy data engineering solutions using...

  • Azure Cloud Engineer

    2 weeks ago

    San Diego, California, United States Insight Global Full time

    Job Title: Azure DevOps EngineerWe are seeking an experienced Azure DevOps Engineer to join our Site Reliability Engineering team at Insight Global. As a key member of our team, you will collaborate with cross-functional teams to revamp our client's Azure architecture, ensuring standardization across teams and applications.Key Responsibilities:Collaborate...

  • Azure DevOps Engineering Lead

    2 weeks ago

    San Diego, California, United States Hologic Full time

    Lead Azure DevOps EngineerWe are seeking a highly skilled and experienced Lead Azure DevOps Engineer to join our team at Hologic. As a key member of our DevOps team, you will play a critical role in supporting our R&D, Engineering, and Software Development teams.Key Responsibilities:Design, build, and run our DevOps processes and infrastructure in Azure.Lead...

  • Senior Integration and Test Engineer

    4 weeks ago

    San Diego, California, United States Azure Summit Technology Full time

    About Azure Summit TechnologyAzure Summit Technology is a leading provider of high-performance RF hardware, firmware, and software products, as well as innovative, practical, multi-function RF systems solutions that address emerging missions of national importance for customers across the Department of Defense.Job SummaryWe are seeking a highly skilled...

  • Senior Integration and Test Engineer

    3 weeks ago

    San Diego, California, United States Azure Summit Technology Full time

    About Azure Summit TechnologyAzure Summit Technology is a leading provider of high-performance RF hardware, firmware, and software products, as well as innovative, practical, multi-function RF systems solutions that address emerging missions of national importance for customers across the Department of Defense.Job SummaryWe are seeking a highly skilled...

  • Azure Cloud Data Architect-Director

    3 weeks ago

    San Francisco, California, United States Cedent Consulting Inc Full time

    Azure Cloud Data Architect-Director PositionCedent Consulting Inc is seeking a highly skilled Azure Cloud Data Architect-Director to lead the development of our cloud data platform.Key Responsibilities:Design and implement large-scale data storage, compute, and distribution systems on Azure.Evaluate and recommend cloud data platforms and services, such as...

  • Azure Cloud Data Architect-Director

    3 weeks ago

    San Francisco, California, United States Cedent Consulting Inc Full time

    Azure Cloud Data Architect-Director Position at Cedent Consulting IncWe are seeking a highly skilled Azure Cloud Data Architect-Director to lead our cloud data strategy and implementation.Key Responsibilities:Design and implement large-scale data storage, compute, and distribution systems on Azure.Evaluate and recommend cloud data platforms and services,...

  • Senior Integration and Test Engineer

    4 days ago

    San Diego, California, United States Azure Summit Technology Full time

    Job OpportunityAzure Summit Technology is a leading provider of high-performance RF hardware, firmware, and software products, as well as innovative RF systems solutions. We are seeking a highly skilled Senior Integration and Test Engineer to join our dynamic team.Key Responsibilities:Execute research and development of complex SIGINT, EW, radar,...

  • Senior Systems Integration and Test Engineer

    4 weeks ago

    San Diego, California, United States Azure Summit Technology Full time

    About Azure Summit TechnologyAzure Summit Technology is a leading provider of high-performance RF hardware, firmware, and software products, as well as innovative, practical, multi-function RF systems solutions that address emerging missions of national importance for customers across the Department of Defense.Job SummaryWe are seeking a highly skilled...

  • Senior Azure Cloud Engineer

    4 weeks ago

    San Diego, California, United States Peraton Full time

    Role OverviewWe are seeking a Senior Microsoft Azure Administrator/Engineer to join our dynamic team. This role focuses on enhancing the Microsoft Azure Stack HCI solution by spearheading engineering and design initiatives for the migration of on-premises server solutions to Azure Stack HCI.Key ResponsibilitiesAs an Azure Administrator/Engineer, you...

  • Data Engineer

    4 days ago

    San Diego, California, United States San Diego Community Power Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at San Diego Community Power. As a Data Engineer, you will play a critical role in designing, maintaining, and optimizing our data infrastructure to support business decision-making.Key Responsibilities:Design and implement scalable data pipelines to extract, transform,...

  • Azure Cloud Data Architect Director

    1 week ago

    San Francisco, California, United States Cedent Consulting Full time

    Cloud Data Architect DirectorCedent Consulting is seeking a highly skilled Cloud Data Architect Director to lead the build-out of our platform on Azure and migration from on-prem systems.Key Responsibilities:Architect and lead the build-out of our platform on AzureMigrate from on-prem systems to AzureUnderstand the existing on-prem technology landscape and...

  • Azure Solutions Engineer

    1 month ago

    San Francisco, California, United States JLL Full time

    Join JLL in Shaping the Future of Real Estate At JLL, we are dedicated to transforming the real estate landscape through innovative technology and exceptional service. Our team at JLL Technologies is at the forefront of this transformation, and we are looking for a skilled Software Engineer to contribute to our mission. Position Overview: We are in...

  • Senior Azure ML/Data Scientist

    3 days ago

    San Diego, California, United States KForce Full time

    Job Title: Senior Azure ML/Data ScientistKforce has a client in San Diego, CA that is looking for a Senior Azure ML/Data Scientist (Mortgage) to lead and perform number of activities related to the company's Information Technology functions.Key Responsibilities:Lead the development and deployment of sophisticated analytics models to predict, quantify, and...

  • Senior Integration and Test Engineer

    4 weeks ago

    San Diego, California, United States Azure Summit Technology Full time

    About the RoleAzure Summit Technology is a leading provider of high-performance RF hardware, firmware, and software products, and innovative, practical, multi-function RF systems solutions that address emerging missions of national importance for customers across the Department of Defense.We are a diverse team of highly qualified RF systems engineers and...

  • Senior Integration and Test Engineer

    4 weeks ago

    San Diego, California, United States Azure Summit Technology Full time

    About the RoleAzure Summit Technology is a leading provider of high-performance RF hardware, firmware, and software products, as well as innovative, practical, multi-function RF systems solutions that address emerging missions of national importance for customers across the Department of Defense.We are a diverse team of highly qualified RF systems engineers...

  • Data Engineer, Senior

    4 weeks ago

    San Diego, California, United States Booz Allen Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Booz Allen. As a Data Engineer, you will play a critical role in designing, developing, and maintaining large-scale data systems and pipelines.Key ResponsibilitiesDesign and implement data pipelines and architectures to support business intelligence and analytics...

  • Data Engineering Specialist

    4 days ago

    San Diego, California, United States Vets Hired Full time

    Job OverviewVets Hired is seeking a highly skilled Data Automation Specialist to join our team. As a key member of our data engineering team, you will be responsible for designing, implementing, and maintaining data pipelines and packages for our Enterprise Data Warehouse (EDW).Key ResponsibilitiesData Pipeline Development: Design and implement efficient and...