Data Engineer (Finance)
Gibraltar is a leading manufacturer and supplier of products and services for North American agtech, renewable energy, residential, and infrastructure markets. By building solutions that make life better for people and the planet, Gibraltar advances the art and science of engineering, science and technology to shape the future of comfortable living, sustainable power, and productive growing.
Guided by an inclusive, values-driven culture that celebrates and rewards different perspectives, we work together to create lasting positive impact on everyone our business touches. To learn more about what makes us #GibraltarProud, visit our website: www.gibraltar1.com
Position Summary
We are seeking a skilled and motivated Data Engineer to join our team. In this role, you will be responsible for designing, building, and maintaining robust data pipelines and systems that support the collection, processing, and storage of large datasets. You will work closely with data scientists and analysts to ensure seamless access to high-quality, reliable data for business insights and reporting. Key responsibilities include optimizing data workflows, ensuring data integrity, and implementing data security measures. The ideal candidate will have a strong background in data architecture, SQL, and cloud-based technologies, with a focus on scalability and performance.
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.
**Sponsorship is not available for this opportunity.**
Position Qualifications
- Bachelor's degree in Computer Science, Information Science, or equivalent relevant experience
- Highly proficient with SQL coding; experience using advanced concepts (windowing functions, complex joins)
- 5 years' experience SQL Server
- Proficient in T-SQL development (stored procedures, functions, etc).
- Experience with Azure Data Factory (ADF) or other ETL tool
- Power BI development experience a plus
- Familiarity with dimensional data modeling and Kimball data warehousing concepts
- Ability to understand query optimizer plans to identify processing bottlenecks and improve performance
- Experience in using Azure BI stack (Synapse, Fabric)
- Understanding of Agile application development methodologies and tools (Azure DevOps, Jira)
Core Competencies
- Ability to collaborate in a remote work environment.
- Excellent verbal and written skills.
- Self-direct to complete assignments within a specified timeline
- Team-focused mindset with a dedication to continuous improvement.
Work Conditions
- Environment: Remote, Dallas, TX or Chicago, IL preferred.
- Travel:
What we offer
Health & Welfare
- Medical, dental, and vision insurance plans for employees and dependents
- Health care & dependent flexible spending plans
- Free Life and AD&D coverage with supplemental coverage options
- Employee assistance programs focused on mental health
Financial Wellbeing
- Competitive compensation
- Bonus opportunities
- Generous 401(k) plan
Flexibility & Time Off
- Paid time off, including vacation, bereavement, jury duty, sick leave, disability, holidays.
- Hybrid & remote work opportunities available
Community & Personal Development
- Donation matching and time off to volunteer
- Educational reimbursement
About Us
Gibraltar is a leading manufacturer and supplier of products and services for North American agtech, renewable energy, residential, and infrastructure markets. By building solutions that make life better for people and the planet, Gibraltar advances the art and science of engineering, science and technology to shape the future of comfortable living, sustainable power, and productive growing.
EEOE
Gibraltar is an Equal Employment Opportunity Employer and gives all applicants for employment equal consideration regardless of race, color, sex, religion, national origin, arrest record, ancestry, age, physical or mental disability, sexual orientation, transgender status, genetic information, marital status, citizenship status, veteran status, pregnancy, or any other status protected by federal, state, or local law. Upon request and consistent with applicable laws, Gibraltar will provide reasonable accommodations to individuals with disabilities who need an accommodation to fully participate in the application process.
