Data Engineer

As a Data Engineer, you will play a critical part in harnessing the power of data to derive business insights. Your primary responsibility will be to employ your expertise in data engineering and programming to construct robust systems that competently gather, manage, and convert raw data into actionable information for all major functions of the organization. You will build, maintain, and enhance MARS (Management, Analysis and Reporting System) applications constructed and utilized by BW Energy. You will also design and maintain integrations between multiple systems, create business solutions and preserve the integrity and security of data and data storage. You will cooperate with internal departments to automate processes with the aim of enhancing performance and developing leading reporting and forecasting. Your tasks will include: 1. Modifying existing Azure SQL databases, queries, integrations, and pipelines as required to accomplish evolving goals and needs. 2. Designing, developing, creating, and maintaining database integrations, storage, and applications using Microsoft development tools in a cloud environment. 3. Participating in the transition of data from traditional storage models. 4. Providing technical assistance to architect scalable solutions to support automation and integration. 5. Ensuring database integrity, working with IT data integrity audits, enforcing standards and preventing redundant/duplicate data. 6. Maintaining, supporting, and improving data analytics platforms and storage systems. 7. Designing and building integrations for existing applications. 8. Participating in the creation of requirement analysis and definitions. 9. Developing, debugging, testing and deploying new and existing applications. 10. Creating and updating technical documentation. Requirements: Necessary: • Proficiency in Microsoft SQL including Azure SQL Server and SQL Server. • Experience with ETL/ELT and data modelling. • Experience with Azure DevOps, Power Automate / Flow, PowerApps and/or SharePoint. • Working knowledge with modern DevOps solution patterns and Infrastructure as code cloud automation solutions. • Proficiency with developing Power BI reports, dashboards, visualization utilizing periodic and streaming data. • Experience with Azure DevOps, Azure Data Factory and Data Pipelines. • Strong OOP principles and practice with Python, Java, or C#. • Experience in Design & Implementation of end-end data pipelines. • Ability to integrate with line of business (LOB) applications. • Experience designing and supporting batch and REST based API integrations. • Ability to prioritize and manage multiple tasks in a high-energy environment. • Strong interpersonal skills and the ability to create and maintain solid working relationships. • Excellent verbal and written communication skills. • Proven ability to take initiative and be innovative. Desired: • Experience in the upstream Oil and Gas industry. • Familiar with data warehouse automation tools, specifically Xpert BI. • Familiarity with PI, IFS and Cornerstone applications. • Knowledge of Finance and Strategy business processes. The Ideal Candidate Possesses: • Willingness to invest in a long-term career with BWE and grow with the business. • Ability to understand the big picture and implement processes/workflows coupled with technical solutions to achieve strategic business objectives. • Ability to think through processes, workflows, and requirements. And suggest improvements to enhance efficiency and effectiveness. • Enhance horizontal communication to eliminate information silos and strive to achieve one version of the truth. • Strong communication skills, with the ability to engage with business users to gather their needs and translate them into clear specifications for solution implementation. Minimum Qualifications: • Bachelor’s degree from a four-year accredited college or university in Computer Science, Management Information Systems or related field required. • High School Diploma required. • Minimum of three to five (3-5) years applicable work experience required. Benefits: • Health Care Plan (Medical, Dental & Vision) • Retirement Plan (401k, IRA) • Life Insurance (Basic, Voluntary & AD&D) • Paid Time Off (Vacation, Sick & Public Holidays) • Family Leave (Maternity, Paternity) • Short Term & Long Term Disability