Role Overview
We are looking for a Data/BI Engineer to join our technology team and contribute to the development and maintenance of scalable data solutions. This role involves working with structured and unstructured data, integrating new sources, and optimizing data pipelines to support reporting and analytics.
The position focuses on SQL Server as the primary database technology, with an increasing emphasis on cloud-based services, including AWS tools such as Athena, Glue, and SageMaker.
This role will play a key part in enabling data-driven decision-making by ensuring efficient data processing and high-quality insights.
Key Responsibilities
* Collaborate with stakeholders to define and scope data processing requirements.
* Develop and maintain data pipelines using SQL, SSIS, AWS Glue, and Athena.
* Optimize and debug SQL Server procedures, functions, and queries for performance and efficiency.
* Work with internal teams to integrate data from various sources into a centralized data platform.
* Ensure data quality, consistency, and reliability for business intelligence and analytics.
* Stay updated on cloud-based data pipeline tools and big data technologies to enhance scalability and performance.
Skills & Experience
Required:
* Strong proficiency in SQL Server (T-SQL, Query Optimization, Indexing, Partitioning).
* Experience with SSIS for data integration and ETL processes.
* Scripting knowledge using PowerShell.
* Familiarity with data modeling and designing efficient database structures.
* Strong problem-solving and analytical skills.
Preferred:
* Experience with AWS services (Glue, Lambda, Redshift, Athena).
* Knowledge of big data technologies and scalable data architectures.
* Proficiency in Python for data processing and automation.
Ideal Candidate Traits
Successful candidates typically:
* Have a passion for working with data and solving complex challenges.
* Are curious, detail-oriented, and proactive in optimizing data solutions.
* Demonstrate strong time management and prioritization skills.
* Adapt well to changing requirements and business needs.
* Communicate effectively and collaborate across teams.
* Take ownership of their work and seek continuous improvement.