What are the responsibilities and job description for the Data Engineer position at Prospiant?
This position is not eligible for visa sponsorship. Candidates must be authorized to work in the United States without the need for sponsorship, now or in the future.
Qualifications, skills, and all relevant experience needed for this role can be found in the full description below.
Position Summary
Gibraltar and its subsidiaries are industry leading innovators and suppliers to a range of infrastructure, agriculture technology, solar and home service products. As part of this team, you will be an integral resource to continue our business adoption and use of Azure, Microsoft Fabric, and other cloud environments for business intelligence and analytics. The team is well positioned to advance the company on multiple fronts, and we need a great team player to help us build robust data systems. This is a new position which expands our commitment and focuses on rapid delivery of key data elements to the business.
This role will report to the Senior Data Architect. The Data Engineer will be a critical member of a team that is responsible for the strategy, design, implementation, development, and support of the company’s Microsoft Fabric platform, data warehouse, data lake, Power BI reporting platform and various other data assets across the company.
Primary Accountabilities (Essential Duties)
- Work with stakeholders to understand business processes, document requirements and define data solutions.
- Write SQL queries to extract and manipulate data from multiple data sources.
- Perform discovery and profiling of new or undocumented data sources.
- Develop, maintain and troubleshoot T-SQL and Python ETL code.
- Develop, maintain and troubleshoot Azure Data Factory pipelines / Data Flows
- Develop data transformations using provided business rules and logic.
- Meet deadlines for individual and team projects.
- Maintain technical documentation and source control related to project design and implementation.
- Support ongoing data integration efforts and troubleshooting across Azure Synapse, Microsoft Fabric Lakehouse / Warehouse, and Power BI.
- Respond quickly to resolve application issues and minimize downtime.
- Other duties as assigned.
Position Qualifications
Core Competencies
Work Conditions
Environment : Remote, Dallas, TX or Chicago, IL preferred.
Travel :