Application Engineer - Indiana, United States - Mastech Digital

    Mastech Digital
    Mastech Digital Indiana, United States

    Found in: Appcast US C2 - 1 week ago

    Default job background
    Description

    Job Role: Data Engineer

    Job Location: Remote/Hybrid (Indiana Harbor, IN)

    Duration: 8+ Months (high chances of extension)

    Summary of Responsibilities:

    • Design and develop end-to-end business intelligence solutions using Azure technologies, including but not limited to: Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, and Azure Analysis Services.
    • Design and develop data models, data warehouses, and ETL processes.
    • Collaborate with business analysts and development teams.
    • Create and maintain SQL queries, stored procedures, and functions to extract, transform, and load data from various sources.
    • Optimize and tune SQL queries, data models, and ETL processes for performance and efficiency.
    • Implement data security measures and ensure compliance with data governance policies.
    • Keep up-to-date with the latest Microsoft BI technologies and best practices.

    Required Qualifications

    • Bachelor's degree in computer science, or Information Systems
    • Experience with Microsoft Azure services such as Azure Data Factory, Azure Analysis Services, or Azure Synapse Analytics.
    • Synapse/ADF Experience:
    • Pipelines
    • Activities: Dataflows and Notebooks (Phyton)
    • Gen 2 Storage
    • SQL Serverless and SQL Dedicated Pool
    • Understanding of data warehousing principles and ETL processes.
    • Ability to work independently and as part of a team, managing multiple priorities and deadlines.
    • Excellent analytical and problem-solving skills.
    • Strong communication and collaboration abilities.
    • Experience with agile development methodologies.
    • Proficient in SQL querying and data modeling

    Additional Qualification

    • Minimum of three (3) years experience as a BI Developer or similar role, utilizing Microsoft BI technologies
    • Design and develop interactive dashboards using Microsoft Power BI utilizing drill down data exploration for deep insights.
    • Strong knowledge of Microsoft SQL Server, SSIS, and SSAS.
    • Experience in developing data visualizations.
    • Knowledge of data visualization best practices and user experience design.