Information Technology Data Engineer

Position Summary

As a Data Engineer, you will play a critical role in designing, developing, and maintaining our organization's data infrastructure.  You will work closely with others in the Information Technology department: analysts, developers, administrators and engineers to extract, transform, and load data from various sources into our data repositories.  You will also work with others within the business (e.g. business process) to drive and deliver improvements.  Your expertise in data engineering will enable us to make data-driven decisions, gain valuable insights, and improve user experiences.  As a member of our technology team, you will help contribute to the overall success of the Information Technology organization and the business.  As a Data Engineer you will be empowered with the opportunity to go above and beyond to simplify our user experiences while enhancing our data posture to improve our products and services we deliver.  Behind the scenes, this dedicated individual's focus will follow a continuous improvement model on refining solutions, improving experiences of every user and make data accessible and usable for our business to make informed decisions.

Duties & Responsibilities

• Participate in design and architecture of software solutions with focus on ETL data management
• Design, develop, and optimize complex queries to support data discovery, analysis, and reporting.  Leverage databases to ensure accurate data staging and transformation processes that align with business requirements
• Develop and implement data staging strategies to prepare data for analysis and reporting
• Conduct thorough data discovery to identify and address data quality issues (including handling of structured or unstructured data in data lakes, data warehouses or other data repository types), ensuring that the data is accurate, complete, and accessible for business needs
• Partnering with our business, business process group and key stakeholder teams to create effective solutions
• Embrace challenges and seek innovative solutions to enhance the performance and scalability of data systems and applications
• Drive improvements and push the boundaries of existing processes to elevate data engineering efforts and impact
• Data Engineering:

• Design, develop, and maintain robust data pipelines to ingest, process, and transform raw data from various sources (e.g., databases, APIs, connectors, cloud storage) into actionable insights
• Optimize data pipelines for performance, scalability, and reliability
• Implement and ensure data quality and reliability checks and monitoring to ensure data accuracy and consistency
• Collaborate with analysts to understand data needs and translate them into technical solutions

• Data Modeling:

• Design and implement data models (e.g., hierarchical, network, relational, entity-relationship, dimensional, star schema) to efficiently store and retrieve data
• Optimize data models for query performance and scalability

• Data Repositories, Warehousing, and Data Lakes:

• Manage and maintain data repositories, data warehouses and data lakes, including structured and unstructured data, data loading, indexing, and partitioning
• Implement data security and privacy measures to protect sensitive information

• Cloud Technologies:

• Leverage cloud platforms (e.g., Azure) to build scalable and cost-effective data solutions
• Utilize cloud-native data services (e.g., data repositories, data warehouses, data lakes, data pipelines) to accelerate data processing and analysis

• Data Governance:
• Contribute to the development and implementation of data governance policies and standards
• Ensure compliance with data regulations and industry best practices

Minimum Qualifications

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Minimum 7 years experience in IT
• Minimum 3 years experience as a Data Engineer
• Strong proficiency in Microsoft SQL programming languages
• Experience with data engineering tools and technologies (e.g., SQL, Power BI, Tableau)
• Knowledge of cloud platforms (e.g., Azure) and cloud-native data services
• Experience with data repositories, data warehousing and data modeling concepts
• Understanding of data quality and data governance principles
• Strong analytical and problem-solving skills
• Excellent communication and collaboration skills.
• Basic knowledge of technology infrastructure, including network, servers, PCs, and operating systems
• Worked with Dynamics and Power Platform suites, ERP
• Worked with and/or delivered in house custom solutions
• Experience with ServiceNow ITSM and PPM tools
• Experience with Azure Data Lake
• Experience managing SharePoint and ITIL systems
• Experience with Enterprise Service Bus (ESB) platforms (e.g., iPaaS) used to integrate applications
• Excellent verbal and written communication skills; ability to interact professionally with diverse groups across org
• High emotional intelligence and executive presence
• Strong interpersonal skills, a team player, must be able to work with both technical and business colleagues globally
• Self-motivated, eager to learn and grow; desire to advance expertise in leadership and application management
• Strong technical writing capabilities
• Strong analytical, problem-solving, and troubleshooting skills
• Robust skills with desktop applications (e.g., Word, Excel, PowerPoint, etc.)
• Experience with data visualization tools (e.g., Power BI, Tableau).
• Skilled in SSRS (SQL Server Reporting Services), Power BI, or similar enterprise reporting tools
• Fluent in ETL concepts and languages such as SSIS (SQL Server Integration Services)

Preferred Qualifications

• Knowledge of machine learning and artificial intelligence concepts
• Certifications in cloud platforms or data engineering
• Experience delivering and supporting custom and SaaS applications
• Demonstrated knowledge of scripting languages (e.g., .NET using C#, PowerShell, Python, etc.)
• Proven skillset in SQL or other enterprise database query languages
• Demonstrated experience with Source Control solutions such as GitHub
• Demonstrated continuous improvement of application solutions and business processes
• Front line leadership, management skills to lead a technical team and be the voice across all levels of the organization

Customer Service Skills

• Demonstrates commitment to deliver outstanding service (internal users and external customers/partners)
• Takes ownership to personally resolve customer problems, escalate when needed
• Listens well, asks clarifying questions, and checks for agreement with customers
• Committed to following up with management and customers in all instances in a timely manner
• Strong sense of accountability

Other

• Ability to travel up to 10% of the year