Position Summary:
In this position, you will play a crucial role in managing and optimizing our data processes within our emerging Data Warehouse/Data Lake environments. This position requires a strong foundation in ETL systems, SQL development, and a solid understanding of relational databases. You will work to ensure the efficiency and reliability of our data pipelines, contributing directly to the success of our projects. The ideal candidate will have a strong background in data analysis and data visualization with specific expertise in using SQL to transform and analyze data. You will work closely with stakeholders across the organization to deliver actionable insights and support data-driven decision-making.
Essential Functions:
* Collaborate with data engineers, analysts, and other stakeholders on data flows, scripts, and models using SQL, SnapLogic, and other ETL systems, optimizing for performance and reliability.
* Assist in the development and testing of new features, models, or data processes within our data warehouses, leveraging feedback for continuous improvement.
* Document data processes, models, and workflows within our data warehouses for internal knowledge sharing and ongoing learning.
* Ensure data integrity and quality throughout the data lifecycle by implementing validation and cleansing processes.
* Maintain security protocols and data governance practices to ensure compliance with policies and regulations.
* Monitor performance and troubleshoot issues within ETL projects and data environments.
* Create and maintain interactive dashboards and reports using SSRS, Power BI, or similar tools.
* Implement best practices in data governance to ensure data quality and integrity.
Education and Experience:
* Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field.
* 3+ years of experience in a data engineering role focusing on SQL development (MS SQL Server preferred).
* Strong proficiency in relational databases and data querying techniques.
* Expertise in data modeling, ETL processes, and data integration.
* Experience with programmatic tools for data manipulation and analysis.
* Familiarity with cloud platforms such as Azure, AWS, or GCP.
* Knowledge of data visualization tools like Power BI, Tableau, or similar.
* Excellent problem-solving skills and attention to detail.
* Strong communication and collaboration skills.
* Ability to learn quickly, adapt, and be creative.
* Capability to work independently and in teams.
Physical Demands:
* Perform essential functions safely, meeting productivity standards, consistent with ADA, FMLA, and other standards.
* Maintain regular attendance.
* Ability to sit, stand, stoop, or bend for extended periods (up to 8 hours).
* Listen and speak clearly over the phone.
Work Environment:
The work environment is typically moderate noise level. Reasonable accommodations are available for individuals with disabilities.
Perks:
* Health, dental, and vision benefits.
* Employer-paid disability and life insurance.
* Flexible spending accounts.
* 401K with company match.
* Paid time off and holidays.
* Wellness resources.
Note: This job description is not exhaustive and may be amended as needed.
#J-18808-Ljbffr